Rolling restarts with multiple management servers. When performing a rolling restart of a MySQL Cluster with multiple management nodes, you should keep in mind that ndb_mgmd checks to see if any other management node is running, and, if so, tries...
Row based format. Tells the server not to log updates to any tables in the database db_name. The current database has no effect. When using statement-based logging, the following example does not work as you might expect. Suppose that the server is started with --binlog-ignore-db=sales [2043] and...
Safe Shutdown and Restart of MySQL Cluster To shut down the cluster, enter the following command in a shell on the machine hosting the manage...
Safe slave shutdown when using temporary tables. Temporary tables are replicated except in the case where you stop the slave server (not just the slave threads) and you have replicated temporary tables that are open for use in updates that have ...
Sample data. We use the world database which is available for download from the MySQL Web site (see http://dev.mysql.com/doc/index-other.html). We assume that each machine has sufficient memory for running the operating system, required MySQL Cluster processes, and (on the data nodes) storing the...
SCI Transport Connections in MySQL Cluster [sci] sections in the config.ini file explicitly define SCI (Scalable Coherent Interface) connections between cluster nodes. Using SCI transporters in MySQL Cluster is supported only when the MySQL binaries are built using --with-ndb-sci=/your/path/to/SC...
Sections of the config.ini File There are six different sections that you can use in the config.ini configuration file, as described in the following list: • [computer]: Defines cluster hosts. This is not required to configure a viable MySQL Cluster, but be may used as a convenience when setting...
Semisynchronous Replication Monitoring The plugins for the semisynchronous replication capability expose several system and status variables that you can examine to determine its configuration and operational state. The system variable reflect how semisynchronous replication is configured. To che...
Semisynchronous Replication MySQL 5.6 supports an interface to semisynchronous replication in addition to the built-in asynchronous replication. This section discusses what semisynchronous replication is and how it works. The following sections cover the administrative interface to semisynchronou...
Setting the Replication Master Configuration On a replication master, you must enable binary logging and establish a unique server ID. If this has not already been done, this part of master setup requires a server restart. Binary logging must be enabled on the master because the binary log is the...
