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.