-- Semisynchronous Replication Installation and Configuration - https://dev.mysql.com/doc/refman/5.7/en/replication-semisync-installation.html

rm -rf master/
bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/master -v
bin/mysqld --basedir=$PWD --datadir=$PWD/master --log-bin  --server_id=1 --socket=/tmp/mysql_master.sock --port=3306 --log-error=$PWD/master/log.err 2>&1 &

rm -rf slave/
bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/slave -v
bin/mysqld --basedir=$PWD --datadir=$PWD/slave --log-bin  --server_id=2 --socket=/tmp/mysql_slave.sock --port=3307 --log-error=$PWD/slave/log.err 2>&1 &

-- Master

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.17: bin/mysql -uroot -S /tmp/mysql_master.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.17-log MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@localhost [(none)]> CREATE USER 'repl'@'localhost' IDENTIFIED BY 'slavepass';
Query OK, 0 rows affected (0.00 sec)

root@localhost [(none)]> GRANT REPLICATION SLAVE ON *.* TO 'repl'@'localhost';
Query OK, 0 rows affected (0.00 sec)

root@localhost [(none)]>
root@localhost [(none)]> CREATE USER 'repl'@'127.0.0.1' IDENTIFIED BY 'slavepass';
Query OK, 0 rows affected (0.00 sec)

root@localhost [(none)]> GRANT REPLICATION SLAVE ON *.* TO 'repl'@'127.0.0.1';
Query OK, 0 rows affected (0.00 sec)

root@localhost [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

root@localhost [(none)]> show master status;
+------------------+----------+--------------+------------------+-------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| hod03-bin.000001 |     1220 |              |                  |                   |
+------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)

root@localhost [(none)]> INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';
Query OK, 0 rows affected (0.02 sec)

root@localhost [(none)]>  SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%semi%';
+----------------------+---------------+
| PLUGIN_NAME          | PLUGIN_STATUS |
+----------------------+---------------+
| rpl_semi_sync_master | ACTIVE        |
+----------------------+---------------+
1 row in set (0.00 sec)

root@localhost [(none)]> SET GLOBAL rpl_semi_sync_master_enabled = 1;
Query OK, 0 rows affected (0.01 sec)

root@localhost [(none)]> SET GLOBAL rpl_semi_sync_master_timeout =1000;
Query OK, 0 rows affected (0.00 sec)



-- Slave

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.17: bin/mysql -uroot -S /tmp/mysql_slave.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.17-log MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@localhost [(none)]> CHANGE MASTER TO
    ->      MASTER_HOST='localhost',
    ->      MASTER_PORT=3306,
    ->      MASTER_USER='repl',
    ->      MASTER_PASSWORD='slavepass',
    ->      MASTER_LOG_FILE='hod03-bin.000001',
    ->      MASTER_LOG_POS=1220;
Query OK, 0 rows affected, 2 warnings (0.00 sec)

root@localhost [(none)]> start slave;
Query OK, 0 rows affected (0.00 sec)

root@localhost [(none)]> show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: localhost
                  Master_User: repl
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: hod03-bin.000001
          Read_Master_Log_Pos: 1220
               Relay_Log_File: hod03-relay-bin.000002
                Relay_Log_Pos: 320
        Relay_Master_Log_File: hod03-bin.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 1220
              Relay_Log_Space: 527
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
                  Master_UUID: dab1493c-04bc-11e7-855a-0010e05f3e06
             Master_Info_File: /export/umesh/server/binaries/GABuilds/mysql-5.7.17/slave/master.info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
           Master_Retry_Count: 86400
                  Master_Bind:
      Last_IO_Error_Timestamp:
     Last_SQL_Error_Timestamp:
               Master_SSL_Crl:
           Master_SSL_Crlpath:
           Retrieved_Gtid_Set:
            Executed_Gtid_Set:
                Auto_Position: 0
         Replicate_Rewrite_DB:
                 Channel_Name:
           Master_TLS_Version:
1 row in set (0.00 sec)

root@localhost [(none)]> INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so';
Query OK, 0 rows affected (0.01 sec)

root@localhost [(none)]> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%semi%';
+---------------------+---------------+
| PLUGIN_NAME         | PLUGIN_STATUS |
+---------------------+---------------+
| rpl_semi_sync_slave | ACTIVE        |
+---------------------+---------------+
1 row in set (0.00 sec)

root@localhost [(none)]> SET GLOBAL rpl_semi_sync_slave_enabled =1;
Query OK, 0 rows affected (0.00 sec)

root@localhost [(none)]> STOP SLAVE IO_THREAD;
Query OK, 0 rows affected (0.00 sec)

root@localhost [(none)]> START SLAVE IO_THREAD;
Query OK, 0 rows affected (0.00 sec)

