Statement-based replication. When using statement-based replication, a simple rule of thumb to follow is, “If the statement run on the master would also execute successfully on the slave, it should also replicate successfully”. In other words, if the statement uses a value that is compatible with ...
Statement Event Consumers These consumers require both global_instrumentation and thread_instrumentation to be YES or they are not checked. • events_statements_current, if NO, disables collection of individual statement events in the events_statements_current table. If YES, it enables statement ...
Statements that are unsafe for SBR. Not all statements which modify data (such as INSERT DELETE, UPDATE, and REPLACE statements) can be replicated using statement-based replication. Any nondeterministic behavior is difficult to replicate when using statement-based replication. Examples of such DM...
Static Table Characteristics Static format is the default for MyISAM tables. It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Each row is stored using a fixed number of bytes. Of the three MyISAM ...
Statistics commands: stats The stats command provides detailed statistical information about the current status of the memcached instance and the data it is storing. Statistics commands take the form: STAT [name] [value] Where: • name: The ...
Supported conversions. Supported conversions between different but similar data types are shown in the following list: • Between any of the integer types TINYINT, SMALLINT, MEDIUMINT, INT, and BIGINT. This includes conversions between the signed and unsigned versions of these types. Lossy conver...
Switching Masters During Failover There is currently no official solution for providing failover between master and slaves in the event of a failure. With the currently available features, you would have to set up a master and a slave (or several slaves), and to write a script that monitors the m...
System reset (cluster reset). To reset the cluster because it has reached an undesirable state. In such cases it is often desirable to reload the data and metadata of one or more data nodes. This can be done in any of three ways: • Start each data node process (ndbd or possibly ndbmtd) with the -...
Temporary tables and replication options. By default, all temporary tables are replicated; this happens whether or not there are any matching --replicate-do-db [2010], --replicatedo- table [2012], or --replicate-wild-do-table [2014] options in effect. However, the -- replicate-ignore-table [2013]...
The Common Database Server Layer A MySQL pluggable storage engine is the component in the MySQL database server that is responsible for performing the actual data I/O operations for a database as well as enabling and enforcing certain feature se...
