[cluster1]

title = "cluster1"

prov-orchestrator = "onpremise"
prov-db-tags = "innodb,noquerycache,slow,pfs,pkg,linux,smallredolog,logtotable"
prov-db-memory = "256"
prov-db-memory-shared-pct = "threads:16,innodb:60,myisam:10,querycache:0"
prov-db-disk-size = "1"
prov-db-cpu-cores = "1"
prov-db-disk-iops = "300"

db-servers-hosts = "192.168.50.35:3306,192.168.50.36:3306"

db-servers-prefered-master = "192.168.50.35:3306"

db-servers-credential = "mrmuser:mrmuser"
replication-credential = "repl:repl"

db-servers-connect-timeout = 2

verbose = false
log-failed-election  = true
log-level = 1
log-rotate-max-age = 7
log-rotate-max-backup = 7
log-rotate-max-size = 5
##log-sql-in-monitoring   = true
log-sql-in-monitoring   = false
log-sst = true

##############
## TOPOLOGY ##
##############

replication-multi-master = false
replication-multi-tier-slave = false


#backup-mysqlclient-path = "/app/mariadb10.6/mariadb/bin/mysql"
#backup-mysqlbinlog-path = "/app/mariadb10.6/mariadb/bin/mysqlbinlog"
#backup-mysqldump-path = "/app/mariadb10.6/mariadb/bin/mysqldump"

#backup-mydumper-path = "/usr/local/bin/mydumper"
#backup-myloader-path = "/usr/local/bin/myloader"

############
# BACKUPS ##
###########

backup = false

backup-streaming = false
backup-streaming-aws-access-key-id = "admin"
backup-streaming-aws-access-secret = "xxxx"
backup-streaming-endpoint= "https://s3.signal18.io/"
backup-streaming-region= "fr-1"
backup-streaming-bucket= "repman"

backup-restic = false
backup-restic-aws =  false
backup-physical-type = "mariabackup"
backup-logical-type = "mysqldump"
backup-restic-aws-access-secret = "xxxx"
backup-restic-password = "xxxx"
backup-restic-binary-path = "/usr/local/bin/restic"

monitoring-scheduler = false
scheduler-db-servers-logical-backup  = false
scheduler-db-servers-logical-backup-cron= "0 0 1 * * 6"
scheduler-db-servers-logs   =  false
scheduler-db-servers-logs-cron = "0 0 * * * *"
scheduler-db-servers-logs-table-keep = 4
scheduler-db-servers-logs-table-rotate  = false
scheduler-db-servers-logs-table-rotate-cron = "0 0 0/6 * * *"
scheduler-db-servers-optimize  = false
scheduler-db-servers-optimize-cron = "0 0 3 1 * 5"
scheduler-db-servers-physical-backup = false
scheduler-db-servers-physical-backup-cron = "0 0 0 * * *"

##############
## FAILOVER ##
##############

failover-mode = "automatic"
failover-pre-script = ""
failover-post-script = ""

## Slaves will re enter with read-only

#failover-readonly-state = true

## Only MySQL Server
#failover-superreadonly-state = true

## Failover activate and disable event scheduler
#failover-event-scheduler = true

## Failover change the event status ENABLE OR DISABLE ON SLAVE
#failover-event-status = true

## Failover after N failures detection

failover-falsepositive-ping-counter = 3

## 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 if one slave receive master heartbeat
## Cancel failover when replication delay is more than N seconds

failover-limit = 0
failover-time-limit = 0
#failover-at-sync = false
failover-at-sync = true
#failover-max-slave-delay = 30
failover-max-slave-delay = 10
failover-restart-unsafe = false

# 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 ##
################

## 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

switchover-wait-kill = 5000
switchover-wait-trx = 10
switchover-wait-write-query = 10
switchover-at-equal-gtid = false
#switchover-at-equal-gtid = true
switchover-at-sync = false
switchover-max-slave-delay = 30

############
## REJOIN ##
############

autorejoin = true
autorejoin-script = ""
autorejoin-semisync = true
autorejoin-backup-binlog = true
autorejoin-flashback = true
autorejoin-mysqldump = false

####################
## CHECKS & FORCE ##
####################

check-replication-filters = true
check-binlog-filters = true
check-replication-state = true

force-slave-heartbeat= false
force-slave-heartbeat-retry = 5
force-slave-heartbeat-time = 3

force-slave-gtid-mode = false

force-slave-semisync = true

force-slave-readonly = true

#force-slave-failover-readonly-state = true
force-binlog-row = false
force-binlog-annotate = false
force-binlog-slowqueries = false

force-binlog-compress = false

force-binlog-checksum = 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