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
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.
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