A series of blog entries from the MySQL Performance Blog on keeping MySQL available in an Amazon EC2 Cloud
Link: High availability MySQL on Amazon EC2