Best unofficial Apache Server developers community |
Virtual IP or Load balancing for a http/ mysql cluster
|
Hi everybody, First of all i have to say i'm very very newbie as sysadmin. I'm trying to do someone else's work, and i have almost 0 experience in clustering / load balancing and related stuff. This is the situation. I have 4 phisical servers. The wanted configurations would be: 2 replicated Webservers, they are the public interface to access database data 2 replicated MySQL What i'd like to have is: 1 virtual ip address shared by webservers, with a load balancing for the 2 machines. This ip will be the public ip, pointed by the DNS. 1 virtual ip address shared by mysql, same as above. This one will be the interface used by application's connection. The servers are on a remote server farm, but they are included in a VLAN. Is it possible to reach this configuration ? In that case, how ? If not, what would be a good alternative? Thanks for any hint. Dario
posted via ServerFault
|
1 Answer
|
|
A few Questions do you want it to be load balanced cause if you have 4 machines 2apache and 2 mysql you get set up a fail over setup such that if one server goes down it will use the other server.And to achive this you can use HeartBeat http://www.linuxjournal.com/article/5862 IF you have a high load you maby have 3 nodes with apache/mysql all replicated and convert 1 of the box's into a dedeicated load balancer. The most reliable set up is 2 load balancers 3 apache servers 1 strong mysql server and 1 backup through heart beat more to read i really liked the guide on howto forge http://www.howtoforge.com/high_availability_loadbalanced_apache_cluster |
Your answer
January 13, 2011
January 28, 2011