Take the 2-minute tour ×
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.

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
add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.