I have setup a two node cluster using using MySQL-5.7. Now i am trying to stop one of the nodes using the command “systemctl stop mysql” and it keeps waiting. I can see the following at the end of the logs
2018-08-29T16:40:19.055121Z 2 [Note] WSREP: Setting wsrep_ready to false
2018-08-29T16:40:19.055080Z 0 [Note] WSREP: RECV thread exiting 0: Success
2018-08-29T16:40:19.055267Z 0 [Note] WSREP: recv_thread() joined.
2018-08-29T16:40:19.055298Z 0 [Note] WSREP: Closing replication queue.
2018-08-29T16:40:19.055322Z 0 [Note] WSREP: Closing slave action queue.
2018-08-29T16:40:19.055345Z 0 [Note] WSREP: Waiting for active wsrep applier to exit
mysql: [Warning] Using a password on the command line interface can be insecure.
It seems while it is stopping the server it tries to use some command close to the end and that is not responding. Please help.