Ok, here goes... its a tough one I think...
- Server A sits in American Samoa
- Server B sits in O'ahu
- Server A & B are connected through a satellite transmission - minimum latency is >= 500 ms.
At this time I am able to replicate files in realtime using rsync. However... I would like Server A & Server B to have the same database information processed in realtime, basically a mysql ring replication like topology. The problems I run into include... lag and serious auto increment misses because of network latency.
Goal: Both sites in O'ahu & American Samoa have local copies of moodle database theorectically providing "fast" local access to each island.
Any ideas on how to approach this problem and reach my intended goal?
I was thinking about running a wide area cluster and having the load balancer direct traffic to specific servers. Thoughts please...