[TCP DEFAULT] #SendBufferMemory=2M #ReceiveBufferMemory=2M #OverloadLimit=128000 [NDB_MGMD DEFAULT] DataDir=/var/lib/mysql-cluster [NDB_MGMD] Id=201 HostName=172.27.149.10 ArbitrationRank=1 # db-mgmt-01 vserver on host-db-01.phx1.good.net [NDB_MGMD] Id=202 HostName=172.27.149.30 ArbitrationRank=2 # db-mgmt-02 vserver on host-db-02.phx1.good.net [NDBD DEFAULT] NoOfReplicas=2 TotalSendBufferMemory=500M DataDir=/var/lib/mysql-cluster FileSystemPath=/store1 FileSystemPathDD=/store0 MaxNoOfConcurrentOperations = 500000 MaxNoOfConcurrentTransactions = 64000 LockPagesInMainMemory=1 ODirect=1 DataMemory=2GB IndexMemory=500MB FragmentLogFileSize=256M NoOfFragmentLogFiles=12 RedoBuffer=32M SchedulerSpinTimer=400 SchedulerExecutionTimer=100 RealTimeScheduler=1 HeartbeatIntervalDbDb=1500 CompressedBackup=1 [NDBD] HostName=172.27.149.31 Id=1 NodeGroup=0 # db-data-01 vserver on host-db-01.phx1.good.net [NDBD] HostName=172.27.149.32 Id=2 NodeGroup=0 # db-data-02 vserver on host-db-02.phx1.good.net [NDBD] HostName=172.27.149.33 Id=3 NodeGroup=1 # db-data-03 vserver on host-db-03.phx1.good.net [NDBD] HostName=172.27.149.34 Id=4 NodeGroup=1 # db-data-03 vserver on host-db-04.phx1.good.net [MYSQLD] Id=101 HostName=172.27.149.51 # db-sql-01 vserver on host-db-01.phx1.good.net [MYSQLD] HostName=172.27.149.52 Id=102 # db-sql-02 vserver on host-db-02.phx1.good.net [MYSQLD] HostName=172.27.149.53 Id=103 # db-sql-03 vserver on host-db-03.phx1.good.net [MYSQLD] HostName=172.27.149.54 Id=104 # db-sql-04 vserver on host-db-04.phx1.good.net [MYSQLD] # slot reserved for api connects [MYSQLD] # slot reserved for api connects # 4*3 = 12 extra mysqld entries needed for connection pooling [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD]