Debian Codegraph @

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

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