EmergencyEMERGENCY? Get 24/7 Help Now!

Webinar Wednesday, September 6, 2017: Percona Roadmap and Software News Update – Q3 2017

 | September 5, 2017 |  Posted In: MongoDB, MySQL, Percona Live, Percona Monitoring and Management, Technical Webinars

Percona Roadmap

Come and listen to Percona CEO Peter Zaitsev on Wednesday, September 6, 2017 at 10am PT / 1pm ET (UTC-7) discuss the Percona roadmap, as well as what’s new in Percona open source software. Reserve Your Spot   During this webinar Peter will talk about newly released features in Percona software, show a few quick demos and […]

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

Percona XtraBackup 2.4.8 is Now Available

 | July 24, 2017 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraBackup

Percona XtraBackup

Percona announces the GA release of Percona XtraBackup 2.4.8 on July 24, 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

Percona XtraBackup 2.3.9 is Now Available

 | July 24, 2017 |  Posted In: Events and Announcements, MyRocks, Percona Software, Percona XtraBackup

Percona XtraBackup

Percona announces the release of Percona XtraBackup 2.3.9 on July 24, 2017. Downloads are available from our download site or Percona Software 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 as an open […]

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

Percona Software and Roadmap Update with CEO Peter Zaitsev: Q2 2017

 | May 24, 2017 |  Posted In: Backups, Benchmarks, MariaDB, MongoDB, MySQL, Percona XtraBackup, Percona XtraDB Cluster, PMM, Technical Webinars

Percona Software and Services

This blog post is a summary of the Percona Software and Roadmap Update – Q2 2017 webinar given by Peter Zaitsev on May 4, 2017. This webinar reflects changes and updates since the last update (Q1 2017). A full recording of this webinar, along with the presentation slide deck, can be found here. Percona Software Below are the […]

Read More

How to Restore a Single InnoDB Table from a Full Backup After Accidentally Dropping It

 | March 15, 2017 |  Posted In: InnoDB, Insight for DBAs, Percona XtraBackup, Quality Assurance

InnoDB

In this blog post, we’ll look at how to restore a single InnoDB table from a full backup after dropping the table. You can also see an earlier blog post about restoring a single table from a full backup here: How to recover a single InnoDB table from a full backup. The idea behind the actions […]

Read More

CVE-2016-6225: Percona Xtrabackup Encryption IV Not Being Set Properly

and  | January 12, 2017 |  Posted In: MySQL, Security

Percona XtraBackup 2.4.7-2

If you are using Percona XtraBackup with xbcrypt to create encrypted backups, and are using versions older than 2.3.6 or 2.4.5, we advise that you upgrade Percona XtraBackup. Note: this does not affect encryption of encrypted InnoDB tables. CVE-2016-6225 Percona XtraBackup versions older than 2.3.6 or 2.4.5 suffered an issue of not properly setting the Initialization Vector (IV) for […]

Read More

Using Percona XtraBackup on a MySQL Instance with a Large Number of Tables

 | December 28, 2016 |  Posted In: Insight for DBAs, MySQL, Percona XtraBackup

Percona XtraBackup 2.4.7-2

In this blog post, we’ll find out how to use Percona XtraBackup on a MySQL instance with a large number of tables. As of Percona Xtrabackup 2.4.5, you are required to have enough open files to open every single InnoDB tablespace in the instance you’re trying to back up. So if you’re running innodb_file_per_table=1, and […]

Read More