Thinking about separating apache+php and mysql on two different virtual servers. Is this a good idea? Possibly multiple apache+php servers connecting to a single mysql server.
on 01/13/2012 – Made popular on 01/13/2012
I recently setup a Ubuntu 12.04 LAMP Server at home that I use to develop websites in corporation with clients. I've been using Ubuntu and other Linux distros for a few years, but I am new to servers and have been learning a lot.
I have a (possibly not so quick question) about the best way to set up a 'global' MySQL Database.
I basically need to set up multiple MySQL servers in separate geographical locations that will all server the same data set (i.e. If I add data to one server, it will appear on another server relatively quickly).
I am setting up a single Debian server serving Magento with Mysql. High load is expected (millions of hits per day). I've been reading various people's comments and found so many different setups but I am not sure what to do if I want to. Load balancing between several servers would of course be nice but I have only one server.