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. Join them; it only takes a minute:

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

Looking for some insight and opinions from some DBAs, as I've been tasked to look into using Master/Master replication for a single table in a database.

We currently run mysql replication using a Master/Slave setup for all of our DBs. Is it possible to run Master/Master on a single table within a database while the remaining tables are replicated using Master/Slave? Is this even possible, or just a nightmare?

Another way I've seen it done, is to run 2 different mysql daemons (running on different ports), one using master/master and the other running master/slave. This method though seems like it would require more maintenance. Again, any comments?

Thanks for your help.

share|improve this question

Your Answer


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

Browse other questions tagged or ask your own question.