Automatic promotion of slave in MySQL master-slave replication

view full story

http://serverfault.com – In a master-slave replication environment, what is required to automatically promote the slave as the master if the master goes down. What are common practice used to change the database reference from an application if the heartbeat of the master database is not detected? Do I need a cluster to achieve this or is simple 2 machine environment sufficient? (HowTos)