List:Backup« Previous MessageNext Message »
From:Emre Hasegeli Date:September 2 2012 11:39am
Subject:Re: Recovery from a MySQL dump is too long !
View as plain text  
 On Sat, 1 Sep 2012 21:15:15 +0200, Manuel Arostegui wrote:
> Hello *,
>
> My INNODB database has a size of 80GO. I've a replication setup on 3
> slaves and I backup my db from them.
> If a problem occurs on the database, a recovery from a dump takes
> around 6H ! That's too long for us.
>
> 2 ideas :
> 1. Stop the slave and rsync the folder /var/lib/mysql to another 
> server
> 2. Stop the slave, take a dump and when it's finish, pull the dump in
> another MySQL instance daily.
>
> Do you have another ideas ? What's your advices ?

 I dump and restore the tables in parallel. My simple scripts are on the 
 GitHub [1].

 [1] http://github.com/tart/SimpleMySQLParallelDumpRestore

Thread
Re: Recovery from a MySQL dump is too long !Manuel Arostegui1 Sep
  • Re: Recovery from a MySQL dump is too long !Emre Hasegeli2 Sep