/usr/bin/mysqlrplshow is in mysql-utilities 1.6.1-2.
This file is owned by root:root, with mode 0o755.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 | #!/usr/bin/python
#
# Copyright (c) 2011, 2014, Oracle and/or its affiliates. All rights reserved.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; version 2 of the License.
#
# This program 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 this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
#
"""
This file contains the show replication topology utility. It is used to
find the slaves for a given master and can traverse the list of slaves
checking for additional master/slave connections.
"""
from mysql.utilities.common.tools import check_python_version
# Check Python version compatibility
check_python_version()
import os.path
import sys
from mysql.utilities.exception import UtilError, FormatError
from mysql.utilities.command.show_rpl import show_topology
from mysql.utilities.common.ip_parser import parse_connection
from mysql.utilities.common.tools import check_connector_python
from mysql.utilities.common.options import (add_verbosity, add_format_option,
setup_common_options,
add_ssl_options,
check_password_security)
# Constants
NAME = "MySQL Utilities - mysqlrplshow "
DESCRIPTION = "mysqlrplshow - show slaves attached to a master"
USAGE = "%prog --master=root@localhost:3306 "
PRINT_WIDTH = 75
# Check for connector/python
if not check_connector_python():
sys.exit(1)
if __name__ == '__main__':
# Setup the command parser
parser = setup_common_options(os.path.basename(sys.argv[0]),
DESCRIPTION, USAGE, True, False)
# Setup utility-specific options:
# Connection information for the source server
parser.add_option("--master", action="store", dest="master",
type="string", default="root@localhost:3306",
help="connection information for master server in the "
"form: <user>[:<password>]@<host>[:<port>]"
"[:<socket>] or <login-path>[:<port>][:<socket>]"
" or <config-path>[<[group]>].")
# Show graph option
parser.add_option("-l", "--show-list", action="store_true",
dest="show_list",
help="print a list of the topology.",
default=False)
# Output format
add_format_option(parser, "display the list in either grid (default), "
"tab, csv, or vertical format", "grid")
# Check slaves option - if True, recurse slaves from master to find
# additional master/slave connections
parser.add_option("-r", "--recurse", action="store_true",
dest="recurse",
help="traverse the list of slaves to find additional "
"master/slave connections. User this option to map a "
"replication topology.", default=False)
# Add limit for recursion
parser.add_option("--max-depth", action="store", default=None, type="int",
help="limit the traversal to this depth. Valid only "
"with the --recurse option. Valid values are "
"non-negative integers.",
dest="max_depth")
# Prompt for slave connections if default login/password fail
parser.add_option("-p", "--prompt", action="store_true", dest="prompt",
help="prompt for slave user and password if different "
"from master login.",
default=False)
# Number of retries for failed slave login
parser.add_option("-n", "--num-retries", action="store",
dest="num_retries", type="int",
help="number of retries allowed for failed slave login "
"attempt. Valid with --prompt only.",
default=0)
# Add ssl options
add_ssl_options(parser)
# Add verbosity mode and quiet option
add_verbosity(parser, True)
parser.add_option("--discover-slaves-login", action="store",
dest="discover", default=None, type="string",
help="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=joe:secret will use 'joe' as the user and "
"'secret' as the password for each discovered "
"slave.")
# Now we process the rest of the arguments.
opt, args = parser.parse_args()
# Check security settings
check_password_security(opt, args)
# Fail is --discover-slaves-login not specified
if opt.discover is None:
parser.error("The --discover-slaves-login is required to test slave "
"connectivity.")
# Fail if recurse specified and max-depth is invalid
if opt.recurse and opt.max_depth is not None:
if opt.max_depth < 0:
parser.error("The --max-depth option needs to be >= 0.")
# Parse master connection values
try:
m_values = parse_connection(opt.master, None, opt)
except FormatError:
_, err, _ = sys.exc_info()
parser.error("Master connection values invalid: %s." % err)
except UtilError:
_, err, _ = sys.exc_info()
parser.error("Master connection values invalid: %s." % err.errmsg)
# Create dictionary of options
options = {
'quiet': opt.quiet,
'prompt': opt.prompt,
'num_retries': opt.num_retries,
'recurse': opt.recurse,
'show_list': opt.show_list,
'format': opt.format,
'max_depth': opt.max_depth,
'discover': opt.discover,
'verbosity': opt.verbosity
}
try:
show_topology(m_values, options)
except UtilError:
_, e, _ = sys.exc_info()
print("ERROR: {0}".format(e.errmsg))
sys.exit(1)
sys.exit()
|