In the mysqlreplicate utility we could have also used the --test-db option which creates a dummy database to test the replication setup. However, the mysqlrplcheck provides more detailed information in that regard.
As previously stated, the -b option tells the utility to start replication from the first event recorded in the master's binary log. Omitting this flag, in turn, makes the slaves replicate only what is stored in the master's binary log from the present moment onward.
Furthermore, using the
options it is possible to specify respectively the master log
file and the master log position from which the slave will
start its replication process.
The -p flag can be used to ensure that the replication setup is only executed in case the storage engines match in both the master and the slave.
Regarding the mysqlrplcheck utility, we can
use the -s option to check the output of the show slave status
command. This can be useful for instance to check what might
be causing the "Is slave connected" test to fail. We can also
option to specify the name of the master information file to
Lastly, we can use the
--verbose option in
order to get more information about what is happening "under