MySQL mysqlrplcheck replication check utility
mysqlrplcheck MySQL utility to check MySQL replication between master slave
Usage: mysqlrplcheck --master=root@localhost:3306 --slave=root@localhost:3310
mysqlrplcheck is to check prerequisites for replication between a MySQL master and a slave, to ensure a healthy replication setup.
mysqlrplcheck --help
mysqlrplcheck --version
mysqlrplcheck --master=dbhost1 --slave=dbhost2
mysqlrplcheck --master=dbhost1 --slave=dbhost2 --verbose
mysqlrplcheck --master=master_host --slave=slave_host --vv --width=120
[root@localhost]# mysqlrplcheck --master=mysql1 --slave=mysql2
mysqlrplcheck --master=root@proddb --slave=root@prodslave
mysqlrplcheck --master=root:secret@localhost:3306 --slave=root:secret@localhost:3310 --show-slave-status
mysqlrplcheck --master=root:secret@localhost:3306 --slave=root:secret@localhost:3310 --show-slave-status --verbose --width=200
mysql rpl check command options:
--version show program's version number and exit
--help display a help message and exit
--license display program's license and exit
--master=MASTER connection information for master server in the form:
user[:password]@host[:port][:socket] or login-path[:port][:socket] or config-path[[group]].
--slave=SLAVE connection information for slave server in the form:
user[:password]@host[:port][:socket] or login-path[:port][:socket] or config-path[[group]].
--master-info-file=MASTER_INFO the name of the master information file on the slave. Default = 'master.info' read from the data directory. Note: this option requires that the utility run on the slave with appropriate file read access to the data directory.
-s, --show-slave-status show slave status
--width=WIDTH display width
--suppress suppress warning messages
--ssl-ca=SSL_CA path to a file that contains a list of trusted SSL CAs.
--ssl-cert=SSL_CERT name of the SSL certificate file to use for establishing a secure connection.
--ssl-key=SSL_KEY name of the SSL key file to use for establishing a secure connection.
--ssl=SSL specifies if the server connection requires use of SSL. If an encrypted connection cannot be established, the connection attempt fails. By default 0 (SSL not required).
-v, --verbose control how much information is displayed. e.g., -v = verbose, -vv = more verbose, -vvv = debug
-q, --quiet turn off all messages for quiet execution.
Related MySQL Articles: MySQL mysqlreplicate cheatsheet mysqlrpladmin utility commands
