MySQL Forums
Forum List  »  Security

How to find all slaves of mysql master server
Posted by: vinod ora
Date: October 23, 2017 05:05AM

Is there any standard way to find all slaves of a master server?

From internet I found following approaches:

1st Approach:

Using 'show slave hosts', but it require --report-host and --report-port entry in config file.
Which require server restart, so we can not do that in production.


2nd Approach:
Using
'SELECT Host, STATE FROM information_schema.PROCESSLIST AS p WHERE p.command ='Binlog Dump';'

But it is looks like dirty(hack) way to find all slave of a master.


Please suggest if there any official way to find all slaves of a master server.

Options: ReplyQuote


Subject
Views
Written By
Posted
How to find all slaves of mysql master server
762
October 23, 2017 05:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.