EC2 Instance Limitations Be aware of the following limitations of the EC2 instances before deploying your applications. Although these shouldn't affect your ability to deploy within the Amazon EC2 environment, they may alter the way you setu...
EF 5 Features Spatial Data Type (Geometry type support). Spatial data types support is backed up by the server capabilities which are documented at: Section 12.18, “Spatial Extensions” There are different types for spatial data, and the instant...
Efficiency. Setting up a MySQL Cluster on a private or protected network enables the cluster to make exclusive use of bandwidth between cluster hosts. Using a separate switch for your MySQL Cluster not only helps protect against unauthorized ac...
Enable InnoDB Memcached Binary Log with innodb_api_enable_binlog: • To use the InnoDB memcached plugin with the MySQL binary log, enable the innodb_api_enable_binlog [1740] configuration option on the master server. This option can only be set at...
Enum types Support • Enumeration types are used to define a set of named constants that may be assigned to a numeric value. • By default the underlying type of each element in the enum is int. But it can be specified another numeric type by using a colon. Example:enum Months : byte { Jan, Feb, M...
Evaluation of Database-Level Replication and Binary Logging Options When evaluating replication options, the slave begins by checking to see whether there are any -- replicate-do-db [2010] or --replicate-ignore-db [2011] options that apply. When using -- binlog-do-db [2041] or --binlog-ignore-db ...
Evaluation of Table-Level Replication Options The slave checks for and evaluates table options only if no matching database options were found (see Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”). First, as a preliminary condition, the slave checks whether...
Event Pre-Filtering Pre-filtering is done by the Performance Schema and has a global effect that applies to all users. Prefiltering can be applied to either the producer or consumer stage of event processing: • To configure pre-filtering at ...
Event Reports Generated in MySQL Cluster In this section, we discuss the types of event logs provided by MySQL Cluster, and the types of events that are logged. MySQL Cluster provides two types of event log: • The cluster log, which includes events generated by all cluster nodes. The cluster log...
Examining the Authentication Credentials with read_auth() The read_auth() function is triggered when an authentication handshake is initiated by the client. In the execution sequence, read_auth() occurs immediately after read_handshake(), so th...
