load balancing two web servers each on two different isp's?
Posted
by Scott
on Server Fault
See other posts from Server Fault
or by Scott
Published on 2010-04-20T11:14:59Z
Indexed on
2010/04/20
14:34 UTC
Read the original article
Hit count: 255
I have two ISP's that provide me hosting via apache / php / mysql. I am running drupal on them. On occasion the mysql server will go away (crash), so I was hoping to find a reasonable way to have a fail over, if server A SQL is down, all traffic is sent to server B.
I know traditionally this is handled in DNS where a second alternate ip is given if there is a problem - or similar. But I do not have control over the isp, other than I can run php, perl and the usual apache stuff. Also, I have static ip's on each isp, and I can create dns entries (A/CNAME/TXT).
So, I was hoping there might be a way for me to have a script that checks if drupal has a problem, and if so, somehow alter dns, or ?
Or, any other ideas? (other than spending lots more $ on a better isp)
© Server Fault or respective owner