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

This article shares with you about the features, compatibility, and limitations available in PXC. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Percona XtraDB Cluster is a solution for MySQL high availability and scalability, and Percona XtraDB Cluster provides the following features:

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

2)。 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.

Compatibility:

1)。 Fully compatible with existing systems (innodb engine, optimizer execution plan, exactly the same optimization idea)

2)。 Minimal migration (very convenient migration from existing systems to PXC)

3)。 Fast fallback version (unlocked, very easy to restore to non-PXC systems)

Restrictions:

1)。 Only INNODB tables are supported

2)。 Big business is not allowed to happen (otherwise the consequences will be serious)

3)。 Write performance depends on the worst node

4)。 Unable to solve hot spot update problem

5)。 Optimistic lock control

6)。 For write-intensive applications, the size of a single node needs to be controlled. The larger the data of a single node, the greater the jitter may occur if the new node is added automatically. (backup or backup + binlog is recommended for IST (Incremental State Transfer) incremental synchronization.

Thank you for reading! This is the end of the article on "what are the features, compatibility and limitations provided in PXC?". I hope the above content can be helpful to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

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.