All, I have a situation whereby I have two servers each running mysql in a Master slave replicated setup. Currently if the master server goes down we have to manually failover the database servers, taking a snaphost etc.. Is this still the optimal way to do this, or has the 'Change Master' command, and various other things superceded this method now, and thus is there a better and more automated way to do db failover?
Regards Marty p.s. If this is better implemented in Version 4, I would be happy to receive advice on this, as it would form ammunition to push for an upgrade. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.516 / Virus Database: 313 - Release Date: 01/09/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
