mirror of
https://github.com/MariaDB/server.git
synced 2025-09-11 05:52:26 +03:00
26 lines
582 B
Plaintext
26 lines
582 B
Plaintext
include/master-slave.inc
|
|
[connection master]
|
|
drop database if exists mysqltest1;
|
|
drop database if exists mysqltest2;
|
|
create database mysqltest1;
|
|
create database mysqltest2;
|
|
use mysqltest1;
|
|
create table t1 (a int);
|
|
insert into t1 values(1);
|
|
connection slave;
|
|
select * from mysqltest1.t1;
|
|
ERROR 42S02: Table 'mysqltest1.t1' doesn't exist
|
|
connection master;
|
|
use mysqltest2;
|
|
create table t1 (a int);
|
|
insert into t1 values(1);
|
|
connection slave;
|
|
select * from mysqltest2.t1;
|
|
a
|
|
1
|
|
connection master;
|
|
drop database mysqltest1;
|
|
drop database mysqltest2;
|
|
connection slave;
|
|
include/rpl_end.inc
|