| 1 |
!include include/default_mysqld.cnf |
| 2 |
!include include/default_ndbd.cnf |
| 3 |
|
| 4 |
[cluster_config] |
| 5 |
TimeBetweenEpochsTimeout = 30000 |
| 6 |
|
| 7 |
[cluster_config.1] |
| 8 |
NoOfReplicas= 2 |
| 9 |
ndbd=, |
| 10 |
ndb_mgmd= |
| 11 |
mysqld=, |
| 12 |
ndbapi=,,,,,,,,, |
| 13 |
|
| 14 |
[cluster_config.slave] |
| 15 |
NoOfReplicas= 1 |
| 16 |
ndbd= |
| 17 |
ndb_mgmd= |
| 18 |
mysqld= |
| 19 |
ndbapi=,,,, |
| 20 |
|
| 21 |
[mysqld] |
| 22 |
# Make all mysqlds use cluster |
| 23 |
ndbcluster |
| 24 |
ndb-wait-connected=30 |
| 25 |
ndb-wait-setup=120 |
| 26 |
ndb-cluster-connection-pool=3 |
| 27 |
replica-allow-batching |
| 28 |
ndb-log-orig |
| 29 |
# Turn on bin logging |
| 30 |
log-bin= master-bin |
| 31 |
# for performance reasons |
| 32 |
ndb-table-temporary=1 |
| 33 |
ndb-log-bin=1 |
| 34 |
# Use smaller than default cache size to save resources |
| 35 |
ndb-log-cache-size=32768 |
| 36 |
replica-parallel-workers=1 |
| 37 |
|
| 38 |
ndb-extra-logging=99 |
| 39 |
|
| 40 |
# Cluster supports row and mixed formats |
| 41 |
binlog-format= row |
| 42 |
|
| 43 |
[mysqld.1.1] |
| 44 |
|
| 45 |
[mysqld.2.1] |
| 46 |
|
| 47 |
[mysqld.1.slave] |
| 48 |
|
| 49 |
# Append <testname>-slave.opt file to the list of argument used when |
| 50 |
# starting the mysqld |
| 51 |
#!use-slave-opt |
| 52 |
|
| 53 |
log-bin= slave-bin |
| 54 |
relay-log= slave-relay-bin |
| 55 |
# Cluster only supports row format |
| 56 |
binlog-format= row |
| 57 |
|
| 58 |
log-replica-updates |
| 59 |
master-retry-count= 10 |
| 60 |
|
| 61 |
# Values reported by slave when it connect to master |
| 62 |
# and shows up in SHOW SLAVE STATUS; |
| 63 |
report-host= 127.0.0.1 |
| 64 |
report-port= @mysqld.1.slave.port |
| 65 |
report-user= root |
| 66 |
|
| 67 |
skip-replica-start |
| 68 |
|
| 69 |
# Directory where slaves find the dumps generated by "load data" |
| 70 |
# on the server. The path need to have constant length otherwise |
| 71 |
# test results will vary, thus a relative path is used. |
| 72 |
replica-load-tmpdir= ../../../tmp |
| 73 |
|
| 74 |
[ENV] |
| 75 |
NDB_CONNECTSTRING= @mysql_cluster.1.ndb_connectstring |
| 76 |
MASTER_MYPORT= @mysqld.1.1.port |
| 77 |
MASTER_MYPORT1= @mysqld.2.1.port |
| 78 |
|
| 79 |
NDB_CONNECTSTRING_SLAVE= @mysql_cluster.slave.ndb_connectstring |
| 80 |
SLAVE_MYPORT= @mysqld.1.slave.port |
| 81 |
SLAVE_MYSOCK= @mysqld.1.slave.socket |
| 82 |
|
| 83 |
NDB_BACKUP_DIR= @cluster_config.ndbd.1.1.BackupDataDir |