/usr/bin/mysqlrplshow is in mysql-utilities 1.0.5-1.
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 | #!/usr/bin/python
#
# Copyright (c) 2011, 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.
"""
import optparse
import os.path
import sys
from mysql.utilities.exception import UtilError
from mysql.utilities.common.options import setup_common_options
from mysql.utilities.common.options import parse_connection, add_verbosity
from mysql.utilities.common.options import add_format_option
from mysql.utilities.command.show_rpl import show_topology
from mysql.utilities.exception import FormatError
from mysql.utilities import VERSION_FRM
# Constants
NAME = "MySQL Utilities - mysqlrplshow "
DESCRIPTION = "mysqlrplshow - show slaves attached to a master"
USAGE = "%prog --master=root@localhost:3306 "
PRINT_WIDTH = 75
# 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>")
# 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 quiet
parser.add_option("-q", "--quiet", action="store_true", dest="quiet",
help="turn off all messages for quiet execution.")
# Now we process the rest of the arguments.
opt, args = parser.parse_args()
# 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)
except FormatError, e:
parser.error("Master connection values invalid or cannot be parsed.")
# 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,
}
try:
res = show_topology(m_values, options)
if res:
exit(1)
except UtilError, e:
print "ERROR:", e.errmsg
exit(1)
exit()
|