集群开启mysql

来源：互联网发布：知非之年意思是什么编辑：程序博客网时间：2024/04/28 23:22

集群开启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 &
//////////////////////////////////////////////

0 0