January 24, 2019

MySQL mysqlrplcheck utility commands

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

1 comment: