1
# Copyright (c) 2008 MySQL AB
2
# Use is subject to license terms.
4
# This program is free software; you can redistribute it and/or modify
5
# it under the terms of the GNU General Public License as published by
6
# the Free Software Foundation; version 2 of the License.
8
# This program is distributed in the hope that it will be useful,
9
# but WITHOUT ANY WARRANTY; without even the implied warranty of
10
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
11
# GNU General Public License for more details.
13
# You should have received a copy of the GNU General Public License
14
# along with this program; if not, write to the Free Software
15
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
17
######################################################
18
# MySQL NDB Cluster Huge Sample Configuration File #
19
######################################################
20
# This files assumes that you are using at least 9 #
21
# hosts for running the cluster. Hostnames and paths #
22
# listed below should be changed to match your setup #
23
######################################################
27
DataDir: /add/path/here
28
FileSystemPath: /add/path/here
30
# Data Memory, Index Memory, and String Memory #
35
# Transaction Parameters #
36
MaxNoOfConcurrentTransactions: 4096
37
MaxNoOfConcurrentOperations: 100000
38
MaxNoOfLocalOperations: 100000
40
# Transaction Temporary Storage #
41
MaxNoOfConcurrentIndexOperations: 8192
42
MaxNoOfFiredTriggers: 4000
43
TransactionBufferMemory: 1M
45
# Scans and buffering #
46
MaxNoOfConcurrentScans: 300
48
BatchSizePerLocalScan: 64
51
# Logging and Checkpointing #
52
NoOfFragmentLogFiles: 300
53
FragmentLogFileSize: 16M
55
InitialNoOfOpenFiles: 27
56
MaxNoOfSavedMessages: 25
59
MaxNoOfAttributes: 1500
61
MaxNoOfOrderedIndexes: 200
62
MaxNoOfUniqueHashIndexes: 200
65
# Boolean Parameters #
66
LockPagesInMainMemory: 0
71
# Controlling Timeouts, Intervals, and Disk Paging #
72
TimeBetweenWatchDogCheck: 6000
73
TimeBetweenWatchDogCheckInitial: 6000
74
StartPartialTimeout: 30000
75
StartPartitionedTimeout: 60000
76
StartFailureTimeout: 1000000
77
HeartbeatIntervalDbDb: 2000
78
HeartbeatIntervalDbApi: 3000
79
TimeBetweenLocalCheckpoints: 20
80
TimeBetweenGlobalCheckpoints: 2000
81
TransactionInactiveTimeout: 0
82
TransactionDeadlockDetectionTimeout: 1200
84
DiskCheckpointSpeed: 10M
85
DiskCheckpointSpeedInRestart: 100M
86
ArbitrationTimeout: 10
88
# Buffering and Logging #
96
LogLevelNodeRestart: 0
101
MemReportFrequency: 0
103
# Backup Parameters #
104
BackupDataBufferSize: 2M
105
BackupLogBufferSize: 2M
108
BackupMaxWriteSize: 256K
112
DataDir: /add/path/here
117
#######################################
118
# Change HOST1 to the name of the NDB_MGMD host
119
# Change HOST2 to the name of the NDB_MGMD host
120
# Change HOST3 to the name of the NDB_MGMD host
121
# Change HOST4 to the name of the NDBD host
122
# Change HOST5 to the name of the NDBD host
123
# Change HOST6 to the name of the NDBD host
124
# Change HOST7 to the name of the NDBD host
125
# Change HOST8 to the name of the NDBD host
126
# Change HOST9 to the name of the NDBD host
127
#######################################
168
######################################################
169
# Note: The following can be MySQLD connections or #
170
# NDB API application connecting to the cluster #
171
######################################################