An attendee to Espen’s recent webinar asked how to check tables for corruption. This kind of ties into my recent post on InnoDB’s handling of corrupted pages, because the best way to check for corruption is with CHECK TABLES, but if a page is corrupt, InnoDB will crash the server to prevent access to the [...] [...more]
Sometimes we need to restore only some tables from a full backup maybe because your data loss affect a small number of your tables. In this particular scenario is faster to recover single tables than a full backup. This is easy with MyISAM but if your tables are InnoDB the process is a little bit [...] [...more]
Package: RoboTamer Backup Summary: Backup files using rsync Groups: Files and Folders, PHP 5, Systems administration, Unix Author: Dennis Kaplan Description: This class can backup files using rsync… Read more at http://www.phpclasses.org/package/7264-PHP-Backup-files-using-rsync.html View full post on PHP Classes: Latest entries [...more]
With this revision, My xtrabackup branch has been merged into trunk. What does this mean? It means that we now get a drizzlebackup.innobase binary which is the xtrabackup port for Drizzle. Exciting times. View full post on Planet Drizzle [...more]
For backups, historically in the MySQL world you’ve had mysqldump (a SQL dump, means on restore you have to rebuild indexes), InnoDB Hot Backup (proprietary, but takes a copy of the InnoDB data files, so restore is much quicker), LVM snapshots (various scripts exist, does have larger IO impact, requires LVM) and more recently xtrabackup. [...] [...more]
