mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 19:06:14 +01:00
44 lines
1.1 KiB
INI
44 lines
1.1 KiB
INI
!include ../galera_2nodes.cnf
|
|
|
|
[mysqld.1]
|
|
# server-id=101
|
|
#wsrep-debug=1
|
|
innodb_file_per_table
|
|
innodb_autoinc_lock_mode=2
|
|
wsrep_sst_method=rsync
|
|
#wsrep_sst_method=mariabackup
|
|
wsrep_sst_auth=root:
|
|
binlog_format=ROW
|
|
core-file
|
|
log-output=none
|
|
wsrep_slave_threads=2
|
|
wsrep_on=1
|
|
gtid_strict_mode=1
|
|
log_slave_updates=ON
|
|
log_bin=binlog
|
|
|
|
[mysqld.2]
|
|
# server-id=102
|
|
#wsrep-debug=1
|
|
innodb_file_per_table
|
|
innodb_autoinc_lock_mode=2
|
|
wsrep_sst_method=rsync
|
|
#wsrep_sst_method=mariabackup
|
|
wsrep_sst_auth=root:
|
|
binlog_format=ROW
|
|
core-file
|
|
log-output=none
|
|
wsrep_slave_threads=2
|
|
wsrep_on=1
|
|
gtid_strict_mode=1
|
|
log_slave_updates=ON
|
|
log_bin=binlog
|
|
|
|
[mysqld.1]
|
|
wsrep_provider_options='pc.ignore_sb=true;repl.causal_read_timeout=PT90S;base_port=@mysqld.1.#galera_port;evs.suspect_timeout=PT10S;evs.inactive_timeout=PT30S;evs.install_timeout=PT15S;pc.wait_prim_timeout=PT60S;gcache.size=10M'
|
|
|
|
[mysqld.2]
|
|
wsrep_provider_options='pc.ignore_sb=true;repl.causal_read_timeout=PT90S;base_port=@mysqld.2.#galera_port;evs.suspect_timeout=PT10S;evs.inactive_timeout=PT30S;evs.install_timeout=PT15S;pc.wait_prim_timeout=PT60S;gcache.size=10M'
|
|
|
|
[sst]
|
|
transferfmt=@ENV.MTR_GALERA_TFMT
|