Debian Codegraph @

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

raw
1 # *************************************************************
2 # Test the following DDL not to replay on slave
3 # ALTER INSTANCE [ENABLE|DISABLE] INNODB REDO_LOG and
4 # Check Red-Log Archive error cases when redo_log disable
5 # *************************************************************
6 --source include/master-slave.inc
7
8 --disable_query_log
9 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* InnoDB redo logging is disabled. All data could be lost in case of a server crash");
10 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* InnoDB redo logging is enabled. Data is now safe and can be recovered in case of a server crash.");
11 --enable_query_log
12
13 --echo [Connection Master]
14 --connection master
15
16 # Check Default status of the redo_log on Master
17 SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled';
18 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
19
20 #Check DDL and DML operations on Master
21 CREATE TABLE tab1(c1 int,c2 text);
22 INSERT INTO tab1 VALUES(1,'Test');
23
24 --source include/sync_slave_sql_with_master.inc
25 --echo [Connection Slave]
26
27 #Check Default status of the redo_log on Slave
28 SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled';
29 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
30
31 #Check DDL and DML operations on Slave
32 SELECT * FROM tab1;
33
34 --echo [Connection Master]
35 --connection master
36
37 --let $IRLA_DIRECTORY_1 = $MYSQLTEST_VARDIR/log/redo_log_archive_1
38 --mkdir $IRLA_DIRECTORY_1
39
40 --let $saved_master_dirs = `SELECT @@global.innodb_redo_log_archive_dirs`
41
42 # Set the redo_log_archive path on master
43 --replace_result $IRLA_DIRECTORY_1 IRLA_DIRECTORY_1
44 eval SET @@global.innodb_redo_log_archive_dirs = 'label1:$IRLA_DIRECTORY_1';
45
46 # Set Disable On Master
47 ALTER INSTANCE DISABLE INNODB REDO_LOG;
48
49 # Check redo_log status DISABLE on Master as set
50 SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled';
51 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
52
53 # Try to start redo log Archiving On Master
54 --error ER_INNODB_REDO_DISABLED
55 SELECT innodb_redo_log_archive_start('label1');
56
57 #Check DDL and DML operations on Master, after redo_log status disable
58 CREATE TABLE tab2(c1 int,c2 text);
59 INSERT INTO tab2 VALUES(1,'Test');
60
61 --source include/sync_slave_sql_with_master.inc
62 --echo [Connection Slave]
63
64 --let $saved_slave_dirs = `SELECT @@global.innodb_redo_log_archive_dirs`
65
66 # Check redo_log status still ENABLE on Slave
67 SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled';
68 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
69
70 # Set the redo_log_archive path on slave
71 --replace_result $IRLA_DIRECTORY_1 IRLA_DIRECTORY_1
72 eval SET @@global.innodb_redo_log_archive_dirs = 'label2:$IRLA_DIRECTORY_1';
73
74 #Check DDL and DML operations on Slave
75 SELECT * FROM tab1;
76 SELECT * FROM tab2;
77
78 # Set Disable On Slave
79 ALTER INSTANCE DISABLE INNODB REDO_LOG;
80
81 # Check redo_log status DISABLE on Slave
82 SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled';
83 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
84
85 # Try to start redo log Archiving On Slave
86 --error ER_INNODB_REDO_DISABLED
87 DO innodb_redo_log_archive_start("label2");
88
89 --echo [Connection Master]
90 --connection master
91
92 # Check redo_log status still Disable on Slave
93 SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled';
94 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
95
96 # Set Enable On Master
97 ALTER INSTANCE ENABLE INNODB REDO_LOG;
98
99 #clean up
100 DROP TABLE tab1;
101 DROP TABLE tab2;
102
103 # Check redo_log status Enable on Master
104 SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled';
105 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
106
107 --echo # Set Default value on master side
108 eval SET @@global.innodb_redo_log_archive_dirs = '$saved_master_dirs';
109
110 --source include/sync_slave_sql_with_master.inc
111 --echo [Connection Slave]
112
113 # Set Enable On Slave
114 ALTER INSTANCE ENABLE INNODB REDO_LOG;
115
116 # Check redo_log status Enable on Slave
117 SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled';
118 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
119
120 --echo # Set Default value on master side
121 eval SET @@global.innodb_redo_log_archive_dirs = '$saved_master_dirs';
122
123 --remove_files_wildcard $IRLA_DIRECTORY_1/ archive*
124 --rmdir $IRLA_DIRECTORY_1
125
126 --source include/rpl_end.inc