mysqlfailover(1) - Linux man page

Name

Synopsis

Description

Options

--version

show program's version number and exit

--help

--candidates=CANDIDATES

connection information for candidate slave servers for failover in the form: <user>[:<password>]@<host>[:<port>][:<socket>] or <login-path>[:<port>][:<socket>]. Valid only with failover command. List multiple slaves in commaseparated list.

--discover-slaves-login=DISCOVER

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.

--exec-after=EXEC_AFTER

name of script to execute after failover or switchover

--exec-before=EXEC_BEFORE

name of script to execute before failover or switchover

--log=LOG_FILE

specify a log file to use for logging messages

--log-age=LOG_AGE

specify maximum age of log entries in days. Entries older than this will be purged on startup. Default = 7 days.

--master=MASTER

connection information for master server in the form: <user>[:<password>]@<host>[:<port>][:<socket>] or <login-path>[:<port>][:<socket>]

--max-position=MAX_POSITION

Used to detect slave delay. The maximum difference between the master's log position and the slave's reported read position of the master. A value greater than this means the slave is too far behind the master. Default is 0.

--ping=PING

Number of ping attempts for detecting downed server.

--seconds-behind=MAX_DELAY

Used to detect slave delay. The maximum number of seconds behind the master permitted before slave is considered behind the master. Default is 0.

--slaves=SLAVES

connection information for slave servers in the form: <user>[:<password>]@<host>[:<port>][:<socket>] or <login-path>[:<port>][:<socket>]. List multiple slaves in comma-separated list.

--timeout=TIMEOUT

Maximum timeout in seconds to wait for each replication command to complete. For example, timeout for slave waiting to catch up to master. Default = 300.

-i INTERVAL, --interval=INTERVAL

interval in seconds for polling the master for failure and reporting health. Default = 15 seconds. Lowest value is 5 seconds.

-f FAILOVER_MODE, --failover-mode=FAILOVER_MODE

action to take when the master fails. 'auto' = automatically fail to best slave, 'elect' = fail to candidate list or if no candidate meets criteria fail, 'fail' = take no action and stop when master fails. Default = 'auto'.

--exec-fail-check=EXEC_FAIL

name of script to execute on each interval to invoke failover

--force

override the registration check on master for multiple instances of the console monitoring the same master.

--exec-post-failover=EXEC_POST_FAIL

name of script to execute after failover is complete and the utility has refreshed the health report.

--rediscover

Rediscover slaves on interval. Allows console to detect when slaves have been removed or added.

-v, --verbose

control how much information is displayed. e.g., -v = verbose, -vv = more verbose, -vvv = debug

--rpl-user=RPL_USER

the user and password for the replication user requirement, in the form: <user>[:<password>] or <login-path>. E.g. rpl:passwd - By default = none

Copyright