mirror of
https://github.com/MariaDB/server.git
synced 2025-02-05 13:22:17 +01:00
32 lines
531 B
Text
32 lines
531 B
Text
include/master-slave.inc
|
|
[connection master]
|
|
CREATE TABLE t1 (n INT);
|
|
connection slave;
|
|
connection master;
|
|
RESET MASTER;
|
|
connection slave;
|
|
STOP SLAVE;
|
|
RESET SLAVE;
|
|
connection master;
|
|
SELECT COUNT(*) FROM t1;
|
|
COUNT(*)
|
|
5000
|
|
connection slave;
|
|
LOCK TABLES t1 READ;
|
|
START SLAVE;
|
|
UNLOCK TABLES;
|
|
SELECT COUNT(*) FROM t1;
|
|
COUNT(*)
|
|
5000
|
|
connection master;
|
|
DROP TABLE t1;
|
|
CREATE TABLE t1 (n INT);
|
|
INSERT INTO t1 VALUES(3456);
|
|
connection slave;
|
|
SELECT n FROM t1;
|
|
n
|
|
3456
|
|
connection master;
|
|
DROP TABLE t1;
|
|
connection slave;
|
|
include/rpl_end.inc
|