集群开启mysql

集群开启mysql

sudo /usr/local/mysql/ndb_mgm -e shutdown – sql节点需要重新关闭再启动
sudo /usr/local/mysql/mgmd – 重启管理节点
sudo /usr/local/mysql/ndbd – 重启数据节点
sudo /usr/local/mysql/mysqld_safe– 重启SQL节点
sudo /usr/local/mysql/ndb_mgm -e show – 检查状态

/

• 关闭集群
  在管理节点所在的主机上执行下面命令
  [root@localhost config]# /cluster/bin/ndb_mgm -e shutdown
  Connected to Management Server at: localhost:1186
  3 NDB Cluster node(s) have shutdown.
  Disconnecting to allow management server to shutdown.

• 启动管理节点
  [root@localhost config]# /cluster/bin/ndb_mgmd -f /cluster_data/config/config.ini
  MySQL Cluster Management Server mysql-5.6.29 ndb-7.4.11

• 启动数据节点
  [root@localhost mysql-cluster-gpl-7.4.11]# /cluster/bin/ndbd
  2016-05-15 06:41:36 [ndbd] INFO – Angel connected to ‘192.168.XX.XXX:XXXX’
  2016-05-15 06:41:36 [ndbd] INFO – ## 标题 ##Angel allocated nodeid: 2

• 重启SQL节点
  [root@localhost mysql-cluster-gpl-7.4.11]# /cluster/bin/mysqladmin -usystem -p shutdown
  [root@localhost mysql-cluster-gpl-7.4.11]# /cluster/bin/mysqld_safe –defaults-file=/etc/my.cnf &
  //