help="changes the size of the key used for compare table contents. A "
"higher value can help to get more accurate results comparing "
"large databases, but may slow the algorithm. Default value is "
"{0}.".format(DEFAULT_SPAN_KEY_SIZE)
)
# add the use indexes option
parser.add_option(
"--use-indexes", action="store", type="string", default='',
dest="use_indexes",
help="for each table, indicate which index to use as if were a "
"primary key (each of his columns must not allow null values)."
)
# Add verbosity and quiet (silent) mode
add_verbosity(parser, True)
# Add difftype option
add_difftype(parser, True)
# Add the direction (changes-for)
add_changes_for(parser)
# Add show reverse option
add_reverse(parser)
# Add regexp
add_regexp(parser)
# Add ssl options
add_ssl_options(parser)
parser.add_option("-x", "--exclude", action="append", dest="exclude",
type="string", default=None, help="exclude one or more "
"objects from the operation using either a specific name "
"(e.g. db1.t1), a LIKE pattern (e.g. db1.t% or db%.%) or a "
"REGEXP search pattern. To use a REGEXP search pattern for "
"all exclusions, you must also specify the --regexp option. "
"Repeat the --exclude option for multiple exclusions.")
# Add the all database options
add_all(parser, "databases")
# Add the skip common options
add_skip_options(parser)
# Add verbosity and quiet (silent) mode
add_verbosity(parser, True)
# Add engine options
add_engines(parser)
# Add locking options
add_locking(parser)
# Add regexp
add_regexp(parser)
# Replication user and password
add_rpl_user(parser, None)
# Add replication options but don't include 'both'
add_rpl_mode(parser, False, False)
# Add --datadir option
parser.add_option("--datadir", action="store", dest="datadir", default=None,
type="string", help="the data directory for the server")
# Add --search-port
parser.add_option("--port-range", action="store", dest="ports",
default="3306:3333",
type="string", help="the port range to search for running"
" mysql servers on Windows systems")
# Add --show-servers option
parser.add_option("--show-servers", action="store_true", dest="show_servers",
help="show any known MySQL servers running on this host")
# Add verbosity mode
add_verbosity(parser, False)
# Now we process the rest of the arguments.
opt, args = parser.parse_args()
# Check port range
if os.name == 'nt':
parts = opt.ports.split(":")
if len(parts) != 2:
print "# WARNING : %s is not a valid port range. Using default." % \
opt.ports
opt.ports = "3306:3333"
# Set options for database operations.
options = {
"format" : opt.format,
parser.add_option(
"-b",
"--start-from-beginning",
action="store_true",
default=False,
dest="from_beginning",
help="start replication from the first event recorded "
"in the binary logging of the master. Not valid "
"with --master-log-file or --master-log-pos.",
)
# Add ssl options
add_ssl_options(parser)
# Add verbosity
add_verbosity(parser)
# 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)
# Add the maximum age of log entries in days for the logging system
parser.add_option("--log-age",
action="store",
dest="log_age",
default=7,
type="int",
help="specify maximum age of log entries in "
"days. Entries older than this will be purged on "
"startup. Default = 7 days.")
# Add ssl options
add_ssl_options(parser)
# Add verbosity
add_verbosity(parser)
# Now we process the rest of the arguments.
opt, args = parser.parse_args()
# Check security settings
check_password_security(opt, args)
# Check if the values specified for the --report-values option are valid.
for report in opt.report_values.split(","):
if report.lower() not in ("health", "gtid", "uuid"):
parser.error("The value for the option --report-values is not "
"valid: '{0}', the values allowed are 'health', "
"'gitd' or 'uuid'".format(opt.report_values))
# Check for errors
# Set limit for best
parser.add_option("--best",
action="store",
dest="best",
default=None,
help="limit index statistics to the best N indexes")
# Set limit for worst
parser.add_option("--worst",
action="store",
dest="worst",
default=None,
help="limit index statistics to the worst N indexes")
# Add verbosity mode
add_verbosity(parser, False)
# Now we process the rest of the arguments.
opt, args = parser.parse_args()
# Check to make sure at least one table specified.
if len(args) == 0:
parser.error("You must specify at least one table or database to check.")
PERMITTED_FORMATS = ("SQL", "GRID", "TAB", "CSV", "VERTICAL")
if opt.index_format.upper() not in PERMITTED_FORMATS:
print "WARNING : '%s' is not a valid index format. Using default." % \
opt.index_format
opt.index_format = "GRID"
else:
dest="binlog", default=None, type="string",
help="Binlog file name to keep (not to purge). All the "
"binary log files prior to the specified file will be "
"removed.")
# Add the --discover-slaves-login option.
add_discover_slaves_option(parser)
# Add the --master option.
add_master_option(parser)
# Add the --slaves option.
add_slaves_option(parser)
# Add verbosity
add_verbosity(parser, quiet=False)
# Now we process the rest of the arguments.
opt, args = parser.parse_args()
server_val = None
master_val = None
slaves_val = None
if opt.server and opt.master:
parser.error(PARSE_ERR_OPTS_EXCLD.format(opt1="--server",
opt2="--master"))
if opt.master is None and opt.slaves:
parser.error(PARSE_ERR_OPT_REQ_OPT.format(opt="--slaves",
opts="--master"))
False,
True,
server_default=None,
extended_help=EXTENDED_HELP,
add_ssl=True)
# Do not Purge binlog, instead print info
parser.add_option("--min-size",
action="store",
dest="min_size",
type="int",
help="rotate the active binlog file only if the file "
"size exceeds the specified value in bytes.")
# Add verbosity
add_verbosity(parser, quiet=False)
# Now we process the rest of the arguments.
opt, args = parser.parse_args()
# Check mandatory options: --server
if not opt.server:
parser.error(PARSE_ERR_OPTS_REQ.format(opt="--server"))
servers_val = None
# Parse source connection values if --server provided or default
try:
ssl_opts = get_ssl_dict(opt)
server_val = parse_connection(opt.server, None, ssl_opts)
except FormatError as err:
# pylint: disable=E1101
