Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
November 20, 2025
Performing Standby Datacentre Promotions of a Patroni Cluster
Unlike the standard multi-node Postgres replication cluster, when managed by Patroni, all failovers are automatically executed. However, this is not [...]
October 28, 2025
Practical Data Masking in Percona Server for MySQL 8.4
Data masking lets you hide sensitive fields (emails, credit-card numbers, job titles, etc.) while keeping data realistic for reporting, support, [...]
October 27, 2025
Troubleshooting PostgreSQL Logical Replication, Working with LSNs
PostgreSQL logical replication adoption is becoming more popular as significant advances continue to expand its range of capabilities. While quite [...]
September 30, 2025
Tackling the Cache Invalidation and Cache Stampede Problem in Valkey with Debezium Platform
There are two hard problems in computer science: cache invalidation, naming things, and off-by-1 errors. This classic joke, often attributed [...]
August 21, 2025
MySQL Router 8.4: How to Deal with Metadata Updates Overhead
It may be surprising when a new InnoDB Cluster is set up, and despite not being in production yet and completely idle, [...]
August 4, 2025
Integrating Citus with Patroni: Sharding and High Availability Together
Citus is a PostgreSQL extension developed with the intention of sharding and distributing the data across multiple machines. It offers [...]
July 14, 2025
Running PostgreSQL on Kubernetes: High Availability, Scaling, and Disaster Recovery
This blog was originally published in 2021 and updated in 2025. Running PostgreSQL in production means balancing high availability, disaster [...]
July 10, 2025
Working with Geospatial Data? PostGIS Makes PostgreSQL Enterprise-Ready
Do you find yourself struggling with geospatial data in your database? You know the feeling: you need quick answers about [...]
April 30, 2025
Benchmarking PostgreSQL: The Hidden Cost of Over-Indexing
Indexing is one of PostgreSQL’s most effective tools for improving query performance, but like any powerful tool, it can cause [...]
April 16, 2025
How to Extend Percona Monitoring and Management to Add Logging Functionality
Evolution is one of the inherent traits of modern software. Many people reach out to product teams daily, asking to [...]
April 15, 2025
Avoiding PostgreSQL Upgrade Errors: A Practical Guide
This post was originally published in January 2024 and was updated in April 2025. Thinking about a PostgreSQL upgrade? Here’s [...]
April 3, 2025
4 Ways to Convert MongoDB BSON to JSON Format
This post was originally published in April, 2023 and was updated in April, 2025. Binary Javascript Object Notation (BSON) is [...]
April 1, 2025
Kubernetes Sidecar Containers Explained: Benefits, Use Cases, and What’s New
Kubernetes is becoming a popular choice for running containerized applications. While the core idea is to have a single container [...]
March 26, 2025
Enhancing Keyhole: Pulling More Metrics from MongoDB’s FTDC
Everyone knows that MongoDB has FTDC (Full-Time Diagnostic Data Capture), which helps MongoDB engineers analyze server behavior, tune parameters, and [...]
March 24, 2025
Percona XtraBackup 8.4 Pro: Reduce Server Locking by up to 4300X
When performing backups, reducing the amount of time your server is locked can significantly improve performance and minimize disruptions. Percona [...]
March 1, 2025
5 Effective Strategies for MongoDB Performance Tuning
This blog was published in January of 2021 and updated in March of 2025. Effective MongoDB performance tuning is crucial [...]
February 2, 2025
MongoDB Indexes Explained: A Comprehensive Guide to Better MongoDB Performance
This blog was originally published in March 2021 and was updated in February 2025. Good intentions can sometimes end up [...]
January 14, 2025
What Hurts in PostgreSQL Part One: Temporary Tables
PostgreSQL is one of the most powerful database systems in the world. I have always been passionate about its great [...]
December 20, 2024
MySQL Transaction ERROR 1412 and Isolation Levels
This blog post explains the cause of “ERROR 1412 (HY000): Table definition has changed, please retry transaction” with the specific [...]
December 18, 2024
How To Deal with a AUTO_INCREMENT Max Value Problem in MySQL and MariaDB
An application down due to not being able to write into a table anymore due to a maximum allowed auto-increment [...]