There is a problem concerning large ALTER or for example adding the index - the whole database comes to pre-commit stage and until the request is executed it will remain in this stage. This means that all other databases which are on the same server can not process requests and are waiting for that …

pre-commit stage

filaret March 30, 2017, 5:39am 4

Thank you!

Topic		Replies	Views
Cluster hangs during alter table command Percona XtraDB Cluster 5.x	0	575	June 14, 2018
ALTER TABLE locks up cluster Percona XtraDB Cluster 5.x	0	698	January 14, 2015
ALTER TABLE without downtime in a cluster Percona XtraDB Cluster 5.x	2	2392	February 23, 2017
Error Code: 1213. WSREP with concurrent DML when DDL is executed Percona XtraDB Cluster 5.x	3	1277	December 12, 2018
Cluster re-sync causes much lock Percona XtraDB Cluster 5.x mysql	2	902	June 23, 2021