Download MySQL Utilities - Oracle Documentation

NOTES
To connect to a server, it is necessary to specify connection parameters such as user name, host
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 via a command-line option such as -server, --master, --slave, etc. The methods include the following in order of most secure to least secure.
• Use login-paths from your .mylogin.cnf file (encrypted, not visible). Example : <login-path>[:<port>]
[:<socket>]
• Use a configuration file (unencrypted, not visible) Note: available in release-1.5.0. Example :
<configuration-file-path>[:<section>]
• Specify the data on the command-line (unencrypted, visible). Example :
<user>[:<passwd>]@<host>[:<port>][:<socket>]
• --ssl-ca
The path to a file that contains a list of trusted SSL CAs.
• --ssl-cert
The name of the SSL certificate file to use for establishing a secure connection.
• --ssl-key
The name of the SSL key file to use for establishing a secure connection.
• --ssl
Specifies if the server connection requires use of SSL. If an encrypted connection cannot be established,
the connection attempt fails. Default setting is 0 (SSL not required).
• --timeout=<seconds>
Maximum timeout in seconds to wait for each replication command to complete. For example, timeout for
slave waiting to catch up to master.
Default = 3.
• --verbose, -v
Specify how much information to display. Use this option multiple times to increase the amount of
information. For example, -v = verbose, -vv = more verbose, -vvv = debug.
• --version
Display version information and exit.
NOTES
The login user must have the appropriate permissions for the utility to check servers and monitor
their status (e.g., SHOW SLAVE STATUS, SHOW MASTER STATUS). The user must also
have permissions to execute the failover procedure (e.g., STOP SLAVE, START SLAVE,
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS, CHANGE MASTER TO ...). Lastly, the user must have the
REPLICATE SLAVE privilege for slaves to connect to their master. The same permissions are required
by the failover utility for master and slaves in order to run successfully. In particular, users connected to
slaves, candidates and master require SUPER, GRANT OPTION, REPLICATION SLAVE, RELOAD,
DROP, CREATE, INSERT and SELECT privileges.
135