Debian Codegraph @

mysql-test/suite/rpl/r/rpl_innodb_redo_log.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 [Connection Master]
7 SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled';
8 VARIABLE_NAME VARIABLE_VALUE
9 Innodb_redo_log_enabled ON
10 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
11 Variable_name Value
12 Innodb_redo_log_enabled ON
13 CREATE TABLE tab1(c1 int,c2 text);
14 INSERT INTO tab1 VALUES(1,'Test');
15 include/sync_slave_sql_with_master.inc
16 [Connection Slave]
17 SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled';
18 VARIABLE_NAME VARIABLE_VALUE
19 Innodb_redo_log_enabled ON
20 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
21 Variable_name Value
22 Innodb_redo_log_enabled ON
23 SELECT * FROM tab1;
24 c1 c2
25 1 Test
26 [Connection Master]
27 SET @@global.innodb_redo_log_archive_dirs = 'label1:IRLA_DIRECTORY_1';
28 ALTER INSTANCE DISABLE INNODB REDO_LOG;
29 SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled';
30 VARIABLE_NAME VARIABLE_VALUE
31 Innodb_redo_log_enabled OFF
32 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
33 Variable_name Value
34 Innodb_redo_log_enabled OFF
35 SELECT innodb_redo_log_archive_start('label1');
36 ERROR HY000: Cannot perform operation as InnoDB redo logging is disabled. Please retry after enabling redo log with ALTER INSTANCE
37 CREATE TABLE tab2(c1 int,c2 text);
38 INSERT INTO tab2 VALUES(1,'Test');
39 include/sync_slave_sql_with_master.inc
40 [Connection Slave]
41 SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled';
42 VARIABLE_NAME VARIABLE_VALUE
43 Innodb_redo_log_enabled ON
44 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
45 Variable_name Value
46 Innodb_redo_log_enabled ON
47 SET @@global.innodb_redo_log_archive_dirs = 'label2:IRLA_DIRECTORY_1';
48 SELECT * FROM tab1;
49 c1 c2
50 1 Test
51 SELECT * FROM tab2;
52 c1 c2
53 1 Test
54 ALTER INSTANCE DISABLE INNODB REDO_LOG;
55 SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled';
56 VARIABLE_NAME VARIABLE_VALUE
57 Innodb_redo_log_enabled OFF
58 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
59 Variable_name Value
60 Innodb_redo_log_enabled OFF
61 DO innodb_redo_log_archive_start("label2");
62 ERROR HY000: Cannot perform operation as InnoDB redo logging is disabled. Please retry after enabling redo log with ALTER INSTANCE
63 [Connection Master]
64 SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled';
65 VARIABLE_NAME VARIABLE_VALUE
66 Innodb_redo_log_enabled OFF
67 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
68 Variable_name Value
69 Innodb_redo_log_enabled OFF
70 ALTER INSTANCE ENABLE INNODB REDO_LOG;
71 DROP TABLE tab1;
72 DROP TABLE tab2;
73 SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled';
74 VARIABLE_NAME VARIABLE_VALUE
75 Innodb_redo_log_enabled ON
76 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
77 Variable_name Value
78 Innodb_redo_log_enabled ON
79 # Set Default value on master side
80 SET @@global.innodb_redo_log_archive_dirs = '';
81 include/sync_slave_sql_with_master.inc
82 [Connection Slave]
83 ALTER INSTANCE ENABLE INNODB REDO_LOG;
84 SELECT * FROM performance_schema.global_status WHERE variable_name = 'innodb_redo_log_enabled';
85 VARIABLE_NAME VARIABLE_VALUE
86 Innodb_redo_log_enabled ON
87 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
88 Variable_name Value
89 Innodb_redo_log_enabled ON
90 # Set Default value on master side
91 SET @@global.innodb_redo_log_archive_dirs = '';
92 include/rpl_end.inc