From: Bob Sauvage
Date: August 14 2012 7:42am
Subject: Recovery from a MySQL dump is too long !
List-Archive: http://lists.mysql.com/backup/153
Message-Id: <20120814074207.97000@gmx.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="========GMXBoundary97001344930127694201"

--========GMXBoundary97001344930127694201
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 8bit

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 ?

 Thanks in advance,

--========GMXBoundary97001344930127694201--