Set aurora_replica_read_consistency in DB cluster parameters

Hi, thank you for asking your question.

aurora_replica_read_consistency is session level parameter, so you cannot set this parameter via parameter group directly. However, please use init_connect to set this parameter instead. This parameter can be used for a string to be executed by the server for each client that connects. https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_init_connect

Please note:

• For users that have the SUPER privilege, the content of init_connect is not executed.
• Always set the aurora_replica_read_consistency parameter for any session for which you want to forward writes.
• If you set aurora_replica_read_consistency parameter by using init_connect, all connections will be enabled aurora_replica_read_consistency parameter. It means, every query will be forwarded to primary cluster. To avoid this per session, you need to set aurora_replica_read_consistency as blank using SET SESSION query.

I hope this might help.