[ndbd default] # Options affecting ndbd processes on all data nodes: NoOfReplicas=2 # Number of replicas DataMemory=2048M # How much memory to allocate for data storage IndexMemory=512M # How much memory to allocate for index storage # For DataMemory and IndexMemory, we have used the # default values. Since the "world" database takes up # only about 500KB, this should be more than enough for # this example Cluster setup. UndoIndexBuffer=128M RedoBuffer=256M TimeBetweenLocalCheckpoints=20 #4MB writes NoOfFragmentLogFiles=8 #512MB of REDO log -- reasonable, and we could most likely do with less # These are somewhat arbitrary, although make sense for the most part MaxNoOfAttributes=20000 MaxNoOfConcurrentOperations=50000 MaxNoOfLocalOperations=60000 MaxNoOfOrderedIndexes=5000 MaxNoOfUniqueHashIndexes=5000 [mysqld default] [ndb_mgmd default] [tcp default] # TCP/IP options: portnumber=2202 # This the default; however, you can use any # port that is free for all the hosts in the cluster # Note: It is recommended that you do not specify the port # number at all and simply allow the default value to be use instead [ndb_mgmd] # Management process options: nodeid=1 hostname= 10.192.10.137 # Hostname or IP address of MGM node datadir=/var/lib/mysql-cluster # Directory for MGM node log files [ndbd] # Options for data node "1": # (one [ndbd] section per data node) nodeid=2 hostname= 10.192.10.138 # Hostname or IP address datadir=/usr/local/mysql/data # Directory for this data node's data files [ndbd] # Options for data node "2": nodeid=3 hostname= 10.192.10.137 # Hostname or IP address datadir=/usr/local/mysql/data # Directory for this data node's data files [mysqld] # SQL node options: nodeid=4 hostname= 10.192.10.137 [mysqld] # SQL node options: nodeid=5 hostname= 10.192.10.138 [mysqld] # SQL node options: nodeid=6 #hostname= 10.192.10.137 [mysqld] # SQL node options: nodeid=7 #hostname= 10.192.10.138 [mysqld] [mysqld] [mysqld] [mysqld] [mysqld] [mysqld] [mysqld] [mysqld] [mysqld] [mysqld]