# cat t/multisource1.cnf
!include include/default_mysqld.cnf
!include include/default_client.cnf

[mysqld.1]
server-id=1
log-bin=master-bin

[mysqld.2]
server-id=1
log-bin=master-bin

[mysqld.3]
server-id=3
log-slave-updates
log-bin=master-bin

[ENV]
SERVER_MYPORT_1= @mysqld.1.port
SERVER_MYSOCK_1= @mysqld.1.socket
SERVER_MYPORT_2= @mysqld.2.port
SERVER_MYSOCK_2= @mysqld.2.socket
SERVER_MYPORT_3= @mysqld.3.port
SERVER_MYSOCK_3= @mysqld.3.socket

# In the cnf file for this test, mysqld.1 and mysqld.2 have
# the same server-id=1, and mysqld.3 has server-id=3

--connect (slave,127.0.0.1,root,,,$SERVER_MYPORT_3)

# Start replication from the first master

--replace_result $SERVER_MYPORT_1 MYPORT_1
eval change master 'master1' to
master_port=$SERVER_MYPORT_1,
master_host='127.0.0.1',
master_user='root';

start slave 'master1';
set default_master_connection = 'master1';
--source include/wait_for_slave_to_start.inc

# Start replication from the second master

--replace_result $SERVER_MYPORT_2 MYPORT_2
eval change master 'master2' to
master_port=$SERVER_MYPORT_2,
master_host='127.0.0.1',
master_user='root';

start slave 'master2';
set default_master_connection = 'master2';
--source include/wait_for_slave_to_start.inc

set default_master_connection = '';

--connect (master1,127.0.0.1,root,,,$SERVER_MYPORT_1)
--disable_warnings
drop table if exists t1;
--enable_warnings
create table t1 (i int) engine=MyISAM;
--save_master_pos

--connection slave
--sync_with_master 0,'master1'

--connect (master2,127.0.0.1,root,,,$SERVER_MYPORT_2)
--disable_warnings
drop table if exists t2;
--enable_warnings
create table t2 (j int) engine=MyISAM;
--save_master_pos

--connection slave
--sync_with_master 0,'master2'

--echo
--echo # See that all entries are written with the same
--echo # server_id = 1
show binlog events;

--save_master_pos

# Now set up replication from the slave to the second master
# (the 'circular' part)

--connection master2

--replace_result $SERVER_MYPORT_3 MYPORT_3
eval change master to
master_port=$SERVER_MYPORT_3,
master_host='127.0.0.1',
master_user='root';

start slave;
--sync_with_master 0

--echo
--echo # See that t1 was not replicated
--echo # (because the entry had the same server_id)
show tables;