AWS re:Post을(를) 사용하면 다음에 동의하게 됩니다. AWS re:Post 이용 약관
AWS re:Postre:Post

read replicas with legacy code that doesn't properly separate queries

0

For applications that are not built to use read replicas and send writes to a master connection, is there an option to have the read replicas pass on all write queries while handling reads themselves?

The multi-master mode might work for this but it sounds risky if the code doesn't divide writes between the nodes to avoid conflicts.

주제
분석데이터베이스
태그
아마존 Aurora
언어
English
richardgvancouver
질문됨 4년 전189회 조회
2개 답변
0

I was working on read-write separation (Aurora 4 MySQL) for quite some time and as far as I can tell read replicas do not have such an option.

If the implementation of query routing is not an option, then you may consider using third-party RW splitters, like ProxySQL, Apache Sharding Sphere (https://shardingsphere.apache.org/document/current/en/features/read-write-split/) or
Heimdall proxy (https://aws.amazon.com/blogs/apn/using-the-heimdall-proxy-to-split-reads-and-writes-for-amazon-aurora-and-amazon-rds/).

HTH

epNIck
답변함 4년 전
0

Excellent options, thanks!

richardgvancouver
답변함 4년 전

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

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

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

관련 콘텐츠