mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +01:00
71 lines
1.6 KiB
Text
71 lines
1.6 KiB
Text
connection node_2;
|
|
connection node_1;
|
|
connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
|
|
create user repl@'%' identified by 'repl';
|
|
grant all on *.* to repl@'%';
|
|
flush privileges;
|
|
ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
|
|
connection node_1;
|
|
connection node_2;
|
|
connection node_2;
|
|
START SLAVE;
|
|
connection node_3;
|
|
CREATE TABLE t1 (id bigint primary key, msg varchar(100)) engine=innodb;
|
|
SELECT COUNT(*) AS EXPECT_10000 FROM t1;
|
|
EXPECT_10000
|
|
10000
|
|
connection node_2;
|
|
SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
|
|
EXPECT_1
|
|
1
|
|
SELECT COUNT(*) AS EXPECT_10000 FROM t1;
|
|
EXPECT_10000
|
|
10000
|
|
connection node_1;
|
|
SELECT COUNT(*) AS EXPECT_0 FROM mysql.gtid_slave_pos;
|
|
EXPECT_0
|
|
0
|
|
SELECT COUNT(*) AS EXPECT_10000 FROM t1;
|
|
EXPECT_10000
|
|
10000
|
|
connection node_2;
|
|
# Verify that graceful shutdown succeeds.
|
|
# Force SST
|
|
connection node_1;
|
|
# Waiting until node_2 is not part of cluster anymore
|
|
connection node_2;
|
|
# Start node_2 again
|
|
¤ Wait until node_2 is back on cluster
|
|
connection node_2;
|
|
call mtr.add_suppression("Slave: Operation CREATE USER failed for ");
|
|
SELECT COUNT(*) AS EXPECT_0 FROM mysql.gtid_slave_pos;
|
|
EXPECT_0
|
|
0
|
|
SELECT COUNT(*) AS EXPECT_10000 FROM t1;
|
|
EXPECT_10000
|
|
10000
|
|
connection node_1;
|
|
SELECT COUNT(*) AS EXPECT_0 FROM mysql.gtid_slave_pos;
|
|
EXPECT_0
|
|
0
|
|
SELECT COUNT(*) AS EXPECT_10000 FROM t1;
|
|
EXPECT_10000
|
|
10000
|
|
connection node_3;
|
|
SELECT COUNT(*) AS EXPECT_10000 FROM t1;
|
|
EXPECT_10000
|
|
10000
|
|
connection node_2;
|
|
STOP SLAVE;
|
|
RESET SLAVE ALL;
|
|
connection node_3;
|
|
RESET MASTER;
|
|
drop table t1;
|
|
connection node_2;
|
|
DROP TABLE t1;
|
|
connection node_1;
|
|
connection node_1;
|
|
disconnect node_3;
|
|
disconnect node_2;
|
|
disconnect node_1;
|
|
# End of test
|