Debian Codegraph @

mysql-test/suite/rpl_nogtid/t/rpl_read_only_myisam.test

raw
1 # Test case for BUG #11733
2 --source include/not_have_privilege_checks_user.inc
3 -- source include/master-slave.inc
4 -- source include/force_myisam_default.inc
5 -- source include/have_myisam.inc
6
7 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
8
9 # Create a test and replicate it to slave
10 connection master;
11 create user test;
12 --source include/sync_slave_sql_with_master.inc
13
14 # Setting the master readonly :
15 # - the variable @@readonly is not replicated on the slave
16
17 connect (master2,127.0.0.1,test,,test,$MASTER_MYPORT,);
18 connect (slave2,127.0.0.1,test,,test,$SLAVE_MYPORT,);
19
20 connection master1;
21
22 create table t2(a int) engine=MyISAM;
23 insert into t2 values(2001);
24
25 connection master;
26 set global read_only=1;
27
28 connection master1;
29 select @@read_only;
30 select * from t2;
31
32 --source include/sync_slave_sql_with_master.inc
33 select @@read_only;
34 select * from t2;
35
36 # - replication of transactions
37 connection master;
38 set global read_only=0;
39
40 connection master1;
41 BEGIN;
42
43 connection master2;
44 BEGIN;
45
46 connection master;
47 select @@read_only;
48 set global read_only=1;
49
50 connection master1;
51 -- echo *** On SUPER USER connection ***
52 --disable_warnings
53 insert into t2 values(2002);
54 --enable_warnings
55
56 connection master2;
57 -- echo *** On regular USER connection ***
58 --error ER_OPTION_PREVENTS_STATEMENT
59 insert into t2 values(2003);
60
61 connection master1;
62 ## works even with read_only=1, because master1 is root
63 -- echo *** SUPER USER COMMIT (must succeed) ***
64 COMMIT;
65
66 connection master2;
67 -- echo *** regular USER COMMIT (must succeed - nothing to commit) ***
68 COMMIT;
69
70 connection master;
71 select @@read_only;
72 set global read_only=0;
73
74 connection master1;
75 insert into t2 values(2004);
76
77 select * from t2;
78
79 --source include/sync_slave_sql_with_master.inc
80 select * from t2;
81
82 # Setting the slave readonly : replication will pass
83 #
84 connection slave1;
85 set global read_only=1;
86
87 connection slave;
88 select @@read_only;
89 # Make sure the replicated table is not transactional
90 show create table t2;
91
92 connection master;
93 insert into t2 values(2005);
94 select * from t2;
95
96 --source include/sync_slave_sql_with_master.inc
97 connection slave;
98 select * from t2;
99
100 # Non root user can not write on the slave
101 connection slave2;
102 --error ER_OPTION_PREVENTS_STATEMENT
103 insert into t2 values(2006);
104
105 ## Cleanup
106 connection master;
107 drop user test;
108 drop table t2;
109 --source include/sync_slave_sql_with_master.inc
110 set global read_only=0;
111
112
113 --source include/rpl_end.inc