Debian Codegraph @

mysql-test/suite/galera_3nodes/galera_3nodes.cnf

raw
1 # Use default setting for mysqld processes
2 !include include/default_my.cnf
3
4 [mysqld]
5 loose-innodb
6 binlog-format=row
7 innodb-autoinc-lock-mode=2
8 default-storage-engine=innodb
9 auto_increment_increment=3
10
11 [email protected]_PROVIDER
12 # enforce read-committed characteristics across the cluster
13 # wsrep-causal-reads=ON
14 wsrep-sync-wait=15
15
16 [mysqld.1]
17 wsrep-on=1
18 #[email protected]
19 #[email protected]
20 #[email protected]
21 wsrep_cluster_address=gcomm://
22 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'
23 wsrep_node_address='127.0.0.1:@mysqld.1.#galera_port'
24 wsrep_node_incoming_address=127.0.0.1:@mysqld.1.port
25 wsrep_sst_receive_address='127.0.0.1:@mysqld.1.#sst_port'
26 wsrep_node_name=node1
27
28 [mysqld.2]
29 wsrep-on=1
30 #[email protected]
31 #[email protected]
32 #[email protected]
33 wsrep_cluster_address='gcomm://127.0.0.1:@mysqld.1.#galera_port'
34 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'
35 wsrep_node_address='127.0.0.1:@mysqld.2.#galera_port'
36 wsrep_node_incoming_address=127.0.0.1:@mysqld.2.port
37 wsrep_sst_receive_address='127.0.0.1:@mysqld.2.#sst_port'
38 wsrep_node_name=node2
39
40 [mysqld.3]
41 wsrep-on=1
42 #[email protected]
43 #[email protected]
44 #[email protected]
45 wsrep_cluster_address='gcomm://127.0.0.1:@mysqld.1.#galera_port'
46 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'
47 wsrep_node_address='127.0.0.1:@mysqld.3.#galera_port'
48 wsrep_node_incoming_address=127.0.0.1:@mysqld.3.port
49 wsrep_sst_receive_address='127.0.0.1:@mysqld.3.#sst_port'
50 wsrep_node_name=node3
51
52 [sst]
53 [email protected]_VARDIR/log
54 [email protected]_GALERA_TFMT
55
56 [ENV]
57 NODE_MYPORT_1= @mysqld.1.port
58 NODE_MYSOCK_1= @mysqld.1.socket
59
60 NODE_MYPORT_2= @mysqld.2.port
61 NODE_MYSOCK_2= @mysqld.2.socket
62
63 NODE_MYPORT_3= @mysqld.3.port
64 NODE_MYSOCK_3= @mysqld.3.socket