…_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the backup using the –export flag: innobackupex…[.]“ (i.e. functional partitioning) Combine with –replicate-rewrite-db Daily backups from production to staging with different db names (i.e…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… instances each of production database servers and will perform the backups. The write load is not excessive so a single server… many scripts ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the snapshot while… on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance with ZFS the…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can achieve the following benefits: Backups that complete quickly and reliably Uninterrupted transaction processing during backups Savings on disk space and network bandwidth Automatic backup verification Higher…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
….] The other two NIC ports should be bonded with active-backup or LACP (depending on your switching infrastructure). In essence, you… –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap just hung…
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
We’ve been using ZFS on FreeBSD for backup and production for a few years now. Performance was a … write buffering, so make sure these are turned off in InnoDB.
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… in an InnoDB page. Normally we either recover the structure from .frm files or take it from some old backup. A new tool sys_parser can recover the table structure from InnoDB dictionary. Why do we… over taken from backups. But in some cases even .frm files is not an option: Table was dropped and innodb_file_per…
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… a full backup and an incremental one were present in the full backup directory, and were not removed when incremental backups has been… fixed #1169509. innobackupex wasn’t handling the innodb_data_file_path option which could cause backup to fail. Bug fixed #1169726. For…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…. MySQL 5.6 buffer pool dump is copied into backup directory during the backup stage. During the copy back stage (restore) it… a full backup and an incremental one were present in the full backup directory, and were not removed when incremental backups has been… fixed #1172016. innobackupex wasn’t handling the innodb_data_file_path option which could cause backup to fail. Bug fixed #1169726. For…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… an open source solution, XtraBackup drives down backup costs while providing unique features for MySQL backup. The new 2.1.1 GA… XtraBackup now has support for Compact Backups. This feature can be used for taking the backups that will take less amount of… spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1 builtin has been removed from Percona XtraBackup…
Post: Percona XtraBackup 2.1.0 for MySQL alpha now available
April 2, 2013 By Leave a Comment
… MySQL now has support for Compact Backups. This feature can be used for taking the backups that will take less amount of…/decrypt both local and streamed backups in order to add another layer of protection to the backups. innobackupex now uses Perl’s… spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1-builtin has been removed from Percona XtraBackup…
