I am looking for a solution for production which can manage the read and write splitting on master and slave connection as i can't affford to define multiple connection string for R/W in whole application.

  • Gradually split the connections in your app. Perhaps build a DB layer to help isolate things. – Rick James Oct 5 '18 at 4:19

AWS does not have a service that provides this.

Transparent, intelligent read/write splitting is a Hard Problem™ because there are so many details that can go wrong, such as queries that use user-defined variables, which aren't deterministic unless the state of the variables is maintained across multiple connections... inconsistent reads and read-after-write due to replication lag... and many others.

The only solutions for now are third-party products like Maxscale and ProxySQL, unless you are using a connector library or ORM that manages such things for you (assuming such things exist).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.