I talk with lot of people who are really interested in Percona XtraDB Cluster (PXC) and mostly they are interested in PXC as a high-availability solution. But, what they tend not to think too much about is if moving from async to synchronous replication is right for their application or not.
Facts about Galera replication
There’s a lot of different facts about Galera that come into play here, and it isn’t always obvious how they will affect your database workload. For example:
- Transaction commit takes approximately the worst packet round trip time (RTT) between any two nodes in your cluster.
- Transaction apply on slave nodes is still asynchronous from client commit (except on the original node where the transaction is committed)
- Galera prevents writing conflicts to these pending transactions …