Linux mysql 双机集群 配置教程(2)

# mv mysql-5.0.85-linux-i686 mysql

# cd mysql

# scripts/mysql_install_db --user=mysql

# chown -R root   .

# chown -R mysql data

# chgrp -R mysql .

# cp support-files/mysql.server /etc/rc.d/init.d/mysqld

# chmod +x /etc/rc.d/init.d/mysqld

# chkconfig --add mysqld

my.cnf:

[mysqld]
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
default-storage-engine=ndbcluster
ndbcluster
ndb-connectstring=192.168.1.229,192.168.1.191
[ndbd]
connect-string=192.168.1.229,192.168.1.191
[ndb_mgm]
connect-string=192.168.1.229,192.168.1.191
[ndb_mgmd]
config-file=/var/lib/mysql-cluster/config.ini
[mysql_cluster]
ndb-connectstring= 192.168.1.229,192.168.1.191
[mysql_server]
user=mysql
basedir=/usr/local
[mysqld_safe]
log-error=/var/log/mysqld.log
[mysql]
[mysqladmin]

config.ini:

[ndbd default]
NoOfReplicas= 2
MaxNoOfConcurrentOperations= 10000
DataMemory= 128M
IndexMemory= 24M
TimeBetweenWatchDogCheck= 30000
DataDir= /var/lib/mysql-cluster
MaxNoOfOrderedIndexes= 512
StartPartialTimeout=100
StartPartitionedTimeout=100
ArbitrationTimeout=5000
TransactionDeadlockDetectionTimeout=5000
HeartbeatIntervalDbDb=5000
StopOnError=0

[ndb_mgmd default]
DataDir= /var/lib/mysql-cluster
[ndb_mgmd]
Id=1
HostName= 192.168.1.229
[ndb_mgmd]
Id=2
HostName= 192.168.1.191
[ndbd]
Id=3
HostName= 192.168.1.229
[ndbd]
Id=4
HostName= 192.168.1.191
[mysqld]
ArbitrationRank=2
[mysqld]
ArbitrationRank=2
[mysqld]
[mysqld]