by Satya Bodapati | Mar 24, 2025 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
When performing backups, reducing the amount of time your server is locked can significantly improve performance and minimize disruptions. Percona XtraBackup 8.4 Pro introduces improvements in how DDL (Data Definition Language) locks (aka Backup Locks) are managed,...
by Fernando Mattera | Dec 19, 2024 | Insight for DBAs, MySQL, Percona Software
This blog is not intended to offer anything extraordinary; instead, consider it an anecdote, a lesson, or simply a proper way of doing things without the need to run a test when in doubt. That said, I must emphasize that, as always, testing everything before deploying...
by Alina Derkach | Jul 15, 2024 | Insight for DBAs, MySQL, Percona Software
We’re excited to announce that both Percona Server for MySQL and Percona XtraBackup now support the ARM64 architecture on Red Hat Enterprise Linux (RHEL) 8/9 and Oracle Linux (OL) 8/9. The packages with the aarch64.rpm extension can be found on Percona Software...
by Yunus Shaikh | Mar 18, 2024 | MySQL, Percona Software, Security
Percona XtraBackup (PXB) version 8.0.28 supports taking backups for the encrypted tables in your MySQL database using the AWS Key Management Service. For setting up data-at-rest encryption using AWS key management service, please see Configuring Keyring for Encryption...
by Mohit Joshi | Dec 7, 2023 | Insight for DBAs, MySQL, Percona Software
Ensuring the security and resilience of your data hinges on having a robust backup strategy, and Percona XtraBackup (PXB), our open source backup solution for all versions of MySQL, is designed to make backups a seamless procedure without disrupting the performance of...
by Patrick Birch | Nov 8, 2023 | MySQL, Percona Software
With the release of Percona XtraBackup 8.0.34-39, Percona XtraBackup (PXB) allows a backup on server version 8.0.35 and higher. We have removed the server version check because the MySQL 8.0 series has transitioned to bug fixes. A feature change in the MySQL 8.0...
by Walter Garcia | Nov 1, 2023 | Insight for DBAs, MySQL, Open Source, Percona Software
This blog was originally published in January 2021 and updated in November of 2023. As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes paramount. In this age of digital...
by Alina Derkach | Aug 23, 2023 | Insight for DBAs, MySQL, Percona Software
To reduce the backup size, save storage space, and speed up the backup and restore process, you can compress a backup with Percona XtraBackup. The XtraBackup –compress option makes XtraBackup compress all output data, including the transaction log file and...
by Satya Bodapati | Jul 25, 2023 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
In this blog post, we will describe the improvements to Percona XtraBackup 8.0.33-28 (PXB), which significantly reduces the time to prepare the backups before the restore operation. This improvement in Percona XtraBackup significantly reduces the time required for a...
by Marcelo Altmann | Jul 25, 2023 | Insight for DBAs, MySQL, Percona Software
When it comes to backups, there are several options for saving backup files. You can choose to save them locally on the same server, stream them to different servers, or store them in object storage. Percona XtraBackup facilitates streaming through the use of an...
by Bhuvanes Waran | Jun 27, 2023 | Insight for DBAs, MySQL, Percona Software
MySQL Shell is an advanced client and code editor for MySQL. In addition to the provided SQL functionality, similar to MySQL, MySQL Shell provides scripting capabilities for JavaScript and Python and includes APIs for working with MySQL. The X DevAPI enables you to...
by Eduardo Krieg | Jun 23, 2023 | Insight for DBAs, MySQL, Percona Software
In Percona Managed Services, one key aspect of managing the databases is configuring backups. Percona XtraBackup is one of the best tools for performing physical database backups. It is a good practice to compress the backups to save costs on storage and to encrypt...
by Baron Schwartz | Jun 6, 2023 | Insight for DBAs, Percona Software
This blog was originally published in January 2012 and was updated in June 2023. In today’s data-driven world, the protection and reliability of our valuable information is vital. The potential impact of data loss or corruption on individuals and organizations...
by Larry Xia | Mar 13, 2023 | Insight for DBAs, MySQL, Percona Software
When we need to upgrade from MySQL 5.7 to MySQL 8, we could choose to do an in-place upgrade or set up another MySQL 8 server(s) from the existing running MySQL 5.7 replica. This article will explain how to set up MySQL 8 as a replica from an existing MySQL 5.7 server...
by Lalit Choudhary | Feb 10, 2023 | Insight for DBAs, MySQL, Percona Software, Storage Engine
Percona XtraBackup is an open source hot backup utility for MySQL-based servers. To take consistent and hot backup, it uses various locking methods, especially for non-transactional storage engine tables. This blog post discusses the cause and possible solution for...
by Marcelo Altmann | Feb 10, 2023 | Cloud, Insight for DBAs, MySQL, Percona Software
Amazon instance profiles are used to pass IAM roles to an EC2 instance. This IAM role can be queried using EC2 instance metadata to access an S3 bucket. Please check Amazon’s Official Documentation for more information. Today we are happy to announce that...
by Brijesh Chauhan | Jan 5, 2023 | Insight for DBAs, MySQL, Percona Software
Recently, we performed a database engine major version upgrade in one of our customers’ environments from MySQL 5.7.26 to 8.0.27. After this version upgrade, we experienced issues with backups and replication for one of the nodes. In this article, I will explain these...
by Marcelo Altmann | Nov 18, 2022 | Insight for DBAs, MySQL, Percona Software
Taking a MySQL backup using Percona XtraBackup (PXB) consists of basically two steps: 1) take the backup and 2) prepare the backup. Briefly speaking, taking a backup means that PXB will copy all of the files from your instance and transfer them to another location....
by Marcelo Altmann | Nov 17, 2022 | Insight for DBAs, MySQL, Percona Software
Having a backup of your database is like insurance, you have to pay a monthly price to ensure you have a service available when you need to. When talking about backups, the storage required to keep your backups is what comes into factor when talking about price, the...
by Marcelo Altmann | Jul 19, 2022 | Insight for DBAs, MySQL, Percona Software
Oracle’s MySQL 8.0.29 release extended the support for ALTER TABLE … ALGORITHM=INSTANT to 1) allow users to instantly add columns in any position of the table, and 2) instantly drop columns. As part of this work, the InnoDB redo log format has changed for all DML...