root@localhost [(none)]> show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: localhost
                  Master_User: repl
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: hod03-bin.000001
          Read_Master_Log_Pos: 1220
               Relay_Log_File: hod03-relay-bin.000003
                Relay_Log_Pos: 320
        Relay_Master_Log_File: hod03-bin.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 1220
              Relay_Log_Space: 693
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
                  Master_UUID: dab1493c-04bc-11e7-855a-0010e05f3e06
             Master_Info_File: /export/umesh/server/binaries/GABuilds/mysql-5.7.17/slave/master.info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
           Master_Retry_Count: 86400
                  Master_Bind:
      Last_IO_Error_Timestamp:
     Last_SQL_Error_Timestamp:
               Master_SSL_Crl:
           Master_SSL_Crlpath:
           Retrieved_Gtid_Set:
            Executed_Gtid_Set:
                Auto_Position: 0
         Replicate_Rewrite_DB:
                 Channel_Name:
           Master_TLS_Version:
1 row in set (0.00 sec)

-- master

root@localhost [(none)]> set global slave_compressed_protocol=1;
Query OK, 0 rows affected (0.00 sec)

root@localhost [(none)]> create database test;
Query OK, 1 row affected (1.00 sec)

root@localhost [(none)]>

-- slave

root@localhost [(none)]> set global slave_compressed_protocol=1;
Query OK, 0 rows affected (0.00 sec)

root@localhost [(none)]> STOP SLAVE;
Query OK, 0 rows affected (0.01 sec)

root@localhost [(none)]> STARt SLAVE;
Query OK, 0 rows affected (0.00 sec)

root@localhost [(none)]> show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: localhost
                  Master_User: repl
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: hod03-bin.000001
          Read_Master_Log_Pos: 1220
               Relay_Log_File: hod03-relay-bin.000004
                Relay_Log_Pos: 320
        Relay_Master_Log_File: hod03-bin.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 1220
              Relay_Log_Space: 693
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
                  Master_UUID: dab1493c-04bc-11e7-855a-0010e05f3e06
             Master_Info_File: /export/umesh/server/binaries/GABuilds/mysql-5.7.17/slave/master.info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
           Master_Retry_Count: 86400
                  Master_Bind:
      Last_IO_Error_Timestamp:
     Last_SQL_Error_Timestamp:
               Master_SSL_Crl:
           Master_SSL_Crlpath:
           Retrieved_Gtid_Set:
            Executed_Gtid_Set:
                Auto_Position: 0
         Replicate_Rewrite_DB:
                 Channel_Name:
           Master_TLS_Version:
1 row in set (0.00 sec)

root@localhost [(none)]> show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: localhost
                  Master_User: repl
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: hod03-bin.000001
          Read_Master_Log_Pos: 1379
               Relay_Log_File: hod03-relay-bin.000004
                Relay_Log_Pos: 479
        Relay_Master_Log_File: hod03-bin.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 1379
              Relay_Log_Space: 852
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
                  Master_UUID: dab1493c-04bc-11e7-855a-0010e05f3e06
             Master_Info_File: /export/umesh/server/binaries/GABuilds/mysql-5.7.17/slave/master.info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
           Master_Retry_Count: 86400
                  Master_Bind:
      Last_IO_Error_Timestamp:
     Last_SQL_Error_Timestamp:
               Master_SSL_Crl:
           Master_SSL_Crlpath:
           Retrieved_Gtid_Set:
            Executed_Gtid_Set:
                Auto_Position: 0
         Replicate_Rewrite_DB:
                 Channel_Name:
           Master_TLS_Version:
1 row in set (0.00 sec)


-- Observe master/slave log

- master

2017-03-09T11:38:04.884451Z 0 [Note] bin/mysqld: ready for connections.
Version: '5.7.17-log'  socket: '/tmp/mysql_master.sock'  port: 3306  MySQL Community Server (GPL)
2017-03-09T11:39:52.312047Z 4 [Note] Start binlog_dump to master_thread_id(4) slave_server(2), pos(hod03-bin.000001, 1220)
2017-03-09T11:40:49.049406Z 3 [Note] Semi-sync replication initialized for transactions.
2017-03-09T11:40:49.049433Z 3 [Note] Semi-sync replication enabled on the master.
2017-03-09T11:40:49.049582Z 0 [Note] Starting ack receiver thread
2017-03-09T11:41:54.188691Z 5 [Note] While initializing dump thread for slave with UUID <e51d35db-04bc-11e7-881b-0010e05f3e06>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(4).
2017-03-09T11:41:54.188758Z 5 [Note] Start binlog_dump to master_thread_id(5) slave_server(2), pos(hod03-bin.000001, 1220)
2017-03-09T11:41:54.188778Z 5 [Note] Start semi-sync binlog_dump to slave (server_id: 2), pos(hod03-bin.000001, 1220)
2017-03-09T11:41:54.188823Z 4 [Note] Stop asynchronous binlog_dump to slave (server_id: 2)
2017-03-09T11:43:22.709417Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:43:25.927832Z 6 [Note] While initializing dump thread for slave with UUID <e51d35db-04bc-11e7-881b-0010e05f3e06>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(5).
2017-03-09T11:43:25.927890Z 6 [Note] Start binlog_dump to master_thread_id(6) slave_server(2), pos(hod03-bin.000001, 1220)
2017-03-09T11:43:25.927953Z 5 [Note] Stop semi-sync binlog_dump to slave (server_id: 2)
2017-03-09T11:43:26.713802Z 6 [Note] Start semi-sync binlog_dump to slave (server_id: 2), pos(hod03-bin.000001, 1220)
2017-03-09T11:43:26.713822Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:43:38.755022Z 0 [ERROR] Read semi-sync reply magic number error
2017-03-09T11:43:38.756149Z 0 [ERROR] bin/mysqld: Got timeout reading communication packets
2017-03-09T11:43:39.754781Z 3 [Warning] Timeout waiting for reply of binlog (file: hod03-bin.000001, pos: 1379), semi-sync up to file hod03-bin.000001, position 1220.
2017-03-09T11:43:39.754817Z 3 [Note] Semi-sync replication switched OFF.
2017-03-09T11:44:08.755086Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:44:08.757013Z 7 [Note] While initializing dump thread for slave with UUID <e51d35db-04bc-11e7-881b-0010e05f3e06>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(6).
2017-03-09T11:44:08.757070Z 7 [Note] Start binlog_dump to master_thread_id(7) slave_server(2), pos(hod03-bin.000001, 1379)
2017-03-09T11:44:08.757128Z 6 [Note] Stop semi-sync binlog_dump to slave (server_id: 2)
2017-03-09T11:44:09.756223Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:44:09.756226Z 7 [Note] Semi-sync replication switched ON at (hod03-bin.000001, 1379)
2017-03-09T11:44:09.756259Z 7 [Note] Start semi-sync binlog_dump to slave (server_id: 2), pos(hod03-bin.000001, 1379)


