mysqlrplshow(1)
NAME
mysqlrplshow - Show Slaves for Master Server
SYNOPSIS
mysqlrplshow [options]
DESCRIPTION
This utility shows the replication slaves for a master. It prints a
graph of the master and its slaves labeling each with the host name and
port number.
You must specify the --discover-slaves-login option to provide the user
name and password to discover any slaves in the topology.
To explore the slaves for each client, use the --recurse option. This
causes the utility to connect to each slave found and attempt to
determine whether it has any slaves. If slaves are found, the process
continues until the slave is found in the list of servers serving as
masters (a circular topology). The graph displays the topology with
successive indents. A notation is made for circular topologies.
If you use the --recurse option, the utility attempts to connect to the
slaves using the user name and password provided for the master. By
default, if the connection attempt fails, the utility throws an error
and stops. To change this behavior, use the --prompt option, which
permits the utility to prompt for the user name and password for each
slave that fails to connect. You can also use the --num-retries=n
option to reattempt a failed connection 'n' times before the utility
fails.
An example graph for a typical topology with relay slaves is shown
here:
# Replication Topology Graph::
localhost:3311 (MASTER)
|
+--- localhost:3310 - (SLAVE)
|
+--- localhost:3312 - (SLAVE + MASTER)
|
+--- localhost:3313 - (SLAVE)
MASTER, SLAVE, and SLAVE+MASTER indicate that a server is a master
only, slave only, and both slave and master, respectively.
A circular replication topology is shown like this, where <-->
indicates circularity:
# Replication Topology Graph
localhost:3311 (MASTER)
|
+--- localhost:3312 - (SLAVE + MASTER)
|
+--- localhost:3313 - (SLAVE + MASTER)
|
+--- localhost:3311 <--> (SLAVE)
To produce a column list in addition to the graph, specify the
--show-list option. In this case, to specify how to display the list,
use one of the following values with the --format option:
* grid (default)
Display output in grid or table format like that of the mysql
client command-line tool.
* csv
Display output in comma-separated values format.
* tab
Display output in tab-separated format.
* vertical
Display output in single-column format like that of the \G command
for the mysql client command-line tool.
The utility uses of the SHOW SLAVE HOSTS statement to determine which
slaves the master has. If you want to use the --recurse option, slaves
should have been started with the --report-host and --report-port
options set to their actual host name and port number or the utility
may not be able to connect to the slaves to determine their own slaves.
OPTIONS.PP mysqlrplshow accepts the following command-line options:
* --help
Display a help message and exit.
* --license
Display license information and exit.
* --discover-slaves-login=<slave-login>
Supply the user and password in the form <user>[:<passwd>] or
<login-path> for discovering slaves and relay slaves in the
topology. For example, --discover=joe:secret will use 'joe' as the
user and 'secret' as the password for each discovered slave.
* --format=<format>, -f<format>
Specify the display format for column list output. Permitted format
values are grid, csv, tab, and vertical. The default is grid. This
option applies only if --show-list is given.
* --master=<source>
Connection information for the master server.
To connect to a server, it is necessary to specify connection
parameters such as user name, host name, password, and either a
port or socket. MySQL Utilities provides a number of ways to supply
this information. All of the methods require specifying your choice
via a command-line option such as --server, --master, --slave, etc.
The methods include the following in order of most secure to least
secure.
* Use login-paths from your .mylogin.cnf file (encrypted, not
visible). Example : <login-path>[:<port>][:<socket>]
* Use a configuration file (unencrypted, not visible) Note:
available in release-1.5.0. Example :
<configuration-file-path>[:<section>]
* Specify the data on the command-line (unencrypted, visible).
Example : <user>[:<passwd>]@<host>[:<port>][:<socket>]
* --max-depth=<N>
The maximum recursion depth. This option is valid only if --recurse
is given.
* --num-retries=<num_retries>, -n<num_retries>
The number of retries permitted for failed slave login attempts.
This option is valid only if --prompt is given.
* --prompt, -p
Prompt for the slave user and password if different from the master
user and password.
If you give this option, the utility sets --num-retries to 1 if
that option is not set explicitly. This ensures at least one
attempt to retry and prompt for the user name and password should a
connection fail.
* --quiet, -q
Turn off all messages for quiet execution. This option does not
suppress errors or warnings.
* --recurse, -r
Traverse the list of slaves to find additional master/slave
connections. User this option to map a replication topology.
* --show-list, -l
Display a column list of the topology.
* --ssl-ca
The path to a file that contains a list of trusted SSL CAs.
* --ssl-cert
The name of the SSL certificate file to use for establishing a
secure connection.
* --ssl-cert
The name of the SSL key file to use for establishing a secure
connection.
* --ssl
Specifies if the server connection requires use of SSL. If an
encrypted connection cannot be established, the connection attempt
fails. Default setting is 0 (SSL not required).
* --verbose, -v
Specify how much information to display. If this option is used,
the IO thread status of each slave is also displayed. Use this
option multiple times to increase the amount of information. For
example, -v = verbose, -vv = more verbose, -vvv = debug. If you use
-vvv, the output will contain the state of the IO and SQL threads
for each slave.
* --version
Display version information and exit.
NOTES.PP The login user must have the REPLICATE SLAVE and REPLICATE
CLIENT privileges to successfully execute this utility. Specifically,
the login user must have appropriate permissions to execute SHOW SLAVE
STATUS, SHOW MASTER STATUS, and SHOW SLAVE HOSTS.
For the --format option, the permitted values are not case sensitive.
In addition, values may be specified as any unambiguous prefix of a
valid value. For example, --format=g specifies the grid format. An
error occurs if a prefix matches more than one valid value.
Mixing IP and hostnames is not recommended. The replication-specific
utilities will attempt to compare hostnames and IP addresses as aliases
for checking slave connectivity to the master. However, if your
installation does not support reverse name lookup, the comparison could
fail. Without the ability to do a reverse name lookup, the replication
utilities could report a false negative that the slave is (not)
connected to the master.
For example, if you setup replication using MASTER_HOST=ubuntu.net on
the slave and later connect to the slave with mysqlrplcheck and have
the master specified as --master=192.168.0.6 using the valid IP address
for ubuntu.net, you must have the ability to do a reverse name lookup
to compare the IP (192.168.0.6) and the hostname (ubuntu.net) to
determine if they are the same machine.
The path to the MySQL client tools should be included in the PATH
environment variable in order to use the authentication mechanism with
login-paths. This will allow the utility to use the my_print_defaults
tools which is required to read the login-path values from the login
configuration file (.mylogin.cnf). EXAMPLES.PP To show the slaves for
a master running on port 3311 on the local host, use the following
command:
shell> mysqlrplshow --master=root@localhost:3311 --discover-slaves-login=root
# master on localhost: ... connected.
# Finding slaves for master: localhost:3311
# Replication Topology Graph
localhost:3311 (MASTER)
|
+--- localhost:3310 - (SLAVE)
|
+--- localhost:3312 - (SLAVE)
As shown in the example, you must provide valid login information for
the master.
To show additional information about the IO thread status (to confirm
if the slaves are really connected to the master) use the option
--verbose:
shell> mysqlrplshow --master=root@localhost:3311 --discover-slaves-login=root --verbose
# master on localhost: ... connected.
# Finding slaves for master: localhost:3311
# Replication Topology Graph
localhost:3311 (MASTER)
|
+--- localhost:3310 [IO: Yes, SQL: Yes] - (SLAVE)
|
+--- localhost:3312 [IO: Yes, SQL: Yes] - (SLAVE)
To show the full replication topology of a master running on the local
host, use the following command:
shell> mysqlrplshow --master=root@localhost:3311 --recurse --discover-slaves-login=root
# master on localhost: ... connected.
# Finding slaves for master: localhost:3311
# Replication Topology Graph
localhost:3311 (MASTER)
|
+--- localhost:3310 - (SLAVE)
|
+--- localhost:3312 - (SLAVE + MASTER)
|
+--- localhost:3313 - (SLAVE)
To show the full replication topology of a master running on the local
host, prompting for the user name and password for slaves that do not
have the same user name and password credentials as the master, use the
following command:
shell> mysqlrplshow --recurse --prompt --num-retries=1 \
--master=root@localhost:3331 --discover-slaves-login=root
Server localhost:3331 is running on localhost.
# master on localhost: ... connected.
# Finding slaves for master: localhost:3331
Server localhost:3332 is running on localhost.
# master on localhost: ... FAILED.
Connection to localhost:3332 has failed.
Please enter the following information to connect to this server.
User name: root
Password:
# master on localhost: ... connected.
# Finding slaves for master: localhost:3332
Server localhost:3333 is running on localhost.
# master on localhost: ... FAILED.
Connection to localhost:3333 has failed.
Please enter the following information to connect to this server.
User name: root
Password:
# master on localhost: ... connected.
# Finding slaves for master: localhost:3333
Server localhost:3334 is running on localhost.
# master on localhost: ... FAILED.
Connection to localhost:3334 has failed.
Please enter the following information to connect to this server.
User name: root
Password:
# master on localhost: ... connected.
# Finding slaves for master: localhost:3334
# Replication Topology Graph
localhost:3331 (MASTER)
|
+--- localhost:3332 - (SLAVE)
|
+--- localhost:3333 - (SLAVE + MASTER)
|
+--- localhost:3334 - (SLAVE)
PERMISSIONS REQUIRED.PP The user connected to the master must have the
REPLICATION SLAVE privilege.
The user specified with the --discover-slaves-login option that logs
into each slave must have the REPLICATION CLIENT privilege.
COPYRIGHT
Copyright 2006, 2016, Oracle and/or its affiliates. All rights reserved. This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License. This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Utilities and Fabric documentation, which is available online at http://dev.mysql.com/doc/index-utils-fabric.html
AUTHOR
Oracle Corporation (http://dev.mysql.com/).
Opportunity
Personal Opportunity - Free software gives you access to billions of dollars of software at no cost. Use this software for your business, personal use or to develop a profitable skill. Access to source code provides access to a level of capabilities/information that companies protect though copyrights. Open source is a core component of the Internet and it is available to you. Leverage the billions of dollars in resources and capabilities to build a career, establish a business or change the world. The potential is endless for those who understand the opportunity.
Business Opportunity - Goldman Sachs, IBM and countless large corporations are leveraging open source to reduce costs, develop products and increase their bottom lines. Learn what these companies know about open source and how open source can give you the advantage.
Free Software
Free Software provides computer programs and capabilities at no cost but more importantly, it provides the freedom to run, edit, contribute to, and share the software. The importance of free software is a matter of access, not price. Software at no cost is a benefit but ownership rights to the software and source code is far more significant.
Free Office Software - The Libre Office suite provides top desktop productivity tools for free. This includes, a word processor, spreadsheet, presentation engine, drawing and flowcharting, database and math applications. Libre Office is available for Linux or Windows.
Free Books
The Free Books Library is a collection of thousands of the most popular public domain books in an online readable format. The collection includes great classical literature and more recent works where the U.S. copyright has expired. These books are yours to read and use without restrictions.
Source Code - Want to change a program or know how it works? Open Source provides the source code for its programs so that anyone can use, modify or learn how to write those programs themselves. Visit the GNU source code repositories to download the source.
Education
Study at Harvard, Stanford or MIT - Open edX provides free online courses from Harvard, MIT, Columbia, UC Berkeley and other top Universities. Hundreds of courses for almost all major subjects and course levels. Open edx also offers some paid courses and selected certifications.
Linux Manual Pages - A man or manual page is a form of software documentation found on Linux/Unix operating systems. Topics covered include computer programs (including library and system calls), formal standards and conventions, and even abstract concepts.
