I'm looking for some advice with regards to serving a dynamic social/ecommerce website to a global audience. At present our market is primarily in the USA but we would like to expand to Europe, South Africa, Australia and other regions.
We are a UK based company, and would like to house our core hosting operations in the UK. I have had suggestions to use CDNs for static content and an anycast DNS service, but what about the dynamic content?
Do we need a web/database mirror in each region to keep the site 'snappy'? Due to user-interaction and other such elements, the databases would need to stay in 'sync' with each other. What options do we have to achieve this?
- Servers: 1 web + 1 db server
- Environment: LAMP
- Software: Joomla!
Thanks in advance,