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

2 Answers

You should probably go for Master-Master Replication .

http://www.howtoforge.com/mysql_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
add comment

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

http://stackoverflow.com/questions/7946540/how-do-i-sync-2-mysql-databases

share|improve this answer
add comment

Your Answer

 
discard

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.