I am migrating from a system running master-slave replication with a master and 5 slave servers. I have set up a cluster with 6 nodes and am replicating from the original master into the new cluster in preparation for switching over to the new cluster. The problem I have is the replication into the …

Are you seeing any flow control issues on your PXC? Are all 5 nodes (that’s unusual, 3 is typical) on the same network? PXC cannot replicate faster than the slowest link between any two nodes. That’s why removing one sped things up. PXC synchronously replicates incoming traffic. All 5 nodes must ACK…

Replicating into cluster is slow

MySQL & MariaDB Percona XtraDB Cluster 5.x

matthewb November 24, 2020, 3:38pm 14

Interesting limitation from PXC. I was unaware.

Just so I can understand, is this the setup? M – MIXED → S — ROW —> PXC1

And PXC has 3 nodes? And you are watching slave lag on PXC1? What happens if you stop PXC2 and PXC3? Does lag go down?

Topic		Replies	Views
Slow replication when adding a second node Percona XtraDB Cluster 5.x	0	580	February 10, 2014
Replication cannot catch up between PXC and Percona Server Percona XtraDB Cluster 5.x	0	532	February 25, 2014
Very very slow insert for a cluster of 3 nodes :( Percona XtraDB Cluster 5.x	12	9770	January 22, 2014
Write performance is horrible on 2nd node Percona XtraDB Cluster 5.x	2	971	September 9, 2013
Some newbie questions Percona XtraDB Cluster 8.x	3	703	January 16, 2023

Replicating into cluster is slow

Related topics