RDS Read Replica, binlog_format

0

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?

1개 답변
1

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.

profile picture
전문가
답변함 3달 전
  • Both primary and replica instance are using the same parameter group, binlog_format is set to ROW in parameter group and primary instance correctly reflects it while read replica reflects MIXED. I believe it is due to incompatible-parameters error observed, hence it didn't get updated but unsure why it happened.

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