| 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 |