Here’s a good link from or friend Paul Moen on how to promote a slave to a master.
http://www.pythian.com/blogs/300/mysql-recipes-promoting-a-slave-to-master-or-changing-masters
The basic idea hear, is to simply tell the slave to no longer pay attention to the master… and things should work as is.
Kind of obvious really.
