… a new server. However, given the import/export functionality of Xtrabackup combined with Percona Server (Exporting and Importing Tables), it did…) as well further polluting the buffer pool. Enter Xtrabackup… As a quick refresher, Xtrabackup works by copying the dirty tablespace files while… the same server. This will allow you to compare and restore values (potentially corrupted via user error or other issues) with…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… non-blocking backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can achieve the following benefits: Backups that complete quickly… network bandwidth Automatic backup verification Higher uptime due to faster restore time XtraBackup makes MySQL hot backups for all versions of Percona…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… can be used to create/restore a slave can be found in this blogpost. Percona XtraBackup option xtrabackup –export now supports transportable tablespaces… the incremental backup directory. Bug fixed #856400. Percona XtraBackup would leave stale xtrabackup_tmp* files in the datadir after applying incremental backups…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… can be used to create/restore a slave can be found in this blogpost. Percona XtraBackup option xtrabackup –export now supports transportable tablespaces… if xtrabackup would fail when copying logs. Fixed by terminating xtrabackup process immediately on log copying failure. Bug fixed #1170806. Percona XtraBackup would…
Post: Percona XtraBackup 2.1.0 for MySQL beta now available
April 22, 2013 By Leave a Comment
… and bug fixes in Percona XtraBackup for MySQL 2.0.6, plus the following: New Features: Percona XtraBackup has implemented basic support… support means that these versions are are recognized by XtraBackup, and that backup/restore works as long as no 5.6-specific… output. Bug fixed #1157225. Redundant code has been removed from xtrabackup.cc. Bug fixed #1162765. Other bugs fixed: bug fixed #1158154…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
… new GTID based slave (or repair a broken one) using XtraBackup. The process is pretty straightforward. 1- Take a backup from… folder there will be a file with the name xtrabackup_binlog_info: # cat xtrabackup_binlog_info mysql-bin.000002 1232 c777888a-b6df… the content on the mysql’s datadir. Follow the usual restore procedure, for example remember to change the permissions to mysql…
Post: dbqp and Xtrabackup testing
November 16, 2011 By Leave a Comment
… of xtrabackup: Basic test of backup + restore: Populate server Take a validation snapshot (mysqldump) Take the backup (via innobackupex) Clean datadir Restore from…, respectively. To run them: $./dbqp.py –suite=xtrabackup_basic –basedir=/path/to/mysql –xtrabackup-path=/mah/path –innobackupex-path=/mah/other/path…
Post: Percona Server and XtraBackup weekly news, April 4th
April 4, 2011 By 1 Comment
… restoring a dump, which can potentially speed up restores greatly. Laurynas worked on ensuring that Percona Server compiles on Windows. In XtraBackup news… code that makes xtrabackup copy the LRU dump file from Percona Server, so that after the backup is restored, the server will warm up very quickly. We merged new documentation into innobackupex, the Perl wrapper script around xtrabackup. We…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… error messages can dissapear on the shell buffer because the restore of the dump will continue. Be cautious. Same problem again… account, gtid_executed and gtid_purged are our new friends. Xtrabackup still doesn’t support it but we are working on… this post and create a one when we publish a xtrabackup version with full support of GTID.
Post: Percona XtraBackup 1.4
November 22, 2010 By 10 Comments
… option now reports xtrabackup_binlog_pos_innodb if the information exists. (Yasufumi Kinoshita) When –prepare is used to restore a partical backup… in “xtrabackup“. (Yasufumi Kinoshita) Miscellaneous important fixes related to incremental backups. Release Notes for this and previous releases of Percona Xtrabackup can…
