Shulou(Shulou.com)05/31 Report--

This article shows you what the features and advantages and disadvantages of PXC are, concise and easy to understand, which will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Percona XtraDB Cluster is a solution for high availability and scalability of MySQL.

The features provided by Percona XtraDB Cluster are:

1. In synchronous replication, transactions are either committed on all nodes or not committed.

two。 Multi-master replication, which can be written at any node.

3. Events are applied in parallel from the server, which is true parallel replication.

4. The node is automatically configured.

5. Data consistency, no longer asynchronous replication.

Percona XtraDB Cluster is fully compatible with MySQL and Percona Server, as shown in:

1. Data compatibility

two。 Application compatibility: no need to change the application

1. The cluster is made up of nodes. It is recommended to configure at least 3 nodes, but it can also run on 2 nodes.

two。 Each node is an ordinary mysql/percona server, and the existing database servers can be clustered, or the cluster can be split into separate servers.

3. Each node contains a complete copy of the data.

The advantages are as follows:

1. When a query is executed, it is executed on the local node. Because all data is local, there is no need for remote access.

two。 There is no need for centralized management. You can lose any node at any point in time, but the cluster will work as usual.

3. Good read load expansion, any node can query.

The disadvantages are as follows:

1. Adding a new node costs a lot of money. The complete data needs to be copied.

two。 Can not effectively solve the write scaling problem, all write operations will occur on all nodes.

3. There are as many duplicated data as there are nodes.

Percona XtraDB Cluster differs from MySQL Replication in:

CAP theory of distributed system.

Cmurmuri-consistent, the data of all nodes are consistent.

Murray-availability, where one or more nodes fail and do not affect service requests.

Pmurmuri-Partition tolerance, connection failure between nodes, can still process requests.

Any distributed system needs to satisfy two of these three.

MySQL Replication: availability and partition tolerance

Percona XtraDB Cluster: consistency and availability

Therefore, MySQL Replication does not guarantee data consistency, while Percona XtraDB Cluster provides data consistency.

Percona XtraDB Cluster components:

Percona XtraDB Cluster is based on XtraDB's Percona Server and contains write replication set patches. Use Galera 2.x library, a general multi-master synchronous replication plug-in for transactional applications.

The new features of Galera 2.x are:

1.IST (Incremental State Transfer) incremental state transfer. Especially useful for WAN.

2.RSU (Rolling Schema Update) rotates to update the schema. Operations on the table are not blocked.

The above is what the features and advantages and disadvantages of PXC are, and have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.