[Linux-HA] mySQL localhost failover
msoffen at iso-ne.com
Tue Jun 15 13:19:00 MDT 2004
There are a couple of ways that you "might" want to try. One question
though. Have you looked at drbd for the database disk ? We are using it
for a fairly heavily hit database and it never gave us any issues. Also,
if you "fail" does your application fail over to the "slave" server as well
This way, you set up a drbd between node3 and node1. The Webserver Process
can also be on node3 and fail to node1. Then just make your hearbeat init
startup mysql on the primary and then start your apache/web server process.
From: Daniel Khan [mailto:d.khan at ventigo.com]
Sent: Tuesday, June 15, 2004 3:09 PM
To: linux-ha at lists.linux-ha.org
Subject: [Linux-HA] mySQL localhost failover
my question may be semi OT but I think that most probably someone on
this list may allready have solved an issue like mine.
I want to build a cluster for webhosting and use a master server as for
node3 is the master, node1 is the slave.
node1 uses mysql replication (node3 is master).
Now all scripts on this host use 'localhost' as hostname (and we don't
want to change this for all sites...).
What I want is to redirect this socket connection to the master server
(kind of transparent socket 'proxy'?).
If the master dies - and now we are back to HA :) - the slave should
fall back to use the socket connection to the local mysql server.
Has anyone ever done such a setup?
Should I try to hack mysql or php to do what I expect or are there
Maybe someone could help me out.
Thanks in advance
Linux-HA mailing list
Linux-HA at lists.linux-ha.org
More information about the Linux-HA