Safe Shutdown and Restart of MySQL Cluster-opracowanie

Nasza ocena:

3
Wyświetleń: 441
Komentarze: 0
Notatek.pl

Pobierz ten dokument za darmo

Podgląd dokumentu
Safe Shutdown and Restart of MySQL Cluster-opracowanie - strona 1 Safe Shutdown and Restart of MySQL Cluster-opracowanie - strona 2

Fragment notatki:

Safe Shutdown and Restart of MySQL Cluster
To shut down the cluster, enter the following command in a shell on the machine hosting the
management node:
shell ndb_mgm -e shutdown
The -e option here is used to pass a command to the ndb_mgm client from the shell. (See
Section 17.4.26, “Options Common to MySQL Cluster Programs — Options Common to MySQL
Cluster Programs”, for more information about this option.) The command causes the ndb_mgm,
ndb_mgmd, and any ndbd or ndbmtd processes to terminate gracefully. Any SQL nodes can be
terminated using mysqladmin shutdown and other means. On Windows platforms, assuming that
you have installed the SQL node as a Windows service, you can use NET STOP MYSQL.
To restart the cluster on Unix platforms, run these commands:
• On the management host (192.168.0.10 in our example setup):
shell ndb_mgmd -f /var/lib/mysql-cluster/config.ini
• On each of the data node hosts (192.168.0.30 and 192.168.0.40):
shell ndbd
• Use the ndb_mgm client to verify that both data nodes have started successfully.
• On the SQL host (192.168.0.20):
shell mysqld_safe &
On Windows platforms, assuming that you have installed all MySQL Cluster processes as Windows
services using the default service names (see Section 17.2.3.4, “Installing MySQL Cluster Processes
as Windows Services”), you can restart the cluster as follows:
• On the management host (192.168.0.10 in our example setup), execute the following command:
C:\ NET START ndb_mgmd
• On each of the data node hosts (192.168.0.30 and 192.168.0.40), execute the following
command:
C:\ NET START ndbd
• On the management node host, use the ndb_mgm client to verify that the management node and
both data nodes have started successfully (see Section 17.2.3.3, “Initial Startup of MySQL Cluster on
Windows”).
• On the SQL node host (192.168.0.20), execute the following command:
C:\ NET START mysql
In a production setting, it is usually not desirable to shut down the cluster completely. In many cases,
even when making configuration changes, or performing upgrades to the cluster hardware or software
(or both), which require shutting down individual host machines, it is possible to do so without shutting
down the cluster as a whole by performing a rolling restart of the cluster. For more information about
doing this, see Section 17.5.5, “Performing a Rolling Restart of a MySQL Cluster”.
... zobacz całą notatkę

Komentarze użytkowników (0)

Zaloguj się, aby dodać komentarz