by Jorge Torralba | Jul 11, 2025 | Insight for DBAs, PostgreSQL
This post was originally published in 2022, and we’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring its original perspective. If you’re a DBA who’s comfortable with Oracle, MySQL, or SQL Server, stepping into PostgreSQL can...
by Jean da Silva | Jul 1, 2024 | Insight for DBAs, MongoDB, Percona Software
Configuring and managing backups is one of the top priorities among the many tasks we deal with daily in our database instances. In this context, it’s not rare to see deployments with more than one mongod process running per node, creating a multi-instance...
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 Sveta Smirnova | Oct 17, 2023 | Insight for DBAs, MySQL
This blog post discusses using the CLONE INSTANCE command with the safety option DATA DIRECTORY when you do not have enough disk space to store two datasets. In my previous blog post on the CLONE INSTANCE command, The MySQL Clone Plugin Is Not Your Backup, I...
by Sveta Smirnova | Sep 26, 2023 | Insight for DBAs, MySQL, Percona Software
This blog post discusses the limitations of the MySQL Clone plugin. The MySQL clone plugin significantly simplifies the process of replica provisioning. All you need to do is: Ensure that the source server has binary logs enabled Grant appropriate permissions Execute...
by Pete Scott | Aug 30, 2023 | Insight for DBAs, Insight for Developers, Open Source
People used to say, “Coal is king,” and for decades, it was. Coal powered just about everything, but mismanagement and a lack of stewardship left some messes. These days, “Data is king,” and a lot more. Data powers everything, and unlike coal and coal combustion,...
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 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 Sergey Pronin | Jan 24, 2023 | Cloud, Open Source, Percona Platform, Percona Software
Databases on Kubernetes continue their rising trend. We see the growing adoption of our Percona Kubernetes Operators and the demand to migrate workloads to the cloud-native platform. Our Operators provide built-in backup and restore capabilities, but some users are...
by Vinodh Krishnaswamy | Nov 25, 2022 | Cloud, Hardware and Storage, MongoDB, Percona Software
One of the main features that I like about the Percona Operator for MongoDB is the integration with Percona Backup for MongoDB (PBM) tool and the ability to backup/restore the database without manual intervention. The Operator allows backing up the DB to S3-compatible...
by Anastasia Alexandrova | May 27, 2022 | MongoDB, Open Source, Percona Software
Percona Backup for MongoDB (PBM) is a backup utility custom-built by Percona to help solve the needs of customers and users who don’t want to pay for proprietary software like MongoDB Enterprise and Ops Manager but want a fully-supported open-source backup tool that...
by Sveta Smirnova | Jul 7, 2021 | Insight for DBAs, MySQL, Open Source
“It would be nice to have an option, that would allow to suppress the DEFINER statement in the CREATE VIEW statements generated by mysqldump. This would help when transferring data structures between databases with different security models.” TLDR; Use mysqlpump with...
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 Mani Paluru | Nov 6, 2020 | Insight for DBAs, Insight for Developers, MySQL
Mysqlpump is a client program that was released with MySQL 5.7.8 and is used to perform logical backups in a better way. Mysqlpump supports parallelism and it has the capability of creating compressed output. Pablo already wrote a blog about this utility (The...
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 Daniel Guzmán Burgos | Jan 9, 2020 | MySQL, Percona Software
The importance of having periodic backups is a given in Database life. There are different flavors: binary ones (Percona XtraBackup), binlog backups, disk snapshots (lvm, ebs, etc) and the classic ones: logical backups, the ones that you can take with tools like...
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...
by Borys Belinsky | May 9, 2019 | MySQL, Percona Software
Percona is glad to announce the release of Percona XtraBackup 8.0.6 on May 9, 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 | May 1, 2019 | MySQL, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.4.14 on May 1, 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...
