by Marcelo Altmann | May 9, 2022 | MySQL, Percona Software
Earlier last week, Oracle released their Q2 releases series. Unlike previous releases, backward compatibility has now been broken with previous versions of MySQL. MySQL 8.0.29 extended the support for the online DDL algorithm INSTANT. Prior to 8.0.29 only adding...
by Manish Chawla | Mar 10, 2022 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
KMIP (Key Management Interoperability Protocol) is an open standard developed by OASIS (Organization for Advancement of Structured Information Standards) for the encryption of stored data and cryptographic key management. Percona Server for MySQL 8.0.27 and Percona...
by Vinicius Grippa | Feb 28, 2022 | Insight for DBAs, MySQL, Percona Software
A little bit ago, I released a blog post comparing the backup performance of different MySQL tools such as mysqldump, the MySQL Shell feature called Instance Dump, mysqlpump, mydumper, and Percona XtraBackup. You can find the first analysis here: Backup Performance...
by Marcelo Altmann | Jan 20, 2022 | MySQL, Percona Software
Backups are a key part of a disaster recovery strategy, making sure you can continue or restore your business in case of an unwanted event with your data. We always work on trying to improve Percona XtraBackup reliability, always favoring consistency, attempting to...
by Lenz Grimmer | Aug 17, 2021 | MongoDB, MySQL, Open Source, Percona Software
Over the weekend, the Debian project announced the availability of their newest major distribution release, Debian 11 (code name “bullseye”). We’d like to congratulate the Debian project and the open source community for achieving this major milestone! With over two...
by Pep Pla | Jun 25, 2021 | Insight for DBAs, MySQL, Percona Software
Don’t Try This at Home! Disclaimer: The procedure described in this blog post is not officially supported by Percona XtraBackup. Use it under your responsibility. I tested and used it successfully, but your mileage may vary. Note from the author: Wikipedia...
by Marcelo Altmann | Apr 12, 2021 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Chasing bugs can be a tedious task, and multi-threaded software doesn’t make it any easier. Threads will be scheduled at different times, instructions will not have deterministic results, and in order for one to reproduce a particular issue, it might require the...
by Sveta Smirnova | Apr 2, 2021 | Insight for DBAs, MySQL, Percona Software
Recovering to a particular time in the past is called Point-In-Time Recovery (PITR). With PITR you can rollback unwanted DELETE without WHERE clause or any other harmful command. PITR with Percona XtraBackup is pretty straightforward and perfectly described in the...
by Patrick Birch | Jan 27, 2021 | Insight for DBAs, MySQL, Percona Software
Percona XtraBackup 8.0.23 enables the “lock-ddl” option by default to ensure any DDL events do not corrupt the backups. Any DML events continue to occur, and only DDL events are blocked. A DDL lock protects the definition of tables and views. With the...
by Pep Pla | Jan 19, 2021 | Benchmarks, Insight for DBAs, MySQL, Percona Software
Large replication topologies are quite common nowadays, and this kind of architecture often requires a quick method to rebuild a replica from another server. The Clone Plugin, available since MySQL 8.0.17, is a great feature that allows cloning databases out of the...
by Marcelo Altmann | Dec 22, 2020 | Insight for DBAs, MySQL, Percona Software
MySQL 5.7, alongside other many improvements, brought bulk load for creating an index (WL#7277 to be specific), which made ADD INDEX operations much faster by disabling redo logging and making the changes directly to tablespace files. This change requires extra care...
by Marcelo Altmann | Oct 23, 2020 | Insight for DBAs, MySQL, Percona Software
Earlier this week, Oracle released their Q4 releases series. As on the previous releases, backward compatibility has been broken with previous versions of the server. This time on both MySQL 5.7 and 8.0: MySQL 5.7.32 While our QA team was performing an extensive test...
by Ivan Groenewold | Aug 26, 2020 | Cloud, Insight for DBAs, MySQL
Oftentimes, we need to replicate between Amazon Aurora and an external MySQL server. The idea is to start by taking a point-in-time copy of the dataset. Next, we can configure MySQL replication to roll it forward and keep the data up-to-date. This process is...
by Ivan Groenewold | Aug 20, 2020 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Have you ever had to provision a large number of instances from a single backup? The most common use case is having to move to new hardware, but there are other scenarios as well. This kind of procedure can involve multiple backup/restore operations which can easily...
by Kathy Williamson | Aug 18, 2020 | MySQL, Percona Software
We are excited to let you know about two upcoming changes to Percona XtraBackup which will align Percona XtraBackup Versions with Percona Server for MySQL. These changes are to bring Percona XtraBackup release naming line with Percona Server and MySQL and ensure...
by George O. Lorch III | Jul 21, 2020 | MySQL, Percona Software
On Monday, July 13, 2020, Oracle released MySQL 8.0.21. This release contained a few new changes that cause issues with Percona XtraBackup. First, this release introduced the ability to temporarily disable InnoDB redo logging (see the work log and documentation). If...
by George O. Lorch III | Apr 28, 2020 | MySQL, Percona Software
Update: Percona XtraBackup 8.0.12 now supports backup and restore processing for versions of MySQL 8.x; previous versions of Percona XtraBackup will not work with MySQL 8.0.20 and higher. More information On Monday, April 27, 2020, Oracle released the highly...
by Manish Chawla | Apr 10, 2020 | MySQL, Percona Software
The backup and restore of a complete database is an extensive exercise. But what if you need to restore just one table which has been mistakenly modified by an incorrect query? Help is at hand with Percona XtraBackup. For our purpose, we will take a test database...
by Borys Belinsky | Aug 7, 2019 | MySQL, Percona Software
Percona is glad to announce the release of Percona XtraBackup 8.0.7 on August 7, 2019. 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...
by Borys Belinsky | Jul 10, 2019 | MySQL, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.4.15 on July 10, 2019. 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...
