Debian Codegraph @

mysql-test/suite/galera_3nodes/galera_2x3nodes.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
15 [email protected]_PROVIDER
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 #[email protected]
23 #[email protected]
24 #[email protected]
25 wsrep_cluster_address=gcomm://
26 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'
27
28 wsrep_node_address='127.0.0.1:@mysqld.1.#galera_port'
29 wsrep_node_incoming_address=127.0.0.1:@mysqld.1.port
30 wsrep_sst_receive_address='127.0.0.1:@mysqld.1.#sst_port'
31
32 [mysqld.2]
33 wsrep-on=1
34 #[email protected]
35 #[email protected]
36 #[email protected]
37 wsrep_cluster_address='gcomm://127.0.0.1:@mysqld.1.#galera_port'
38 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'
39 wsrep_node_address='127.0.0.1:@mysqld.2.#galera_port'
40 wsrep_node_incoming_address=127.0.0.1:@mysqld.2.port
41 wsrep_sst_receive_address='127.0.0.1:@mysqld.2.#sst_port'
42
43 [mysqld.3]
44 wsrep-on=1
45 #[email protected]
46 #[email protected]
47 #[email protected]
48 wsrep_cluster_address='gcomm://127.0.0.1:@mysqld.1.#galera_port'
49 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'
50 wsrep_node_address='127.0.0.1:@mysqld.3.#galera_port'
51 wsrep_node_incoming_address=127.0.0.1:@mysqld.3.port
52 wsrep_sst_receive_address='127.0.0.1:@mysqld.3.#sst_port'
53
54 [mysqld.4]
55 wsrep-on=1
56 #[email protected]
57 #[email protected]
58 #[email protected]
59 wsrep_cluster_address=gcomm://
60 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'
61 wsrep_node_address='127.0.0.1:@mysqld.4.#galera_port'
62 wsrep_node_incoming_address=127.0.0.1:@mysqld.4.port
63 wsrep_sst_receive_address='127.0.0.1:@mysqld.4.#sst_port'
64
65 [mysqld.5]
66 wsrep-on=1
67 #[email protected]
68 #[email protected]
69 #[email protected]
70 wsrep_cluster_address='gcomm://127.0.0.1:@mysqld.4.#galera_port'
71 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'
72 wsrep_node_address='127.0.0.1:@mysqld.5.#galera_port'
73 wsrep_node_incoming_address=127.0.0.1:@mysqld.5.port
74 wsrep_sst_receive_address='127.0.0.1:@mysqld.5.#sst_port'
75
76 [mysqld.6]
77 wsrep-on=1
78 #[email protected]
79 #[email protected]
80 #[email protected]
81 wsrep_cluster_address='gcomm://127.0.0.1:@mysqld.4.#galera_port'
82 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'
83 wsrep_node_address='127.0.0.1:@mysqld.6.#galera_port'
84 wsrep_node_incoming_address=127.0.0.1:@mysqld.6.port
85 wsrep_sst_receive_address='127.0.0.1:@mysqld.6.#sst_port'
86
87 [sst]
88 [email protected]_VARDIR/log
89
90 [ENV]
91 NODE_MYPORT_1= @mysqld.1.port
92 NODE_MYSOCK_1= @mysqld.1.socket
93
94 NODE_MYPORT_2= @mysqld.2.port
95 NODE_MYSOCK_2= @mysqld.2.socket
96
97 NODE_MYPORT_3= @mysqld.3.port
98 NODE_MYSOCK_3= @mysqld.3.socket
99
100 NODE_MYPORT_4= @mysqld.4.port
101 NODE_MYSOCK_4= @mysqld.4.socket
102
103 NODE_MYPORT_5= @mysqld.5.port
104 NODE_MYSOCK_5= @mysqld.5.socket
105
106 NODE_MYPORT_6= @mysqld.6.port
107 NODE_MYSOCK_6= @mysqld.6.socket