Shulou(Shulou.com)06/01 Report--

Every node in the cluster is a normal MySQL/Percona Server, which means that you can connect the existing MySQL/Percona Server directly to the cluster, or take it out of the cluster as a normal MySQL service.

Each node has all the data, which means that the data of the node is completely equivalent, and any query can be done locally. It also means that the data is highly redundant and is not very friendly to write extensions (write scalling).

Advantages:

Synchronous replication, highly consistent

Multiple master replication, which can be read and written by any node

Concurrent replication (Parallel applying events on slave. Real "parallel replication")

Automatic node provisioning.

Data consistency

Disadvantages:

Only replication of InnoDB storage engine (including XtraDB engine) is supported

Lock statements or functions such as LOCK/UNLOCK TABLES, GET_LOCK (), RELESE_LOCK () are not supported

In the short board effect, the throughput of the cluster depends on the worst node.

...

Overall, Percona XtraDB Cluster is a little easier to use than MySQL Cluster NDB, thanks to his peer-to-peer design, while using XTraDB as a storage engine. So it is relatively much more transparent to the application.

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.