Recovery from a MySQL dump is too long !
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,
Re: Recovery from a MySQL dump is too long !
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
Re: gmane
On Mon, Aug 13, 2012 at 8:25 PM, Thufir hawat.thu...@gmail.com wrote: Looking at: Group gmane.comp.db.mysql.general Description The main list for general MySQL discussion Address mysql@... Status posting allowed http://dir.gmane.org/gmane.comp.db.mysql.general It would really be nice if posting were actually allowed, but apparently this is not the case and the list is read-only on gmane. Would it be possible to change that? Posting is allowed --- directly to the list, as you just did. You're hoping to change it to be able to post from Gmane to the list? -- /Daniel P. Brown Network Infrastructure Manager http://www.php.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql