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
