php中mysql数据库集群,MySQL集群

1，将6.0版本的mysql集群软件上传到Linux或是Solaris上，解压

1>，为了方便调用将其改名为mysql，并且放于/usr/local/下

2>，创建连接文件，进入/usr/local/下

ln -s ..../mysql mysql

2，创建组，添加用户

groupadd mysql

useradd -g mysql mysql

3，权限的修改

cd /usr/local/mysql

chown -Rhf mysql .

chgrp -Rhf mysql .

执行脚本，创建数据库

scritps/mysql_install_db --user=mysql &

chown -Rhf root .

chown -Rhf mysql .

chown -R mysql data

chgrp -R mysql .

cp support-file/mysql.server /etc/rc.d/ini.d/mysqld

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

验证启动数据库

启动失败可以尝试：

/etc/rc.d/init.d/mysqld stop/start

service mysqld restart

如果还是失败

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

bin/mysqld_safe --user=mysql &

验证成功后，停止mysql，停止进程

ps -ef | grep mysql

kill -9 进程标号

4，创建配置文件

vi my.cnf

[mysqld]

default-storage-engine=ndbcluster

ndbcluster

ndb-connectstring=10.85.0.90,10.85.0.80

[ndbd]

connect-string=10.85.0.90,10.85.0.80

[ndb_mgm]

connect-string=10.85.0.90,10.85.0.80

[ndb_mgmd]

config-file=/usr/local/mysql/config.ini

[mysql_cluster]

ndb-connectstring=10.85.0.90,10.85.0.80

5，创建启动文件

vi config.ini

[ndbd default]

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

[ndb_mgmd default]

DataDir= /var/lib/mysql-cluster

[ndb_mgmd]

Id=1

HostName= 10.85.0.90

[ndb_mgmd]

Id=2

Ho