- slave

Version: '5.7.17-log'  socket: '/tmp/mysql_slave.sock'  port: 3307  MySQL Community Server (GPL)
2017-03-09T11:39:48.662400Z 3 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=hod03-relay-bin' to avoid this problem.
2017-03-09T11:39:48.663863Z 3 [Note] 'CHANGE MASTER TO FOR CHANNEL '' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='localhost', master_port= 3306, master_log_file='hod03-bin.000001', master_log_pos= 1220, master_bind=''.
2017-03-09T11:39:52.310350Z 4 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-03-09T11:39:52.310849Z 5 [Warning] Slave SQL for channel '': If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0
2017-03-09T11:39:52.310882Z 5 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'hod03-bin.000001' at position 1220, relay log './hod03-relay-bin.000001' position: 4
2017-03-09T11:39:52.311289Z 4 [Note] Slave I/O thread for channel '': connected to master 'repl@localhost:3306',replication started in log 'hod03-bin.000001' at position 1220
2017-03-09T11:41:53.012998Z 4 [Note] Slave I/O thread killed while reading event for channel ''
2017-03-09T11:41:53.013019Z 4 [Note] Slave I/O thread exiting for channel '', read up to log 'hod03-bin.000001', position 1220
2017-03-09T11:41:54.187264Z 6 [Note] Slave I/O thread: Start semi-sync replication to master 'repl@localhost:3306' in log 'hod03-bin.000001' at position 1220
2017-03-09T11:41:54.187295Z 6 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-03-09T11:41:54.187950Z 6 [Note] Slave I/O thread for channel '': connected to master 'repl@localhost:3306',replication started in log 'hod03-bin.000001' at position 1220
2017-03-09T11:43:22.709084Z 5 [Note] Error reading relay log event for channel '': slave SQL thread was killed
2017-03-09T11:43:22.709384Z 6 [Note] Slave I/O thread killed while reading event for channel ''
2017-03-09T11:43:22.709414Z 6 [Note] Slave I/O thread exiting for channel '', read up to log 'hod03-bin.000001', position 1220
2017-03-09T11:43:25.925971Z 7 [Note] Slave I/O thread: Start semi-sync replication to master 'repl@localhost:3306' in log 'hod03-bin.000001' at position 1220
2017-03-09T11:43:25.925993Z 7 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-03-09T11:43:25.926243Z 8 [Warning] Slave SQL for channel '': If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0
2017-03-09T11:43:25.926282Z 8 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'hod03-bin.000001' at position 1220, relay log './hod03-relay-bin.000003' position: 320
2017-03-09T11:43:25.926486Z 7 [Note] Slave I/O thread for channel '': connected to master 'repl@localhost:3306',replication started in log 'hod03-bin.000001' at position 1220
2017-03-09T11:44:08.755068Z 7 [ERROR] Error reading packet from server for channel '': Lost connection to MySQL server during query (server_errno=2013)
2017-03-09T11:44:08.755090Z 7 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'hod03-bin.000001' at position 1379 for channel ''
2017-03-09T11:44:08.755096Z 7 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
[umshastr@hod03]~/bugs/sysbench:

###
[umshastr@hod03]~/bugs/sysbench: sysbench/sysbench --num-threads=16 --max-requests=300000 --db-driver=mysql --test=/home/umshastr/bugs/sysbench/sysbench/tests/db/oltp.lua --mysql-table-engine=InnoDB --mysql-db=test --mysql-user=root --oltp-table-size=1000000 --mysql-socket=/tmp/mysql_master.sock prepare
sysbench 0.5:  multi-threaded system evaluation benchmark

Creating table 'sbtest1'...
Inserting 1000000 records into 'sbtest1'

-- extract from master's error log

