manish,
LVS can do that, all these servers located in local data center or remote data center?
For MySQL use official mysql load balancing server as follows
Mysql cluster
master <==> slave
If master goes down slave will take place, official cluster will do sync between two server. Minimum
3 servers required for mysql clustering. Please read following tutorials. Go with 5.1 as it is stable and working well:
Official mysql clustering information =>
MySQL AB :: MySQL Cluster
A good tutorial =>
How To Set Up A Load-Balanced MySQL Cluster | HowtoForge - Linux Howtos and Tutorials
Apache load balacing tutorial
How To Set Up A Loadbalanced High-Availability Apache Cluster | HowtoForge - Linux Howtos and Tutorials
Following diagram will clear your idea:
Code:
Internet
|
|
Linux LVS Loadbalacer 2 servers
| |
| |
/ \ / \
Mysql cluster Apache
2 server 2-3 servers
You need to install MySQL cluster management server on one of the LVS load balancer. To sync web server server you can use rsync or use DRDB. Third possibility is use centralized SAN to push data to all server.
Hope this helps! If you have other problem just hit reply button
