1include/master-slave.inc 2Warnings: 3Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. 4Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 5[connection master] 6SHOW VARIABLES LIKE 'relay_log_space_limit'; 7Variable_name Value 8relay_log_space_limit 0 9CREATE TABLE t1 (name varchar(64), age smallint(3))ENGINE=InnoDB; 10INSERT INTO t1 SET name='Andy', age=31; 11INSERT INTO t1 SET name='Jacob', age=2; 12INSERT INTO t1 SET name='Caleb', age=1; 13ALTER TABLE t1 ADD id int(8) ZEROFILL AUTO_INCREMENT PRIMARY KEY, 14ALGORITHM=COPY; 15SELECT * FROM t1 ORDER BY id; 16name age id 17Andy 31 00000001 18Jacob 2 00000002 19Caleb 1 00000003 20include/sync_slave_sql_with_master.inc 21SELECT * FROM t1 ORDER BY id; 22name age id 23Andy 31 00000001 24Jacob 2 00000002 25Caleb 1 00000003 26DROP TABLE t1; 27include/rpl_end.inc 28