# Options affecting ndbd processes on all data nodes: [ndbd default] NoOfReplicas=2 # Number of replicas DataMemory=80M # How much memory to allocate for data storage IndexMemory=18M # 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. BackupDataDir=/usr/local/mysql/backups # TCP/IP options: [tcp default] 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 beginning with MySQL 5.0 that # you do not specify the portnumber at all and simply allow # the default value to be used instead # Management process options (mysql-mng1): [ndb_mgmd] Id=1 hostname=mysql-mng1 # Hostname or IP address of MGM node datadir=/var/lib/mysql-cluster # Directory for MGM node log files # Management process options (mysql-mng2): [ndb_mgmd] Id=2 hostname=mysql-mng2 # Hostname or IP address of MGM node datadir=/var/lib/mysql-cluster # Directory for MGM node log files # Options for data node "A" (mysql-data1): [ndbd] Id=3 # (one [ndbd] section per data node) hostname=mysql-data1 # Hostname or IP address datadir=/usr/local/mysql/data # Directory for this data node's data files MaxNoOfAttributes=4000 # Options for data node "B" (mysql-data2): [ndbd] Id=4 hostname=mysql-data2 # Hostname or IP address datadir=/usr/local/mysql/data # Directory for this data node's data files MaxNoOfAttributes=4000 # Options for SQL node "A" (mysql-sql1): [mysqld] Id=5 hostname=mysql-sql1 # Hostname or IP address # (additional mysqld connections can be # specified for this node for various # purposes such as running ndb_restore) # Options for SQL node "B" (mysql-sql2): [mysqld] Id=6 hostname=mysql-sql2 # Hostname or IP address # (additional mysqld connections can be # specified for this node for various # purposes such as running ndb_restore)