Debian Codegraph @

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

raw
1 !include include/default_mysqld.cnf
2 !include include/default_ndbd.cnf
3
4 [cluster_config.1]
5 # NoOfReplicas refers to NDBD nodes/nodegroup
6 NoOfReplicas= 2
7 ndbd=,
8 ndb_mgmd=
9 # 3 MySQLDS attached to Cluster 1
10 mysqld=,,
11
12
13
14 [cluster_config.slave]
15 # NoOfReplicas refers to NDBD nodes/nodegroup
16 NoOfReplicas= 2
17 ndbd=,
18 ndb_mgmd=
19 # 3 MySQLDs attached to Cluster 2
20 mysqld=,,
21
22
23
24 [mysqld]
25 # Make all mysqlds use cluster
26 ndbcluster
27 ndb-wait-connected=30
28 ndb-wait-setup=120
29 # Default log-replica-updates to off and turn it on
30 # only selectively for some of the servers in config
31 log-replica-updates=0
32 # Use smaller than default cache size to save resources
33 ndb-log-cache-size=32768
34
35
36 [cluster_config.mysqld.1.1]
37 NodeId=49
38 Dedicated=1
39
40 [cluster_config.mysqld.2.1]
41 NodeId=16
42 Dedicated=1
43
44 [cluster_config.mysqld.3.1]
45 NodeId=32
46 Dedicated=1
47
48 [mysqld.1.1]
49 ndb-nodeid=49
50 server-id= 1
51 ndb-log-bin=1
52 log-bin= master-bin
53 binlog_format=row
54
55
56
57 [mysqld.2.1]
58 ndb-nodeid=16
59 server-id= 2
60 # Note no binary log
61 skip-log-bin
62
63
64
65 [mysqld.3.1]
66 ndb-nodeid=32
67 server-id= 3
68 ndb-log-bin=1
69 log-bin= master-bin
70 binlog_format=row
71
72
73 [cluster_config.mysqld.1.slave]
74 NodeId=49
75 Dedicated=1
76
77 [cluster_config.mysqld.2.slave]
78 NodeId=16
79 Dedicated=1
80
81 [cluster_config.mysqld.3.slave]
82 NodeId=32
83 Dedicated=1
84
85
86 [mysqld.1.slave]
87 ndb-nodeid=49
88 # Note no binlog on this slave
89 skip-log-bin
90 server-id= 4
91 skip-replica-start
92
93
94 [mysqld.2.slave]
95 ndb-nodeid=16
96 # Note binlog on this slave, but not logging slave updates
97 server-id= 5
98 skip-replica-start
99 log-bin= slave-master-bin
100 binlog_format=row
101 ndb-log-bin=1
102
103
104 [mysqld.3.slave]
105 ndb-nodeid=32
106 # Note binlog on this slave, with slave updates logged
107 server-id= 6
108 skip-replica-start
109 log-bin= slave-master-bin
110 binlog_format=row
111 log-replica-updates
112 ndb-log-bin=1
113
114
115 [ENV]
116 SERVER_MYPORT_1= @mysqld.1.1.port
117 SERVER_MYPORT_2= @mysqld.2.1.port
118 SERVER_MYPORT_3= @mysqld.3.1.port
119 SERVER_MYPORT_4= @mysqld.1.slave.port
120 SERVER_MYPORT_5= @mysqld.2.slave.port
121 SERVER_MYPORT_6= @mysqld.3.slave.port
122