Web server and database running on a server in Boston.
There is a worldwide user base that accesses the site. Most users have typical page load speeds, but users in China experience heavy network latency.
My first thought to solve the problem is to install another server in one of our companies data centers in China that would run another web server and database instance. The URL for users in China or other parts of Asia would be something similar to asia.productname.com, so that traffic routes to the server based in China.
Part of this solution would require master/master replication of the databases. I have read mixed reviews of PostgreSQL support for master/master replication. I know MySQL supports master/master replication fairly well.
My question is if anyone on the forum has experience working with a similar set up?
Has anyone successfully set up PostgreSQL master/master replication? Were there major issues?
What about suggestions on other ways to deal with the latency problem, if any?*
*The product is mostly serving news and commentary that is updated very frequently throughout the day, so the database is very write heavy. I point that out in case someone wanted to suggest some caching strategies.