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


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.

asked 3 years ago29 views
2 Answers

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 ( or
Heimdall proxy (


answered 3 years ago

Excellent options, thanks!

answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions