2

Is there any solution (say a proxy) that makes MySQL replication cluster behave like one database towards developers? Developers then won't need to worry about using master to write and slaves to read etc.?

3

The new MySQL Router is one possible solution. Please take a look and let us know what you think!

I'd love to hear what features you most want in future versions.

http://mysqlhighavailability.com/mysql-router-on-labs-the-newest-member-of-the-mysql-family/

http://mysqlhighavailability.com/easy-load-balancing-and-high-availability-using-mysql-router/

2

My first thought was that you would need a read/write splitting proxy. And the closest to that is the MySQL Proxy project, but the furthest that project has is a proof of concept

The other, probably more desired, approach is to set up something like Percona XtraDB Cluster behind HAProxy.

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.