Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Are there any pitfalls or gotchas for replicating (master->slave) MySQL DB to a remote server about 100ms ping away?

share|improve this question
4  
Yes, just one, to make it asynchronous and not synchronous. –  Andrew Smith Aug 30 '12 at 18:11
    
Pointers out of sync –  Steve Robbins Aug 30 '12 at 19:32

1 Answer 1

up vote 0 down vote accepted

Tons depending on what you want to do and what features you are using. The documentation points out most common things you should be aware of; especially the "features and issues" section.

http://dev.mysql.com/doc/refman/5.5/en/replication.html

share|improve this answer

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.