I’m running cluster 5.7 with MySQL 5.7 on Debian 9 and issuing a “service mysql stop” doesn’t seem to do anything. If I issue “service mysql restart” it does seem to shutdown mysql gracefully and restart it. However, stop, does nothing. This is a problem because rebooting the node without stopping mysql first gracefully forces crash recovery on startup which takes quite a while and is unnecessary. Is there a fix or workaround for this problem?
Try
mysqladmin -u root -p shutdown
I have a similar problem on a cluster of three nodes.
Do you have a new cluster installation with an empty database or was the database imported from another server?
Hi. In general it depends on the way you have started mysql process.
If you have started mysql as
then
should help you to stop it.
In case you have started
So in this case you should stop bootstrapped node using