MySQL High Availability FreeBSD Cluster

[businessgeeks]

Hi,

My boss has asked me to build a High Availability FreeBSD MySQL cluster so Im trying to research on guides or howtos to do it in FreeBSD 7.0. I've been reading that I need to use heartbeat to achieve high availablity. is this enough?

How will i able to keep the database information between each node sync?

Any helpful hints or links would be great.

Thanks in Advance..

[falko]

Hi,

My boss has asked me to build a High Availability FreeBSD MySQL cluster so Im trying to research on guides or howtos to do it in FreeBSD 7.0. I've been reading that I need to use heartbeat to achieve high availablity. is this enough?You can use heartbeat or keepalived for it. There are a few tutorials about this in http://www.howtoforge.com/howtos/high-availability (but not for FreeBSD).

How will i able to keep the database information between each node sync?
You can do this with MySQL-Master-Master-Replication: http://www.howtoforge.com/mysql5_master_master_replication_debian_etch