| 1 |
!include include/default_mysqld.cnf |
| 2 |
|
| 3 |
[cluster_config] |
| 4 |
MaxNoOfSavedMessages= 1000 |
| 5 |
DataMemory= 700M |
| 6 |
Diskless= 0 |
| 7 |
TimeBetweenWatchDogCheck= 30000 |
| 8 |
MaxNoOfOrderedIndexes= 128 |
| 9 |
MaxNoOfAttributes= 2048 |
| 10 |
TimeBetweenGlobalCheckpoints= 3000 |
| 11 |
TimeBetweenEpochs= 100 |
| 12 |
NoOfFragmentLogFiles= 4 |
| 13 |
FragmentLogFileSize= 12M |
| 14 |
DiskPageBufferMemory= 4M |
| 15 |
SharedGlobalMemory= 20M |
| 16 |
LongMessageBuffer= 4M |
| 17 |
RedoBuffer= 4M |
| 18 |
BackupDataBufferSize= 2M |
| 19 |
BackupLogBufferSize= 2M |
| 20 |
BackupMemory= 4M |
| 21 |
TwoPassInitialNodeRestartCopy=1 |
| 22 |
TransactionDeadlockDetectionTimeout=3000 |
| 23 |
Checksum=1 |
| 24 |
CompressedLCP= 1 |
| 25 |
CompressedBackup= 1 |
| 26 |
InitialNoOfOpenFiles= 27 |
| 27 |
HeartbeatIntervalDbDb= 30000 |
| 28 |
HeartbeatIntervalDbApi= 30000 |
| 29 |
DiskIOThreadPool=1 |
| 30 |
|
| 31 |
[cluster_config.1] |
| 32 |
ndbd=, |
| 33 |
ndb_mgmd= |
| 34 |
mysqld=, |
| 35 |
ndbapi=,,,,,,,,,,, |
| 36 |
DefaultOperationRedoProblemAction=queue |
| 37 |
|
| 38 |
# NdbAPI nodes intended for use by MySQL server(s). |
| 39 |
# Node id must explicitly be requested either by --ndb-nodeid or |
| 40 |
# --ndb-cluster-connection-pool-nodeids. |
| 41 |
|
| 42 |
[cluster_config.mysqld.1.1] |
| 43 |
NodeId=49 |
| 44 |
Dedicated=1 |
| 45 |
|
| 46 |
[cluster_config.mysqld.2.1] |
| 47 |
NodeId=16 |
| 48 |
Dedicated=1 |
| 49 |
|
| 50 |
[cluster_config.ndbapi.1.1] |
| 51 |
NodeId=32 |
| 52 |
Dedicated=1 |
| 53 |
|
| 54 |
[cluster_config.ndbapi.2.1] |
| 55 |
NodeId=48 |
| 56 |
Dedicated=1 |
| 57 |
|
| 58 |
[cluster_config.ndbapi.3.1] |
| 59 |
NodeId=63 |
| 60 |
Dedicated=1 |
| 61 |
|
| 62 |
[cluster_config.ndbapi.4.1] |
| 63 |
NodeId=127 |
| 64 |
Dedicated=1 |
| 65 |
|
| 66 |
# NdbAPI nodes free for use by any NdbAPI connection. |
| 67 |
|
| 68 |
[cluster_config.ndbapi.5.1] |
| 69 |
NodeId=192 |
| 70 |
|
| 71 |
[cluster_config.ndbapi.6.1] |
| 72 |
NodeId=228 |
| 73 |
|
| 74 |
[cluster_config.ndbapi.12.1] |
| 75 |
NodeId=255 |
| 76 |
|
| 77 |
[mysqld] |
| 78 |
# Make all mysqlds use cluster |
| 79 |
ndbcluster |
| 80 |
ndb-wait-connected=30 |
| 81 |
ndb-wait-setup=120 |
| 82 |
ndb-cluster-connection-pool=3 |
| 83 |
ndb-extra-logging=99 |
| 84 |
ndb-join-pushdown=1 |
| 85 |
# Enable load data local functionality |
| 86 |
local-infile=true |
| 87 |
|
| 88 |
[mysqld.1.1] |
| 89 |
# Specify which nodeids the connection pool on first mysqld should use |
| 90 |
ndb-cluster-connection-pool-nodeids=49,63,127 |
| 91 |
# This suite(--suite=ndb) is designed to be run without binogging, |
| 92 |
# turn off binlogging(and thus also slave updates) for this mysqld |
| 93 |
skip-log-bin |
| 94 |
skip-log-replica-updates |
| 95 |
|
| 96 |
[mysqld.2.1] |
| 97 |
# Specify which nodeids the connection pool on second mysqld should use |
| 98 |
ndb-cluster-connection-pool-nodeids=16,32,48 |
| 99 |
# This suite(--suite=ndb) is designed to be run without binogging, |
| 100 |
# turn off binlogging(and thus also slave updates) for this mysqld |
| 101 |
skip-log-bin |
| 102 |
skip-log-replica-updates |
| 103 |
|
| 104 |
[ENV] |
| 105 |
NDB_CONNECTSTRING= @mysql_cluster.1.ndb_connectstring |
| 106 |
MASTER_MYSOCK= @mysqld.1.1.socket |
| 107 |
MASTER_MYPORT= @mysqld.1.1.port |
| 108 |
MASTER_MYPORT1= @mysqld.2.1.port |
| 109 |
MASTER_MYSOCK= @mysqld.1.1.socket |
| 110 |
|
| 111 |
NDB_BACKUP_DIR= @cluster_config.ndbd.1.1.BackupDataDir |
| 112 |
MTR_NDBMTD= 1 |
| 113 |
|