root@localhost (none)>show replica status\G
*************************** 1. row ***************************
Replica_IO_State: Waiting for source to send event
Source_Host: 192.168.1.1
Source_User: repl
Source_Port: 3306
Connect_Retry: 60
Source_Log_File: binlog.000501 #i/o thread当前正在读取的主库的binary日志文件
Read_Source_Log_Pos: 1020321958 #i/o thread当前正在读取的主库的binary日志文件中的位置
Relay_Log_File: relay.001313 #sql thread当前正在处理的relay日志文件
Relay_Log_Pos: 203735030 #sql thread当前正在处理的relay日志文件的位置
Relay_Source_Log_File: binlog.000500 #sql thread最近执行事件的主库的binary日志文件
Replica_IO_Running: Yes
Replica_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_Source_Log_Pos: 203734820 #sql thread当前在处理的主库的二进制日志的位置，可以使用该信息做新的复制节点
Relay_Log_Space: 2667599650
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Source_SSL_Allowed: No
Source_SSL_CA_File:
Source_SSL_CA_Path:
Source_SSL_Cert:
Source_SSL_Cipher:
Source_SSL_Key:
Seconds_Behind_Source: 1057
Source_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Source_Server_Id: 2508
Source_UUID: cd87eea-e3d8-11ed-bacd-123456b0rd4c
Source_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Replica_SQL_Running_State: Waiting for replica workers to process their queues
Source_Retry_Count: 86400
Source_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Source_SSL_Crl:
Source_SSL_Crlpath:
Retrieved_Gtid_Set: cd87eea-e3d8-11ed-bacd-123456b0rd4c:79714658-92160430
Executed_Gtid_Set: cd87eea-e3d8-11ed-bacd-123456b0rd4c:1-92160425
Auto_Position: 1
Replicate_Rewrite_DB:
Channel_Name:
Source_TLS_Version:
Source_public_key_path:
Get_Source_public_key: 1
Network_Namespace:
1 row in set (0.00 sec)
root@localhost (none)>
借用下面的这张图，可以帮助理解show replica status的结果：
标签：STATUS,Last,Log,SSL,SHOW,Source,REPLICA,Replicate,SQL From： https://www.cnblogs.com/abclife/p/17729912.html