准备：1、下载 MySQL-Cluster-gpl-7.3.8-1.el6.x86_64.rpm-bundle.tar

　　　　下载地址： 

　　　　解压：　　

[root@test1 files]# tar -xvf MySQL-Cluster-gpl-7.3.8-1.el6.x86_64.rpm-bundle.tarMySQL-Cluster-test-gpl-7.3.8-1.el6.x86_64.rpmMySQL-Cluster-shared-compat-gpl-7.3.8-1.el6.x86_64.rpmMySQL-Cluster-client-gpl-7.3.8-1.el6.x86_64.rpmMySQL-Cluster-embedded-gpl-7.3.8-1.el6.x86_64.rpmMySQL-Cluster-server-gpl-7.3.8-1.el6.x86_64.rpmMySQL-Cluster-devel-gpl-7.3.8-1.el6.x86_64.rpmMySQL-Cluster-shared-gpl-7.3.8-1.el6.x86_64.rpm

　　   2、停掉原有mysql 删除开机自动运行 卸载原有mysql 相关（未有任何相关则忽略）

[root@test1 files]# service mysql stop Shutting down MySQL.. SUCCESS! [root@test1 files]# chkconfig  mysql  off [root@test1 files]# rpm -qa | grep MySQL MySQL-client-5.6.24-1.el6.x86_64 MySQL-server-5.6.24-1.el6.x86_64 MySQL-devel-5.6.24-1.el6.x86_64

[root@test1 files]# rpm -e --nodeps MySQL-client-5.6.24-1.el6.x86_64 MySQL-server-5.6.24-1.el6.x86_64 MySQL-devel-5.6.24-1.el6.x86_64

进行安装操作

[root@test1 files]# rpm -ivh MySQL-Cluster-server-gpl-7.3.8-1.el6.x86_64.rpm

[root@test1 files]# rpm -ivh MySQL-Cluster-client-gpl-7.3.8-1.el6.x86_64.rpm

 

添加用户信息：

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

　flush privileges ;

创建工作目录及文件配置：

[root@test1 var]# mkdir /var/mysql-cluster [root@test1 var]# mkdir /var/lib/mysql/data [root@test1 var]# mkdir /var/run/mysqld

　[root@test1 var]# chmod -R 1777 /var/lib/mysql

　[root@test1 var]# chmod -R 1777 /var/run/mysqld

　[root@test1 var]# chmod -R 1777 /var/lib/mysql-cluster

 

  [root@test1 var]  vi /etc/config.ini

[computer]

Id=mgr-server-01

HostName=192.168.1.240

[mgm default]

datadir=/var/lib/mysql-cluster

[mgm]

HostName=192.168.1.240

NodeId=60

ExecuteOnComputer=mgr-server-01

PortNumber=1186

ArbitrationRank=2

[ndbd default]

NoOfReplicas=2

DataMemory=500M

IndexMemory=500M

[ndbd]

HostName=192.168.1.240

DataDir=/var/lib/mysql

NodeId=1

[ndbd]

HostName=192.168.1.241

DataDir=/var/lib/mysql

NodeId=2

       

　[root@test1 var] vi /etc/my.conf

[client]

socket=/var/lib/mysql/mysql.sock

[mysqld]

max_connections=100

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

ndbcluster

ndb-connectstring=192.168.1.240

[mysqld_safe]

log-error=/var/log/mysqld.log

#pid-file=/var/run/mysqld/mysqld.pid

pid-file=/var/lib/mysql/mysqld.pid

[mysql_cluster]

ndb-connectstring=192.168.1.240

 启动：

 注：关闭防火墙设置(可待调试成功后重新开启防火墙仅开放用到的端口)，selinux 设为 disabled

顺序：管理节点->均衡节点->数据节点 （关闭时相反：数据节点 service mysql stop ->均衡节点 ndb_mgm -e shutdown）

[root@test1 mysql-cluster]# ndb_mgmd -f /var/lib/mysql-cluster/config.ini  //启动 管理节点 操作 MySQL Cluster Management Server mysql-5.6.22 ndb-7.3.8 [root@test1 mysql-cluster]# ndbd --initial //均衡节启动 首次启动加 --initial 再次不需加 [root@test1 mysql-cluster]# mysqld_safe --defaults-file=/etc/my.cnf --explicit_defaults_for_timestamp & //启动数据节点

 查看连接情况：

[root@test1 ~]# ndb_mgm-- NDB Cluster -- Management Client --ndb_mgm> showConnected to Management Server at: 192.168.1.240:1186Cluster Configuration---------------------[ndbd(NDB)]     2 node(s)id=1    @192.168.1.240  (mysql-5.6.22 ndb-7.3.8, Nodegroup: 0)id=2    @192.168.1.241  (mysql-5.6.22 ndb-7.3.8, Nodegroup: 0, *)[ndb_mgmd(MGM)] 1 node(s)id=60   @192.168.1.240  (mysql-5.6.22 ndb-7.3.8)[mysqld(API)]   2 node(s)id=81   @192.168.1.240  (mysql-5.6.22 ndb-7.3.8)id=82   @192.168.1.241  (mysql-5.6.22 ndb-7.3.8)

 

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

进入mysql出错处理：

mysqld_safe --skip-grant-tables & mysql -uroot -p >use mysql; >update mysql.user set password=PASSWORD('123456') where User='root' ;  >flush privileges ; or //在mysql 配置文件中加入以下一句话 ，重新启动输入 mysql 进入命令行修改密码 [root@test1 files]# vi /etc/my.cnf

[mysqld] skip-grant-tables

[root@test1 files]# mysql

 

出错：

ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

>SET PASSWORD = PASSWORD('123456');