… XtraBackup: Hot Backups and More and Recovery of Lost or Corrupted InnoDB Tables. WebConf is the first big conference of its kind in…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… number of Innodb tables you have, as well as many other operations, so beware. Binary log corruption – Binary log may become corrupted and out… care of this synchronization. .frm Corruption – Few people know MySQL is not really ACID even with Innodb tables, at least not for DDL… experience related to MySQL Crash Recovery – Restoring data from backup, corrupted Innodb tablespace recovery etc but I should write about them some…
Post: Magic Innodb Recovery self healing
May 22, 2007 By 2 Comments
… the table corrupting with Innodb, as it is limited to only one particular index on one particular table type it is likely to be Innodb… to now dump potentially corrupted tables (in this particular corruption instance Innodb did not print table name in question), drop tables, restart Innodb without innodb_force_recovery and…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… to be removed or overwritten A table (or entire schema) was dropped accidentally Your InnoDB table was corrupt and mysql shuts down Your server… to mysqldump Consistent backups between myisam and innodb tables. Global read lock only held until myisam tables are dumped. We are researching into…
Post: Small things are better
October 8, 2006 By 15 Comments
… with Innodb tables. They are designed to never crash, surviving power failures and even partial page writes but still they can get corrupted…, misconfiguration or failures. Sometimes corruption kind be mild, so ALTER TABLE to rebuild the table fixes it. Sometimes table needs to be dropped and… add extra column to 500GB Innodb table. It will probably take long hours or even days for ALTER TABLE to complete and about…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… careful such as using sync-binlog innodb_flush_logs_at_trx_commit=1 and only using Innodb tables to be OK in most cases. There are still some edge cases such as modifying meta data stored in MyISAM tables… or disk failure. Though it also can be things like Innodb corruption or soft crash which you can’t recover promptly enough…
Post: How Percona Server handles data corruption more gracefully
January 6, 2012 By 2 Comments
… from Oracle, if any page of data in InnoDB is found to be corrupt, the entire instance will crash forcefully. This is… to continue running, so the corruption in one database does not affect the others. Percona Server handles corruption more gracefully, if you enable it, by simply marking the single table as corrupt, and not crashing the…
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
… is heavily corrupted and innodb_force_recovery doesn’t help Chris Calender suggests two methods. The first is create/drop the table many… an InnoDB dictionary. It consists of several internal tables. For our topic only SYS_TABLES and SYS_INDEXES are relevant. These are usual InnoDB tables…
Post: xtrabackup-0.8
July 1, 2009 By 8 Comments
… “Impossible – possible, moving InnoDB tables between servers”for details) tar4ibd is made to be sure that read of InnoDB page is consistent. Before we had some complains what in stream mode some pages are getting corrupted, and we… To extend tablespace size, if needed after –prepare Data page corruption check is added to local backup mode innobackupex can pass…
Post: Innodb crash recovery update
May 22, 2007 By 3 Comments
… serious Innodb corruptions for a while, typically even if it happened it was some simple table related corruption which was easy to fix on table… worry. If it is global bug it should have been Innodb recovery show stopper while it goes back so many releases…
