… world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. With Percona… benefits: Backups that complete quickly and reliably Uninterrupted transaction processing during backups Savings on disk space and network bandwidth Automatic backup verification Higher…
Comment: What Are Full, Incremental, and Differential Backups?
May 22, 2013 By 9 Comments
… of data usage with each of the types of backup e.g. A backup done once per week using full on the…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… each flight (Q1.1 for example) is tested with a cold buffer pool. Then the query is tested again without restarting the database. The first test is described as the cold test, and the second as the hot test. The database… already. The buffer pool and adaptive hash index are cold for the cold test. All tests were done with no concurrency. The…
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
… it is worth reiterating the point made by AFTAB, crash recovery is far cheaper in modern versions of InnoDB: https://blogs.oracle.com/mysqlinnodb/entry/innodb_recovery_is_now_faster And from the manual: http://dev.mysql…/en/innodb-performance-recovery.html “If you kept the size of your redo log files artificially low because recovery took a long…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… structure from .frm files or take it from some old backup. A new tool sys_parser can recover the table structure… to have an accurate table definition to ensure a successful recovery. Even an unnoticeable difference like NULL or NOT NULL can…. 0. Download the latest revision of the recovery tool bzr branch lp:percona-data-recovery-tool-for-innodb 1. Compile the dictionary…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… captured from our production systems. We restored a production database backup to our test database so that our test database was… into chunks, each containing roughly 1M queries. We warmed the cold database with the first chunk and replayed the second chunk…
Post: Why use encrypted backup with Percona XtraBackup 2.1 for MySQL?
April 10, 2013 By 2 Comments
… MySQL and with it we included the ability to encrypt backups on the fly (full documentation here). This feature is different than simply piping the backup stream through the openssl or gpg binaries, which is what… are using cloud storage to store your backups but also applies to simple off-site backups. Percona XtraBackup 2.1.0-alpha1…
Post: Percona XtraBackup 2.1.2 for MySQL available for download
May 18, 2013 By 4 Comments
… the server could cause server to close the connection while backup is being taken. Fixed by setting the bigger value for…
Comment: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 16, 2013 By 10 Comments
… cluster has 3 nodes, and is up and running (all tip top according to wsrep status indicators). It did the SST…
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…/decrypt both local and streamed backups in order to add another layer of protection to the backups. innobackupex now uses Perl’s…
