Find us on Google+ Google+

February 3, 2019

MySQL mysqlrplshow utility

mysqlrplshow utility commands in MySQL

mysqlrplshow      Show slaves attached to a master

mysqlrplshow utility shows the MySQL replication slaves for a master. And prints a graph of the master and the slaves connected labeling each with the host name and port number.

Usage: mysqlrplshow --master=root@localhost:3306

mysqlrplshow --help

mysqlrplshow --version

mysqlrplshow --master=dbhost1 --discover-slaves-login=monitor

mysqlrplshow --master=dbhost2 --discover-slaves-login=dba --verbose

[root@localhost]# mysqlrplshow --master=mylogin --discover-slaves-login=mylogin -v

mysqlrplshow --master=root:secret@proddb:3306 --discover-slaves-login=root:secret

mysqlrplshow --master=root:secret@proddb:3310 --discover-slaves-login=root:secret --show-list --format=tab

mysqlrplshow --master=root@localhost:3310 --recurse --discover-slaves-login=root

mysqlrplshow --master=mysql-dba --recurse --prompt --num-retries=1 --discover-slaves-login=root


mysql rpl show 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]].
  -l, --show-list       print a list of the topology.

  -f FORMAT, --format=FORMAT  display the list in either grid (default), tab, csv, or vertical format
  -r, --recurse         traverse the list of slaves to find additional  master/slave connections. User this option to map a replication topology.
  --max-depth=MAX_DEPTH limit the traversal to this depth. Valid only with the --recurse option. Valid values are non-negative integers.
  -p, --prompt          prompt for slave user and password if different from master login.
  -n NUM_RETRIES, --num-retries=NUM_RETRIES   number of retries allowed for failed slave login attempt. Valid with --prompt only.

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

  --discover-slaves-login=DISCOVER  at startup, query master for all registered slaves and use the user name and password specified to connect. Supply the user and password in the form user[:password] or login-path. For example, --discover-slaves-login=satya:secret will use 'satya' as the user and 'secret' as the password for each discovered slave.

Related MySQL Articles: mysqlrpladmin utility commands mysqlrplcheck replication check utility


No comments:

Post a Comment