This is an automated archive.
The original was posted on /r/mysql by /u/Dull-String945 on 2023-08-13 14:44:49+00:00.
mysql> show master status \G
*************************** 1. row ***************************
File: mysql-bin.003048
Position: 564297083
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set: 44bb99b2-d23e-11ea-8cd3-42010a5b0009:1-5047082753,
510a4a4d-9ca6-11e9-be1a-42010a2a0002:1-431998131,
897c72f1-e976-11e9-9016-42010a800fcb:1-537,
d98cad4b-8ca6-11eb-bdc5-42010a8a0002:1-7
1 row in set (0.00 sec)
mysql> show slave status \G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 35.203.185.90
Master_User: replication_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.032487
Read_Master_Log_Pos: 608102971
Relay_Log_File: mao-sql-production-relay-bin.073640
Relay_Log_Pos: 608103144
Relay_Master_Log_File: mysql-bin.032487
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB: mysql,performance_schema,information_schema
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table: mysql.%,performance_schema.%,information_schema.%
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 608102971
Hello,
Master_log_position is lower in MASTER than SLAVE. How could I interpret it?
Does it mean SLAVE is in SYNC with MASTER? I have never seen SLAVE is ahead of MASTER.