EmergencyEMERGENCY? Get 24/7 Help Now!

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

Percona XtraBackup 2.4.7-2 is Now Available

 | May 30, 2017 |  Posted In: Backups, MySQL, Percona XtraBackup

Percona XtraBackup

Percona announces the GA release of Percona XtraBackup 2.4.7-2 on May 29, 2017. You can download it from our download site and apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free […]

Read More

Webinar May 31, 2017: Online MySQL Backups with Percona XtraBackup

 | May 30, 2017 |  Posted In: Backups, MySQL, Percona XtraBackup, Technical Webinars

Percona XtraBackup

Please join Percona’s solution engineer, Dimitri Vanoverbeke as he presents Online MySQL Backups with Percona XtraBackup on Wednesday, May 31, 2017 at 7:00 am PDT / 10:00 am EDT (UTC-7). Register Now Percona XtraBackup is a free, open source, complete online backup solution for all versions of Percona Server, MySQL® and MariaDB®. Percona XtraBackup provides: Fast […]

Read More