SHOW SLAVE HOSTS shows incorrect output

Question

I had used --report-host option in one of my slaves, so that I could see that under SHOW SLAVE HOSTS. Now that server is no longer in use. I have uninstalled that server as well. Unfortunately I still see the details of that server under SHOW SLAVE HOSTS(When this is executed on the uninstalled server's master) which is incorrect.

What changes should I make such that SHOW SLAVE HOSTS gives me the correct output?

Answer 1

You will have to check the following items

• If the decommissioned Slave server still has /etc/my.cnf, do one of the following
  • rm -f /etc/my.cnf
  • mv /etc/my.cnf /etc/my.cnf.old
• If the Master Server still has any --report-host in its /etc/my.cnf
  • remove report-host from /etc/my.cnf
  • service mysql restart
• You may need service mysql restart on the Master anyway
• Make sure you delete master.info in the datadir of the old Slave

Give it a Try !!!