Debian Codegraph @

mysql-test/suite/ndb_rpl/t/ndb_rpl_log_updates.cnf

raw
1 !include include/default_mysqld.cnf
2 !include include/default_ndbd.cnf
3
4 [cluster_config.cluster1]
5 NoOfReplicas= 1
6 ndbd=
7 ndb_mgmd=
8 mysqld=,
9 ndbapi=,
10
11 [cluster_config.cluster2]
12 NoOfReplicas= 1
13 ndbd=
14 ndb_mgmd=
15 mysqld=,,
16 ndbapi=,,
17
18 [cluster_config.cluster3]
19 NoOfReplicas= 1
20 ndbd=
21 ndb_mgmd=
22 mysqld=,
23 ndbapi=,
24
25 [mysqld]
26 # Make all mysqlds use cluster
27 ndbcluster
28 ndb-wait-connected=30
29 ndb-wait-setup=60
30 replica-allow-batching
31 ndb-log-orig
32 # Turn on bin logging
33 ndb-log-bin=1
34 # for performance reasons
35 ndb-table-temporary=1
36 ndb-extra-logging=99
37 ndb-log-apply-status=ON
38 # Set error log verbosity to max, otherwise info messages
39 # are filtered away
40 log-error-verbosity=3
41 binlog-format=row
42 replica-parallel-workers=1
43 # Use smaller than default cache size to save resources
44 ndb-log-cache-size=32768
45
46 [cluster_config.mysqld.1.cluster1]
47 NodeId=10
48 Dedicated=1
49
50 [cluster_config.mysqld.2.cluster1]
51 NodeId=11
52 Dedicated=1
53
54 [cluster_config.ndbapi.1.cluster1]
55 NodeId=12
56 Dedicated=1
57
58 [cluster_config.mysqld.1.cluster2]
59 NodeId=20
60 Dedicated=1
61
62 [cluster_config.mysqld.2.cluster2]
63 NodeId=21
64 Dedicated=1
65
66 [cluster_config.mysqld.3.cluster2]
67 NodeId=22
68 Dedicated=1
69
70 [cluster_config.mysqld.1.cluster3]
71 NodeId=30
72 Dedicated=1
73
74 [cluster_config.mysqld.2.cluster3]
75 NodeId=31
76 Dedicated=1
77
78 [cluster_config.ndbapi.1.cluster3]
79 NodeId=32
80 Dedicated=1
81
82 [mysqld.1.cluster1]
83 ndb-nodeid=10
84 log-bin= cluster1-bin
85 server_id= 1
86 log-replica-updates= OFF
87
88 [mysqld.2.cluster1]
89 ndb-nodeid=11
90 log-bin= cluster1-bin
91 server_id= 2
92 log-replica-updates= OFF
93
94 [mysqld.1.cluster2]
95 ndb-nodeid=20
96 server_id= 4
97 log-bin= cluster2-bin
98 relay-log= cluster2-relay-bin
99 log-replica-updates= ON
100
101 [mysqld.2.cluster2]
102 ndb-nodeid=21
103 server_id= 8
104 log-bin= cluster2-bin
105 log-replica-updates= OFF
106
107 [mysqld.3.cluster2]
108 ndb-nodeid=22
109 server_id= 16
110 log-bin= cluster2-bin
111 log-replica-updates= OFF
112
113 [mysqld.1.cluster3]
114 ndb-nodeid=30
115 server_id= 32
116 log-bin= cluster3-bin
117 relay-log= cluster3-relay-bin
118 log-replica-updates= ON
119
120 [mysqld.2.cluster3]
121 ndb-nodeid=31
122 server_id= 64
123 log-bin= cluster3-bin
124 relay-log= cluster3-relay-bin
125 log-replica-updates= ON
126
127 [ENV]
128 SERVER_MYPORT_1= @mysqld.1.cluster1.port
129 SERVER_MYPORT_2= @mysqld.2.cluster1.port
130 SERVER_MYPORT_3= @mysqld.1.cluster2.port
131 SERVER_MYPORT_4= @mysqld.2.cluster2.port
132 SERVER_MYPORT_5= @mysqld.3.cluster2.port
133 SERVER_MYPORT_6= @mysqld.1.cluster3.port
134 SERVER_MYPORT_7= @mysqld.2.cluster3.port
135 NUM_MYSQLD= 7