List:Replication« Previous MessageNext Message »
From:Marcus Bointon Date:January 19 2012 12:02pm
Subject:Re: Slow Slave Replication Catchup
View as plain text  
On 19 Jan 2012, at 09:49, Richard Bensley wrote:

> Not only are they great backup tools, I also use xtrabackup to quickly
> duplicate slaves.

Absolutely - I'd even go as far as saying that xtrabackup should be the first choice for
setting up new slaves as it makes it so ridiculously easy.

Because xtrabackup doesn't block at all, you don't have to stop your slave, so you won't
accumulate lag. The other big thing about xtrabackup is that its backups can be quite
slow, but its restores are really fast (only slightly longer than copying the files).
mysqldump is usually the reverse, which is not what you want when you're in a mad panic
trying to restore a backup!

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



Thread
Slow Slave Replication CatchupSimon18 Jan
  • Re: Slow Slave Replication CatchupMarcus Bointon18 Jan
  • RE: Slow Slave Replication CatchupAndrew Morgan19 Jan
    • RE: Slow Slave Replication CatchupRichard Bensley19 Jan
      • Re: Slow Slave Replication CatchupMarcus Bointon19 Jan
    • RE: Slow Slave Replication CatchupDavid Lerer19 Jan
  • Re: Slow Slave Replication CatchupDimitre Radoulov19 Jan
    • Re: Slow Slave Replication Catchupmartín arrieta19 Jan
      • Re: Slow Slave Replication CatchupDimitre Radoulov19 Jan
        • Re: Slow Slave Replication Catchupmartín arrieta19 Jan
  • Re: Slow Slave Replication CatchupDimitre Radoulov19 Jan
Re: Slow Slave Replication CatchupSimon19 Jan
  • Re: Slow Slave Replication CatchupMarcus Bointon20 Jan