by Pablo Svampa | Apr 30, 2025 | Benchmarks, Insight for DBAs, Insight for Developers, PostgreSQL
Indexing is one of PostgreSQL’s most effective tools for improving query performance, but like any powerful tool, it can cause real problems when overused. A while ago, my colleague Jobin wrote a blog post exploring the negative side effects of over-indexing in...
by Ibrar Ahmed | Apr 5, 2025 | Insight for DBAs, PostgreSQL
This blog was first authored by Ibrar Ahmed in 2020. We’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring their original perspective. If you’re running PostgreSQL and suddenly hit an error you don’t recognize, you’re in...
by Divyanshu Soni | Apr 2, 2025 | Insight for DBAs, MongoDB, Percona Software
This blog was originally published in September 2020 and was updated in April 2025. As a MongoDB user, ensuring your data is safe and secure in the event of a disaster or system failure is crucial. That’s why it’s essential to implement effective MongoDB...
by Ibrar Ahmed | Apr 1, 2025 | Insight for DBAs, PostgreSQL, Security
This blog was first authored by Ibrar Ahmed in 2021. We’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring their original perspective. You think your PostgreSQL setup is secure. That is, until you actually try to document it....
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 Mike Grayson | Mar 8, 2025 | Insight for DBAs, MongoDB, Open Source
by Mike Benshoof | Mar 3, 2025 | Insight for DBAs, Monitoring, MySQL, Percona Software
This blog was originally published in June 2020 and was updated in March 2025. One of the most common support tickets we get at Percona is the infamous “database is running slower” ticket. While this can be caused by a multitude of factors, it is more often than not...
by Mike Grayson | Mar 1, 2025 | Insight for DBAs, Insight for Developers, MongoDB
by Jean da Silva | Feb 3, 2025 | Insight for DBAs, MongoDB
by Corrado Pandiani | Feb 2, 2025 | Insight for DBAs, Insight for Developers, MongoDB
by Brian Sumpter | Feb 1, 2025 | Insight for DBAs, Monitoring, MySQL
This post was originally published in June 2020 and was updated in February 2025. While there is no magic bullet for MySQL performance tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL...
by Roberto De Bem | Jan 22, 2025 | Insight for DBAs, MySQL
Large tables can pose challenges for many operations when working with a database. Occasionally, we may need to modify the table definition. Since RDS replication does not use asynchronous for its replication, the typical switchover procedure is not feasible. However,...
by Konstantin Trushin | Jan 10, 2025 | Insight for DBAs, MongoDB, Security
When setting up data-at-rest encryption (also known as transparent data encryption) in Percona Server for MongoDB, one has three options for storing a master encryption key: Encryption key file on a filesystem, KMIP server, HashiCorp’s Vault. An encryption key...
by Juan Arruti | Jan 1, 2025 | Insight for DBAs, Monitoring, MySQL
This post was originally published in April 2020 and was updated in January 2025. One of our customers recently asked whether it is possible to identify, from the MySQL side, the query that is causing high CPU usage on his system.The usage of simple OS tools to find...
by Brian Sumpter | Jun 18, 2024 | Insight for DBAs
With the holiday season approaching quickly, it’s an opportune time to discuss preparation for the busiest shopping season of the year, especially the typical surge of high traffic on Black Friday. Many businesses find themselves caught off guard by high holiday...
by David Quilty | Mar 25, 2024 | Insight for DBAs, Percona Services, Security
Anyone working with databases knows that data is the driving force behind every online activity, and data security is always a top concern. Seeing as how they store and manage vast amounts of sensitive and valuable data, ranging from financial records to personal...
by Sonia Valeja | Feb 7, 2024 | Insight for DBAs, PostgreSQL
Backup management is the backbone of any reliable database administration strategy, and while pgBackRest simplifies this process, its default configuration often combines backup and expiry together. At times, due to slow network bandwidth, huge database sizes, or any...
by Bhargav Kamineni | Dec 14, 2023 | Insight for DBAs, PostgreSQL
While a hallmark feature of PostgreSQL is streaming replication, sometimes data demands a more refined and adaptable replication approach to address different requirements. Logical replication offers a distinct advantage over traditional streaming replication by...
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 Robert Bernier | Jun 15, 2023 | Insight for DBAs, Insight for Developers, PostgreSQL
This post was originally published in 2020 and has been updated in 2023. Mastering Geographical Information Systems, better known simply as GIS, can be considered in some ways as a rite of passage. The complexities and challenges involved in learning, which are...
