There’s an interesting article over at ONLamp which covers
Advanced MySQL Replication, covering how to go beyond master-master replication to create a circular cluster of MySQL servers. It includes details on how you can use MySQL 5.1 features to manage automatic failover to remove any failed node from the cluster.