1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
1
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_connectis not executed. - Always set the
aurora_replica_read_consistencyparameter for any session for which you want to forward writes. - If you set
aurora_replica_read_consistencyparameter by usinginit_connect, all connections will be enabledaurora_replica_read_consistencyparameter. It means, every query will be forwarded to primary cluster. To avoid this per session, you need to setaurora_replica_read_consistencyas blank usingSET SESSIONquery.
I hope this might help.
답변함 일 년 전
Thanks for the reply, the
init_connectwill do the trick. Anyway, the fact that is a session parameter is not incompatible to assigning a default value. It has already a default value chosen by AWS (the empty value) that affects the way the server works in a global scenario.