| 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 |
Setup circular replication |
| 7 |
RESET MASTER; |
| 8 |
SLAVE_SERVER_ID: 3 |
| 9 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST="127.0.0.1",SOURCE_PORT=SLAVE_PORT,SOURCE_USER="root"; |
| 10 |
Warnings: |
| 11 |
Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 12 |
Note 1760 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. |
| 13 |
START SLAVE; |
| 14 |
Warnings: |
| 15 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 16 |
MASTER_SERVER_ID: 1 |
| 17 |
Setup ndb_replication and exceptions tables |
| 18 |
Populate ndb_replication table as necessary |
| 19 |
replace into mysql.ndb_replication values |
| 20 |
("test", "t1", 3, 7, NULL), |
| 21 |
("test", "t1", 1, 7, "NDB$EPOCH()"), |
| 22 |
("test", "t2", 3, 7, NULL), |
| 23 |
("test", "t2", 1, 7, "NDB$EPOCH_TRANS()"); |
| 24 |
create table test.t1$EX |
| 25 |
(SERVER_ID int unsigned, |
| 26 |
NDB$MASTER_SERVER_ID int unsigned, |
| 27 |
NDB$MASTER_EPOCH bigint unsigned, |
| 28 |
NDB$COUNT int unsigned, |
| 29 |
a int not null, |
| 30 |
NDB$OP_TYPE ENUM('WRITE_ROW','UPDATE_ROW', 'DELETE_ROW') NOT NULL, |
| 31 |
NDB$CFT_CAUSE ENUM('ROW_DOES_NOT_EXIST','ROW_ALREADY_EXISTS','DATA_IN_CONFLICT','TRANS_IN_CONFLICT') NOT NULL, |
| 32 |
primary key(SERVER_ID, NDB$MASTER_SERVER_ID, NDB$MASTER_EPOCH, NDB$COUNT)) |
| 33 |
ENGINE=NDB; |
| 34 |
create table test.t1 ( |
| 35 |
a int not null, |
| 36 |
b int not null, |
| 37 |
c varchar(2000), |
| 38 |
primary key (a,b)) engine=ndb; |
| 39 |
MySQLD error output for server 1.1 matching pattern %Exceptions table % |
| 40 |
relevant |
| 41 |
[warning] replica: exceptions table t1$ex has wrong definition (column 1): |
| 42 |
drop table test.t1$EX, test.t1; |
| 43 |
create table test.t1$EX |
| 44 |
(NDB$SERVER_ID int unsigned, |
| 45 |
NDB$MASTER_SERVER_ID int unsigned, |
| 46 |
NDB$MASTER_EPOCH bigint unsigned, |
| 47 |
NDB$COUNT int unsigned, |
| 48 |
a$old int, |
| 49 |
a$new int, |
| 50 |
NDB$OP_TYPE ENUM('WRITE_ROW','UPDATE_ROW', 'DELETE_ROW') NOT NULL, |
| 51 |
NDB$CFT_CAUSE ENUM('ROW_DOES_NOT_EXIST','ROW_ALREADY_EXISTS','DATA_IN_CONFLICT','TRANS_IN_CONFLICT') NOT NULL, |
| 52 |
primary key(NDB$SERVER_ID, NDB$MASTER_SERVER_ID, NDB$MASTER_EPOCH, NDB$COUNT)) |
| 53 |
ENGINE=NDB; |
| 54 |
create table test.t1 ( |
| 55 |
a int not null, |
| 56 |
b int not null, |
| 57 |
c varchar(2000), |
| 58 |
primary key (a,b)) engine=ndb; |
| 59 |
MySQLD error output for server 1.1 matching pattern %Exceptions table % |
| 60 |
relevant |
| 61 |
[warning] replica: exceptions table t1$ex has wrong definition (column 5): old or new values of primary key columns cannot be referenced since primary keys cannot be updated, column a$new in table t1$ex |
| 62 |
drop table test.t1$EX, test.t1; |
| 63 |
create table test.t1$EX |
| 64 |
(NDB$SERVER_ID int unsigned, |
| 65 |
NDB$MASTER_SERVER_ID int unsigned, |
| 66 |
NDB$MASTER_EPOCH bigint unsigned, |
| 67 |
NDB$COUNT int unsigned, |
| 68 |
c$old varchar(2000) not null, |
| 69 |
c$new varchar(2000) not null, |
| 70 |
NDB$OP_TYPE ENUM('WRITE_ROW','UPDATE_ROW', 'DELETE_ROW') NOT NULL, |
| 71 |
NDB$CFT_CAUSE ENUM('ROW_DOES_NOT_EXIST','ROW_ALREADY_EXISTS','DATA_IN_CONFLICT','TRANS_IN_CONFLICT') NOT NULL, |
| 72 |
primary key(NDB$SERVER_ID, NDB$MASTER_SERVER_ID, NDB$MASTER_EPOCH, NDB$COUNT)) |
| 73 |
ENGINE=NDB CHARACTER SET latin1; |
| 74 |
create table test.t1 ( |
| 75 |
a int not null, |
| 76 |
b int not null, |
| 77 |
c varchar(2000), |
| 78 |
primary key (a,b)) engine=ndb CHARACTER SET latin1; |
| 79 |
MySQLD error output for server 1.1 matching pattern %Exceptions table % |
| 80 |
relevant |
| 81 |
[warning] replica: exceptions table t1$ex has wrong definition (column 5): old or new column reference c$new in table t1$ex is not nullable and doesn't have a default value |
| 82 |
drop table test.t1$EX, test.t1; |
| 83 |
create table test.t1$EX |
| 84 |
(NDB$SERVER_ID int unsigned, |
| 85 |
NDB$MASTER_SERVER_ID int unsigned, |
| 86 |
NDB$MASTER_EPOCH bigint unsigned, |
| 87 |
NDB$COUNT int unsigned, |
| 88 |
a int not null, |
| 89 |
NDB$OP_TYPE ENUM('WRITE_ROW','UPDATE_ROW', 'DELETE_ROW') NOT NULL, |
| 90 |
NDB$CFT_CAUSE ENUM('ROW_DOES_NOT_EXIST','ROW_ALREADY_EXISTS','DATA_IN_CONFLICT','TRANS_IN_CONFLICT') NOT NULL, |
| 91 |
primary key(NDB$SERVER_ID, NDB$MASTER_SERVER_ID, NDB$MASTER_EPOCH, NDB$COUNT)) |
| 92 |
ENGINE=NDB; |
| 93 |
create table test.t1 ( |
| 94 |
a int not null, |
| 95 |
b int not null, |
| 96 |
c varchar(2000), |
| 97 |
primary key (a,b)) engine=ndb; |
| 98 |
create table test.t2$ex |
| 99 |
(ndb$server_id int unsigned, |
| 100 |
ndb$master_server_id int unsigned, |
| 101 |
ndb$master_epoch bigint unsigned, |
| 102 |
ndb$count int unsigned, |
| 103 |
d varchar(2000), |
| 104 |
c int not null default 99, |
| 105 |
b int not null, |
| 106 |
a int not null, |
| 107 |
d$old varchar(2000), |
| 108 |
d$new varchar(2000), |
| 109 |
ndb$op_type enum('write_row','update_row', 'delete_row') not null, |
| 110 |
ndb$cft_cause enum('row_does_not_exist','row_already_exists','data_in_conflict','trans_in_conflict') not null, |
| 111 |
ndb$orig_transid bigint unsigned not null, |
| 112 |
e int, |
| 113 |
primary key(ndb$server_id, ndb$master_server_id, ndb$master_epoch, ndb$count)) |
| 114 |
engine=ndb CHARACTER SET latin1; |
| 115 |
create table test.t2 ( |
| 116 |
x int default 21, |
| 117 |
a int not null, |
| 118 |
b int not null, |
| 119 |
c int, |
| 120 |
d varchar(2000), |
| 121 |
e int, |
| 122 |
primary key(a,b)) engine=ndb CHARACTER SET latin1; |
| 123 |
Add some data |
| 124 |
stop slave; |
| 125 |
Warnings: |
| 126 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 127 |
Slave contents |
| 128 |
select * from t1 order by a; |
| 129 |
a b c |
| 130 |
1 2 Initial data 1 |
| 131 |
2 3 Initial data 2 |
| 132 |
3 4 Initial data 3 |
| 133 |
4 5 Initial data 4 |
| 134 |
5 6 Initial data 5 |
| 135 |
6 7 Initial data 6 |
| 136 |
7 8 Initial data 7 |
| 137 |
8 9 Initial data 8 |
| 138 |
9 10 Initial data 9 |
| 139 |
10 11 Initial data 10 |
| 140 |
select * from test.t2 order by a; |
| 141 |
x a b c d e |
| 142 |
21 1 2 3 Initial data 1 17 |
| 143 |
21 2 3 4 Initial data 2 17 |
| 144 |
21 3 4 5 Initial data 3 17 |
| 145 |
21 4 5 6 Initial data 4 17 |
| 146 |
21 5 6 7 Initial data 5 17 |
| 147 |
21 6 7 8 Initial data 6 17 |
| 148 |
21 7 8 9 Initial data 7 17 |
| 149 |
21 8 9 10 Initial data 8 17 |
| 150 |
21 9 10 11 Initial data 9 17 |
| 151 |
21 10 11 12 Initial data 10 17 |
| 152 |
Master contents |
| 153 |
select * from test.t1 order by a; |
| 154 |
a b c |
| 155 |
1 2 Master updated data 1 |
| 156 |
2 3 Master updated data 2 |
| 157 |
3 4 Master updated data 3 |
| 158 |
4 5 Master updated data 4 |
| 159 |
5 6 Master updated data 5 |
| 160 |
6 7 Master updated data 6 |
| 161 |
7 8 Master updated data 7 |
| 162 |
8 9 Master updated data 8 |
| 163 |
9 10 Master updated data 9 |
| 164 |
10 11 Master updated data 10 |
| 165 |
select * from test.t2 order by a; |
| 166 |
x a b c d e |
| 167 |
21 1 2 3 Master updated data 1 17 |
| 168 |
21 2 3 4 Master updated data 2 17 |
| 169 |
21 3 4 5 Master updated data 3 17 |
| 170 |
21 4 5 6 Master updated data 4 17 |
| 171 |
21 5 6 7 Master updated data 5 17 |
| 172 |
21 6 7 8 Master updated data 6 17 |
| 173 |
21 7 8 9 Master updated data 7 17 |
| 174 |
21 8 9 10 Master updated data 8 17 |
| 175 |
21 9 10 11 Master updated data 9 17 |
| 176 |
21 10 11 12 Master updated data 10 17 |
| 177 |
Slave contents |
| 178 |
select * from test.t1 order by a; |
| 179 |
a b c |
| 180 |
1 2 Slave updated data 1 |
| 181 |
2 3 Slave updated data 2 |
| 182 |
3 4 Slave updated data 3 |
| 183 |
4 5 Slave updated data 4 |
| 184 |
5 6 Slave updated data 5 |
| 185 |
6 7 Slave updated data 6 |
| 186 |
7 8 Slave updated data 7 |
| 187 |
8 9 Slave updated data 8 |
| 188 |
9 10 Slave updated data 9 |
| 189 |
10 11 Slave updated data 10 |
| 190 |
select * from test.t2 order by a; |
| 191 |
x a b c d e |
| 192 |
21 1 2 3 Slave updated data 1 17 |
| 193 |
21 2 3 4 Slave updated data 2 17 |
| 194 |
21 3 4 5 Slave updated data 3 17 |
| 195 |
21 4 5 6 Slave updated data 4 17 |
| 196 |
21 5 6 7 Slave updated data 5 17 |
| 197 |
21 6 7 8 Slave updated data 6 17 |
| 198 |
21 7 8 9 Slave updated data 7 17 |
| 199 |
21 8 9 10 Slave updated data 8 17 |
| 200 |
21 9 10 11 Slave updated data 9 17 |
| 201 |
21 10 11 12 Slave updated data 10 17 |
| 202 |
Primary should have rejected change from Secondary, keeping its value |
| 203 |
select * from t1 order by a; |
| 204 |
a b c |
| 205 |
1 2 Master updated data 1 |
| 206 |
2 3 Master updated data 2 |
| 207 |
3 4 Master updated data 3 |
| 208 |
4 5 Master updated data 4 |
| 209 |
5 6 Master updated data 5 |
| 210 |
6 7 Master updated data 6 |
| 211 |
7 8 Master updated data 7 |
| 212 |
8 9 Master updated data 8 |
| 213 |
9 10 Master updated data 9 |
| 214 |
10 11 Master updated data 10 |
| 215 |
select * from t2 order by a; |
| 216 |
x a b c d e |
| 217 |
21 1 2 3 Master updated data 1 17 |
| 218 |
21 2 3 4 Master updated data 2 17 |
| 219 |
21 3 4 5 Master updated data 3 17 |
| 220 |
21 4 5 6 Master updated data 4 17 |
| 221 |
21 5 6 7 Master updated data 5 17 |
| 222 |
21 6 7 8 Master updated data 6 17 |
| 223 |
21 7 8 9 Master updated data 7 17 |
| 224 |
21 8 9 10 Master updated data 8 17 |
| 225 |
21 9 10 11 Master updated data 9 17 |
| 226 |
21 10 11 12 Master updated data 10 17 |
| 227 |
start slave; |
| 228 |
Warnings: |
| 229 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 230 |
Secondary should have been realigned to Primary |
| 231 |
Slave contents |
| 232 |
select * from t1 order by a; |
| 233 |
a b c |
| 234 |
1 2 Master updated data 1 |
| 235 |
2 3 Master updated data 2 |
| 236 |
3 4 Master updated data 3 |
| 237 |
4 5 Master updated data 4 |
| 238 |
5 6 Master updated data 5 |
| 239 |
6 7 Master updated data 6 |
| 240 |
7 8 Master updated data 7 |
| 241 |
8 9 Master updated data 8 |
| 242 |
9 10 Master updated data 9 |
| 243 |
10 11 Master updated data 10 |
| 244 |
select * from t2 order by a; |
| 245 |
x a b c d e |
| 246 |
21 1 2 3 Master updated data 1 17 |
| 247 |
21 2 3 4 Master updated data 2 17 |
| 248 |
21 3 4 5 Master updated data 3 17 |
| 249 |
21 4 5 6 Master updated data 4 17 |
| 250 |
21 5 6 7 Master updated data 5 17 |
| 251 |
21 6 7 8 Master updated data 6 17 |
| 252 |
21 7 8 9 Master updated data 7 17 |
| 253 |
21 8 9 10 Master updated data 8 17 |
| 254 |
21 9 10 11 Master updated data 9 17 |
| 255 |
21 10 11 12 Master updated data 10 17 |
| 256 |
Show rollback of whole secondary transaction |
| 257 |
-------------------------------------------- |
| 258 |
flush logs; |
| 259 |
Slave contents |
| 260 |
select * from t1 order by a; |
| 261 |
a b c |
| 262 |
1 2 Master updated data 1 |
| 263 |
2 3 Master updated data 2 |
| 264 |
3 4 Master updated data 3 |
| 265 |
4 5 Master updated data 4 |
| 266 |
5 6 Master updated data 5 |
| 267 |
6 7 Master updated data 6 |
| 268 |
7 8 Master updated data 7 |
| 269 |
8 9 Master updated data 8 |
| 270 |
9 10 Master updated data 9 |
| 271 |
10 11 Master updated data 10 |
| 272 |
select * from t2 order by a; |
| 273 |
x a b c d e |
| 274 |
21 1 2 3 Master updated data 1 17 |
| 275 |
21 2 3 4 Master updated data 2 17 |
| 276 |
21 3 4 5 Master updated data 3 17 |
| 277 |
21 4 5 6 Master updated data 4 17 |
| 278 |
21 5 6 7 Master updated data 5 17 |
| 279 |
21 6 7 8 Master updated data 6 17 |
| 280 |
21 7 8 9 Master updated data 7 17 |
| 281 |
21 8 9 10 Master updated data 8 17 |
| 282 |
21 9 10 11 Master updated data 9 17 |
| 283 |
21 10 11 12 Master updated data 10 17 |
| 284 |
select count(*) from t1$EX; |
| 285 |
count(*) |
| 286 |
10 |
| 287 |
select NDB$OP_TYPE,NDB$CFT_CAUSE from t1$EX |
| 288 |
order by a; |
| 289 |
NDB$OP_TYPE NDB$CFT_CAUSE |
| 290 |
UPDATE_ROW DATA_IN_CONFLICT |
| 291 |
UPDATE_ROW DATA_IN_CONFLICT |
| 292 |
UPDATE_ROW DATA_IN_CONFLICT |
| 293 |
UPDATE_ROW DATA_IN_CONFLICT |
| 294 |
UPDATE_ROW DATA_IN_CONFLICT |
| 295 |
UPDATE_ROW DATA_IN_CONFLICT |
| 296 |
UPDATE_ROW DATA_IN_CONFLICT |
| 297 |
UPDATE_ROW DATA_IN_CONFLICT |
| 298 |
UPDATE_ROW DATA_IN_CONFLICT |
| 299 |
UPDATE_ROW DATA_IN_CONFLICT |
| 300 |
select count(*) from t2$ex; |
| 301 |
count(*) |
| 302 |
10 |
| 303 |
select a, b, c, d, d$old, d$new, e, ndb$count > 0,ndb$op_type,ndb$cft_cause, ndb$orig_transid > 0 from t2$ex order by a; |
| 304 |
a b c d d$old d$new e ndb$count > 0 ndb$op_type ndb$cft_cause ndb$orig_transid > 0 |
| 305 |
1 2 3 Slave updated data 1 Initial data 1 Slave updated data 1 17 1 update_row trans_in_conflict 1 |
| 306 |
2 3 4 Slave updated data 2 Initial data 2 Slave updated data 2 17 1 update_row trans_in_conflict 1 |
| 307 |
3 4 5 Slave updated data 3 Initial data 3 Slave updated data 3 17 1 update_row trans_in_conflict 1 |
| 308 |
4 5 6 Slave updated data 4 Initial data 4 Slave updated data 4 17 1 update_row trans_in_conflict 1 |
| 309 |
5 6 7 Slave updated data 5 Initial data 5 Slave updated data 5 17 1 update_row trans_in_conflict 1 |
| 310 |
6 7 8 Slave updated data 6 Initial data 6 Slave updated data 6 17 1 update_row trans_in_conflict 1 |
| 311 |
7 8 9 Slave updated data 7 Initial data 7 Slave updated data 7 17 1 update_row trans_in_conflict 1 |
| 312 |
8 9 10 Slave updated data 8 Initial data 8 Slave updated data 8 17 1 update_row trans_in_conflict 1 |
| 313 |
9 10 11 Slave updated data 9 Initial data 9 Slave updated data 9 17 1 update_row trans_in_conflict 1 |
| 314 |
10 11 12 Slave updated data 10 Initial data 10 Slave updated data 10 17 1 update_row trans_in_conflict 1 |
| 315 |
SET NAMES utf8; |
| 316 |
Warnings: |
| 317 |
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. |
| 318 |
replace into mysql.ndb_replication values |
| 319 |
("test", "アアア", 3, 7, NULL), |
| 320 |
("test", "アアア", 1, 7, "NDB$EPOCH_TRANS()"); |
| 321 |
create table test.`アアア$ex` |
| 322 |
(ndb$server_id int unsigned, |
| 323 |
ndb$master_server_id int unsigned, |
| 324 |
ndb$master_epoch bigint unsigned, |
| 325 |
ndb$count int unsigned, |
| 326 |
`キキキ` varchar(2000) charset utf8, |
| 327 |
`カカカ` int not null, |
| 328 |
ndb$op_type enum('write_row','update_row', 'delete_row') not null, |
| 329 |
ndb$cft_cause enum('row_does_not_exist','row_already_exists','data_in_conflict','trans_in_conflict') not null, |
| 330 |
ndb$orig_transid bigint unsigned not null, |
| 331 |
primary key(ndb$server_id, ndb$master_server_id, ndb$master_epoch, ndb$count)) |
| 332 |
engine=ndb; |
| 333 |
Warnings: |
| 334 |
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. |
| 335 |
create table test.`アアア` ( |
| 336 |
`カカカ` int primary key, |
| 337 |
`キキキ` varchar(2000) charset utf8) engine=ndb; |
| 338 |
Warnings: |
| 339 |
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. |
| 340 |
SET NAMES latin1; |
| 341 |
MySQLD error output for server 1.1 matching pattern %suspicious % column op_type % |
| 342 |
relevant |
| 343 |
SET NAMES utf8; |
| 344 |
Warnings: |
| 345 |
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. |
| 346 |
drop table test.`アアア`,test.`アアア$ex`; |
| 347 |
SET NAMES utf8; |
| 348 |
Warnings: |
| 349 |
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. |
| 350 |
replace into mysql.ndb_replication values |
| 351 |
("test", "アアア", 3, 7, NULL), |
| 352 |
("test", "アアア", 1, 7, "NDB$EPOCH_TRANS()"); |
| 353 |
create table test.`アアア$ex` |
| 354 |
(ndb$server_id int unsigned, |
| 355 |
ndb$master_server_id int unsigned, |
| 356 |
ndb$master_epoch bigint unsigned, |
| 357 |
ndb$count int unsigned, |
| 358 |
`キキキ$old` varchar(2000) charset utf8, |
| 359 |
`キキキ$new` varchar(2000) charset utf8, |
| 360 |
`カカカ` int not null, |
| 361 |
ndb$op_type enum('write_row','update_row', 'delete_row') not null, |
| 362 |
ndb$cft_cause enum('row_does_not_exist','row_already_exists','data_in_conflict','trans_in_conflict') not null, |
| 363 |
ndb$orig_transid bigint unsigned not null, |
| 364 |
primary key(ndb$server_id, ndb$master_server_id, ndb$master_epoch, ndb$count)) |
| 365 |
engine=ndb; |
| 366 |
Warnings: |
| 367 |
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. |
| 368 |
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. |
| 369 |
create table test.`アアア` ( |
| 370 |
`カカカ` int primary key, |
| 371 |
`キキキ` varchar(2000) charset utf8) engine=ndb; |
| 372 |
Warnings: |
| 373 |
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. |
| 374 |
SET NAMES latin1; |
| 375 |
MySQLD error output for server 1.1 matching pattern %suspicious % column op_type % |
| 376 |
relevant |
| 377 |
flush logs; |
| 378 |
drop table test.t1$EX, test.t1, test.t2$ex, test.t2; |
| 379 |
SET NAMES utf8; |
| 380 |
Warnings: |
| 381 |
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. |
| 382 |
drop table test.`アアア`, test.`アアア$ex`; |
| 383 |
SET NAMES latin1; |
| 384 |
flush logs; |
| 385 |
drop table mysql.ndb_replication; |
| 386 |
stop slave; |
| 387 |
Warnings: |
| 388 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 389 |
reset slave; |
| 390 |
Warnings: |
| 391 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 392 |
include/rpl_end.inc |