Re: Slave not updating(no error, log position same as master)

[saranjeet singh]

Hi James,

My master is RDS. It does not have my.cnf.
Below is the output:
File: mysql-bin-changelog.013116
Position: 412
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set:
1 row in set (0.00 sec)

Here is the slave output:

show slave status \G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: master.xxxx.rds.xxx-1.amazonaws.com.cn
Master_User: database
Master_Port: 3306
Connect_Retry: 20
Master_Log_File: mysql-bin-changelog.013117
Read_Master_Log_Pos: 120
Relay_Log_File: localhost-relay-bin.000074
Relay_Log_Pos: 293
Relay_Master_Log_File: mysql-bin-changelog.013117
Slave_IO_Running: Yes
Slave_SQL_Running: Yes