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.

we intend so replicate a database around 500GB in size from one host to another and use a loadbalancer splitting up the requests.

On small test databases that worked great, yet repliating the main database would take an estimated 127 days. Apparently our hoster doesn't provide a great connection between the two servers.

Instead we asked the hoster to copy the database's files to a disk and use those files on the second server. We assumed that this would fix the issue and we'd be able to sync the database much quicker afterwards.

As it turned out, that dindn't work very well.

My assumption is that both databases need to sync their status in order to know about their respective states. Is that assumption correct?

If so, is there a way to force both databases into accepting the other database as up to date without having to sync through all documents?

Could you think of another reason or better yet a solution to this problem?

Thanks a lot in advance
Roman

share|improve this question
add comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

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