• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

The Geek Diary

CONCEPTS | BASICS | HOWTO

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • Linux Services
    • VCS
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
    • Data Guard
  • DevOps
    • Docker
    • Shell Scripting
  • Interview Questions
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

How To Start And Stop MySQL Cluster

By admin

It’s important to know how can we start and stop the entire MySQL cluster. In an earlier post, we have seen how to start/stop individual nodes on the MySQL Cluster without restarting the MySQL cluster itself.

Traditional Start and Stop

It is necessary to start each node in the cluster separately, in the following order:

  • Start the management node with the ndb_mgmd command
  • Start each data node with the ndbd command and option –nostart
  • Start each MySQL server (SQL node) using: mysqld_safe –user=mysql &

Each of these commands must be run from a system shell on the machine housing the affected node. You can verify the cluster is running by starting the MGM management client ndb_mgm on the machine housing the MGM node. Starting individual nodes can be done using the MGM management client start command:

mgm> 2 START

or if starting more than a specific node:

mgm> ALL START

To stop the server, use the MGM management client and use one of the commands:

mgm> 2 STOP    /* for individual node */
mgm> ALL STOP  /* stop all data nodes */
mgm> SHUTDOWN  /* stop the whole cluster */
How To Shut Down a Node in MySQL Cluster

Using MySQL Cluster Manager

The new MySQL Cluster Manager software allows the cluster to be configured and managed in a more user friendly way. To get a cluster up and going using the manager, the following steps should be taken:

  1. Install the MySQL Cluster Manager Agent on each of the different nodes.
  2. Download the cluster software package and make it available on each of the nodes.
  3. Create a site definition to manage the server and details.
  4. Create a package definition to manage the cluster software version.
  5. Create a cluster definition to manage the cluster and the nodes.
  6. Define the configuration settings for the cluster.
  7. Issue the start cluster command.

To stop the cluster, issue the command in MySQL Cluster Manager:

mcm> stop cluster mycluster;

Filed Under: mysql, MySQL Cluster

Some more articles you might also be interested in …

  1. Understanding MySQL Privileges
  2. How to backup and restore MySQL database
  3. How to Disable Client Access Control in MySQL
  4. mysqldump – How to Restore a Specific Database From a Backup of All Databases
  5. What is an Arbitrator in MySQL Cluster
  6. how to capture the SQL statements of a binary log and edit them before restoring the data (Point-in-time Recovery for MySQL)
  7. How to Generate Unique IDs For MySQL Cluster Backups
  8. How to configure resource groups for MySQL Server running on Linux
  9. MySQL – How to Backup User Privileges as CREATE USER and/or GRANT Statements
  10. Understanding MySQL Pluggable Authentication

You May Also Like

Primary Sidebar

Recent Posts

  • How to disable ACPI in CentOS/RHEL 7
  • How to Use real-time query to access data on a physical standby database
  • CentOS/RHEL 8: “ACPI MEMORY OR I/O RESET_REG” Server Hung after reboot
  • How to Create a Physical Standby Database by Using SQL and RMAN Commands
  • Archives
  • Contact Us
  • Copyright

© 2021 · The Geek Diary