In the above example we made use of the
mysqlreplicate utility to setup a two layer
replication topology, where the existing server is now the
master for the two new servers which will act as slaves.
Notice how we used the address of the old existing server in
--master option and
--slave option we
used the addresses of the new servers. Also notice the use of
the -b flag, this makes replication start from the first event
recorded in the master's binary log.
Also notice how we used the mysqlrplcheck utility to check the health of the replication. In this case, the failing test "Check slave delay" is expected, since the slaves are catching up with the master. When the slaves have read and applied all the transactions from the master's binary log the "Check slave delay" test will pass. Also, in case the slave wasn't properly configured and pointing to the master specified the "Is slave connect to master" test would notify us of that with a FAIL or WARN status.