Debian Codegraph @

mysql-test/suite/ndb_rpl/r/ndb_rpl_apply_status.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 *** on slave there should be zero rows ***
7 select count(*) from mysql.ndb_apply_status;
8 count(*)
9 0
10 create table t1 (a int key, b int) engine ndb;
11 insert into t1 values (1,1);
12 *** on master it should be empty ***
13 select * from mysql.ndb_apply_status where server_id <> 0;
14 server_id epoch log_name start_pos end_pos
15 #
16 # Bug#14139386 DDL APPLY SET MYSQL.NDB_APPLY_STATUS EPOCH=0
17 # - check that ndb_apply_status.epoch is not set to 0 by DDL
18 #
19 select epoch from mysql.ndb_apply_status into @epoch_before_alter;
20 alter table t1 add key k(b);
21 select epoch=@epoch_before_alter from mysql.ndb_apply_status;
22 epoch=@epoch_before_alter
23 1
24 # Check again with copying alter table
25 [connection master]
26 alter table t1 modify b varchar(255);
27 select epoch=@epoch_before_alter from mysql.ndb_apply_status;
28 epoch=@epoch_before_alter
29 1
30 # Check copying alter without any row in ndb_apply_status -> should insert
31 # row for source server_id with epoch 0
32 [connection slave]
33 stop replica;
34 reset replica;
35 select count(*) from mysql.ndb_apply_status;
36 count(*)
37 0
38 [connection master]
39 reset master;
40 alter table t1 modify b varchar(255);
41 [connection slave]
42 start replica;
43 [connection master]
44 select server_id, epoch, log_name from mysql.ndb_apply_status;
45 server_id epoch log_name
46 1 0 master-bin.000001
47 # End of test for Bug#14139386
48 *** on slave there should be one row ***
49 select count(*) from mysql.ndb_apply_status;
50 count(*)
51 1
52 drop table t1;
53 *** Test reset slave clearing ndb_apply_status ***
54 create table test.t1 (a int primary key) engine=ndb;
55 insert into test.t1 values (1);
56 Add a dummy entry
57 insert into mysql.ndb_apply_status values (999, 9677, 'CaramelLog', 1977, 2015);
58 select count(1) from mysql.ndb_apply_status;
59 count(1)
60 2
61 *** Standard reset slave should clear ndb_apply_status ***
62 stop slave;
63 Warnings:
64 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
65 reset slave;
66 Warnings:
67 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
68 select count(1) from mysql.ndb_apply_status;
69 count(1)
70 0
71 reset master;
72 include/rpl_start_slaves.inc
73 *** Test reset slave all ***
74 insert into test.t1 values (2);
75 Add a dummy entry
76 insert into mysql.ndb_apply_status values (999, 9677, 'CaramelLog', 1977, 2015);
77 select count(1) from mysql.ndb_apply_status;
78 count(1)
79 2
80 *** Reset slave all should clear ndb_apply_status ***
81 stop slave;
82 Warnings:
83 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
84 reset slave all;
85 Warnings:
86 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
87 select count(1) from mysql.ndb_apply_status;
88 count(1)
89 0
90 reset master;
91 RESET SLAVE ALL zapped Master info - re-set it.
92 include/rpl_change_topology.inc [new topology=1->2]
93 Warnings:
94 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
95 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.
96 include/rpl_start_slaves.inc
97 *** Test effect of ndb_clear_apply_status = 0 ***
98 set global ndb_clear_apply_status=0;
99 insert into test.t1 values (3);
100 Add a dummy entry
101 insert into mysql.ndb_apply_status values (999, 9677, 'CaramelLog', 1977, 2015);
102 select count(1) from mysql.ndb_apply_status;
103 count(1)
104 2
105 *** Standard reset slave should NOT clear ndb_apply_status ***
106 stop slave;
107 Warnings:
108 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
109 reset slave;
110 Warnings:
111 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
112 select count(1) from mysql.ndb_apply_status;
113 count(1)
114 2
115 delete from mysql.ndb_apply_status;
116 reset master;
117 include/rpl_start_slaves.inc
118 *** Test reset slave all ***
119 insert into test.t1 values (4);
120 Add a dummy entry
121 insert into mysql.ndb_apply_status values (999, 9677, 'CaramelLog', 1977, 2015);
122 select count(1) from mysql.ndb_apply_status;
123 count(1)
124 2
125 *** Reset slave all should NOT clear ndb_apply_status ***
126 stop slave;
127 Warnings:
128 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
129 reset slave all;
130 Warnings:
131 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
132 select count(1) from mysql.ndb_apply_status;
133 count(1)
134 2
135 reset master;
136 RESET SLAVE ALL zapped Master info - re-set it.
137 include/rpl_change_topology.inc [new topology=1->2]
138 Warnings:
139 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
140 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.
141 include/rpl_start_slaves.inc
142 set global ndb_clear_apply_status=1;
143 drop table test.t1;
144 include/rpl_end.inc
145 Warnings:
146 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
147 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.