MySQL HA

We’re currently in the process of splitting our websites out onto pairs of servers for High Availability, unfortunately MySQL is pretty poor when it comes to this, its replication facilities leave a lot to be desired and often fall out of sync. But there is a collection of scripts called Maatkit which can help fix this.  Here’s a good tutorial http://blogama.org/node/39