Using Ubuntu Server 14.04.1 and Percona XtraDB 5.6.20-68.0-56. When the cluster is running with all three servers and we do a set of inserts (~800,000 of them) we see a through put of around 150 inserts/second. If I shut down servers two and three and now run the same transactions we see a throug…

Cluster performance really slow compared to just one server

Ovi January 14, 2015, 6:09am 7

By default PXC is asynchronous. To make it fully synchronous, you must enable wsrep_sync_wait.

Topic		Replies	Views
Very very slow insert for a cluster of 3 nodes :( Percona XtraDB Cluster 5.x	12	9766	January 22, 2014
Insert update slow sometimes Percona XtraDB Cluster 5.x percona	11	1260	April 25, 2022
2 Node Cluster Very slow Percona XtraDB Cluster 5.x	0	541	February 10, 2020
Improving performance for parallel inserts for XtraDB cluster. Percona XtraDB Cluster 5.x	1	671	March 14, 2014
Write process is Too Much SLOW - Restore process very slow - percona XtraDB Cluster 8.0 Percona XtraDB Cluster 8.x mysql , percona	8	1109	April 8, 2021