Debian Codegraph @

mysql-test/suite/galera/galera_2x2nodes.cnf

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