| 1 |
# Could be : |
| 2 |
# !include ndb_rpl_conflict_epoch.cnf |
| 3 |
# [mysqld] |
| 4 |
# server-id-bits=24 |
| 5 |
# ndb-serverid-transid-bits=8 |
| 6 |
|
| 7 |
!include ../my.cnf |
| 8 |
|
| 9 |
# 2 clusters, each with 2 MySQLDs |
| 10 |
# All MySQLDs log-replica-updates |
| 11 |
# Potential infinite loops are broken by both servers |
| 12 |
# on each cluster having the same server-id |
| 13 |
|
| 14 |
[cluster_config] |
| 15 |
MaxNoOfExecutionThreads=8 |
| 16 |
|
| 17 |
[cluster_config.slave] |
| 18 |
mysqld=, |
| 19 |
|
| 20 |
[mysqld] |
| 21 |
ndb-log-apply-status |
| 22 |
ndb-log-transaction-id |
| 23 |
log-bin-use-v1-row-events=false |
| 24 |
|
| 25 |
[mysqld.1.1] |
| 26 |
server-id= 1 |
| 27 |
log-bin = pref-master-1 |
| 28 |
log-replica-updates |
| 29 |
|
| 30 |
[mysqld.2.1] |
| 31 |
server-id= 2 |
| 32 |
log-bin = pref-master-2 |
| 33 |
|
| 34 |
|
| 35 |
[mysqld.1.slave] |
| 36 |
server-id= 3 |
| 37 |
log-bin = sec-master-1 |
| 38 |
log-replica-updates |
| 39 |
skip-replica-start |
| 40 |
|
| 41 |
[cluster_config.mysqld.2.slave] |
| 42 |
NodeId=16 |
| 43 |
Dedicated=1 |
| 44 |
|
| 45 |
[mysqld.2.slave] |
| 46 |
ndb-cluster-connection-pool-nodeids=16,48,127 |
| 47 |
server-id= 4 |
| 48 |
log-bin = sec-master-2 |
| 49 |
log-replica-updates |
| 50 |
skip-replica-start |
| 51 |
ndb_connectstring= @mysql_cluster.slave.ndb_connectstring |
| 52 |
|
| 53 |
[ENV] |
| 54 |
|
| 55 |
SLAVE_MYPORT1= @mysqld.2.slave.port |
| 56 |
SLAVE_MYSOCK1= @mysqld.2.slave.socket |