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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question

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.

share|improve this answer
Thanks for comment, how it is different from youtube vitess? – Sławosz Oct 6 '15 at 11:53
Vitess is much more today. Vitess seems quite incredible! :) – Matt Lord Oct 6 '15 at 13:38
Wow this looks awesome! Heres a good video on Vitess – Chad Scira Dec 2 '15 at 18:31

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

Your Answer


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.