| Server IP : 39.106.62.82 / Your IP : 216.73.217.83 Web Server : nginx/1.14.1 System : Linux iz2ze1m0zmp2dk5c3j5ap5z 3.10.0-1127.19.1.el7.x86_64 #1 SMP Tue Aug 25 17:23:54 UTC 2020 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /proc/self/root/bin/ |
Upload File : |
#!/usr/bin/python
#
# Copyright (c) 2011, 2016, 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 replicate utility. It is used to establish a
master/slave replication topology among two servers.
"""
import os.path
import sys
from mysql.utilities.common.tools import check_python_version
from mysql.utilities.exception import UtilError, FormatError
from mysql.utilities.command.check_rpl import check_replication
from mysql.utilities.common.options import (add_verbosity, add_ssl_options,
setup_common_options,
check_password_security)
from mysql.utilities.common.ip_parser import parse_connection
from mysql.utilities.common.server import check_hostname_alias
from mysql.utilities.common.tools import check_connector_python
from mysql.utilities.common.messages import (PARSE_ERR_OPTS_REQ,
WARN_OPT_USING_DEFAULT)
# Check Python version compatibility
check_python_version()
# Constants
NAME = "MySQL Utilities - mysqlrplcheck "
DESCRIPTION = "mysqlrplcheck - check replication"
USAGE = "%prog --master=root@localhost:3306 --slave=root@localhost:3310 "
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=None,
help="connection information for master server in the "
"form: <user>[:<password>]@<host>[:<port>]"
"[:<socket>] or <login-path>[:<port>][:<socket>]"
" or <config-path>[<[group]>].")
# Connection information for the destination server
parser.add_option('--slave', action="store", dest="slave",
type="string", default=None,
help="connection information for slave server in the "
"form: <user>[:<password>]@<host>[:<port>]"
"[:<socket>] or <login-path>[:<port>][:<socket>]"
" or <config-path>[<[group]>].")
# Add --master-info-file
parser.add_option("--master-info-file", action="store", dest="master_info",
type="string", default="master.info",
help="the name of the master information file on the "
"slave. Default = 'master.info' read from the data "
"directory. Note: this option requires that the "
"utility run on the slave with appropriate file "
"read access to the data directory.")
# Add --show-slave-status
parser.add_option("--show-slave-status", "-s", action="store_true",
dest="slave_status", default=False,
help="show slave status")
# Add display width option
parser.add_option("--width", action="store", dest="width",
type="int", help="display width",
default=PRINT_WIDTH)
# Add suppress to suppress warning messages
parser.add_option("--suppress", action="store_true", dest="suppress",
default=False, help="suppress warning messages")
# Add ssl options
add_ssl_options(parser)
# Add verbosity
add_verbosity(parser, True)
# Now we process the rest of the arguments.
opt, args = parser.parse_args()
# Check security settings
check_password_security(opt, args)
# option --master is required (mandatory)
if not opt.master:
default_val = 'root@localhost:3306'
print(WARN_OPT_USING_DEFAULT.format(default=default_val,
opt='--master'))
# Print the WARNING to force determinism if a parser error occurs.
sys.stdout.flush()
# option --slave is required (mandatory)
if not opt.slave:
parser.error(PARSE_ERR_OPTS_REQ.format(opt='--slave'))
# Parse source connection values
try:
m_values = parse_connection(opt.master, options=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)
# Parse source connection values
try:
s_values = parse_connection(opt.slave, options=opt)
except FormatError:
_, err, _ = sys.exc_info()
parser.error("Slave connection values invalid: %s." % err)
except UtilError:
_, err, _ = sys.exc_info()
parser.error("Slave connection values invalid: %s." % err.errmsg)
# Check hostname alias
if check_hostname_alias(m_values, s_values):
parser.error("The master and slave are the same host and port.")
# Create dictionary of options
options = {
'verbosity': opt.verbosity,
'pedantic': False,
'quiet': opt.quiet,
'suppress': opt.suppress,
'master_info': opt.master_info,
'slave_status': opt.slave_status,
'width': opt.width
}
try:
res = check_replication(m_values, s_values, options)
if res:
sys.exit(1)
except UtilError:
_, e, _ = sys.exc_info()
print("ERROR: {0}".format(e.errmsg))
sys.exit(1)
sys.exit()