"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "docs/man/mysqlrplshow.1" between
mysql-utilities-1.6.4.tar.gz and mysql-utilities-1.6.5.tar.gz

About: MySQL Utilities is a package of utilities that are used for maintenance and administration of MySQL servers (written in Python).

mysqlrplshow.1  (mysql-utilities-1.6.4):mysqlrplshow.1  (mysql-utilities-1.6.5)
skipping to change at line 16 skipping to change at line 16
SYNOPSIS SYNOPSIS
mysqlrplshow [options] mysqlrplshow [options]
DESCRIPTION DESCRIPTION
This utility shows the replication slaves for a master. It prints a graph of the master and the slaves This utility shows the replication slaves for a master. It prints a graph of the master and the slaves
connected labeling each with the host name and port number. connected labeling each with the host name and port number.
You must specify the --discover-slaves-login option to provide the user n ame and password to discover You must specify the --discover-slaves-login option to provide the user n ame and password to discover
any slaves in the topology. any slaves in the topology.
The discover slaves option requires all slaves use the --report-host and
--report-port server startup
variables with the correct hostname and port. If these are missing or rep
ort the incorrect information,
the slave may not be detected and thus not included in the operation of t
he utility. The discover slaves
option ignores any slaves to which it cannot connect.
To explore the slaves for each client, use the --recurse option. This cau ses the utility to connect to To explore the slaves for each client, use the --recurse option. This cau ses the utility to connect to
each slave found and attempt to determine whether it has any slaves. If s laves are found, the process each slave found and attempt to determine whether it has any slaves. If s laves are found, the process
continues until the slave is found in the list of servers serving as mast ers (a circular topology). The continues until the slave is found in the list of servers serving as mast ers (a circular topology). The
graph displays the topology with successive indents. A notation is made f or circular topologies. graph displays the topology with successive indents. A notation is made f or circular topologies.
If you use the --recurse option, the utility attempts to connect to the s laves using the user name and If you use the --recurse option, the utility attempts to connect to the s laves using the user name and
password provided for the master. By default, if the connection attempt f ails, the utility throws an password provided for the master. By default, if the connection attempt f ails, the utility throws an
error and stops. To change this behavior, use the --prompt option, which permits the utility to prompt 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 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. --num-retries=n option to reattempt a failed connection 'n' times before the utility fails.
skipping to change at line 73 skipping to change at line 78
· tab · tab
Display output in tab-separated format. Display output in tab-separated format.
· vertical · vertical
Display output in single-column format like that of the \G command fo r the mysql client command-line Display output in single-column format like that of the \G command fo r the mysql client command-line
tool. tool.
The utility uses of the SHOW SLAVE HOSTS statement to determine which sla ves the master has. If you want The utility uses of the SHOW SLAVE HOSTS statement to determine which sla ves the master has. If you want
to use the --recurse option, slaves should have been started with the --r eport-host and --report-port to use the --recurse option, slaves must have been started with the --rep ort-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 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 th e following command-line slaves to determine their own slaves. OPTIONS.PP mysqlrplshow accepts th e following command-line
options: options:
· --help · --help
Display a help message and exit. Display a help message and exit.
· --license · --license
Display license information and exit. Display license information and exit.
· --discover-slaves-login=<slave-login> · --discover-slaves-login=slave-login
Supply the user and password in the form <user>[:<passwd>] or <login- Supply the user and password in the form user[:passwd] or login-path
path> for discovering slaves for discovering slaves and
and relay slaves in the topology. For example, --discover=joe:secret relay slaves in the topology. For example, --discover=joe:secret uses
will use 'joe' as the user and 'joe' as the user and 'secret'
'secret' as the password for each discovered slave. as the password for each discovered slave.
· --format=<format>, -f<format> · --format=format, -fformat
Specify the display format for column list output. Permitted format v alues are grid, csv, tab, and Specify the display format for column list output. Permitted format v alues are grid, csv, tab, and
vertical. The default is grid. This option applies only if --show-lis t is given. vertical. The default is grid. This option applies only if --show-lis t is given.
· --master=<source> · --master=source
Connection information for the master server. Connection information for the master server.
To connect to a server, it is necessary to specify connection paramet ers such as the user name, host To connect to a server, it is necessary to specify connection paramet ers such as the user name, host
name, password, and either a port or socket. MySQL Utilities provides a number of ways to supply 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 v ia a command-line option such this information. All of the methods require specifying your choice v ia a command-line option such
as --server, --master, --slave, etc. The methods include the followin g in order of most secure to as --server, --master, --slave, etc. The methods include the followin g in order of most secure to
least secure. least secure.
· Use login-paths from your .mylogin.cnf file (encrypted, not visib le). Example : · Use login-paths from your .mylogin.cnf file (encrypted, not visib le). Example :
<login-path>[:<port>][:<socket>] login-path[:port][:socket]
· Use a configuration file (unencrypted, not visible) Note: availab le in release-1.5.0. Example : · Use a configuration file (unencrypted, not visible) Note: availab le in release-1.5.0. Example :
<configuration-file-path>[:<section>] configuration-file-path[:section]
· Specify the data on the command-line (unencrypted, visible). Exam ple : · Specify the data on the command-line (unencrypted, visible). Exam ple :
<user>[:<passwd>]@<host>[:<port>][:<socket>] user[:passwd]@host[:port][:socket]
· --max-depth=<N> · --max-depth=N
The maximum recursion depth. This option is valid only if --recurse i s given. The maximum recursion depth. This option is valid only if --recurse i s given.
· --num-retries=<num_retries>, -n<num_retries> · --num-retries=num_retries, -nnum_retries
The number of retries permitted for failed slave login attempts. This option is valid only if The number of retries permitted for failed slave login attempts. This option is valid only if
--prompt is given. --prompt is given.
· --prompt, -p · --prompt, -p
Prompt for the slave user and password if different from the master u ser and password. Prompt for the slave user and password if different from the master u ser and password.
If you give this option, the utility sets --num-retries to 1 if that option is not set explicitly. 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 na me and password should a This ensures at least one attempt to retry and prompt for the user na me and password should a
skipping to change at line 154 skipping to change at line 159
Display a column list of the topology. Display a column list of the topology.
· --ssl-ca · --ssl-ca
The path to a file that contains a list of trusted SSL CAs. The path to a file that contains a list of trusted SSL CAs.
· --ssl-cert · --ssl-cert
The name of the SSL certificate file to use for establishing a secure connection. The name of the SSL certificate file to use for establishing a secure connection.
· --ssl-cert · --ssl-key
The name of the SSL key file to use for establishing a secure connect ion. The name of the SSL key file to use for establishing a secure connect ion.
· --ssl · --ssl
Specifies if the server connection requires use of SSL. If an encrypt ed connection cannot be Specifies if the server connection requires use of SSL. If an encrypt ed connection cannot be
established, the connection attempt fails. Default setting is 0 (SSL not required). established, the connection attempt fails. Default setting is 0 (SSL not required).
· --verbose, -v · --verbose, -v
Specify how much information to display. If this option is used, the IO thread status of each slave 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 amo unt of information. For is also displayed. Use this option multiple times to increase the amo unt of information. For
example, -v = verbose, -vv = more verbose, -vvv = debug. If you use - example, -v = verbose, -vv = more verbose, -vvv = debug. If you use -
vvv, the output will contain vvv, the output contains the
the state of the IO and SQL threads for each slave. state of the IO and SQL threads for each slave.
· --version · --version
Display version information and exit. Display version information and exit.
NOTES.PP The login user must have the REPLICATE SLAVE and REPLICATE CLIEN T privileges to successfully NOTES.PP The login user must have the REPLICATE SLAVE and REPLICATE CLIEN T privileges to successfully
execute this utility. Specifically, the login user must have appropriate permissions to execute SHOW execute this utility. Specifically, the login user must have appropriate permissions to execute SHOW
SLAVE STATUS, SHOW MASTER STATUS, and SHOW SLAVE HOSTS. 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 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, --form at=g specifies the grid format. specified as any unambiguous prefix of a valid value. For example, --form at=g specifies the grid format.
An error occurs if a prefix matches more than one valid value. An error occurs if a prefix matches more than one valid value.
Mixing IP and hostnames is not recommended. The replication-specific util ities will attempt to compare Mixing IP and hostnames is not recommended. The replication-specific util ities attempt to compare
hostnames and IP addresses as aliases for checking slave connectivity to the master. However, if your 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 f ail. Without the ability to do installation does not support reverse name lookup, the comparison could f ail. Without the ability to do
a reverse name lookup, the replication utilities could report a false neg ative that the slave is (not) a reverse name lookup, the replication utilities could report a false neg ative that the slave is (not)
connected to the master. connected to the master.
For example, if you setup replication using MASTER_HOST=ubuntu.net on the slave and later connect to the 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.16 8.0.6 using the valid IP slave with mysqlrplcheck and have the master specified as --master=192.16 8.0.6 using the valid IP
address for ubuntu.net, you must have the ability to do a reverse name lo okup to compare the IP address for ubuntu.net, you must have the ability to do a reverse name lo okup to compare the IP
(192.168.0.6) and the hostname (ubuntu.net) to determine if they are the same machine. (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 environ ment variable in order to use The path to the MySQL client tools should be included in the PATH environ ment variable in order to use
the authentication mechanism with login-paths. This will allow the utilit y to use the my_print_defaults the authentication mechanism with login-paths. This permits the utility t o use the my_print_defaults
tools which is required to read the login-path values from the login conf iguration file (.mylogin.cnf). tools which is required to read the login-path values from the login conf iguration file (.mylogin.cnf).
EXAMPLES.PP To show the slaves for a master running on port 3311 on the l ocal host, use the following EXAMPLES.PP To show the slaves for a master running on port 3311 on the l ocal host, use the following
command: command:
shell> mysqlrplshow --master=root@localhost:3311 --discover-slaves-l ogin=root shell> mysqlrplshow --master=root@localhost:3311 --discover-slaves-l ogin=root
# master on localhost: ... connected. # master on localhost: ... connected.
# Finding slaves for master: localhost:3311 # Finding slaves for master: localhost:3311
# Replication Topology Graph # Replication Topology Graph
localhost:3311 (MASTER) localhost:3311 (MASTER)
| |
skipping to change at line 285 skipping to change at line 290
+--- localhost:3333 - (SLAVE + MASTER) +--- localhost:3333 - (SLAVE + MASTER)
| |
+--- localhost:3334 - (SLAVE) +--- localhost:3334 - (SLAVE)
PERMISSIONS REQUIRED.PP The user connected to the master must have the RE PLICATION SLAVE privilege. PERMISSIONS REQUIRED.PP The user connected to the master must have the RE PLICATION SLAVE privilege.
The user specified with the --discover-slaves-login option that logs into each slave must have the The user specified with the --discover-slaves-login option that logs into each slave must have the
REPLICATION CLIENT privilege. REPLICATION CLIENT privilege.
COPYRIGHT COPYRIGHT
Copyright © 2006, 2016, Oracle and/or its affiliates. All rights reserved . Copyright © 2006, 2017, Oracle and/or its affiliates. All rights reserved .
This documentation is free software; you can redistribute it and/or modif y it only under the terms of This documentation is free software; you can redistribute it and/or modif y it only under the terms of
the GNU General Public License as published by the Free Software Foundati on; version 2 of the License. the GNU General Public License as published by the Free Software Foundati on; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without 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 even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General
Public License for more details. Public License for more details.
You should have received a copy of the GNU General Public License along w ith the program; if not, write You should have received a copy of the GNU General Public License along w ith the program; if not, write
to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, B oston, MA 02110-1301 USA or see to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, B oston, MA 02110-1301 USA or see
http://www.gnu.org/licenses/. http://www.gnu.org/licenses/.
SEE ALSO SEE ALSO
For more information, please refer to the MySQL Utilities and Fabric docu mentation, which is available For more information, please refer to the MySQL Utilities and Fabric docu mentation, which is available
online at http://dev.mysql.com/doc/index-utils-fabric.html online at http://dev.mysql.com/doc/index-utils-fabric.html
AUTHOR AUTHOR
Oracle Corporation (http://dev.mysql.com/). Oracle Corporation (http://dev.mysql.com/).
MySQL 1.6.3 08/01/2016 MYSQLRPLSHOW(1) MySQL 1.6.4 01/14/2017 MYSQLRPLSHOW(1)
 End of changes. 17 change blocks. 
21 lines changed or deleted 29 lines changed or added

Home  |  About  |  All  |  Newest  |  Fossies Dox  |  Screenshots  |  Comments  |  Imprint  |  Privacy  |  HTTPS