… MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can achieve the following benefits: Backups… during backups Savings on disk space and network bandwidth Automatic backup verification Higher uptime due to faster restore time XtraBackup makes MySQL hot backups…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
… systems, many people are using a single server with some backups configured, and then simply take the downtime when a restore… needed. As the application evolves, additional requirements will appear like hot backups, online schema changes, replication based high availability (which has some…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release…. 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…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… conference never left California again afterward. Partnership with SAP was hot at this event and MaxDB database looked like it had… “open core” plans are announced for MySQL Server – the online backup in MySQL 6.0, it’s to ship in commercial… GA version of Percona Xtrabackup – open source alternative to Innodb Hot backup. MySQL 5.1.46 is GA and MySQL 5.5…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… developed a solution to keep the standby server’s caches hot. (See my Fosdem 2013 slides for information about discarded designs… captured from our production systems. We restored a production database backup to our test database so that our test database was…
Post: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
February 24, 2009 By 20 Comments
… results forcing us to look at more performing alternatives. Innodb Hot Backup is a good working solution but it is not Open… to develop Percona Xtrabackup tool, which will use same backup approach as InnoDB Hot Backup, that is taking online copy of InnoDB table… looking to implement advanced functionality like incremental backup (copy only changes from last backup),table-level backup (copy only specified tables), streaming and…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… based MySQL backups are great ? There are number of reasons: Almost Hot backup In most cases you can perform this type of backup while… later. Free No extra commercial tools as Innodb Hot Backup are required to perform backup. Are there any downsides ? Need to have snapshot… mentioned this solution is often hot backup, but bad thing it is hard to estimate when it is hot and when it is…
Post: xtrabackup-0.3, binaries and stream backup
March 13, 2009 By 11 Comments
… work as drop-in replacement of innodbackup tool and InnoDB Hot Backup online backup. 2) Do we need to run patched MySQL, because… of xtrabackup contains the feature which is missed in InnoDB Hot Backup – the backup can be produced as stream and copied to remote… run it as innobackupex –stream=tar ./ | ssh user@host cat “>” backup.tar and get copy on remote box. Also new features…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… backup impact on server performance may well be). We also assume backup is done on physical level here (cold backup, slave backup, innodb hot backup or snapshot backup) as this is only…
Post: Thoughs on Innodb Incremental Backups
November 10, 2008 By 8 Comments
… normal Innodb “hot” backups we use LVM or other snapshot based technologies with pretty good success. However having incremental backups remain the problem. First why do you need incremental backups at all ? Why not just take the full backups daily…
