Enable InnoDB Memcached Binary Log with innodb-opracowanie

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 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 server configuration file such
as my.cnf, or on the mysqld command line.
mysqld ... --log-bin --innodb_api_enable_binlog=1
• Then configure your master and slave server, as described in Section 16.1.1, “How to Set Up
Replication”.
• Use mysqldump to create a master data snapshot, and sync it to the slave server.
master shell: mysqldump --all-databases --lock-all-tables dbdump.db
slave shell: 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',
MASTER_PASSWORD='',
MASTER_PORT = 13000,
MASTER_LOG_FILE='0.000001,
MASTER_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 [Note] Slave I/O thread: connected to master 'root@localhost:13000',
replication started in log '0.000001' at position 114

(…)

…
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 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…
... zobacz całą notatkę