82 lines
2.0 KiB
TOML
82 lines
2.0 KiB
TOML
# config.toml
|
|
# Example replication-manager configuration file
|
|
|
|
[Default]
|
|
hosts = "node-000:3306,node-001:3306,node-002:3306"
|
|
user = "skysql:skysql"
|
|
rpluser = "skysql:skysql"
|
|
title = "Cluster01"
|
|
connect-timeout = 1
|
|
prefmaster = "node-000:3306"
|
|
interactive = false
|
|
log-level=1
|
|
|
|
#
|
|
# These are the options that were changed, the rest are set to the default
|
|
# values of the replication-manager.
|
|
#
|
|
monitoring-ticker = 1
|
|
autorejoin = true
|
|
autorejoin-mysqldump = true
|
|
autorejoin-backup-binlog = false
|
|
autorejoin-semisync = false
|
|
autorejoin-flashback = false
|
|
failover-at-sync = false
|
|
switchover-at-sync = false
|
|
failover-falsepositive-heartbeat = false
|
|
|
|
# This needs to point to the 10.2.4 release candidate binaries
|
|
mariadb-binary-path = "/usr/mariadb-10.2/bin/"
|
|
|
|
# LOG
|
|
# ---
|
|
|
|
logfile = "/var/log/replication-manager.log"
|
|
verbose = true
|
|
|
|
# TOPOLOGY
|
|
# --------
|
|
|
|
|
|
# Automatically rejoin a failed server to the current master
|
|
# Slaves will re enter with read-only
|
|
|
|
readonly = true
|
|
failover-event-scheduler = false
|
|
failover-event-status = false
|
|
|
|
# FAILOVER
|
|
# --------
|
|
|
|
# Timeout in seconds between consecutive monitoring
|
|
# check type can be tcp or agent
|
|
check-type = "tcp"
|
|
check-replication-filters = true
|
|
check-binlog-filters = true
|
|
check-replication-state = true
|
|
|
|
# Failover after N failures detection
|
|
# Reset number of failure if server auto recover after N seconds
|
|
failcount = 1
|
|
failcount-reset-time = 300
|
|
|
|
# Cancel failover if already N failover
|
|
# Cancel failover if last failover was N seconds before
|
|
# Cancel failover in semi-sync when one slave is not in sync
|
|
# Cancel failover when replication delay is more than N seconds
|
|
failover-limit = 0
|
|
failover-time-limit = 0
|
|
maxdelay = 30
|
|
|
|
# SWITCHOVER
|
|
# ----------
|
|
|
|
# In switchover Wait N milliseconds before killing long running transactions
|
|
# Cancel switchover if transaction running more than N seconds
|
|
# Cancel switchover if write query running more than N seconds
|
|
# Cancel switchover if one of the slaves is not synced based on GTID equality
|
|
wait-kill = 5000
|
|
wait-trx = 10
|
|
wait-write-query = 10
|
|
gtidcheck = true
|