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…?
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