Defining MySQL Cluster Data Nodes The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data nodes. [ndbd] and [ndbd default] are always used as the section names whether you are using ndbd or ndbmtd binaries for the data node processes. There are many param...
Delayed Replication MySQL 5.6 supports delayed replication such that a slave server deliberately lags behind the master by at least a specified amount of time. The default delay is 0 seconds. Use the MASTER_DELAY option for CHANGE MASTER TO to set the delay to N seconds: CHANGE MASTER TO MASTER_...
Delete commands: delete Deletion commands take the form: delete key [time] [noreply] Where: • key: The key name. • time: The time in seconds (or a specific Unix time) for which the client wishes the server to refuse add or replace commands on ...
Deploying a MySQL Database Using EC2 Because you cannot guarantee the uptime and availability of your EC2 instances, when deploying MySQL within the EC2 environment, use an approach that enables you to easily distribute work among your EC2 i...
Determination of Safe and Unsafe Statements in Binary Logging When speaking of the “safeness” of a statement in MySQL Replication, we are referring to whether a statement and its effects can be replicated correctly using statement-based format. If this is true of the statement, we refer to the st...
Determining What Is Instrumented It is always possible to determine what instruments the Performance Schema includes by checking the setup_instruments table. For example, to see what file-related events are instrumented for the InnoDB storag...
Developing a memcached Application A number of language interfaces let applications store and retrieve information with memcached servers. You can write memcached applications in popular languages such as Perl, PHP, Python, Ruby, C, and Java. ...
Direct the slave to use the master. Instruct the slave to use the master as the replication data source, and to use GTID-based auto-positioning rather than file-based positioning. You can do this by executing a CHANGE MASTER TO statement on the slave, using the MASTER_AUTO_POSITION option to tell...
Disadvantages of row-based replication • RBR tends to generate more data that must be logged. To replicate a DML statement (such as an UPDATE or DELETE statement), statement-based replication writes only the statement to the binary log. By contrast, row-based replication writes each changed row t...
Dynamic Table Characteristics Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table option. Dynamic format is a lit...
