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..
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). You can do this with MySQL-Master-Master-Replication: http://www.howtoforge.com/mysql5_master_master_replication_debian_etch
