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
 <chkconfig - add 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<ndb>
 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