How to reset Percona XtraDB Cluster on all nodes?

  1. No. I have a bare CentOS 7 Minimal installation with Percona XtraDB Cluster on it.
  2. I used bootstrap only for the first node. After that I don’t bootstrap (I.e. when a cluster already running I don’t use it).
  3. How to kill sync? After node starts it stays in a ‘Activating’ state for 2 hours if we try to stop it (systemctl stop mysql) it stays in ‘deactivating’ state infinity time. When it is in ‘deactivating’ state we can’t do anything except node reboot (i.e. ‘systemctl start mysql’, ‘systemctl stop mysql’, kill -9 PID_OF_MYSQL doesn’t work).
  4. Sometims sync doesn’t work. If a node s crashed (power off) and then is stated (power on) it can stay in ‘activating’ stay for infinity time. I tried this situation with 3 VM machines. I crashed one and then booted it and it said that it is in ‘activating’ state (it was in the morning). Then in the midday I tried to check if it is already synk but it wasn’t still in ‘activating’ state. You may think that it is because very huge database but it isn’t. I have only one database with several tables (about 10) each table has from 0 to 20 rows.
  5. I see. But there is can be situation when only one node is reboted but after reboot it don’t want to sync.

Do you know a method how to comleatelly kill mysql without rebooting?
Right now mysql is started automatically (systemctl enable mysql) but sometimes it don’t want to connect to the cluster. For me the only possible way to connect all the cluster togather is the next:

  1. On any node:
    systemctl disable mysql
    shutdown now
  2. On other nodes:
    shutdown now
  3. Start a node where mysql is disabled and use:
    systemctl start mysql@bootstrap.service
    systemctl enable mysql
  4. Start other nodes.

The problem is that I need to restart all the nodes (not kill mysql and restart it but restart all my nodes where PXC is installed).
If I were able to completely stop mysql that I would able to just stop all PXC cluster and create a new one. But other services wouldn’t be restarted. Do you know a way how to just stop mysql when it is in ‘activating’ or ‘deactivating’ state?