…_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the backup using the –export flag: innobackupex… –replicate-rewrite-db Daily backups from production to staging with different db names (i.e. orig_prod restored to orig_staging) I…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
…backup software that performs non-blocking backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can achieve the following benefits: Backups…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release is the… into backup directory during the backup stage. During the copy back stage (restore) it is copied back to data directory. After the backup is restored…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… into backup directory during the backup stage. During the copy back stage (restore) it is copied back to data directory. After the backup is restored… fixed #1172016. innobackupex wasn’t handling the innodb_data_file_path option which could cause backup to fail. Bug fixed #1169726. For…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… –session-init-query command-line option, we set the option innodb_fake_changes to prevent INSERTs, UPDATEs, and DELETEs from corrupting… server. You will need Percona Server in order to use innodb_fake_changes. Thread pool Percona Playback added a connection pool… query logs captured from our production systems. We restored a production database backup to our test database so that our test database…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…. Basically when restoring may take less time that trying to load a logical backup. Restoring your data from backup is another topic. …. Mydumper for logical backups Strong Points: Very fast for logical backups – compared to mysqldump Consistent backups between myisam and innodb tables. Global …
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… envinronment works great for MyISAM but does not work with Innodb. Backup tools like “mysqlhotcopy” does not work etc. Note Performance also… as a backup may well work for MyISAM but will start taking way too much time to do restore for Innodb. On large…) for logging. Innodb Needs Tuning As a final note about MyISAM to Innodb migration I should mention about Innodb tuning. Innodb needs tuning. Really…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
… scenario is worse because we don’t have a backup or the backup restore process doesn’t work. How can I recover deleted…) > select i.INDEX_ID, i.NAME FROM INNODB_SYS_INDEXES as i INNER JOIN INNODB_SYS_TABLES as t USING(TABLE_ID… the error log. mysql (employees) > CREATE TABLE innodb_table_monitor (id int) ENGINE=InnoDB; TABLE: name employees/salaries, id 18, flags 1…
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
… differences between MyISAM and Innodb though well it is typically easily spotted by converting tables to Innodb on restored backup. Full text search indexes… most important values to check are innodb_flush_log_at_trx_commit, innodb_buffer_pool_size and innodb_log_file_size. There are…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 12 Comments
… were all InnoDB Having a backup, customer has first attempted to restore from backup on the production master Luckily (or rather, unfortunately) backup only had… see what you get. If InnoDB Data Dictionary was not overwritten by an attempt to restore from the backup, actually second part would…
