We have a master-master replication setup using MySQL 5.5. On one of the servers I am trying to stop the slave thread, but without success. To ensure that the replication does not connect to a real server, I set
MASTER_HOST to a nonexistent address. I have run the
STOP SLAVE command multiple times, but I am still seeing
Slave_SQL_Running: Yes when I run
SHOW SLAVE STATUS;.
This is what gets logged (every few seconds):
[Note] Error reading relay log event: slave SQL thread was killed [ERROR] Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Error_code: 1593 [Note] Slave I/O thread killed while connecting to master [Note] Slave I/O thread exiting, read up to log 'FIRST', position 4 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/var/log/mysql/mysql01-relay-bin.000002' position: 4
I want all the replication threads to go away. How can I do this?