… cores if needed. In previous versions, compression was only possible with streaming backups + external (usually single-threaded) compression utilities, which also had… will be part of the topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically, there are the…
Post: Living with backups
November 6, 2008 By 28 Comments
… response times, and doing backups which would gladly act as in all-you-can-eat bar. With a busy database server it…/O scheduler will be dealing with I/O request coming from a certain process. Giving the backup application low class or priority… can enjoy experimenting with ionice. It could be also possible to make a backup application that would not interfere with the system cache…
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
… a database from backup you have the option to recover changes that happend after taking a backup. The problem with this approach was that you had to do periodic filesystem level backups of the binary…/5.6/en/mysqlbinlog-backup.html ). This can be used as a foundation of our live binary log backups. The wrapper script below…
Comment: Living with backups
November 14, 2008 By 28 Comments
“Replication, backups. We all have to do it. Maciej Dobrzanski of the MySQL Performance Blog expounds on what it means to be living with backups.”
Post: xtrabackup-0.3, binaries and stream backup
March 13, 2009 By 11 Comments
We are coming with next version of xtrabackup – online backup solution for MySQL 5.0 / 5.1 and InnoDB standard … xtrabackup contains the feature which is missed in InnoDB Hot Backup – the backup can be produced as stream and copied to remote… code if you do not want to deal with bazaar and Launchpad. The project lives on Launchpad : https://launchpad.net/percona-xtrabackup…
Post: xtrabackup-0.5, bugfixes, incremental backup introduction
April 7, 2009 By 6 Comments
…: xtrabackup –incremental_lsn=1319:813219999 –backup –target-dir=/data/backup/increment_day1 and only changed pages (ones with LSN greater than given) will… code if you do not want to deal with bazaar and Launchpad. The project lives on Launchpad : https://launchpad.net/percona-xtrabackup…
Post: Verifying backup integrity with CHECK TABLES
February 1, 2012 By 4 Comments
… is “check your backups for corruption instead of your live server.” You need to do this anyway — a backup that isn’t checked… (at least periodically) that your backups are recoverable. The usual procedure goes like this: copy your backup somewhere, start a server instance…. Some people refresh their dev/staging environment every day with last night’s backup, which is a great way to make failures…
Comment: Percona XtraBackup 1.4
February 12, 2011 By 10 Comments
Does xtrabackup performs LIVE incremental backup as well? Is -no-lock option works with xtrabackup? I know that it works with innobackupex script but I am not sure if we can perform LIVE incremental backup? Please advise.
Post: Upcoming Webinar "Managing Big Data with Percona Server, XtraBackup and Tungsten"
February 2, 2011 By 3 Comments
…, XtraBackup and Tungsten”. This is joint Continuent and Percona Webinar with full description: Big data is a big problem for growing… tricks for backup, restore, and provisioning of large data sets, and how to replicate scalably and safely using Tungsten Replicator with parallel apply. Bring your big data questions to this live webcast as we tour the…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… need 5MB of undo space per second of backup. Now say my backup takes 1 hour which is 3600 second – … to be same 15K RPM RAID10 volume your data lives. It can be single SATA hard drive (and so … it “once” to migrate to the server with proper LVM configuration with no downtime as it is too fragile for …
