Debian Codegraph @

mysql-test/suite/group_replication/r/gr_innodb_doublewrite_dir.result

raw
1 include/group_replication.inc [rpl_server_count=3]
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 server1]
6
7 [connection server1]
8 include/start_and_bootstrap_group_replication.inc
9
10 [connection server2]
11 include/start_group_replication.inc
12 include/rpl_gr_wait_for_number_of_members.inc
13
14 [connection server3]
15 SET GLOBAL group_replication_group_name= "GROUP_REPLICATION_DOUBELWRITE";
16 [connection server1]
17 ALTER INSTANCE DISABLE INNODB REDO_LOG;
18 SET sql_log_bin = 0;
19 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* InnoDB redo logging is disabled. All data could be lost in case of a server crash");
20 SET sql_log_bin = 1;
21 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
22 Variable_name Value
23 Innodb_redo_log_enabled OFF
24 CREATE TABLE test.tab ( c1 int primary key, c2 TEXT);
25 INSERT INTO test.tab VALUES(1, 'Test wl#5655');
26 SELECT @@innodb_doublewrite_dir;
27 @@innodb_doublewrite_dir
28 NULL
29 SELECT @@innodb_doublewrite_files;
30 @@innodb_doublewrite_files
31 1
32 SELECT @@innodb_doublewrite_pages;
33 @@innodb_doublewrite_pages
34 1
35 SELECT @@innodb_doublewrite_batch_size;
36 @@innodb_doublewrite_batch_size
37 1
38 include/rpl_sync.inc
39
40 [connection server3]
41 START GROUP_REPLICATION;
42
43 [connection server2]
44 ALTER INSTANCE DISABLE INNODB REDO_LOG;
45 SET sql_log_bin = 0;
46 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* InnoDB redo logging is disabled. All data could be lost in case of a server crash");
47 SET sql_log_bin = 1;
48 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
49 Variable_name Value
50 Innodb_redo_log_enabled OFF
51 SELECT @@innodb_doublewrite_dir;
52 @@innodb_doublewrite_dir
53 NULL
54 SELECT @@innodb_doublewrite_files;
55 @@innodb_doublewrite_files
56 2
57 SELECT @@innodb_doublewrite_pages;
58 @@innodb_doublewrite_pages
59 2
60 SELECT @@innodb_doublewrite_batch_size;
61 @@innodb_doublewrite_batch_size
62 10
63
64 #Validating the records in server3#
65 [connection server3]
66 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
67 Variable_name Value
68 Innodb_redo_log_enabled ON
69 SELECT * FROM test.tab;
70 c1 c2
71 1 Test wl#5655
72 SELECT @@innodb_doublewrite_dir;
73 @@innodb_doublewrite_dir
74 NULL
75 SELECT @@innodb_doublewrite_files;
76 @@innodb_doublewrite_files
77 0
78 SELECT @@innodb_doublewrite_pages;
79 @@innodb_doublewrite_pages
80 0
81 SELECT @@innodb_doublewrite_batch_size;
82 @@innodb_doublewrite_batch_size
83 0
84 SET GLOBAL innodb_doublewrite_dir=$MYSQL_TMP_DIR/"#DBWL-DIR";
85 ERROR HY000: Variable 'innodb_doublewrite_dir' is a read only variable
86 SET GLOBAL innodb_doublewrite_files=1;
87 ERROR HY000: Variable 'innodb_doublewrite_files' is a read only variable
88 SET GLOBAL innodb_doublewrite_pages=10;
89 ERROR HY000: Variable 'innodb_doublewrite_pages' is a read only variable
90 SET GLOBAL innodb_doublewrite_batch_size=1;
91 ERROR HY000: Variable 'innodb_doublewrite_batch_size' is a read only variable
92 include/rpl_sync.inc
93
94 #Validating the records in server2
95 [connection server2]
96 ALTER INSTANCE ENABLE INNODB REDO_LOG;
97 SET sql_log_bin = 0;
98 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.");
99 SET sql_log_bin = 1;
100 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
101 Variable_name Value
102 Innodb_redo_log_enabled ON
103 SELECT * FROM test.tab;
104 c1 c2
105 1 Test wl#5655
106 SET GLOBAL innodb_doublewrite_dir=$MYSQL_TMP_DIR/"#DBWL-DIR";
107 ERROR HY000: Variable 'innodb_doublewrite_dir' is a read only variable
108 SET GLOBAL innodb_doublewrite_files=1;
109 ERROR HY000: Variable 'innodb_doublewrite_files' is a read only variable
110 SET GLOBAL innodb_doublewrite_pages=10;
111 ERROR HY000: Variable 'innodb_doublewrite_pages' is a read only variable
112 SET GLOBAL innodb_doublewrite_batch_size=1;
113 ERROR HY000: Variable 'innodb_doublewrite_batch_size' is a read only variable
114 [connection server1]
115 ALTER INSTANCE ENABLE INNODB REDO_LOG;
116 SET sql_log_bin = 0;
117 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.");
118 SET sql_log_bin = 1;
119 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
120 Variable_name Value
121 Innodb_redo_log_enabled ON
122
123 DROP TABLE test.tab;
124 include/rpl_sync.inc
125 STOP GROUP_REPLICATION;
126 include/group_replication_end.inc