Why is RDS for MySQL setting replica_exec_mode to IDEMPOTENT by default?

Hi rahul342,

Thanks for your question.

I do see the default being set as "IDEMPOTENT" by the RDS MySQL instances but the default value as per the official MySQL docs, the STRICT mode is the default value.

https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html

I have reached out to my internal team on this and they have agreed to change the default value in the future releases for RDS MySQL.

But till then, you can change the value manually if required.