Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $ mytop
- Id User Host/IP DB Time Cmd Query or State
- -- ---- ------- -- ---- --- ----------
- 322 system us 20715 Connec Reading event from the relay log
- 321 system us 7841 Connec Waiting for master to send event
- $ mysql -e "SHOW SLAVE STATUSG"
- ************************** 1. row ***************************
- Slave_IO_State: Queueing master event to the relay log
- Master_Host: 192.168.1.2
- Master_User: repl
- Master_Port: 3306
- Connect_Retry: 60
- Master_Log_File: mysql-bin.000012
- Read_Master_Log_Pos: 576756032
- Relay_Log_File: mysql-relay-bin.000009
- Relay_Log_Pos: 22727176
- Relay_Master_Log_File: mysql-bin.000004
- 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: 495891486
- Relay_Log_Space: 9166709033
- 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: 20860
- 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: 200
- Master_UUID: 11e5-fd4f-c54f4421-821c-f23c91b04219
- Master_Info_File: /var/lib/mysql/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:
- Executed_Gtid_Set:
- Auto_Position: 0
- Replicate_Rewrite_DB:
- Channel_Name:
- Master_TLS_Version:
- Master_Log_File: mysql-bin.000012
- Read_Master_Log_Pos: 987405670
- Relay_Log_File: mysql-relay-bin.000009
- Relay_Log_Pos: 42272891
- Relay_Master_Log_File: mysql-bin.000004
- Slave_IO_Running: Yes
- Slave_SQL_Running: Yes
- Exec_Master_Log_Pos: 515437201
- Relay_Log_Space: 9577359044
- Until_Condition: None
- Until_Log_Pos: 0
- Master_SSL_Allowed: No
- Seconds_Behind_Master: 21000
- Slave_SQL_Running_State: Reading event from the relay log
- Master_Retry_Count: 86400
- TheSlave$ mysql --host=TheMaster --user=repl --password=$slavepass
- mysql > SHOW GRANTS; /* successfully showing replication privileges */
- master:my.cnf slave:my.cnf
- server_id 200 300
- innodb_buffer_pool_size 48G 32G
- binlog-do-db my_db1 [not set]
- binlog-do-db my_db2 [not set]
- binlog-do-db my_db3 [not set]
- relay-log [not set] /var/log/mysql/mysql-relay-bin.log
- binlog_format mixed [not set]
- log_bin /var/log/mysql/mysql-bin.log [not set]
- sync_binlog 1 [not set]
- log_slave_updates [not set] 1
- read_only [not set] 1
- slave_skip_errors [not set] 1062
- mysql -e "SHOW SLAVE STATUSG"
- *************************** 1. row ***************************
- Slave_IO_State: Waiting for master to send event
- Master_Log_File: mysql-bin.000013
- Read_Master_Log_Pos: 924285271
- Relay_Log_File: mysql-relay-bin.000009
- Relay_Log_Pos: 252434322
- Relay_Master_Log_File: mysql-bin.000004
- Slave_IO_Running: Yes
- Slave_SQL_Running: Yes
- Last_Errno: 0
- Skip_Counter: 0
- Exec_Master_Log_Pos: 725598632
- Relay_Log_Space: 10587985446
- Until_Condition: None
- Until_Log_File:
- Until_Log_Pos: 0
- Seconds_Behind_Master: 21741
- Master_Server_Id: 200
- Master_Info_File: /var/lib/mysql/master.info
- SQL_Delay: 0
- SQL_Remaining_Delay: NULL
- Slave_SQL_Running_State: Reading event from the relay log
- Master_Retry_Count: 86400
- Auto_Position: 0
- Id User Host/IP DB Time Cmd Query or State
- -- ---- ------- -- ---- --- ----------
- 322 system us my_db1 21817 Connec INSERT INTO my_db1.my_table1 ( id, name ) VALUES ( 500810952, 'foo'
- 321 system us 9634 Connec Waiting for master to send event
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement