Debian Codegraph @

mysql-test/suite/galera/galera_2nodes_as_master.cnf

raw
1 #
2 # This file creates a setup with a 2-node Galera cluster (master) and one
3 # standalone MariaDB server, to be used as a slave.
4 #
5
6 # Use default setting for mysqld processes
7 !include include/default_my.cnf
8
9 [mysqld]
10 loose-innodb
11 log-bin=mysqld-bin
12 log-slave-updates
13 binlog-format=row
14 innodb-autoinc-lock-mode=2
15 default-storage-engine=innodb
16 # enforce read-committed characteristics across the cluster
17 # wsrep-causal-reads=ON
18 wsrep-sync-wait=15
19
20 [mysqld.1]
21 wsrep-on=1
22 server-id=1
23 #[email protected]
24 #[email protected]
25 #[email protected]
26 [email protected]_PROVIDER
27 wsrep_cluster_address=gcomm://
28 wsrep_provider_options='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'
29 wsrep_node_address='127.0.0.1:@mysqld.1.#galera_port'
30 wsrep_node_incoming_address=127.0.0.1:@mysqld.1.port
31 wsrep_sst_receive_address='127.0.0.1:@mysqld.1.#sst_port'
32
33 [mysqld.2]
34 wsrep-on=1
35 server-id=2
36 #[email protected]
37 #[email protected]
38 #[email protected]
39 [email protected]_PROVIDER
40 wsrep_cluster_address='gcomm://127.0.0.1:@mysqld.1.#galera_port'
41 wsrep_provider_options='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'
42 wsrep_node_address='127.0.0.1:@mysqld.2.#galera_port'
43 wsrep_node_incoming_address=127.0.0.1:@mysqld.2.port
44 wsrep_sst_receive_address='127.0.0.1:@mysqld.2.#sst_port'
45
46 [mysqld.3]
47 wsrep-on=OFF
48 server-id=3
49
50 [sst]
51 [email protected]_VARDIR/log
52
53 [ENV]
54 NODE_MYPORT_1= @mysqld.1.port
55 NODE_MYSOCK_1= @mysqld.1.socket
56
57 NODE_MYPORT_2= @mysqld.2.port
58 NODE_MYSOCK_2= @mysqld.2.socket
59
60 NODE_MYPORT_3= @mysqld.3.port
61 NODE_MYSOCK_3= @mysqld.3.socket