… feature is similar to the Dump/Restore of the Buffer Pool in Percona Server. MySQL 5.6 buffer pool dump is copied into backup directory during the backup stage. During the copy back stage (restore) it… fail. Bug fixed #1169726. For the Debian and the Linux binaries, the –version message which should include the revision was showing…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… feature is similar to the Dump/Restore of the Buffer Pool in Percona Server. MySQL 5.6 buffer pool dump is copied into backup directory during the backup stage. During the copy back stage (restore) it… fail. Bug fixed #1169726. For the Debian and the Linux binaries, the –version message which should include the revision was showing…
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
… gives you the possibility for point in time recovery. After restoring a database from backup you have the option to recover…. Recently in MySQL 5.6, mysqlbinlog got a new feature addition that supports connecting to remote MySQL instances and dumping binary log data to local disks ( http://dev.mysql.com/doc/refman/5.6…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… DBA? We have these major components: Percona XtraBackup for MySQL for binary backups mydumper for logical backups mysqlbinlog 5.6 Amazon S3… MySQL for binary backups. Strong Points: It can restore an entire server very fast. Often the limiter of how fast this can be restored… table is dumped to a separate file. This is very important to make restoring single tables easy. You can quickly restore a single…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
…there are many documents about that: http://dev.mysql.com/doc/refman/5.6/en/replication-… error 1236 from master when reading data from binary log: ‘The slave is connecting using CHANGE MASTER…dissapear on the shell buffer because the restore of the dump will continue. Be cautious. Same problem again…
Post: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released
March 20, 2013 By 2 Comments
… recognized by XtraBackup, and that backup/restore works as long as no 5… tablespace, 5.6-style buffer pool dump files). Bugs Fixed: Individual InnoDB tablespaces…binary resulting in the server’s tmpdir always being used for temporary files. Bug fixed #1085099 (Alexey Kopytov). XtraBackup for MySQL…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… Percona Software Repositories). Based on MySQL 5.5.16, including all…restore (in 5.1 it is –innodb-blocking-lru-restore), which is OFF by default. When set to ON, restoring from the LRU dump…please see the following links: Downloads: Binary distributions, Percona Software Repositories Installation …
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
…-lru-restore, which is OFF by default. When set to ON, restoring from the LRU dump file…. #851674 (Alexey Kopytov). Backported fix for MySQL bug #53761 (Wrong estimate for RANGE…, please see the following links: Downloads: Binary distributions, Percona Software Repositories Installation instructions …
Post: Percona Server 5.5.13-20.4 Stable Release
July 1, 2011 By 3 Comments
… Percona Software Repositories). Based on MySQL 5.5.13, Percona Server …. Instead, we recommend using the LRU Dump/Restore patch which provides similar improvements in…, please see the following links: Downloads: Binary distributions, Percona Software Repositories Installation instructions Consulting…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… fixes. New features include: Backup and restore of LRU dump. For servers that support dump and restore of the XtraDB buffer pool (LRU), namely… once. tar4ibd functionality is replaced by functionality in the xtrabackup binary itself. The xbstream utility is added This utility has a…
