RDS Read Replica, binlog_format

Question

Switching the binlog_format from the default MIXED to ROW does not reflect on the read replica instance. Although the primary instance correctly adopts the new value, the read replica initially show as having incompatible parameters before eventually transitioning to an available state but binlog_format is still MIXED. In the RDS logs, an event is recorded: "Database instance marked as incompatible-parameters. The Database could not be started". It's worth noting that automated backup is enabled for the read replica instance already.

Have you experienced this?

Answer

Ensure that both the primary instance and the read replica are using the correct parameter groups. If you have custom parameter groups, you need to make sure the binlog_format is set to ROW in both parameter groups.

RDS Read Replica, binlog_format

Relevanter Inhalt