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.

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

2 Answers 2

SQLyog has Database synchronization feature which does the same thing if you do not have Master-Master replication setup


share|improve this answer

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.