search

nevill / zongji

A mysql binlog listener running on Node.js.
Other
375 stars 118 forks source link

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

Open ramaguruprakash opened 5 years ago

ramaguruprakash commented 5 years ago

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 commented 5 years ago

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.

mgttt commented 5 years ago

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