--let $group_replication_group_name= a1e87f30-b156-11e4-ab27-0800200c9a66
--source include/have_group_replication_plugin.inc
--let $rpl_server_count= 4
--let $rpl_skip_group_replication_start= 1
--source include/group_replication.inc

--let $rpl_connection_name = server_1
--source include/rpl_connection.inc
--source include/start_and_bootstrap_group_replication.inc
--let $rpl_connection_name = server_2
--source include/rpl_connection.inc
--source include/start_group_replication.inc
--let $rpl_connection_name = server_3
--source include/rpl_connection.inc
--source include/start_group_replication.inc

--let $rpl_connection_name = server_1
--source include/rpl_connection.inc
SET GLOBAL replica_preserve_commit_order=0;
--replace_result $SERVER_MYPORT_4 PORT_4
eval CHANGE REPLICATION SOURCE TO 
     SOURCE_USER='root', SOURCE_HOST='127.0.0.1', SOURCE_PORT=$SERVER_MYPORT_4, SOURCE_AUTO_POSITION=0,
     SOURCE_LOG_FILE='server-binary-log.000001', SOURCE_LOG_POS=4
     FOR CHANNEL 'ch1';
START REPLICA FOR CHANNEL 'ch1';

--let $rpl_connection_name = server_4
--source include/rpl_connection.inc
CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 INT);
CREATE TABLE t2 (c1 INT PRIMARY KEY, c2 INT);
INSERT INTO t1 VALUES (1,1);
INSERT INTO t1 VALUES (2,2);
INSERT INTO t2 VALUES (1,1);
INSERT INTO t2 VALUES (2,2);
--source include/rpl_sync.inc


connect (conn1_1,127.0.0.1,root,,test,$SERVER_MYPORT_1,);
connect (conn1_2,127.0.0.1,root,,test,$SERVER_MYPORT_1,);
--connection conn1_1
--echo [connect conn1_1]
LOCK TABLE t1 READ;

--let $rpl_connection_name = server_4
--source include/rpl_connection.inc
INSERT INTO t1 VALUES (3,3);
INSERT INTO t1 VALUES (4,4);
INSERT INTO t2 VALUES (3,3);
INSERT INTO t2 VALUES (4,4);

--let $rpl_connection_name = server_1
--source include/rpl_connection.inc
--let $wait_condition=select count(*)=4 from t2
--source include/wait_condition.inc

--let $rpl_connection_name = server_1
--source include/rpl_connection.inc
--let $_group_replication_local_address=`select @@group_replication_local_address`
--let $_group_replication_group_seeds=`select @@group_replication_group_seeds`
--source include/kill_mysqld.inc

--let $rpl_connection_name = server2
--source include/rpl_connection.inc
--let $group_replication_number_of_members = 2
--source include/gr_wait_for_number_of_members.inc

--let $restart_parameters=restart:--group_replication_local_address=$_group_replication_local_address --group_replication_group_seeds=$_group_replication_group_seeds --group_replication_start_on_boot=1 --group-replication-group-name=$group_replication_group_name 
--replace_result $_group_replication_local_address GROUP_REPLICATION_LOCAL_ADDRESS $_group_replication_group_seeds GROUP_REPLICATION_GROUP_SEEDS $group_replication_group_name GROUP_REPLICATION_GROUP_NAME
--source include/start_mysqld.inc
--let $rpl_server_number = 1
--source include/rpl_reconnect.inc
--let $rpl_connection_name = server_1
--source include/rpl_connection.inc
--let $group_replication_member_state= ONLINE
--source include/gr_wait_for_member_state.inc

select * from performance_schema.replication_group_members;

## cleanup
--let $rpl_connection_name = server_4
--source include/rpl_connection.inc
TRUNCATE TABLE t1;
TRUNCATE TABLE t2;

--let $rpl_connection_name = server_1
--source include/rpl_connection.inc
TRUNCATE TABLE t1;
TRUNCATE TABLE t2;
--source include/rpl_sync.inc
sleep 2;
--source include/group_replication_end.inc