The Slave Relay Log The relay log, like the binary log, consists of a set of numbered files containing events that describe database changes, and an index file that contains the names of all used relay log files. The term “relay log file” generally denotes an individual numbered file containing d...
Transaction Isolation When a memcached operation such as get or incr causes a query or DML operation in the underlying InnoDB table, you can control whether it sees the very latest data written...
Transactional nontransactional and mixed statements. To apply those rules, the server considers a statement nontransactional if it changes only nontransactional tables, and transactional if it changes only transactional tables. In MySQL 5.6, a statement that references both nontransactional and t...
Transactions and BLOB or TEXT columns. NDBCLUSTER stores only part of a column value that uses any of MySQL's BLOB or TEXT data types in the table visible to MySQL; the remainder of the BLOB or TEXT is stored in a separate internal table that is not accessible to MySQL. This gives rise to two rel...
Transactions and memory usage. As noted elsewhere in this chapter, MySQL Cluster does not handle large transactions well; it is better to perform a number of small transactions with a few operations each than to attempt a single large transaction...
Transactions and the COUNT() function. When using MySQL Cluster Replication, it is not possible to guarantee the transactional consistency of the COUNT() function on the slave. In other words, when performing on the master a series of statements (INSERT, DELETE, or both) that changes the number o...
Troubleshooting Replication If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for messages. Many users have lost time by not doing this soon enough after encountering problems. If you cannot tell from the error log what ...
Using the InnoDB memcached Plugin with Replication Because the InnoDB memcached daemon plugin supports the MySQL binary log, any updates made on a master server through the memcached interface ...
Additional Resources. More information about MySQL Cluster can be found in the following places: • For answers to some commonly asked questions about MySQL Cluster, see Section B.10, “MySQL 5.6 FAQ: MySQL Cluster”. • The MySQL Cluster mailing list: http://lists.mysql.com/cluster. • The MySQL Cl...
Binlog dump thread. The master creates a thread to send the binary log contents to a slave when the slave connects. This thread can be identified in the output of SHOW PROCESSLIST on the master as the Binlog Dump thread. The binlog dump thread acquires a lock on the master's binary log for readin...
