Winlab password Yahoo0786! ## Server startups (commented thread_concurrency from both confs) rm -rf master/ bin/mysqld --defaults-file=./73066M.cnf --initialize-insecure bin/mysqld --defaults-file=./73066M.cnf --basedir=$PWD --log-error=$PWD/master/log.err 2>&1 & rm -rf slave/ bin/mysqld --defaults-file=./73066S.cnf --initialize-insecure bin/mysqld --defaults-file=./73066S.cnf --basedir=$PWD --log-error=$PWD/slave/log.err 2>&1 & - master [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: bin/mysql -uroot -S /tmp/mysql_master.sock 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. mysql> CREATE USER 'repl'@'localhost' IDENTIFIED BY 'slavepass'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT REPLICATION SLAVE ON *.* TO 'repl'@'localhost'; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> mysql> CREATE USER 'repl'@'127.0.0.1' IDENTIFIED BY 'slavepass'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT REPLICATION SLAVE ON *.* TO 'repl'@'127.0.0.1'; Query OK, 0 rows affected (0.00 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) mysql> - slave [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: bin/mysql -uroot -S /tmp/mysql_slave.sock 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. mysql> CHANGE MASTER TO -> MASTER_HOST='127.0.0.1', -> MASTER_PORT=3333, -> MASTER_USER='repl', -> MASTER_PASSWORD='slavepass', -> MASTER_AUTO_POSITION = 1; Query OK, 0 rows affected, 2 warnings (0.01 sec) mysql> start slave; Query OK, 0 rows affected (0.01 sec) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 127.0.0.1 Master_User: repl Master_Port: 3333 Connect_Retry: 60 Master_Log_File: bin.000002 Read_Master_Log_Pos: 1220 Relay_Log_File: hod03-relay-bin.000002 Relay_Log_Pos: 1421 Relay_Master_Log_File: bin.000002 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: mysql.user,mysql.db,mysql.proxies_priv,mysql.tables_priv Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 1220 Relay_Log_Space: 1628 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: 6666 Master_UUID: ee1b73ba-e4ab-11e8-946e-0010e05f3e06 Master_Info_File: mysql.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: ee1b73ba-e4ab-11e8-946e-0010e05f3e06:1-5 Executed_Gtid_Set: ee1b73ba-e4ab-11e8-946e-0010e05f3e06:1-5 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: Master_TLS_Version: 1 row in set (0.00 sec) mysql> # Stop replication(slave>stop slave;) mysql> stop slave; Query OK, 0 rows affected (0.00 sec) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Master_Host: 127.0.0.1 Master_User: repl Master_Port: 3333 Connect_Retry: 60 Master_Log_File: bin.000002 Read_Master_Log_Pos: 1220 Relay_Log_File: hod03-relay-bin.000002 Relay_Log_Pos: 1421 Relay_Master_Log_File: bin.000002 Slave_IO_Running: No Slave_SQL_Running: No Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: mysql.user,mysql.db,mysql.proxies_priv,mysql.tables_priv Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 1220 Relay_Log_Space: 1628 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: NULL 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: 6666 Master_UUID: ee1b73ba-e4ab-11e8-946e-0010e05f3e06 Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: ee1b73ba-e4ab-11e8-946e-0010e05f3e06:1-5 Executed_Gtid_Set: ee1b73ba-e4ab-11e8-946e-0010e05f3e06:1-5 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: Master_TLS_Version: 1 row in set (0.00 sec) # Emulate load on master, remore -T from mysqlslap - master bin/mysqlslap --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-execute-number=100000 --auto-generate-sql-load-type=mixed --auto-generate-sql-secondary-indexes=2 -c 10 --create-schema='replication' -T -e InnoDB -i 10 --number-char-cols=10 -S /tmp/mysql_master.sock # Start replication(slave>start slave;) mysql> start slave; Query OK, 0 rows affected (0.01 sec) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Queueing master event to the relay log Master_Host: 127.0.0.1 Master_User: repl Master_Port: 3333 Connect_Retry: 60 Master_Log_File: bin.000002 Read_Master_Log_Pos: 95497371 Relay_Log_File: hod03-relay-bin.000003 Relay_Log_Pos: 11480827 Relay_Master_Log_File: bin.000002 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: mysql.user,mysql.db,mysql.proxies_priv,mysql.tables_priv Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 11481611 Relay_Log_Space: 95498061 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: 38 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: 6666 Master_UUID: ee1b73ba-e4ab-11e8-946e-0010e05f3e06 Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Reading event from the relay log Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: ee1b73ba-e4ab-11e8-946e-0010e05f3e06:1-57223 Executed_Gtid_Set: ee1b73ba-e4ab-11e8-946e-0010e05f3e06:1-8029 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: Master_TLS_Version: 1 row in set (0.00 sec) [umshastr@hod03]~: [umshastr@hod03]~: kill -9 19533 [umshastr@hod03]~: [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: bin/mysqld --defaults-file=./73066S.cnf --basedir=$PWD --log-error=$PWD/slave/log.err 2>&1 & [1] 20472 [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: bin/mysql -uroot -S /tmp/mysql_slave.sock ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql_slave.sock' (111) [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: bin/mysql -uroot -S /tmp/mysql_slave.sock ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql_slave.sock' (111) [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: bin/mysql -uroot -S /tmp/mysql_slave.sock ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql_slave.sock' (111) [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: bin/mysql -uroot -S /tmp/mysql_slave.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 14 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. mysql> show processlist; +----+-------------+-----------+------+---------+------+----------------------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------------+-----------+------+---------+------+----------------------------------------+------------------+ | 1 | system user | | NULL | Connect | 3 | Queueing master event to the relay log | NULL | | 2 | system user | | NULL | Connect | 0 | Reading event from the relay log | NULL | | 3 | system user | | NULL | Connect | 3 | Waiting for an event from Coordinator | NULL | | 4 | system user | | NULL | Connect | 3 | Waiting for an event from Coordinator | NULL | | 5 | system user | | NULL | Connect | 3 | Waiting for an event from Coordinator | NULL | | 6 | system user | | NULL | Connect | 3 | Waiting for an event from Coordinator | NULL | | 7 | system user | | NULL | Connect | 3 | Waiting for an event from Coordinator | NULL | | 8 | system user | | NULL | Connect | 3 | Waiting for an event from Coordinator | NULL | | 9 | system user | | NULL | Connect | 3 | Waiting for an event from Coordinator | NULL | | 10 | system user | | NULL | Connect | 3 | Waiting for an event from Coordinator | NULL | | 11 | system user | | NULL | Connect | 3 | Waiting for an event from Coordinator | NULL | | 13 | system user | | NULL | Connect | 292 | System lock | NULL | | 14 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-------------+-----------+------+---------+------+----------------------------------------+------------------+ 13 rows in set (0.00 sec) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Queueing master event to the relay log Master_Host: 127.0.0.1 Master_User: repl Master_Port: 3333 Connect_Retry: 60 Master_Log_File: bin.000009 Read_Master_Log_Pos: 674127887 Relay_Log_File: hod03-relay-bin.000005 Relay_Log_Pos: 363370068 Relay_Master_Log_File: bin.000003 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: mysql.user,mysql.db,mysql.proxies_priv,mysql.tables_priv Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 363369867 Relay_Log_Space: 7116601974 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: 296 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: 6666 Master_UUID: ee1b73ba-e4ab-11e8-946e-0010e05f3e06 Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Reading event from the relay log Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: ee1b73ba-e4ab-11e8-946e-0010e05f3e06:1-4907355 Executed_Gtid_Set: ee1b73ba-e4ab-11e8-946e-0010e05f3e06:1-861309 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: Master_TLS_Version: 1 row in set (0.00 sec) mysql> stop slave; Query OK, 0 rows affected (0.01 sec) mysql> start slave; Query OK, 0 rows affected (0.01 sec) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Queueing master event to the relay log Master_Host: 127.0.0.1 Master_User: repl Master_Port: 3333 Connect_Retry: 60 Master_Log_File: bin.000010 Read_Master_Log_Pos: 375206480 Relay_Log_File: hod03-relay-bin.000005 Relay_Log_Pos: 443318506 Relay_Master_Log_File: bin.000003 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: mysql.user,mysql.db,mysql.proxies_priv,mysql.tables_priv Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 443318305 Relay_Log_Space: 7891428747 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: 312 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: 6666 Master_UUID: ee1b73ba-e4ab-11e8-946e-0010e05f3e06 Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Reading event from the relay log Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: ee1b73ba-e4ab-11e8-946e-0010e05f3e06:1-5371606 Executed_Gtid_Set: ee1b73ba-e4ab-11e8-946e-0010e05f3e06:1-910225 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: Master_TLS_Version: 1 row in set (0.00 sec)