1
set global server_id=1;
3
drop table if exists t1,t2,t3;
4
create table t1 (a int);
8
show binlog events from <binlog_start>;
9
Log_name Pos Event_type Server_id End_log_pos Info
10
master-bin.000001 # Query 1 # use `test`; drop table if exists t1,t2,t3
11
master-bin.000001 # Query 1 # use `test`; create table t1 (a int)
12
set global server_id=2;
13
create table t2 (b int);
17
show binlog events from <binlog_start>;
18
Log_name Pos Event_type Server_id End_log_pos Info
19
master-bin.000001 # Query 1 # use `test`; drop table if exists t1,t2,t3
20
master-bin.000001 # Query 1 # use `test`; create table t1 (a int)
21
master-bin.000001 # Query 2 # use `test`; create table t2 (b int)
22
set global server_id=3;
23
create table t3 (c int);
27
show binlog events from <binlog_start>;
28
Log_name Pos Event_type Server_id End_log_pos Info
29
master-bin.000001 # Query 1 # use `test`; drop table if exists t1,t2,t3
30
master-bin.000001 # Query 1 # use `test`; create table t1 (a int)
31
master-bin.000001 # Query 2 # use `test`; create table t2 (b int)
32
master-bin.000001 # Query 3 # use `test`; create table t3 (c int)
33
set global server_id=1;