Portal Home > Knowledgebase > Articles Database > MySQL heartbeat with failover
MySQL heartbeat with failover
| Posted by carlo_gra, 08-04-2008, 06:26 AM |
| Hello, we need to have about 4 machines with MySQL and it's own disk (no shared filesystem) and 1 server in standby.
We need that all server of pool can work with it's own IP but when one go down, standby server can take it's place.
(mount data partition is not a problem for the moment)
Is it possible?
I've seen some tutorial with heartbeat but in this case I can setup only two servers (one working) with one virtual IP that can switch.
Thanks a lot
|
| Posted by JumpTech, 08-04-2008, 06:59 AM |
| Use clustering with quorums?
|
| Posted by carlo_gra, 08-04-2008, 07:02 AM |
| Have you got some howto or link where I can start to learn it? (I'm just searching on Google)
|
| Posted by JumpTech, 08-04-2008, 07:05 AM |
| I have only ever done it in a windows environment, using windows clustering services, what OS do you currently use?
see http://technet2.microsoft.com/window....mspx?mfr=true
for an overview
Last edited by JumpTech; 08-04-2008 at 07:07 AM.
Reason: link
|
| Posted by carlo_gra, 08-04-2008, 07:06 AM |
| CentOS x86_64
|
| Posted by JumpTech, 08-04-2008, 07:10 AM |
| Okay,
Might be worth taking a look at
http://www.linuxtopia.org/online_boo...nd_management/
Might be of intrest
|
| Posted by carlo_gra, 08-04-2008, 07:51 AM |
| It's good point to start, but I don't use any graphical interface.
I've read some about heartbeat but nothing that can help me about my situation...
|
| Posted by JustinSmall, 08-04-2008, 10:37 AM |
| I hope someone finds a solution, I'm very interested in reading this.
|
| Posted by carlo_gra, 08-06-2008, 03:27 AM |
| Well... I've read this tutorial and it's interesting.
But I need to have distributed cluster system: not with main node that can manage my cluster.
I've another question: I've seen that with heartbeat I can manage more than two node for a service. Have you got some example configuration? I've found some howto but all with only two nodes...
Thanks a lot...
Carlo
|
Add to Favourites 
Print this Article
Also Read
Why? (Views: 575)
