mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
118 lines
2.4 KiB
Text
118 lines
2.4 KiB
Text
connection node_2;
|
|
connection node_1;
|
|
connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
|
|
connect node_4, 127.0.0.1, root, , test, $NODE_MYPORT_4;
|
|
connection node_2;
|
|
call mtr.add_suppression("WSREP: Ignoring server id .* for non bootstrap node");
|
|
connection node_4;
|
|
call mtr.add_suppression("WSREP: Ignoring server id .* for non bootstrap node");
|
|
connection node_3;
|
|
START SLAVE;
|
|
include/wait_for_slave_to_start.inc
|
|
connection node_1;
|
|
CREATE TABLE t1 (id bigint primary key, msg varchar(100)) engine=innodb;
|
|
SET AUTOCOMMIT=1;
|
|
INSERT INTO t1 VALUES (4000000, 'foobar');
|
|
SELECT COUNT(*) FROM t1;
|
|
COUNT(*)
|
|
50001
|
|
connection node_3;
|
|
connection node_1;
|
|
# node_1
|
|
SELECT * FROM t1 WHERE msg='foobar';
|
|
id msg
|
|
4000000 foobar
|
|
SELECT * FROM t1 WHERE msg='foobar';
|
|
id msg
|
|
4000000 foobar
|
|
connection node_2;
|
|
# node_2
|
|
SELECT * FROM t1 WHERE msg='foobar';
|
|
id msg
|
|
4000000 foobar
|
|
SELECT * FROM t1 WHERE msg='foobar';
|
|
id msg
|
|
4000000 foobar
|
|
connection node_3;
|
|
# node_3
|
|
SELECT * FROM t1 WHERE msg='foobar';
|
|
id msg
|
|
4000000 foobar
|
|
SELECT * FROM t1 WHERE msg='foobar';
|
|
id msg
|
|
4000000 foobar
|
|
connection node_4;
|
|
# node_4
|
|
SELECT * FROM t1 WHERE msg='foobar';
|
|
id msg
|
|
4000000 foobar
|
|
SELECT * FROM t1 WHERE msg='foobar';
|
|
id msg
|
|
4000000 foobar
|
|
connection node_1;
|
|
# node_1 insert new
|
|
INSERT INTO t1 values (5000000, 'foobar');
|
|
connection node_3;
|
|
SELECT * FROM t1 WHERE msg='foobar';
|
|
id msg
|
|
4000000 foobar
|
|
5000000 foobar
|
|
SELECT * FROM t1 WHERE msg='foobar';
|
|
id msg
|
|
4000000 foobar
|
|
5000000 foobar
|
|
connection node_2;
|
|
# node_2
|
|
SELECT * FROM t1 WHERE msg='foobar';
|
|
id msg
|
|
4000000 foobar
|
|
5000000 foobar
|
|
SELECT * FROM t1 WHERE msg='foobar';
|
|
id msg
|
|
4000000 foobar
|
|
5000000 foobar
|
|
connection node_3;
|
|
# node_3
|
|
SELECT * FROM t1 WHERE msg='foobar';
|
|
id msg
|
|
4000000 foobar
|
|
5000000 foobar
|
|
SELECT * FROM t1 WHERE msg='foobar';
|
|
id msg
|
|
4000000 foobar
|
|
5000000 foobar
|
|
connection node_4;
|
|
# node_4
|
|
SELECT * FROM t1 WHERE msg='foobar';
|
|
id msg
|
|
4000000 foobar
|
|
5000000 foobar
|
|
SELECT * FROM t1 WHERE msg='foobar';
|
|
id msg
|
|
4000000 foobar
|
|
5000000 foobar
|
|
connection node_2;
|
|
# node_3 different query same table
|
|
SELECT id, msg FROM t1 WHERE msg='foobar';
|
|
id msg
|
|
4000000 foobar
|
|
5000000 foobar
|
|
connection node_4;
|
|
# node_6 different query same table
|
|
SELECT id, msg FROM t1 WHERE msg='foobar';
|
|
id msg
|
|
4000000 foobar
|
|
5000000 foobar
|
|
connection node_1;
|
|
drop table t1;
|
|
connection node_3;
|
|
connection node_3;
|
|
STOP SLAVE;
|
|
RESET SLAVE ALL;
|
|
connection node_1;
|
|
SET SESSION WSREP_ON=OFF;
|
|
RESET MASTER;
|
|
SET SESSION WSREP_ON=ON;
|
|
disconnect node_2;
|
|
disconnect node_1;
|
|
# End of test
|