Changing the binary logging format within transactions. Beginning with MySQL 5.5.3, the binlog_format [2047] system variable is read-only as long as a transaction is in progress. (Bug #47863) Every transaction (including autocommit [479] transactions) is recorded in the binary log as though it s...
Controlling libmemcached Behaviors The behavior of libmemcached can be modified by setting one or more behavior flags. These can either be set globally, or they can be applied during the call to individual functions. Some behaviors also acce...
Foreign keys. Tables created using the NDB storage engine version 7.3.0 and later provide support for foreign key constraints. (This includes all MySQL Cluster NDB 7.3 releases.) For general information about how MySQL 5.6 and MySQL Cluster NDB 7.3 handle foreign keys, see Section 1.8.6.2, “FOREI...
GTID mode and mysqldump. In MySQL 5.6.9 and later, it is possible to import a dump made using mysqldump into a MySQL Server running with GTID mode enabled, provided that there are no GTIDs in the target server's binary log. Prior to MySQL 5.6.9, mysqldump did not record global transaction IDs, an...
Host computer type. Each host computer in our installation scenario is an Intel-based desktop PC running a supported operating system installed to disk in a standard configuration, and running no unnecessary services. The core operating system with standard TCP/IP networking capabilities should b...
InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses InnoDB through InnoDB APIs. Most of the APIs are directly adopted from embedded InnoDB. InnoDB API functions are passed to InnoDB memcached as “callback functions”. I...
Installing MySQL Cluster on Windows This section describes installation procedures for MySQL Cluster on Windows hosts. MySQL Cluster NDB 7.3 binaries for Windows can be obtained from http://dev.mysql.com/downloads/cluster/. For information about installing MySQL Cluster on Windows from a binary r...
Lack of binary log checksums. RBL uses no checksums. This means that network, disk, and other errors may not be identified when processing the binary log. To ensure that data is transmitted without network corruption, you may want to consider using SSL, which adds another layer of checksumming, f...
Loading Data To populate a MEMORY table when the MySQL server starts, you can use the --init-file [438] option. For example, you can put statements such as INSERT INTO ... SELECT or LOAD DATA INFILE into this file to load the table from a persistent data source. See Section 5.1.3, “Server Comman...
Machine architecture. All machines used in the cluster must have the same architecture. That is, all machines hosting nodes must be either big-endian or little-endian, and you cannot use a mixture of both. For example, you cannot have a managemen...
