Hello, we have now percona mysql production and pair of read only slaves in GTID replcation. Can you explain, please (or give some links, where i could read it), if we swich to XtraDBCluster, what happend with time of write queries? Am i right thinking, that these queries will be slower? Due to nature of cluster.
1 Like
Hi @Deniska80
You can find all needed documentation here: About Percona XtraDB Cluster - Percona XtraDB Cluster
Write throughput of the whole cluster is limited by the weakest node.
If one node becomes slow, the whole cluster slows down. If you have requirements for stable high performance, then it should be supported by corresponding hardware.
2 Likes
Thanks for link
Of course. I mean, that, for example, that write time for 3 identical nodes cluster will be slower, that if it be just single server with identical hardware
1 Like
@Deniska80 Only replication of the write events in PXC is synchronous. Apply is async. If all 3 nodes are on the same LAN and of equal specifications, on average, you shouldn’t notice much change in write throughput. Replication/communication in PXC uses a completely different protocol compared to traditional replication.
2 Likes