浅谈Mysql簇
配置管理节点配置文件: # cd /var/lib/mysql-cluster# vi config.ini
在config.ini中添加如下内容:
NoOfReplicas= 2
MaxNoOfConcurrentOperations= 10000
DataMemory= 80M
IndexMemory= 24M
TimeBetweenWatchDogCheck= 30000
DataDir= /var/lib/mysql-cluster
MaxNoOfOrderedIndexes= 512
StartPartialTimeout=100
StartPartitionedTimeout=100
ArbitrationTimeout=5000
TransactionDeadlockDetectionTimeout=5000
HeartbeatIntervalDbDb=5000
StopOnError=0
DataDir= /var/lib/mysql-cluster
Id=1
HostName=db1---------------------------------------也可配成192.168.102.19
Id=2
HostName=db2---------------------------------------也可配成192.168.102.29
Id= 3
HostName=db1---------------------------------------也可配成192.168.102.19
Id= 4
HostName=db2---------------------------------------也可配成192.168.102.29
ArbitrationRank=2 (非常重要,全靠有它,才可以形成仲裁竞争,从而当另一个机子当了时,此机还可以有知道partion完整的节点)
ArbitrationRank=2
-------------------------------------------------空出来以便恢复数据库用-------------------------------------------------空出来以便恢复数据库用 PortNumber=63132
页:
[1]