Version: '5.7.17-log'  socket: '/tmp/mysql_master.sock'  port: 3306  MySQL Community Server (GPL)
2017-03-09T11:39:52.312047Z 4 [Note] Start binlog_dump to master_thread_id(4) slave_server(2), pos(hod03-bin.000001, 1220)
2017-03-09T11:40:49.049406Z 3 [Note] Semi-sync replication initialized for transactions.
2017-03-09T11:40:49.049433Z 3 [Note] Semi-sync replication enabled on the master.
2017-03-09T11:40:49.049582Z 0 [Note] Starting ack receiver thread
2017-03-09T11:41:54.188691Z 5 [Note] While initializing dump thread for slave with UUID <e51d35db-04bc-11e7-881b-0010e05f3e06>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(4).
2017-03-09T11:41:54.188758Z 5 [Note] Start binlog_dump to master_thread_id(5) slave_server(2), pos(hod03-bin.000001, 1220)
2017-03-09T11:41:54.188778Z 5 [Note] Start semi-sync binlog_dump to slave (server_id: 2), pos(hod03-bin.000001, 1220)
2017-03-09T11:41:54.188823Z 4 [Note] Stop asynchronous binlog_dump to slave (server_id: 2)
2017-03-09T11:43:22.709417Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:43:25.927832Z 6 [Note] While initializing dump thread for slave with UUID <e51d35db-04bc-11e7-881b-0010e05f3e06>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(5).
2017-03-09T11:43:25.927890Z 6 [Note] Start binlog_dump to master_thread_id(6) slave_server(2), pos(hod03-bin.000001, 1220)
2017-03-09T11:43:25.927953Z 5 [Note] Stop semi-sync binlog_dump to slave (server_id: 2)
2017-03-09T11:43:26.713802Z 6 [Note] Start semi-sync binlog_dump to slave (server_id: 2), pos(hod03-bin.000001, 1220)
2017-03-09T11:43:26.713822Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:43:38.755022Z 0 [ERROR] Read semi-sync reply magic number error
2017-03-09T11:43:38.756149Z 0 [ERROR] bin/mysqld: Got timeout reading communication packets
2017-03-09T11:43:39.754781Z 3 [Warning] Timeout waiting for reply of binlog (file: hod03-bin.000001, pos: 1379), semi-sync up to file hod03-bin.000001, position 1220.
2017-03-09T11:43:39.754817Z 3 [Note] Semi-sync replication switched OFF.
2017-03-09T11:44:08.755086Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:44:08.757013Z 7 [Note] While initializing dump thread for slave with UUID <e51d35db-04bc-11e7-881b-0010e05f3e06>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(6).
2017-03-09T11:44:08.757070Z 7 [Note] Start binlog_dump to master_thread_id(7) slave_server(2), pos(hod03-bin.000001, 1379)
2017-03-09T11:44:08.757128Z 6 [Note] Stop semi-sync binlog_dump to slave (server_id: 2)
2017-03-09T11:44:09.756223Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:44:09.756226Z 7 [Note] Semi-sync replication switched ON at (hod03-bin.000001, 1379)
2017-03-09T11:44:09.756259Z 7 [Note] Start semi-sync binlog_dump to slave (server_id: 2), pos(hod03-bin.000001, 1379)
2017-03-09T11:56:48.005193Z 0 [ERROR] Read semi-sync reply magic number error
2017-03-09T11:56:48.006290Z 0 [ERROR] bin/mysqld: Got timeout reading communication packets
2017-03-09T11:56:49.004942Z 9 [Warning] Timeout waiting for reply of binlog (file: hod03-bin.000001, pos: 1754), semi-sync up to file hod03-bin.000001, position 1379.
2017-03-09T11:56:49.004963Z 9 [Note] Semi-sync replication switched OFF.
2017-03-09T11:56:49.016540Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:56:49.018308Z 10 [Note] While initializing dump thread for slave with UUID <e51d35db-04bc-11e7-881b-0010e05f3e06>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(7).
2017-03-09T11:56:49.018380Z 10 [Note] Start binlog_dump to master_thread_id(10) slave_server(2), pos(hod03-bin.000001, 1754)
2017-03-09T11:56:49.018388Z 7 [Note] Stop semi-sync binlog_dump to slave (server_id: 2)
2017-03-09T11:56:50.017607Z 10 [Note] Start semi-sync binlog_dump to slave (server_id: 2), pos(hod03-bin.000001, 1754)
2017-03-09T11:56:50.704726Z 0 [ERROR] Read semi-sync reply magic number error
2017-03-09T11:56:50.705824Z 0 [ERROR] bin/mysqld: Got timeout reading communication packets
2017-03-09T11:56:50.723722Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:56:50.725405Z 10 [Note] Stop semi-sync binlog_dump to slave (server_id: 2)
2017-03-09T11:56:50.725513Z 11 [Note] While initializing dump thread for slave with UUID <e51d35db-04bc-11e7-881b-0010e05f3e06>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(10).
2017-03-09T11:56:50.725575Z 11 [Note] Start binlog_dump to master_thread_id(11) slave_server(2), pos(hod03-bin.000001, 13273935)
2017-03-09T11:56:51.724843Z 11 [Note] Start semi-sync binlog_dump to slave (server_id: 2), pos(hod03-bin.000001, 13273935)
2017-03-09T11:56:52.469099Z 0 [ERROR] Read semi-sync reply magic number error
2017-03-09T11:56:52.470197Z 0 [ERROR] bin/mysqld: Got timeout reading communication packets
2017-03-09T11:56:52.494297Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:56:52.495989Z 11 [Note] Stop semi-sync binlog_dump to slave (server_id: 2)
2017-03-09T11:56:52.496110Z 12 [Note] While initializing dump thread for slave with UUID <e51d35db-04bc-11e7-881b-0010e05f3e06>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(11).
2017-03-09T11:56:52.496156Z 12 [Note] Start binlog_dump to master_thread_id(12) slave_server(2), pos(hod03-bin.000001, 27566871)
2017-03-09T11:56:53.495383Z 12 [Note] Start semi-sync binlog_dump to slave (server_id: 2), pos(hod03-bin.000001, 27566871)
2017-03-09T11:56:54.209704Z 0 [ERROR] Read semi-sync reply magic number error
2017-03-09T11:56:54.210804Z 0 [ERROR] bin/mysqld: Got timeout reading communication packets
2017-03-09T11:56:54.225591Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:56:54.227258Z 12 [Note] Stop semi-sync binlog_dump to slave (server_id: 2)
2017-03-09T11:56:54.227373Z 13 [Note] While initializing dump thread for slave with UUID <e51d35db-04bc-11e7-881b-0010e05f3e06>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(12).
2017-03-09T11:56:54.227425Z 13 [Note] Start binlog_dump to master_thread_id(13) slave_server(2), pos(hod03-bin.000001, 41349345)
2017-03-09T11:56:55.226642Z 13 [Note] Start semi-sync binlog_dump to slave (server_id: 2), pos(hod03-bin.000001, 41349345)
2017-03-09T11:56:55.943989Z 0 [ERROR] Read semi-sync reply magic number error
2017-03-09T11:56:55.945085Z 0 [ERROR] bin/mysqld: Got timeout reading communication packets
2017-03-09T11:56:55.976997Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:56:55.978695Z 13 [Note] Stop semi-sync binlog_dump to slave (server_id: 2)
2017-03-09T11:56:55.978805Z 14 [Note] While initializing dump thread for slave with UUID <e51d35db-04bc-11e7-881b-0010e05f3e06>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(13).
2017-03-09T11:56:55.978851Z 14 [Note] Start binlog_dump to master_thread_id(14) slave_server(2), pos(hod03-bin.000001, 55131819)
2017-03-09T11:56:56.978055Z 14 [Note] Start semi-sync binlog_dump to slave (server_id: 2), pos(hod03-bin.000001, 55131819)
2017-03-09T11:56:57.636617Z 0 [ERROR] Read semi-sync reply magic number error
2017-03-09T11:56:57.637714Z 0 [ERROR] bin/mysqld: Got timeout reading communication packets
2017-03-09T11:56:57.671162Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:56:57.672876Z 14 [Note] Stop semi-sync binlog_dump to slave (server_id: 2)
2017-03-09T11:56:57.672966Z 15 [Note] While initializing dump thread for slave with UUID <e51d35db-04bc-11e7-881b-0010e05f3e06>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(14).
2017-03-09T11:56:57.673011Z 15 [Note] Start binlog_dump to master_thread_id(15) slave_server(2), pos(hod03-bin.000001, 67893369)
2017-03-09T11:56:58.672264Z 15 [Note] Start semi-sync binlog_dump to slave (server_id: 2), pos(hod03-bin.000001, 67893369)
2017-03-09T11:56:59.363539Z 0 [ERROR] Read semi-sync reply magic number error
2017-03-09T11:56:59.364638Z 0 [ERROR] bin/mysqld: Got timeout reading communication packets
2017-03-09T11:56:59.386498Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:56:59.388220Z 15 [Note] Stop semi-sync binlog_dump to slave (server_id: 2)
2017-03-09T11:56:59.388291Z 16 [Note] While initializing dump thread for slave with UUID <e51d35db-04bc-11e7-881b-0010e05f3e06>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(15).
2017-03-09T11:56:59.388338Z 16 [Note] Start binlog_dump to master_thread_id(16) slave_server(2), pos(hod03-bin.000001, 81165381)
2017-03-09T11:57:00.387579Z 16 [Note] Start semi-sync binlog_dump to slave (server_id: 2), pos(hod03-bin.000001, 81165381)
2017-03-09T11:57:01.048868Z 0 [ERROR] Read semi-sync reply magic number error
2017-03-09T11:57:01.049965Z 0 [ERROR] bin/mysqld: Got timeout reading communication packets
2017-03-09T11:57:01.073134Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:57:01.074814Z 16 [Note] Stop semi-sync binlog_dump to slave (server_id: 2)
2017-03-09T11:57:01.074986Z 17 [Note] While initializing dump thread for slave with UUID <e51d35db-04bc-11e7-881b-0010e05f3e06>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(16).
2017-03-09T11:57:01.075037Z 17 [Note] Start binlog_dump to master_thread_id(17) slave_server(2), pos(hod03-bin.000001, 93926931)
2017-03-09T11:57:02.074207Z 17 [Note] Start semi-sync binlog_dump to slave (server_id: 2), pos(hod03-bin.000001, 93926931)
2017-03-09T11:57:02.737788Z 0 [ERROR] Read semi-sync reply magic number error
2017-03-09T11:57:02.738875Z 0 [ERROR] bin/mysqld: Got timeout reading communication packets
2017-03-09T11:57:02.769161Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:57:02.770888Z 17 [Note] Stop semi-sync binlog_dump to slave (server_id: 2)
2017-03-09T11:57:02.770993Z 18 [Note] While initializing dump thread for slave with UUID <e51d35db-04bc-11e7-881b-0010e05f3e06>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(17).
2017-03-09T11:57:02.771038Z 18 [Note] Start binlog_dump to master_thread_id(18) slave_server(2), pos(hod03-bin.000001, 106688481)
2017-03-09T11:57:03.770304Z 18 [Note] Start semi-sync binlog_dump to slave (server_id: 2), pos(hod03-bin.000001, 106688481)
2017-03-09T11:57:04.403698Z 0 [ERROR] Read semi-sync reply magic number error
2017-03-09T11:57:04.404796Z 0 [ERROR] bin/mysqld: Got timeout reading communication packets
2017-03-09T11:57:04.422773Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:57:04.424445Z 18 [Note] Stop semi-sync binlog_dump to slave (server_id: 2)
2017-03-09T11:57:04.424630Z 19 [Note] While initializing dump thread for slave with UUID <e51d35db-04bc-11e7-881b-0010e05f3e06>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(18).
2017-03-09T11:57:04.424676Z 19 [Note] Start binlog_dump to master_thread_id(19) slave_server(2), pos(hod03-bin.000001, 118939569)
2017-03-09T11:57:05.423919Z 19 [Note] Start semi-sync binlog_dump to slave (server_id: 2), pos(hod03-bin.000001, 118939569)
2017-03-09T11:57:06.061826Z 0 [ERROR] Read semi-sync reply magic number error
2017-03-09T11:57:06.062925Z 0 [ERROR] bin/mysqld: Got timeout reading communication packets
2017-03-09T11:57:06.082600Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:57:06.084313Z 19 [Note] Stop semi-sync binlog_dump to slave (server_id: 2)
2017-03-09T11:57:06.084413Z 20 [Note] While initializing dump thread for slave with UUID <e51d35db-04bc-11e7-881b-0010e05f3e06>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(19).
2017-03-09T11:57:06.084467Z 20 [Note] Start binlog_dump to master_thread_id(20) slave_server(2), pos(hod03-bin.000001, 131190657)
2017-03-09T11:57:07.083737Z 20 [Note] Start semi-sync binlog_dump to slave (server_id: 2), pos(hod03-bin.000001, 131190657)
2017-03-09T11:57:07.717326Z 0 [ERROR] Read semi-sync reply magic number error
2017-03-09T11:57:07.718435Z 0 [ERROR] bin/mysqld: Got timeout reading communication packets
2017-03-09T11:57:07.737269Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:57:07.738992Z 20 [Note] Stop semi-sync binlog_dump to slave (server_id: 2)
2017-03-09T11:57:07.739107Z 21 [Note] While initializing dump thread for slave with UUID <e51d35db-04bc-11e7-881b-0010e05f3e06>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(20).
2017-03-09T11:57:07.739155Z 21 [Note] Start binlog_dump to master_thread_id(21) slave_server(2), pos(hod03-bin.000001, 143441745)
2017-03-09T11:57:08.738413Z 21 [Note] Start semi-sync binlog_dump to slave (server_id: 2), pos(hod03-bin.000001, 143441745)
2017-03-09T11:57:09.376262Z 0 [ERROR] Read semi-sync reply magic number error
2017-03-09T11:57:09.377367Z 0 [ERROR] bin/mysqld: Got timeout reading communication packets
2017-03-09T11:57:09.405516Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:57:09.407204Z 21 [Note] Stop semi-sync binlog_dump to slave (server_id: 2)
2017-03-09T11:57:09.407308Z 22 [Note] While initializing dump thread for slave with UUID <e51d35db-04bc-11e7-881b-0010e05f3e06>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(21).
2017-03-09T11:57:09.407360Z 22 [Note] Start binlog_dump to master_thread_id(22) slave_server(2), pos(hod03-bin.000001, 155692833)
2017-03-09T11:57:10.406660Z 22 [Note] Start semi-sync binlog_dump to slave (server_id: 2), pos(hod03-bin.000001, 155692833)
2017-03-09T11:57:11.040499Z 0 [ERROR] Read semi-sync reply magic number error
2017-03-09T11:57:11.041597Z 0 [ERROR] bin/mysqld: Got timeout reading communication packets
2017-03-09T11:57:11.059162Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:57:11.060846Z 22 [Note] Stop semi-sync binlog_dump to slave (server_id: 2)
2017-03-09T11:57:11.061089Z 23 [Note] While initializing dump thread for slave with UUID <e51d35db-04bc-11e7-881b-0010e05f3e06>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(22).
2017-03-09T11:57:11.061136Z 23 [Note] Start binlog_dump to master_thread_id(23) slave_server(2), pos(hod03-bin.000001, 167943921)
2017-03-09T11:57:12.060309Z 23 [Note] Start semi-sync binlog_dump to slave (server_id: 2), pos(hod03-bin.000001, 167943921)
2017-03-09T11:57:12.697707Z 0 [ERROR] Read semi-sync reply magic number error
2017-03-09T11:57:12.698812Z 0 [ERROR] bin/mysqld: Got timeout reading communication packets
2017-03-09T11:57:12.718492Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:57:12.720233Z 23 [Note] Stop semi-sync binlog_dump to slave (server_id: 2)
2017-03-09T11:57:12.720538Z 24 [Note] While initializing dump thread for slave with UUID <e51d35db-04bc-11e7-881b-0010e05f3e06>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(23).
2017-03-09T11:57:12.720590Z 24 [Note] Start binlog_dump to master_thread_id(24) slave_server(2), pos(hod03-bin.000001, 180195009)
2017-03-09T11:57:13.719598Z 24 [Note] Start semi-sync binlog_dump to slave (server_id: 2), pos(hod03-bin.000001, 180195009)
2017-03-09T11:57:13.976952Z 9 [Note] Aborted connection 9 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets)
2017-03-09T11:57:14.235933Z 0 [ERROR] Read semi-sync reply magic number error
2017-03-09T11:57:14.237036Z 0 [ERROR] bin/mysqld: Got timeout reading communication packets
2017-03-09T11:57:44.235987Z 0 [ERROR] bin/mysqld: Got an error reading communication packets
2017-03-09T11:57:44.237866Z 25 [Note] While initializing dump thread for slave with UUID <e51d35db-04bc-11e7-881b-0010e05f3e06>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(24).
2017-03-09T11:57:44.237979Z 25 [Note] Start binlog_dump to master_thread_id(25) slave_server(2), pos(hod03-bin.000001, 189906178)
2017-03-09T11:57:44.237987Z 24 [Note] Stop semi-sync binlog_dump to slave (server_id: 2)
2017-03-09T11:57:45.237124Z 25 [Note] Semi-sync replication switched ON at (hod03-bin.000001, 189906178)
2017-03-09T11:57:45.237143Z 25 [Note] Start semi-sync binlog_dump to slave (server_id: 2), pos(hod03-bin.000001, 189906178)
2017-03-09T11:57:45.237145Z 0 [ERROR] bin/mysqld: Got an error reading communication packets


