Example Consumer Configurations The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. The following discussion describes how consumers work, showing specific configurations and their effects as consumer settings are enabled progressively from high to low...
Excluding transactions with gtid_purged. The master's global gtid_purged [2061] variable contains the set of all transactions that have been purged from the master's binary log. As with the method discussed previously (see Injecting empty transactions), you can record the value of gtid_executed [...
FEDERATED Storage Engine Notes and Tips You should be aware of the following points when using the FEDERATED storage engine: • FEDERATED tables may be replicated to other slaves, but you must ensure that the slave servers are able to use the user/password combination that is defined in the CONNEC...
FEDERATED Storage Engine Overview When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the associated d...
Filtering based on server ID not supported. A common practice is to filter out changes on some slaves by using a WHERE clause that includes the relation @@server_id id_value clause with UPDATE and DELETE statements, a simple example of such a clause being WHERE @@server_id 1. However, this does...
Frequency of Commits One tradeoff between durability and raw performance is how frequently new and changed data is committed. If the data is critical, you want it to be committed immediately so that it is safe in case of any crash or outage....
Getting memcached Statistics The memcached system has a built-in statistics system that collects information about the data being stored into the cache, cache hit ratios, and detailed information on the
Global and Thread Consumers • global_instrumentation is the highest level consumer. If global_instrumentation is NO, it disables global instrumentation. All other settings are lower level and are not checked; it does not matter what they are set to. No global or per thread information is maintain...
GTID Concepts A global transaction identifier (GTID) is a unique identifier created and associated with each transaction when it is committed on the server of origin (master). This identifier is unique not only to the server on which it originate...
GTID mode and mysql_upgrade. Prior to MySQL 5.6.7, mysql_upgrade could not connect to a MySQL Server that was running with --gtid-mode=ON [2057] unless mysql_upgrade was run with --write-binlog=OFF [255]. (Otherwise, mysqld had to be restarted with --gtid-mode=OFF before running mysql_upgrade, th...
