MySQL集群的安全关闭和重启方法
--关闭集群
在管理节点所在的主机上执行下面命令
[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.78.141:1186'
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 &
文章题目:MySQL集群的安全关闭和重启方法
浏览路径:http://scyanting.com/article/jchhgi.html
在管理节点所在的主机上执行下面命令
[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.78.141:1186'
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 &
文章题目:MySQL集群的安全关闭和重启方法
浏览路径:http://scyanting.com/article/jchhgi.html