[Linux-HA] mysql replication question

[Sebastian Vieira]

Hi,

I have a heartbeat cluster in which I'm planning to set up MySQL
replication. The cluster is an active-passive setup in v1 style (since i
don't understand v2) with the following resources configured: IPaddr, apache
and DRBD.

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?

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

kind regards,

Sebastian