EmergencyEMERGENCY? Get 24/7 Help Now!

How to Restore MySQL Logical Backup at Maximum Speed

 | February 22, 2018 |  Posted In: Backups, Database Monitoring, Hardware and Storage, InnoDB, Insight for DBAs, MySQL

Restore MySQL Logical Backup

The ability to restore MySQL logical backups is a significant part of disaster recovery procedures. It’s a last line of defense. Even if you lost all data from a production server, physical backups (data files snapshot created with an offline copy or with Percona XtraBackup) could show the same internal database structure corruption as in […]

Read More

autoxtrabackup v1.5.0: A Tool for Automatic Backups

 | November 27, 2017 |  Posted In: Backups, Percona XtraBackup, Quality Assurance

autoxtrabackup

There is a new version of the autoxtrabackup tool. In this post, I’ll provide some of the highlights available this time around. autoxtrabackup is a tool created by PerconLabs. We’ve now put out the 1.5.0 version, and you can test it further. Note: PerconaLabs and Percona-QA are open source GitHub repositories for unofficial scripts and […]

Read More

MySQL Point in Time Recovery the Right Way

 | October 23, 2017 |  Posted In: Backups, GTID, MySQL, Replication

MySQL Point In Time Recovery

In this blog, I’ll look at how to do MySQL point in time recovery (PITR) correctly. Sometimes we need to restore from a backup, and then replay the transactions that happened after the backup was taken. This is a common procedure in most disaster recovery plans, when for example you accidentally drop a table/database or run […]

Read More

Upcoming Webinar Wednesday August 16: Lock, Stock and Backup – Data Guaranteed

 | August 15, 2017 |  Posted In: Backups, MySQL, Technical Webinars

Backup

Join Percona’s, Technical Services Manager, Jervin Real as he presents Lock, Stock and Backup: Data Guaranteed on Wednesday, August 16, 2017 at 7:00 am PDT / 10:00 am EDT (UTC-7). Reserve Your Spot Backups are crucial in a world where data is digital and uptime is revenue. Environments are no longer bound to traditional data […]

Read More

Avoiding the “An optimized (without redo logging) DDL operation has been performed” Error with Percona XtraBackup

 | August 8, 2017 |  Posted In: Backups, MySQL, Percona XtraBackup

Percona XtraBackup

This blog discusses newly added options for Percona XtraBackup 2.4.8 and how they can impact your database backups. To avoid issues with MySQL 5.7 skipping the redo log for DDL, Percona XtraBackup has implemented three new options ( xtrabackup --lock-ddl, xtrabackup --lock-ddl-timeout, xtrabackup --lock-ddl-per-table) that can be used to place MDL locks on tables while they are copied. So […]

Read More

Backups and Disaster Recovery

 | July 18, 2017 |  Posted In: Backups, Business Continuity, MySQL, MySQL 101, Percona Backup Service, Percona XtraBackup

Backups and Disaster Recovery

In this post, we’ll look at strategies for backups and disaster recovery. Note: I am giving a talk on Backups and Disaster Recovery Best Practices on July 27th. Register Now When discussing disaster recovery, it’s important to take your business’ continuity plan into consideration. Backup and recovery processes are a critical part of any application […]

Read More