How to bring a node offline in PXC 8.0.27,other than stopping the mysql service

MySQL & MariaDB Percona XtraDB Cluster 8.x
,
1

Hi there,
I have a 3 node cluster,how do i bring the node offline for few mins/hrs due to maintenance other than STOPPING the MySQL service in percona xtradb cluster 8.0.27.
Is there any command for the same…?

1 Like
2

Hi AneeshBabu,

No, there is no native mysql/pxc command for “having the node UP but not service traffic”.

The closest you can do is “maintenance mode” from proxysql ProxySQL-Assisted Percona XtraDB Cluster Maintenance Mode - Percona Database Performance Blog . You mark the intended node for maintenance and traffic to that node will be stopped while existing connections finish execution

Regards

1 Like