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 having trouble setting up a virtualized HA MySQL/Apache cluster. Currently I have six Dell Optiplex GX240s each with 80gb HDD, 1 10/100 NIC, 2GBs RAM, 2.1GHz Intel P4. I am running F14 with MySQL 5.5, Apache 2.2, HAProxy and keepalived. Two machines are load balancers, two machines are MySQL master-master replication, two machines are MySQL slave replicators and Apache webservers.
I found some real good articles on Mysql load balancing on web but being a new bee could conclude nothing :(:(
I have this requirement where my webapplication running on a tomcat is behind a loadbalancer and I am planning to deploy this application on multiple servers.
This webapp though needs a database ( mysql ) for managing profile and other similar stuff, now i can only have a single master