Debian Codegraph @

mysql-test/suite/rpl/t/rpl_ib_redolog_arch.test

raw
1 # ***************************************************************
2 # wl#12348 : This testcase is to test the functionality of the
3 # Red-Log Archiving in replication mode.
4 # ***************************************************************
5 --source include/master-slave.inc
6
7 --let $IRLA_DIRECTORY_1 = $MYSQLTEST_VARDIR/log/redo_log_archive_1
8 --mkdir $IRLA_DIRECTORY_1
9
10 --echo [Connection Master]
11 --connection master
12 --let $saved_master_dirs = `SELECT @@global.innodb_redo_log_archive_dirs`
13
14 --replace_result $IRLA_DIRECTORY_1 IRLA_DIRECTORY_1
15 eval SET @@global.innodb_redo_log_archive_dirs = 'label1:$IRLA_DIRECTORY_1';
16
17 --echo # Start redo log archiving on Master side
18 SELECT innodb_redo_log_archive_start('label1');
19
20 CREATE TABLE tab(c1 int , c2 text) ;
21
22 INSERT INTO tab VALUES(1, 'test the wl');
23
24 --source include/sync_slave_sql_with_master.inc
25 --echo [Connection Slave]
26 --let $saved_slave_dirs = `SELECT @@global.innodb_redo_log_archive_dirs`
27
28 SELECT COUNT(*) FROM tab;
29
30 --replace_result $IRLA_DIRECTORY_1 IRLA_DIRECTORY_1
31 eval SET @@global.innodb_redo_log_archive_dirs = 'label2:$IRLA_DIRECTORY_1';
32
33 --echo # Start redo log archiving on Slave side
34 Do innodb_redo_log_archive_start("label2");
35
36 --echo [Connection Master]
37 --connection master
38
39 INSERT INTO tab SELECT * FROM tab;
40
41 INSERT INTO tab SELECT * FROM tab;
42
43 --echo # Stop redo log archiving on Master side
44 DO innodb_redo_log_archive_stop();
45
46 --echo # Set Default value on master side
47 eval SET @@global.innodb_redo_log_archive_dirs = '$saved_master_dirs';
48
49 --source include/sync_slave_sql_with_master.inc
50 --echo [Connection Slave]
51
52 SELECT COUNT(*) FROM tab;
53
54 --echo # Stop redo log archiving on Slave side
55 DO innodb_redo_log_archive_stop();
56
57 --echo # Set Default value on slave side
58 eval SET @@global.innodb_redo_log_archive_dirs = '$saved_slave_dirs';
59
60 --echo [Connection Master]
61 --connection master
62
63 DROP TABLE tab;
64
65 --remove_files_wildcard $IRLA_DIRECTORY_1/ archive*
66 --rmdir $IRLA_DIRECTORY_1
67
68 --source include/rpl_end.inc
69