On Thu, 31 Mar 2005 [EMAIL PROTECTED] wrote: > > We have one master and one slave database and use the slave for reads. > If for some reason our master goes down, > we would like to make our slave the master and use it for both writes > and reads and then switch to the original configuration > when the master is up, which includes updating the master copy. Limited > downtime/locking of the second database is OK. > > > Is this something that is easy to do or recommended? If so, what steps > we need to go through or where can I find isome nformation regarding > this? If not, what other approachs are there (assuming we only have two > machines w/ above configuration).
Hi, it's not easy, but if you take great precaution and have a thorough understanding of replication you will be able to pull it off. Have you considered a master <-> master (dual master) replication setup? It's covered in the High Performance MySQL book by Derek Balling and Jeremy Zawodny: http://dev.mysql.com/books/hpmysql-excerpts/ch07.html However, be very careful if you have any AUTO_INCREMENT fields. Good luck! :) Atle - Flying Crocodile Inc, Unix Systems Administrator -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]