Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

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

share|improve this question

1 Answer

up vote 1 down vote

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.

share|improve this answer
I have yet to see an actual implementation of MySQL Proxy past proof-of-concept. +1 for suggesting Percona XtraDB Cluster and HA Proxy (more real-world). – RolandoMySQLDBA Dec 17 '12 at 19:21

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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