SLTechnology News&Howtos › Database ›

Secure shutdown and restart methods of MySQL Cluster

Shulou Source: shulou.com Published: 2022-06-01 06:45:44 11月16日 Update

-- shut down the cluster

Execute the following command on the host where the management node resides

[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.

-- start the management node

[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

-- start the data node

[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.141purl 1186'

2016-05-15 06:41:36 [ndbd] INFO-- Angel allocated nodeid: 2

-- restart the SQL node

[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 &