zongji icon indicating copy to clipboard operation
zongji copied to clipboard

Published 20 hours ago • verified publisher icon nevill

Binlog events are not getting emitted in mysql RDS version:5.6.41

Open ramaguruprakash opened this issue 5 years ago • 2 comments

Hi, I have a mysql RDS replica instance which is configured properly, I am able to do a SHOW BINARY LOGS and the binlog format is set to ROW. When try to use and get the events in debug mode. The last event I am getting is this --> ComBinlog { command: 18, position: 4, flags: 0, serverId: 650931968, filename: 'mysql-bin-changelog.144390' } Not getting even the bin log ROTATE event even though i see new binlog files getting emitted. Am I missing any configuration or something on the RDS instance?

ramaguruprakash avatar Jul 27 '19 05:07 ramaguruprakash

Update: Found out that binlog events are flowing only when binlog_checksum is set to crc32 in the parameter group attached to the RDS instance.

ramaguruprakash avatar Jul 30 '19 04:07 ramaguruprakash

@ramaguruprakash may I ask what is the previous value of binlog_checksum before crc32? thanks

mgttt avatar Nov 21 '19 00:11 mgttt