mysql cluster 配置

 

NDBM 开放1186

NDB: 开放 管理端 [tcp default] PortNumber= 63132
groupadd mysql
useradd -g mysql mysql
tar zxvf mysql-cluster.tar
ln -s mysql-cluster-gpl-7.1.15a-linux-x86_64-glibc23/ mysql
cd mysql
chown -R root .
chown -R mysql data
chgrp -R mysql .
scripts/mysql_install_db  --user=mysql
cp support-files/mysql.server  /etc/rc.d/init.d/mysqld
chmod +x /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
cp support-files/my-medium.cnf  /etc/my.cnf
vi /etc/my.cnf 添加
[mysql_cluster]
ndb-connectstring=19.2.168.145
/usr/local/mysql/bin/ndbd --initial

mysql 节点：
groupadd mysql
useradd -g mysql mysql
tar zxvf mysql-cluster.tar
ln -s mysql-cluster-gpl-7.1.15a-linux-x86_64-glibc23/ mysql
cd mysql
chown -R root .
chown -R mysql data
chgrp -R mysql .
scripts/mysql_install_db  --user=mysql
cp support-files/mysql.server  /etc/rc.d/init.d/mysqld
chmod +x /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
cp support-files/my-medium.cnf  /etc/my.cnf
vi /etc/my.cnf 添加
[mysqld]
ndbcluster
ndb-connectstring=19.2.168.145