-- ENV

## Steps to install dbdeployer https://github.com/datacharmer/dbdeployer and binary https://github.com/datacharmer/dbdeployer/releases
dbdeployer --version
dbdeployer version 1.12.3

cat /etc/*release
CentOS Linux release 7.5.1804 (Core) 
NAME="CentOS Linux"
VERSION="7 (Core)"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="7"
PRETTY_NAME="CentOS Linux 7 (Core)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:centos:centos:7"
HOME_URL="https://www.centos.org/"
BUG_REPORT_URL="https://bugs.centos.org/"

CENTOS_MANTISBT_PROJECT="CentOS-7"
CENTOS_MANTISBT_PROJECT_VERSION="7"
REDHAT_SUPPORT_PRODUCT="centos"
REDHAT_SUPPORT_PRODUCT_VERSION="7"

CentOS Linux release 7.5.1804 (Core) 
CentOS Linux release 7.5.1804 (Core) 

-- binary tarball pulled from internal repositories

[ushastry@BugCentOS7 Downloads]$ dbdeployer deploy replication 5.7.24
Installing and starting master
.. sandbox server started
Installing and starting slave1
.. sandbox server started
Installing and starting slave2
.. sandbox server started
$HOME/sandboxes/rsandbox_5_7_24/initialize_slaves
initializing slave 1
initializing slave 2
Replication directory installed in $HOME/sandboxes/rsandbox_5_7_24
run 'dbdeployer usage multiple' for basic instructions'
[ushastry@BugCentOS7 Downloads]$ cd $HOME/sandboxes/rsandbox_5_7_24
[ushastry@BugCentOS7 rsandbox_5_7_24]$ ./s1 <<< "STOP SLAVE; CHANGE MASTER TO MASTER_DELAY = 30; START SLAVE"; \
>   ./m <<< "CREATE DATABASE test_jfg; CREATE TABLE test_jfg.t1(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, t TIMESTAMP)"
[ushastry@BugCentOS7 rsandbox_5_7_24]$ 
[ushastry@BugCentOS7 rsandbox_5_7_24]$ for i in $(seq 40); do sleep 1.1; ./m <<< "INSERT INTO test_jfg.t1(t) VALUE (NOW())"; done; \
>   ./m <<< "SELECT MAX(id) FROM test_jfg.t1; SET GLOBAL offline_mode = ON"; \
>   ls -1 node1/data/mysql-relay.0*; \
>   ./s1 <<< "SHOW SLAVE STATUS\G STOP SLAVE; CHANGE MASTER TO MASTER_DELAY = 0; START SLAVE"
MAX(id)
40
node1/data/mysql-relay.000001
node1/data/mysql-relay.000002
*************************** 1. row ***************************
               Slave_IO_State: Reconnecting after a failed master event read
                  Master_Host: 127.0.0.1
                  Master_User: rsandbox
                  Master_Port: 19125
                Connect_Retry: 60
              Master_Log_File: mysql-bin.000001
          Read_Master_Log_Pos: 15162
               Relay_Log_File: mysql-relay.000002
                Relay_Log_Pos: 4184
        Relay_Master_Log_File: mysql-bin.000001
             Slave_IO_Running: Connecting
            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: 7953
              Relay_Log_Space: 11596
              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: 30
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 3032
                Last_IO_Error: error reconnecting to master 'rsandbox@127.0.0.1:19125' - retry-time: 60  retries: 1
               Last_SQL_Errno: 0
               Last_SQL_Error: 
  Replicate_Ignore_Server_Ids: 
             Master_Server_Id: 100
                  Master_UUID: 00019125-1111-1111-1111-111111111111
             Master_Info_File: /home/ushastry/sandboxes/rsandbox_5_7_24/node1/data/master.info
                    SQL_Delay: 30
          SQL_Remaining_Delay: 0
      Slave_SQL_Running_State: Waiting until MASTER_DELAY seconds after master executed event
           Master_Retry_Count: 86400
                  Master_Bind: 
      Last_IO_Error_Timestamp: 190108 02:03:22
     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: 
[ushastry@BugCentOS7 rsandbox_5_7_24]$ ./s1 <<< "SELECT MAX(id) FROM test_jfg.t1"
MAX(id)
13
[ushastry@BugCentOS7 rsandbox_5_7_24]$ ls -1 node1/data/mysql-relay.0*
node1/data/mysql-relay.000001
[ushastry@BugCentOS7 rsandbox_5_7_24]$