… the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release… now avoids loading non-relevant tablespaces when partial backup is being taken which speeds up the backup process. Bug fixed #1130145. Percona XtraBackup…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… Buffer Pool in Percona Server. MySQL 5.6 buffer pool dump is copied into backup directory during the backup stage. During the copy… GTID value in the xtrabackup_binlog_info when doing the backup of MySQL and Percona Server 5.6 with the GTID mode… tablespaces when partial backup is being taken which speeds up the backup process. Bug fixed #1130145. Due to different implementation in MySQL 5.6…
Post: Upcoming webinar on Percona XtraBackup
May 9, 2011 By 7 Comments
… backups much easier and faster with Percona XtraBackup utility. We will discuss: * XtraBackup operational principles * Sample usage scenarios * Full backups * Incremental and partial backups * Importing and exporting individual tables * Streaming and parallel backups * Limitations and common issues. You…
Post: Percona Server and XtraBackup weekly news, March 5th
March 6, 2011 By Leave a Comment
… Squeeze in our repositories on the next release based on MySQL 5.1.55, which we estimate will be released on… decided to make innobackupex always back up the MySQL system database, even for partial backups; it contains data that is necessary to restore…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
…’m not a big fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication… to perform mapping between master positions which you get with backup to distribution slave position. You can also clone other slaves… you can see no matter which road you take with partial MySQL Replication there are things to be careful with, so if…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… XtraBackup for MySQL for binary backups mydumper for logical backups mysqlbinlog 5.6 Amazon S3 monitoring for all the above Philosophy on backups It… Re-transfer files that are partially transferred Compress the files after successful transfer Amazon S3 for MySQL I discuss S3 here but…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
…. Partially written .frm files or .frm being unsync with internal Innodb dictionary may cause MySQL to fail with wierd error messages. In MySQL… other problems which you may experience related to MySQL Crash Recovery – Restoring data from backup, corrupted Innodb tablespace recovery etc but I…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…. MySQL also has broken group commit (which we have partial fix for) meaning concurrent transaction commits will need to be serialized. Second, MySQL… MySQL replication is a showstopper) and it also solves the other big pain of semi-online MySQL/OS upgrades and Schema changes. Backups…
Post: Announcing Percona XtraBackup 2.0.1
June 25, 2012 By 1 Comment
…, so that a full backup could be used for incremental backups without decompression. Bug fixed #977652 (Alexey Kopytov). Streaming backups with –stream=tar… with the “log block checksum mismatch” error when reading the partially written log block. Bug fixed #1015416 (Alexey Kopytov). Release notes…
Post: Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
… tracking. This feature will be used for implementing faster incremental backups that use this information to avoid full data scans. New… unbootable server. Bug fixed #999147 (Laurynas Biveinis). Fixed the upstream MySQL bug #66301. Concurrent INSERT … ON DUPLICATE KEY UPDATE statements on… end up with a partially written dump file in case of a crash, or when making a backup copy of it. Safer…
