MySQL proxy to replication configuration

Question

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.?

Answer 1

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/

Answer 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.