-- 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 unpack mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz 
Unpacking tarball mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz to $HOME/opt/mysql/5.7.24
.........100.........200.........300.......375
Renaming directory /home/ushastry/opt/mysql/mysql-5.7.24-linux-glibc2.12-x86_64 to /home/ushastry/opt/mysql/5.7.24
[ushastry@BugCentOS7 Downloads]$ dbdeployer deploy multiple -n 2 --gtid --concurrent 5.7.24
Creating directory /home/ushastry/sandboxes
multiple directory installed in $HOME/sandboxes/multi_msb_5_7_24
run 'dbdeployer usage multiple' for basic instructions'
[ushastry@BugCentOS7 Downloads]$ 
[ushastry@BugCentOS7 Downloads]$ cd $HOME/sandboxes/multi_msb_5_7_24
[ushastry@BugCentOS7 multi_msb_5_7_24]$ ls -l
total 52
-rwxr--r-- 1 ushastry ushastry  963 Nov 30 06:45 clear_all
-rwxr--r-- 1 ushastry ushastry  820 Nov 30 06:45 n1
-rwxr--r-- 1 ushastry ushastry  820 Nov 30 06:45 n2
drwxr-xr-x 4 ushastry ushastry 4096 Nov 30 06:45 node1
drwxr-xr-x 4 ushastry ushastry 4096 Nov 30 06:45 node2
-rwxr--r-- 1 ushastry ushastry  845 Nov 30 06:45 restart_all
-rw-rw-r-- 1 ushastry ushastry  324 Nov 30 06:45 sbdescription.json
-rwxr--r-- 1 ushastry ushastry  987 Nov 30 06:45 send_kill_all
-rwxr--r-- 1 ushastry ushastry  963 Nov 30 06:45 start_all
-rwxr--r-- 1 ushastry ushastry 1227 Nov 30 06:45 status_all
-rwxr--r-- 1 ushastry ushastry  957 Nov 30 06:45 stop_all
-rwxr--r-- 1 ushastry ushastry 1111 Nov 30 06:45 test_sb_all
-rwxr--r-- 1 ushastry ushastry 1003 Nov 30 06:45 use_all
[ushastry@BugCentOS7 multi_msb_5_7_24]$ ./node
node1/ node2/ 
[ushastry@BugCentOS7 multi_msb_5_7_24]$ ./node1/
add_option     data/          load_grants    restart        show_binlog    show_relaylog  status         test_sb        use            
clear          init_db        my             send_kill      show_log       start          stop           tmp/           
[ushastry@BugCentOS7 multi_msb_5_7_24]$ ./n1 -umsandbox -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.24-log MySQL Community Server (GPL)

Copyright (c) 2000, 2018, 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.

node1 [localhost:24125] {msandbox} ((none)) > select version();
+------------+
| version()  |
+------------+
| 5.7.24-log |
+------------+
1 row in set (0.00 sec)

node1 [localhost:24125] {msandbox} ((none)) > reset master;
Query OK, 0 rows affected (0.02 sec)

node1 [localhost:24125] {msandbox} ((none)) > select password('repl');
+-------------------------------------------+
| password('repl')                          |
+-------------------------------------------+
| *A424E797037BF97C19A2E88CF7891C5C2038C039 |
+-------------------------------------------+
1 row in set, 1 warning (0.00 sec)

node1 [localhost:24125] {msandbox} ((none)) > CREATE USER IF NOT EXISTS 'repl'@'127.0.0.1';
Query OK, 0 rows affected (0.01 sec)

node1 [localhost:24125] {msandbox} ((none)) >  ALTER USER 'repl'@'127.0.0.1' IDENTIFIED WITH 'mysql_native_password' AS '*A424E797037BF97C19A2E88CF7891C5C2038C039' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK;
Query OK, 0 rows affected (0.01 sec)

node1 [localhost:24125] {msandbox} ((none)) >  -- change user to root
node1 [localhost:24125] {msandbox} ((none)) > \q
Bye

[ushastry@BugCentOS7 multi_msb_5_7_24]$ ./n1 -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.24-log MySQL Community Server (GPL)

Copyright (c) 2000, 2018, 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.

node1 [localhost:24125] {root} ((none)) > GRANT REPLICATION SLAVE ON *.* TO 'repl'@'127.0.0.1';
Query OK, 0 rows affected (0.01 sec)

node1 [localhost:24125] {root} ((none)) > select @@port;
+--------+
| @@port |
+--------+
|  24125 |
+--------+
1 row in set (0.00 sec)

node1 [localhost:24125] {root} ((none)) > \q
Bye
[ushastry@BugCentOS7 multi_msb_5_7_24]$ 
[ushastry@BugCentOS7 multi_msb_5_7_24]$ 
[ushastry@BugCentOS7 multi_msb_5_7_24]$ ./n2 -umsandbox -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.24-log MySQL Community Server (GPL)

Copyright (c) 2000, 2018, 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.

node2 [localhost:24126] {msandbox} ((none)) > reset master;
Query OK, 0 rows affected (0.02 sec)

node2 [localhost:24126] {msandbox} ((none)) > change master to master_host = '127.0.0.1', master_port = 24125;
Query OK, 0 rows affected (0.05 sec)

node2 [localhost:24126] {msandbox} ((none)) > change master to master_user = 'repl', master_password = 'repl';
Query OK, 0 rows affected, 2 warnings (0.04 sec)

node2 [localhost:24126] {msandbox} ((none)) > change master to master_auto_position = 1;
Query OK, 0 rows affected (0.03 sec)

node2 [localhost:24126] {msandbox} ((none)) > \q
Bye
[ushastry@BugCentOS7 multi_msb_5_7_24]$ ./node2/restart
stop /home/ushastry/sandboxes/multi_msb_5_7_24/node2
.. sandbox server started
[ushastry@BugCentOS7 multi_msb_5_7_24]$ tail -n 8 node2/data/msandbox.err 
2018-11-30T11:52:47.379445Z 0 [ERROR] Error during --relay-log-recovery: Could not locate rotate event from the master.
2018-11-30T11:52:47.381546Z 0 [ERROR] Slave: Failed to initialize the master info structure for channel ''; its record may still be present in 'mysql.slave_master_info' table, consider deleting it.
2018-11-30T11:52:47.381589Z 0 [ERROR] Failed to create or recover replication info repositories.
2018-11-30T11:52:47.381608Z 0 [Note] Failed to start slave threads for channel ''
2018-11-30T11:52:47.381622Z 0 [Note] Some of the channels are not created/initialized properly. Check for additional messages above. You will not be able to start replication on those channels until the issue is resolved and the server restarted.
2018-11-30T11:52:47.400104Z 0 [Note] Event Scheduler: Loaded 0 events
2018-11-30T11:52:47.400656Z 0 [Note] /home/ushastry/opt/mysql/5.7.24/bin/mysqld: ready for connections.
Version: '5.7.24-log'  socket: '/tmp/mysql_sandbox24126.sock'  port: 24126  MySQL Community Server (GPL)
[ushastry@BugCentOS7 multi_msb_5_7_24]$ 
[ushastry@BugCentOS7 multi_msb_5_7_24]$ ./n2 -umsandbox -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.24-log MySQL Community Server (GPL)

Copyright (c) 2000, 2018, 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.

node2 [localhost:24126] {msandbox} ((none)) > start slave;
ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository
node2 [localhost:24126] {msandbox} ((none)) >