Notice the use of the mysqlrplshow utility. Not only did it show us the slaves attached to the master, it also displayed the state of the IO and SQL thread for each slave.

We used the master server for the --master option but for the slaves, we provided the option --discover-slaves-login which provides the user name and password for the account used to connect to each slave. Without this, we would not be able to determine if the slave is attached (currently) or the state of its threads.

The --discover-slaves-login option applies to all slaves. If you do not have the same user defined on all of your slaves, you can use the --prompt option to prompt for the user and password for each slave.

To get the state of the slave threads, use the --verbose option.

User Comments
Sign Up Login You must be logged in to post a comment.