Debian Codegraph @

mysql-test/suite/galera/galera_4nodes.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 [email protected]_PROVIDER
10 # enforce read-committed characteristics across the cluster
11 # wsrep-causal-reads=ON
12 wsrep-sync-wait=15
13 wsrep-debug=1
14
15 [mysqld.1]
16 wsrep-on=1
17 #[email protected]
18 #[email protected]
19 #[email protected]
20 wsrep_cluster_address=gcomm://
21 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'
22 wsrep_node_address='127.0.0.1:@mysqld.1.#galera_port'
23 wsrep_node_incoming_address=127.0.0.1:@mysqld.1.port
24 wsrep_sst_receive_address='127.0.0.1:@mysqld.1.#sst_port'
25 auto-increment-offset=1
26
27 [mysqld.2]
28 wsrep-on=1
29 #[email protected]
30 #[email protected]
31 #[email protected]
32 wsrep_cluster_address='gcomm://127.0.0.1:@mysqld.1.#galera_port'
33 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'
34 wsrep_node_address='127.0.0.1:@mysqld.2.#galera_port'
35 wsrep_node_incoming_address=127.0.0.1:@mysqld.2.port
36 wsrep_sst_receive_address='127.0.0.1:@mysqld.2.#sst_port'
37 auto-increment-offset=2
38
39 [mysqld.3]
40 wsrep-on=1
41 #[email protected]
42 #[email protected]
43 #[email protected]
44 wsrep_cluster_address='gcomm://127.0.0.1:@mysqld.1.#galera_port'
45 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'
46 wsrep_node_address='127.0.0.1:@mysqld.3.#galera_port'
47 wsrep_node_incoming_address=127.0.0.1:@mysqld.3.port
48 wsrep_sst_receive_address='127.0.0.1:@mysqld.3.#sst_port'
49 auto-increment-offset=3
50
51 [mysqld.4]
52 wsrep-on=1
53 #[email protected]
54 #[email protected]
55 #[email protected]
56 wsrep_cluster_address='gcomm://127.0.0.1:@mysqld.1.#galera_port'
57 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'
58 wsrep_node_address='127.0.0.1:@mysqld.4.#galera_port'
59 wsrep_node_incoming_address=127.0.0.1:@mysqld.4.port
60 wsrep_sst_receive_address='127.0.0.1:@mysqld.4.#sst_port'
61 auto-increment-offset=4
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