[+/-]
Managing a MySQL Cluster involves a number of tasks, the first of which is to configure and start MySQL Cluster. This is covered in Section 15.3, “MySQL Cluster Configuration”, and Section 15.4, “MySQL Cluster Programs”.
The next few sections cover the management of a running MySQL Cluster.
For information about security issues relating to management and deployment of a MySQL Cluster, see Section 15.5.8, “MySQL Cluster Security Issues”.
There are essentially two methods of actively managing a running
MySQL Cluster. The first of these is through the use of commands
entered into the management client whereby cluster status can be
checked, log levels changed, backups started and stopped, and nodes
stopped and started. The second method involves studying the
contents of the cluster log
ndb_
;
this is usually found in the management server's
node_id
_cluster.logDataDir
directory, but this location can be
overridden using the LogDestination
option
— see Section 15.3.2.4, “Defining a MySQL Cluster Management Server”, for
details. (Recall that node_id
represents
the unique identifier of the node whose activity is being logged.)
The cluster log contains event reports generated by
ndbd. It is also possible to send cluster log
entries to a Unix system log.
In addition, some aspects of the cluster's operation can be
monitored from an SQL node using the
SHOW ENGINE NDB
STATUS
statement. See Section 12.4.5.9, “SHOW ENGINE
Syntax”, for
more information.
User Comments
Add your own comment.