Debian Codegraph @

mysql-test/suite/memcached/r/memc271_rpl_2.result

raw
1 SET @transaction_isolation= @@global.transaction_isolation;
2 SET GLOBAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
3 INSERT INTO cache_policies VALUES("cache_policy", "innodb_only",
4 "innodb_only", "innodb_only", "innodb_only");
5 INSERT INTO config_options VALUES("separator", "|");
6 INSERT INTO containers VALUES ("desc_t1", "test", "t1",
7 "c1", "c2,c21", "c3", "c4", "c5", "PRIMARY");
8 include/master-slave.inc
9 connection default;
10 connect $rpl_connection_name,127.0.0.1,root,,test,$_rpl_port,;
11 connection master;
12 connection server_1;
13 connect $rpl_connection_name,127.0.0.1,root,,test,$_rpl_port,;
14 connection master1;
15 connection server_1;
16 connect $rpl_connection_name,127.0.0.1,root,,test,$_rpl_port,;
17 connection slave;
18 connection server_1;
19 connect $rpl_connection_name,127.0.0.1,root,,test,$_rpl_port,;
20 connection slave1;
21 connection server_1;
22 connection server_1;
23 connection default;
24 [connection master]
25 connection master;
26 USE test;
27 DROP TABLE IF EXISTS t1;
28 CREATE TABLE t1 (c1 VARCHAR(32),
29 c2 VARCHAR(1024),
30 c21 VARCHAR(1024),
31 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
32 ENGINE = INNODB;
33 INSERT INTO t1 VALUES ('D', 'Darmstadt', 'City', 0, 0, 0);
34 INSERT INTO t1 VALUES ('B', 'Berlin', 'Mitte', 0, 0, 0);
35 INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', 0, 0 ,0);
36 INSERT INTO t1 VALUES ('H', 'Hamburg', 'Norderstedt', 0, 0, 0);
37 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
38 Warnings:
39 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
40 SELECT c1,c2,c21 FROM t1;
41 c1 c2 c21
42 B Berlin Mitte
43 C Cottbus West
44 D Darmstadt City
45 H Hamburg Norderstedt
46 Here are the memcached results with D,B,H,C:
47 Darmstadt|City
48 Berlin|Mitte
49 Hamburg|Norderstedt
50 Cottbus|West
51 SELECT c1,c2,c21 FROM t1;
52 c1 c2 c21
53 B Berlin Mitte
54 C Cottbus West
55 D Darmstadt City
56 H Hamburg Norderstedt
57 sync_slave_with_master;
58 connection slave;
59 connection slave;
60 SHOW CREATE TABLE t1;
61 Table Create Table
62 t1 CREATE TABLE `t1` (
63 `c1` varchar(32) NOT NULL,
64 `c2` varchar(1024) DEFAULT NULL,
65 `c21` varchar(1024) DEFAULT NULL,
66 `c3` int DEFAULT NULL,
67 `c4` bigint unsigned DEFAULT NULL,
68 `c5` int DEFAULT NULL,
69 PRIMARY KEY (`c1`)
70 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
71 SELECT c1,c2,c21 FROM t1;
72 c1 c2 c21
73 B Berlin Mitte
74 C Cottbus West
75 D Darmstadt City
76 H Hamburg Norderstedt
77 connection master;
78 Here are the memcached results after set:
79 Essen|Ost
80 SELECT c1,c2,c21 FROM t1;
81 c1 c2 c21
82 B Berlin Mitte
83 C Cottbus West
84 D Darmstadt City
85 E Essen Ost
86 H Hamburg Norderstedt
87 sync_slave_with_master;
88 connection slave;
89 connection slave;
90 SELECT c1,c2,c21 FROM t1;
91 c1 c2 c21
92 B Berlin Mitte
93 C Cottbus West
94 D Darmstadt City
95 E Essen Ost
96 H Hamburg Norderstedt
97 connection master;
98 Here are the memcached results after add:
99 Frankfurt|Sachsenhause
100 SELECT c1,c2,c21 FROM t1;
101 c1 c2 c21
102 B Berlin Mitte
103 C Cottbus West
104 D Darmstadt City
105 E Essen Ost
106 F Frankfurt Sachsenhause
107 H Hamburg Norderstedt
108 sync_slave_with_master;
109 connection slave;
110 connection slave;
111 SELECT c1,c2,c21 FROM t1;
112 c1 c2 c21
113 B Berlin Mitte
114 C Cottbus West
115 D Darmstadt City
116 E Essen Ost
117 F Frankfurt Sachsenhause
118 H Hamburg Norderstedt
119 connection master;
120 Here are the memcached results after replace:
121 Frankfurt a. M.|Sachsenhausen
122 SELECT c1,c2,c21 FROM t1;
123 c1 c2 c21
124 B Berlin Mitte
125 C Cottbus West
126 D Darmstadt City
127 E Essen Ost
128 F Frankfurt a. M. Sachsenhausen
129 H Hamburg Norderstedt
130 sync_slave_with_master;
131 connection slave;
132 connection slave;
133 SELECT c1,c2,c21 FROM t1;
134 c1 c2 c21
135 B Berlin Mitte
136 C Cottbus West
137 D Darmstadt City
138 E Essen Ost
139 F Frankfurt a. M. Sachsenhausen
140 H Hamburg Norderstedt
141 connection master;
142 Here are the memcached results after delete:
143 SELECT c1,c2,c21 FROM t1;
144 c1 c2 c21
145 B Berlin Mitte
146 C Cottbus West
147 D Darmstadt City
148 E Essen Ost
149 H Hamburg Norderstedt
150 sync_slave_with_master;
151 connection slave;
152 connection slave;
153 SELECT c1,c2,c21 FROM t1;
154 c1 c2 c21
155 B Berlin Mitte
156 C Cottbus West
157 D Darmstadt City
158 E Essen Ost
159 H Hamburg Norderstedt
160 connection master;
161 Here are the memcached results after add Frankfurt|:
162 Frankfurt|
163 Here are the memcached results after add |Airport:
164 Frankfurt|
165 SELECT c1,c2,c21 FROM t1;
166 c1 c2 c21
167 B Berlin Mitte
168 C Cottbus West
169 D Darmstadt City
170 E Essen Ost
171 F Frankfurt NULL
172 H Hamburg Norderstedt
173 sync_slave_with_master;
174 connection slave;
175 connection slave;
176 SELECT c1,c2,c21 FROM t1;
177 c1 c2 c21
178 B Berlin Mitte
179 C Cottbus West
180 D Darmstadt City
181 E Essen Ost
182 F Frankfurt NULL
183 H Hamburg Norderstedt
184 connection master;
185 Here are the memcached results after replace Frankfurt a.M.:
186 Frankfurt a. M.|
187 Here are the memcached results after replace Sachsenhausen:
188 |Sachsenhausen
189 SELECT c1,c2,c21 FROM t1;
190 c1 c2 c21
191 B Berlin Mitte
192 C Cottbus West
193 D Darmstadt City
194 E Essen Ost
195 F NULL Sachsenhausen
196 H Hamburg Norderstedt
197 sync_slave_with_master;
198 connection slave;
199 connection slave;
200 SELECT c1,c2,c21 FROM t1;
201 c1 c2 c21
202 B Berlin Mitte
203 C Cottbus West
204 D Darmstadt City
205 E Essen Ost
206 F NULL Sachsenhausen
207 H Hamburg Norderstedt
208 connection master;
209 DROP TABLE t1;
210 connection slave;
211 include/rpl_end.inc
212 connection default;
213 UNINSTALL PLUGIN daemon_memcached;
214 DROP DATABASE innodb_memcache;
215 SET @@global.transaction_isolation= @transaction_isolation;