1--source include/have_debug.inc
2--source include/master-slave.inc
3
4connection master;
5SET GLOBAL BINLOG_CHECKSUM=NONE;
6connection slave;
7SET GLOBAL BINLOG_CHECKSUM=NONE;
8connection master;
9
10--echo **** On Master ****
11CREATE TABLE t1 (a INT);
12
13INSERT INTO t1 VALUES (1),(2),(3);
14SELECT * FROM t1;
15
16# This will generate an incident log event and store it in the binary
17# log before the replace statement.
18REPLACE INTO t1 VALUES (4);
19
20--sync_slave_with_master
21
22# Now, we should have inserted the row into the table and the slave
23# should be running. We should also have rotated to a new binary log.
24
25SELECT * FROM t1;
26source include/check_slave_is_running.inc;
27
28connection master;
29
30--echo Should have two binary logs here
31--source include/show_binary_logs.inc
32DROP TABLE t1;
33--sync_slave_with_master
34
35
36connection master;
37SET GLOBAL BINLOG_CHECKSUM=default;
38connection slave;
39SET GLOBAL BINLOG_CHECKSUM=default;
40connection master;
41
42--source include/rpl_end.inc
43