Mha master-slave architecture, VIP high availability, trouble, to use downtime need to manually add data, Mha management the opportunity to stop!
Pxc don't need to be synchronized, strong data consistency, no master-slave, support node joining automatically, without having to manually copy,
Who know the use of the advantages and disadvantages of both!

CodePudding user response:

PXC is high availability scheme based on Galere protocol, and MariaDB Galera Cluster

Galere architecture is under all mysql by wsrep API calls galera replication libraries to realize the file synchronization replication, and on each server implementation again, otherwise all the server implementation success, or all rolled back, ensure that all services of data consistency, and all the server synchronous real-time updates,

So disadvantages clearly, because the same transaction need to perform on multiple machines in the cluster, so the network transmission and concurrent execution leads to performance has a certain cost