-- extract from slave's error log

Version: '5.7.17-log'  socket: '/tmp/mysql_slave.sock'  port: 3307  MySQL Community Server (GPL)
2017-03-09T11:39:48.662400Z 3 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=hod03-relay-bin' to avoid this problem.
2017-03-09T11:39:48.663863Z 3 [Note] 'CHANGE MASTER TO FOR CHANNEL '' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='localhost', master_port= 3306, master_log_file='hod03-bin.000001', master_log_pos= 1220, master_bind=''.
2017-03-09T11:39:52.310350Z 4 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-03-09T11:39:52.310849Z 5 [Warning] Slave SQL for channel '': If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0
2017-03-09T11:39:52.310882Z 5 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'hod03-bin.000001' at position 1220, relay log './hod03-relay-bin.000001' position: 4
2017-03-09T11:39:52.311289Z 4 [Note] Slave I/O thread for channel '': connected to master 'repl@localhost:3306',replication started in log 'hod03-bin.000001' at position 1220
2017-03-09T11:41:53.012998Z 4 [Note] Slave I/O thread killed while reading event for channel ''
2017-03-09T11:41:53.013019Z 4 [Note] Slave I/O thread exiting for channel '', read up to log 'hod03-bin.000001', position 1220
2017-03-09T11:41:54.187264Z 6 [Note] Slave I/O thread: Start semi-sync replication to master 'repl@localhost:3306' in log 'hod03-bin.000001' at position 1220
2017-03-09T11:41:54.187295Z 6 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-03-09T11:41:54.187950Z 6 [Note] Slave I/O thread for channel '': connected to master 'repl@localhost:3306',replication started in log 'hod03-bin.000001' at position 1220
2017-03-09T11:43:22.709084Z 5 [Note] Error reading relay log event for channel '': slave SQL thread was killed
2017-03-09T11:43:22.709384Z 6 [Note] Slave I/O thread killed while reading event for channel ''
2017-03-09T11:43:22.709414Z 6 [Note] Slave I/O thread exiting for channel '', read up to log 'hod03-bin.000001', position 1220
2017-03-09T11:43:25.925971Z 7 [Note] Slave I/O thread: Start semi-sync replication to master 'repl@localhost:3306' in log 'hod03-bin.000001' at position 1220
2017-03-09T11:43:25.925993Z 7 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-03-09T11:43:25.926243Z 8 [Warning] Slave SQL for channel '': If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0
2017-03-09T11:43:25.926282Z 8 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'hod03-bin.000001' at position 1220, relay log './hod03-relay-bin.000003' position: 320
2017-03-09T11:43:25.926486Z 7 [Note] Slave I/O thread for channel '': connected to master 'repl@localhost:3306',replication started in log 'hod03-bin.000001' at position 1220
2017-03-09T11:44:08.755068Z 7 [ERROR] Error reading packet from server for channel '': Lost connection to MySQL server during query (server_errno=2013)
2017-03-09T11:44:08.755090Z 7 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'hod03-bin.000001' at position 1379 for channel ''
2017-03-09T11:44:08.755096Z 7 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-03-09T11:56:49.016528Z 7 [ERROR] Error reading packet from server for channel '': Lost connection to MySQL server during query (server_errno=2013)
2017-03-09T11:56:49.016560Z 7 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'hod03-bin.000001' at position 1754 for channel ''
2017-03-09T11:56:49.016571Z 7 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-03-09T11:56:50.723711Z 7 [ERROR] Error reading packet from server for channel '': Lost connection to MySQL server during query (server_errno=2013)
2017-03-09T11:56:50.723734Z 7 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'hod03-bin.000001' at position 13273935 for channel ''
2017-03-09T11:56:50.723744Z 7 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-03-09T11:56:52.494283Z 7 [ERROR] Error reading packet from server for channel '': Lost connection to MySQL server during query (server_errno=2013)
2017-03-09T11:56:52.494305Z 7 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'hod03-bin.000001' at position 27566871 for channel ''
2017-03-09T11:56:52.494314Z 7 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-03-09T11:56:54.225575Z 7 [ERROR] Error reading packet from server for channel '': Lost connection to MySQL server during query (server_errno=2013)
2017-03-09T11:56:54.225591Z 7 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'hod03-bin.000001' at position 41349345 for channel ''
2017-03-09T11:56:54.225600Z 7 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-03-09T11:56:55.976986Z 7 [ERROR] Error reading packet from server for channel '': Lost connection to MySQL server during query (server_errno=2013)
2017-03-09T11:56:55.977008Z 7 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'hod03-bin.000001' at position 55131819 for channel ''
2017-03-09T11:56:55.977018Z 7 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-03-09T11:56:57.671150Z 7 [ERROR] Error reading packet from server for channel '': Lost connection to MySQL server during query (server_errno=2013)
2017-03-09T11:56:57.671167Z 7 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'hod03-bin.000001' at position 67893369 for channel ''
2017-03-09T11:56:57.671176Z 7 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-03-09T11:56:59.386483Z 7 [ERROR] Error reading packet from server for channel '': Lost connection to MySQL server during query (server_errno=2013)
2017-03-09T11:56:59.386500Z 7 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'hod03-bin.000001' at position 81165381 for channel ''
2017-03-09T11:56:59.386511Z 7 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-03-09T11:57:01.073121Z 7 [ERROR] Error reading packet from server for channel '': Lost connection to MySQL server during query (server_errno=2013)
2017-03-09T11:57:01.073141Z 7 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'hod03-bin.000001' at position 93926931 for channel ''
2017-03-09T11:57:01.073151Z 7 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-03-09T11:57:02.769147Z 7 [ERROR] Error reading packet from server for channel '': Lost connection to MySQL server during query (server_errno=2013)
2017-03-09T11:57:02.769165Z 7 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'hod03-bin.000001' at position 106688481 for channel ''
2017-03-09T11:57:02.769175Z 7 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-03-09T11:57:04.422760Z 7 [ERROR] Error reading packet from server for channel '': Lost connection to MySQL server during query (server_errno=2013)
2017-03-09T11:57:04.422781Z 7 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'hod03-bin.000001' at position 118939569 for channel ''
2017-03-09T11:57:04.422791Z 7 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-03-09T11:57:06.082583Z 7 [ERROR] Error reading packet from server for channel '': Lost connection to MySQL server during query (server_errno=2013)
2017-03-09T11:57:06.082601Z 7 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'hod03-bin.000001' at position 131190657 for channel ''
2017-03-09T11:57:06.082611Z 7 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-03-09T11:57:07.737278Z 7 [ERROR] Error reading packet from server for channel '': Lost connection to MySQL server during query (server_errno=2013)
2017-03-09T11:57:07.737297Z 7 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'hod03-bin.000001' at position 143441745 for channel ''
2017-03-09T11:57:07.737307Z 7 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-03-09T11:57:09.405500Z 7 [ERROR] Error reading packet from server for channel '': Lost connection to MySQL server during query (server_errno=2013)
2017-03-09T11:57:09.405521Z 7 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'hod03-bin.000001' at position 155692833 for channel ''
2017-03-09T11:57:09.405531Z 7 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-03-09T11:57:11.059151Z 7 [ERROR] Error reading packet from server for channel '': Lost connection to MySQL server during query (server_errno=2013)
2017-03-09T11:57:11.059181Z 7 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'hod03-bin.000001' at position 167943921 for channel ''
2017-03-09T11:57:11.059190Z 7 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-03-09T11:57:12.718501Z 7 [ERROR] Error reading packet from server for channel '': Lost connection to MySQL server during query (server_errno=2013)
2017-03-09T11:57:12.718520Z 7 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'hod03-bin.000001' at position 180195009 for channel ''
2017-03-09T11:57:12.718528Z 7 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-03-09T11:57:44.235980Z 7 [ERROR] Error reading packet from server for channel '': Lost connection to MySQL server during query (server_errno=2013)
2017-03-09T11:57:44.236006Z 7 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'hod03-bin.000001' at position 189906178 for channel ''
2017-03-09T11:57:44.236016Z 7 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
[umshastr@hod03]~/bugs/sysbench: