Am 14.08.2012 09:42, schrieb Bob Sauvage: > 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.
i do the stop slave and rsync data-dir since many years over WAN connections for offsite backups, never was a friend of dumping databases to textfiles if something is damaged due a power-interruption this is also the fastest restore because rsync is much faster even with --checksums as any dump
signature.asc
Description: OpenPGP digital signature