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