1source include/have_innodb.inc; 2source include/have_log_bin.inc; 3 4# 5# WL#2540 replication event checksum 6# 7# Objectives of the test are: 8# to demo binlog events with CRC32 checksum in them and 9# to prove show binlog events and mysqlbinlog are capable to handle 10# the checksum. 11# 12 13set @save_binlog_checksum = @@global.binlog_checksum; 14set @save_master_verify_checksum = @@global.master_verify_checksum; 15set @@global.binlog_checksum = CRC32; 16set @@global.master_verify_checksum = 1; 17let $MYSQLD_DATADIR= `select @@datadir`; 18 19reset master; 20--echo must be master-bin.000001 21--source include/show_binary_logs.inc 22 23create table t1 (a int); 24flush logs; 25copy_file $MYSQLD_DATADIR/master-bin.000001 $MYSQLD_DATADIR/master-bin.saved; 26drop table t1; 27 28# Reset GTIDs 29RESET MASTER; 30 31--exec $MYSQL_BINLOG -c $MYSQLD_DATADIR/master-bin.saved | $MYSQL 32remove_file $MYSQLD_DATADIR/master-bin.saved; 33--source include/show_binlog_events.inc 34show tables; 35 36# clean-up 37 38drop table t1; 39set @@global.binlog_checksum = @save_binlog_checksum; 40set @@global.master_verify_checksum = @save_master_verify_checksum; 41 42--echo End of the tests 43