89325

Enable InnoDB Memcached Binary Log with

innodb_api_enable_binlog:

•To use the InnoDB memcached plugin withthe MySQL binary log, enablethe innodb_api_enable_binlog [1740] configuration option on the master server. This option can

only be set at server boot time. You must also enable the MySQL binary log on the master server

with the —log-bin [2052] option. You can add these options to your sen/er configuration file such

asmy.cnf, or on the mysqld command linę.

mysqld ... —log-bin —innodb_api_enable_binlog*l

•    Then configure your master and slave server, as described in Section 16.1.1, “How to Set Up

Replication”.

•    Use mysąldump to create a master data snapshot, and sync it to the slave server.

master shell: mysąldump --all-databases —lock-all-tables > dbdump.db slave shell: mysąl < dbdump.db

•    On the master server, issue show master status to obtain the Master Binary Log Coordinates:

mysql> show master status;

•    On the slave server, use a change master to statement to set up a slave server with the above

coordinates:

mysql> CHANGE MASTER TO MASTER_HOST='localhost',

MASTER_USER=¹root',

MAST ER_PASSWORD='*,

MASTER_PORT = 13000,

MASTER_LOG_FILE =' 0. 000001,

MAST ER_LOG_POS-114;

•    Then start the slave:

mysql> start slave;

If the error log prints output similar to the following, the slave is ready for replication:

111002 18:47:15 [Notę] Slave I/O thread: connected to master 'root01ocalhost:13000',

replication started in log '0.000001' at position 114