Creating a Data Snapshot Using mysqldump One way to create a snapshot of the data in an existing master database is to use the mysqldump tool. Once the data dump has been completed, you then import this data into the slave before starting the replication process. To obtain a snapshot of the data...
Creating a Data Snapshot Using Raw Data Files If your database is large, copying the raw data files can be more efficient than using mysqldump and importing the file on each slave. This technique skips the overhead of updating indexes as the INSERT statements are replayed. Using this method with...
Creating a User for Replication Each slave must connect to the master using a MySQL user name and password, so there must be a user account on the master that the slave can use to connect. Any account can be used for this operation, providing it has been granted the REPLICATION SLAVE [775] privil...
Data Expiry There are two types of data expiry within a memcached instance. The first type is applied at the point when you store a new key/value pair into the memcached instance. If there is not enough space within a suitable slab to store th...
Data nodes. The only executable required on a data node host is the data node binary ndbd or ndbmtd. (mysqld, for example, does not have to be present on the host machine.) By default, when building from source, this file is placed in the directory /usr/local/mysql/bin. For installing on multiple...
Data nodes. On a computer that is to host a cluster data node it is necessary to install only the server RPM. To do so, copy this RPM to the data node host, and run the following command as the system root user, replacing the name shown for the R...
Data Stored on Disk, in Memory, or Both Table innodb_memcache.cache_policies specifies whether to store data written through the memcached on disk (innodb_only, the default); to store the data ...
Database-level replication options. The effects of the --replicate-do-db [2010], --replicate-ignore-db [2011], and --replicate-rewrite-db [2013] options differ considerably depending on whether row-based or statement-based logging is used. Because of this, it is recommended to avoid database-leve...
DDL Operations for MEMORY Tables To create a MEMORY table, specify the clause ENGINE=MEMORY on the CREATE TABLE statement. CREATE TABLE t (i INT) ENGINE = MEMORY; As indicated by the engine name,...
Default partitioning scheme. All MySQL Cluster tables are by default partitioned by KEY using the table's primary key as the partitioning key. If no primary key is explicitly set for the table, the “hidden” primary key automatically created by the...
