Re: MySQL replication delaying issue

[Marcus Bointon]

On 26 Feb 2008, at 18:07, Jed Reynolds wrote:

> The only drawback to I find to having just two masters is the  
> situation where one master gets disabled for a prolonged time and I  
> need to take a snapshot from the other master, then I have a few  
> seconds of downtime on the remaining master.


If you use all InnoDB, you can do:

mysqldump --single-transaction --master-data --opt <mydb> > dump.sql

This does a transactional dump (so no need to lock tables), and  
includes the necessary 'SET MASTER' log and position commands for easy  
importing on the slave - and no downtime required!

Marcus
-- 
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK resellers of info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/



Attachment: [application/pkcs7-signature] smime.p7s