Hacker News new | ask | show | jobs
by seanlaff 2308 days ago
This depends on row-based binlog replication, correct? Has netflix had to deal with systems with statement-based replication?
1 comments

correct. This way we can capture create, update and delete events of individual rows. binlog_format must be set to ROW in order to make this work in MySQL. For Postgres we are using replication slots which provide row based events.

We use MySQL RDS and it has "mixed" as the default binlog_format. Mixed uses statement based logging for some event types (see MySQL docu for details). Hence statement based replication is part of the mix unless one explicitly switches to ROW based replication (which is required for DBLog).