| 1 |
!include ../galera_2nodes.cnf |
| 2 |
|
| 3 |
[mysqld.1] |
| 4 |
# server-id=101 |
| 5 |
#wsrep-debug=1 |
| 6 |
innodb_autoinc_lock_mode=2 |
| 7 |
#wsrep_sst_method=rsync |
| 8 |
wsrep_sst_method=mariabackup |
| 9 |
wsrep_sst_auth=root: |
| 10 |
binlog_format=ROW |
| 11 |
core-file |
| 12 |
log-output=none |
| 13 |
wsrep_slave_threads=2 |
| 14 |
wsrep_on=1 |
| 15 |
gtid_strict_mode=1 |
| 16 |
log_slave_updates=ON |
| 17 |
log_bin=binlog |
| 18 |
|
| 19 |
[mysqld.2] |
| 20 |
# server-id=102 |
| 21 |
#wsrep-debug=1 |
| 22 |
innodb_autoinc_lock_mode=2 |
| 23 |
#wsrep_sst_method=rsync |
| 24 |
wsrep_sst_method=mariabackup |
| 25 |
wsrep_sst_auth=root: |
| 26 |
binlog_format=ROW |
| 27 |
core-file |
| 28 |
log-output=none |
| 29 |
wsrep_slave_threads=2 |
| 30 |
wsrep_on=1 |
| 31 |
gtid_strict_mode=1 |
| 32 |
log_slave_updates=ON |
| 33 |
log_bin=binlog |
| 34 |
|
| 35 |
[mysqld.1] |
| 36 |
wsrep_provider_options='pc.ignore_sb=true;repl.causal_read_timeout=PT90S;[email protected].#galera_port;evs.suspect_timeout=PT10S;evs.inactive_timeout=PT30S;evs.install_timeout=PT15S;pc.wait_prim_timeout=PT60S;gcache.size=10M' |
| 37 |
|
| 38 |
[mysqld.2] |
| 39 |
wsrep_provider_options='pc.ignore_sb=true;repl.causal_read_timeout=PT90S;[email protected].#galera_port;evs.suspect_timeout=PT10S;evs.inactive_timeout=PT30S;evs.install_timeout=PT15S;pc.wait_prim_timeout=PT60S;gcache.size=10M' |
| 40 |
|
| 41 |
[sst] |
| 42 |
[email protected]_GALERA_TFMT |