Skip to content

Instantly share code, notes, and snippets.

@narcisbcn
Created February 28, 2019 15:03
Show Gist options
  • Save narcisbcn/cc80223a7b1ebabee0359e640863f940 to your computer and use it in GitHub Desktop.
Save narcisbcn/cc80223a7b1ebabee0359e640863f940 to your computer and use it in GitHub Desktop.
#272 MRM
# cat /etc/replication-manager/config.toml |egrep -v '^#|^$'
[Default]
hosts="10.10.62.165,10.10.61.140,10.10.56.209,10.10.63.130,10.10.67.247,10.10.58.185,10.10.95.9,10.10.64.23,10.10.61.20,10.23.188.171,10.23.171.77,10.25.10.208,10.23.176.99,10.23.185.186,10.10.67.34,10.10.92.179,10.10.61.83,10.10.61.181,10.10.61.114,10.10.64.173,10.10.60.167,10.10.93.125,10.10.56.39,10.10.58.136,10.10.61.4,10.10.65.124,10.10.68.177"
user="mrmuser:XXXXX"
rpluser="slaves:XXXXXX"
ignore-servers = "10.10.62.165,10.10.61.140,10.10.56.209,10.10.63.130,10.10.67.247,10.10.58.185,10.10.95.9,10.10.64.23,10.10.61.20,10.23.188.171,10.23.171.77,10.25.10.208,10.23.176.99,10.23.185.186,10.10.67.34,10.10.92.179,10.10.61.181"
working-directory = "/var/lib/replication-manager"
share-directory = "/usr/share/replication-manager"
logfile = "/var/log/replication-manager.log"
log-level = 1
multimaster = false
multi-tier-slave = false
maxscale-binlog = false
readonly = true
failover-event-scheduler = false
failover-event-status = false
connect-timeout = 1
force-slave-heartbeat= false
force-slave-heartbeat-retry = 5
force-slave-heartbeat-time = 3
force-slave-gtid-mode = false
force-slave-semisync = false
force-slave-readonly = true
force-binlog-row = false
force-binlog-annotate = false
force-binlog-slowqueries = false
force-inmemory-binlog-cache-size = false
force-disk-relaylog-size-limit = false
force-disk-relaylog-size-limit-size = 1000000000
force-sync-binlog = false
force-sync-innodb = false
force-binlog-checksum = false
http-auth = false
http-bind-address = "0.0.0.0"
http-bootstrap-button = false
http-port = "10001"
http-root = "/usr/share/replication-manager/dashboard"
http-server = true
http-session-lifetime = 3600
pre-failover-script = ""
post-failover-script = ""
interactive = true
monitoring-ticker = 2
check-type = "tcp"
check-replication-filters = true
check-binlog-filters = true
check-replication-state = true
failcount = 5
failcount-reset-time = 300
failover-limit = 3
failover-time-limit = 10
failover-max-slave-delay = 30
failover-falsepositive-heartbeat = true
failover-falsepositive-heartbeat-timeout = 3
failover-falsepositive-maxscale = false
failover-falsepositive-maxscale-timeout = 14
failover-falsepositive-external = false
failover-falsepositive-external-port = 80
switchover-wait-kill = 5000
switchover-wait-trx = 10
switchover-wait-write-query = 10
switchover-max-slave-delay = 30
autorejoin = true
autorejoin-semisync = true
autorejoin-flashback = true
autorejoin-mysqldump = false
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment