Need help with Syncing DBs/Dirs and auto redirecting

I currently run a website that is basically divided into four sections

1) Home Page
2) Reviews
3) News
4) Forums

News and Forums share a database while reviews has a seperate database. The Home Page has scripts that call on both the reviews and forums databases and display info.

My curresnt server is setup in Singapore and is a Win2k3 server with PHP/MySQL. The setup is working great, however, its slow for people visitng from the US. Thus, I thought I would take a Linux virtual server in the US and basically have the reviews posted there as well for faster access in the US and maybe Europe.

Now, how would I go about setting it up so that the reviews database and
directory are replicated automatically? Also I would like for the
incoming traffic to be automatically detcted if its from the US or not and
thus take the viewer to that server directly.

Thanks
Abbas

 

 

 

 

Top