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