… make a mistake and need to compare their old data to their current data on the current live server. Mysqldump works well…. The –apply-logs phase simply utilizes the built in crash recovery and applies the redo-logs to the dirty tablespace and… place. Fortunately, this can be done easily using mysqldump –no-data. Now, enough with the theory, here is the procedure I…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… customer and I am involved with servers located in two data centers, one with Solaris servers and the other one with… more zealous. Pretty interesting to speed up point in time recovery when you dataset is 700GB. If you google a bit… well. The tpcc database, which contains a lot of random data that doesn’t compress well showed a compression ration of…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… useful if you’re trying to limit the amount of data sent over the wire, but it comes at the cost… are no longer complete or useful for point-in-time recovery. Generally if you’re considering the binary log filtering approach… on the intermediate server, thus resulting in less binary log data being sent down to the lower-level slaves. You can…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
To recover a dropped or corrupt table with Percona Data Recovery Tool for InnoDB you need two things: media with records(… to have an accurate table definition to ensure a successful recovery. Even an unnoticeable difference like NULL or NOT NULL can…. 0. Download the latest revision of the recovery tool bzr branch lp:percona-data-recovery-tool-for-innodb 1. Compile the dictionary parsers…
Comment: How to recover table structure from InnoDB dictionary
May 8, 2013 By 4 Comments
… do it http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:start . The biggest challenge here is to find index… for each table – http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:advanced_techniques#recovering_the_data_dictionary
Post: Data Recovery Toolkit for InnoDB Version 0.1 Released
November 26, 2007 By 6 Comments
… InnoDB data recovery to provide our customers effective data recovery services and one of major parts of these strategies is our toolkit for InnoDB data recovery… and more links to information resources related to InnoDB data structures and recovery procedures. The commercial Innodb Data Recovery services are available from Percona
Post: Upcoming webinar on Data Recovery for MySQL
April 6, 2011 By 5 Comments
… of April on data recovery for MySQL. Almost every long serving DBA has been faced with the task of recovering data from a… recovery (prerequisites) * Preparing your data * Identifying the structure and state of tables * Retrieving data * Restoring from recovered data During this Webinar the Percona-InnoDB-Recovery…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… which is best done in binary mode for large data sets. Such global recovery can also put very high stress on your… slave if you use one) in each data center you have. The complexity of recovery is another “liability” of compex replication tree… people have their data recovery practices ironed out so they can answer how they would handle at least these 3 data loss cases…
Post: Recovery after DROP & CREATE
August 22, 2012 By 1 Comment
… -4Df pages-1345219305/FIL_PAGE_INDEX/0-1 LOAD DATA INFILE ‘/root/src/recovery-tool/s_tools/dumps/default/SYS_INDEXES’ REPLACE… -4Df pages-1345220873/FIL_PAGE_INDEX/0-1 LOAD DATA INFILE ‘/root/src/recovery-tool/s_tools/dumps/default/SYS_TABLES’ REPLACE… 8 bytes is index_id. In revision 69 of Percona Data Recovery Tool for InnoDB two tools are added: s_tables and…
Post: Recovery after DROP [ TABLE | DATABASE ]
July 19, 2009 By 4 Comments
In your recovery practice we often face the problem when data lost by execution DROP TABLE or DROP DATABASE statement. In this case even our InnoDB Data Recovery tool can…
