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 17, 2020, 10:49am 6

Looking at the PMM graph for replication lag, you are clearly seeing lag go up and down?

Topic		Replies	Views
Slow replication when adding a second node Percona XtraDB Cluster 5.x	0	581	February 10, 2014
Replication cannot catch up between PXC and Percona Server Percona XtraDB Cluster 5.x	0	535	February 25, 2014
Very very slow insert for a cluster of 3 nodes :( Percona XtraDB Cluster 5.x	12	9774	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	706	January 16, 2023

Replicating into cluster is slow

Related topics