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

I need to sync a MySQL database between two servers.

If a new record will be added in server A, then server B fetch new record.

If a new record will be added in server B, then server A fetch new record.

share|improve this question
There is answer here >>… – Mathew Nov 30 '15 at 11:16

You should probably go for Master-Master Replication .

share|improve this answer
Master to Master Replication has data loss? – Batnasan Byambasuren Mar 12 '13 at 1:13
Well mate its open source, and it can't actually work the way we pray. But if you know what your application does, and with test cases that you try to break the replication, I'm sure you will find a way to fix it. And that's how it works if you want to keep it flawless. May I help you if I know on what case does data loss occur for master/master according to you? – Mannoj Mar 12 '13 at 5:29

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.