[umshastr@hod03]~: cd /export/umesh/sandbox/mysql-sandbox-master [umshastr@hod03]/export/umesh/sandbox/mysql-sandbox-master: export PERL5LIB=/home/umshastr/perl5/lib/perl5/ [umshastr@hod03]/export/umesh/sandbox/mysql-sandbox-master: bin/make_replication_sandbox --master_master /export/umesh/server/binaries/GABuilds/mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz installing node 1 installing node 2 # server: 1: # server: 2: # server: 1: # server: 2: # server: 1: # server: 2: Circular replication activated group directory installed in $HOME/sandboxes/rcsandbox_mysql-5_6_35 [umshastr@hod03]/export/umesh/sandbox/mysql-sandbox-master: cd $HOME/sandboxes/rcsandbox_mysql-5_6_35 [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_6_35: ./enable_gtid # option 'master-info-repository=table' added to node1 configuration file # option 'relay-log-info-repository=table' added to node1 configuration file # option 'gtid_mode=ON' added to node1 configuration file # option 'log-slave-updates' already exists in node1 configuration file # option 'enforce-gtid-consistency' added to node1 configuration file # option 'master-info-repository=table' added to node2 configuration file # option 'relay-log-info-repository=table' added to node2 configuration file # option 'gtid_mode=ON' added to node2 configuration file # option 'log-slave-updates' already exists in node2 configuration file # option 'enforce-gtid-consistency' added to node2 configuration file # executing "stop" on /home/umshastr/sandboxes/rcsandbox_mysql-5_6_35 # server: 1: # server: 2: executing "stop" on node 1 executing "stop" on node 2 # executing "start" on /home/umshastr/sandboxes/rcsandbox_mysql-5_6_35 executing "start" on node 1 .. sandbox server started executing "start" on node 2 .. sandbox server started # server: 1: # server: 2: [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_6_35: ./n1 -e 'create database sbtest1' [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_6_35: ./n2 -e 'create database sbtest2' [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_6_35: ./n1 -e 'show slave status\G' |grep 'Running:\|Gtid' Slave_IO_Running: Yes Slave_SQL_Running: Yes Retrieved_Gtid_Set: 00017502-0000-0000-0000-000000000000:1 Executed_Gtid_Set: 00017501-0000-0000-0000-000000000000:1, [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_6_35: ./n2 -e 'show slave status\G' |grep 'Running:\|Gtid' Slave_IO_Running: Yes Slave_SQL_Running: Yes Retrieved_Gtid_Set: 00017501-0000-0000-0000-000000000000:1 Executed_Gtid_Set: 00017501-0000-0000-0000-000000000000:1, -- provision data on master 1 sysbench/sysbench --num-threads=16 --max-requests=3000 --db-driver=mysql --test=/home/umshastr/bugs/sysbench/sysbench/tests/db/oltp.lua --mysql-table-engine=InnoDB --mysql-db=sbtest1 --mysql-user=msandbox --mysql-password=msandbox --oltp-table-size=1000000 --mysql-socket=/tmp/mysql_sandbox17501.sock prepare [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_6_35: ./n2 -e 'show slave status\G' |grep 'Running:\|Gtid' Slave_IO_Running: Yes Slave_SQL_Running: Yes Retrieved_Gtid_Set: 00017501-0000-0000-0000-000000000000:1-376 Executed_Gtid_Set: 00017501-0000-0000-0000-000000000000:1-376, [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_6_35: ./n2 -e 'show slave status\G' |grep 'Running:\|Gtid' Slave_IO_Running: Yes Slave_SQL_Running: Yes Retrieved_Gtid_Set: 00017501-0000-0000-0000-000000000000:1-376 Executed_Gtid_Set: 00017501-0000-0000-0000-000000000000:1-376, -- Shutdown master1 and restart [umshastr@hod03]/export/umesh/server/binaries/GABuilds/5.6.35: bin/mysqladmin -umsandbox -pmsandbox -S /tmp/mysql_sandbox17501.sock shutdown Warning: Using a password on the command line interface can be insecure. [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_6_35: node1/restart .. sandbox server started [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_6_35: ./n1 -e 'show slave status\G' |grep 'Running:\|Gtid' Slave_IO_Running: Yes Slave_SQL_Running: Yes Retrieved_Gtid_Set: 00017502-0000-0000-0000-000000000000:1 Executed_Gtid_Set: 00017501-0000-0000-0000-000000000000:1-376, [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_6_35: ./n2 -e 'show slave status\G' |grep 'Running:\|Gtid' Slave_IO_Running: Yes Slave_SQL_Running: Yes Retrieved_Gtid_Set: 00017501-0000-0000-0000-000000000000:1-376 Executed_Gtid_Set: 00017501-0000-0000-0000-000000000000:1-376, [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_6_35: ./n2 -e 'show slave status\G' |grep 'Running:\|Gtid' Slave_IO_Running: Yes Slave_SQL_Running: Yes Retrieved_Gtid_Set: 00017501-0000-0000-0000-000000000000:1-376 Executed_Gtid_Set: 00017501-0000-0000-0000-000000000000:1-376, [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_6_35: