[Linux-HA] mysql replication question

[Achim Stumpf]

Sebastian Vieira schrieb:
> Now, i can replicate mysql data with DRBD, but mysql also has a built-in
> mechanism. Also i've heard talk about MySQL Proxy, but i'm not sure if i
> need an extra machine for this (i only have the 2 nodes). My question is
> what is the best approach?

I am using active/passive with mysql on the drbd device. You could do even a setup with mysql in Master/Slave mode, and I think I have read somewhere that you could let Heartbeat manage this kind of setup, but my preferred way is it not.

> 
> Unfortunately i'm stuck with heartbeat 2.0.8. Yes, i know there are later
> versions available ... but not for sles10  *sigh*
> 

Maybe this link helps you:

http://download.opensuse.org/repositories/server:/ha-clustering/SLES_10/i586/


Achim