PostgreSQL 13 Is Reaching End of Life. The Time to Upgrade is Now!
PostgreSQL 13 will officially reach End-of-Life (EOL) on November 13, 2025. After this date, the PostgreSQL Global Development Group will stop releasing security patches and bug fixes for this version. That means if you’re still running PostgreSQL 13, you’ll soon be on your own with no updates, no community support, and growing security risks. Why […]

(Comment on this)

Surprise with innodb_doublewrite_pages in MySQL 8.0.20+
In a recent post, The Quirks of Index Maintenance in Open Source Databases, I compared the IO load generated by open source databases while inserting rows in a table with many secondary indexes. Because of its change buffer, InnoDB was the most efficient solution. However, that’s not the end of the story. Evolution of the […]

(Comment on this)

How to Configure pgBackRest Backups and Restores in PostgreSQL (Local/k8s) Using a MinIO Object Store
This blog post explains how to configure and use MinIO as S3-compatible storage for managing PostgreSQL backups, and how to perform data restoration and recovery in both standalone (local) and Kubernetes environments.

(Comment on this)

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, or testing. It is particularly useful when you collaborate with external entities and need to share your data for development reasons. You also need to protect your data and keep your customers’ privacy safe. Last […]

(Comment on this)

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 a few blogs have described features, there seems to be a lack of simple and straightforward advice on restoring stalled replication. This blog demonstrates an extremely powerful approach to resolving replication problems using the Log […]

(Comment on this)

Customizing the New MongoDB Concurrency Algorithm
On some occasions, we realize the necessity of throttling the number of requests that MongoDB tries to execute per second, be it due to resource saturation remediation, machine change planning, or performance tests. The most direct way of doing this is by tuning the WiredTiger transaction ticket parameters. Applying this throttle provides more controlled and […]

(Comment on this)

Security Advisory: CVE Affecting Percona Monitoring and Management (PMM)
A critical security vulnerability has been identified in the following software that Percona has made available and that you may be using:  PMM 3.x installations (that is, 3.0 and forward). The Common Vulnerabilities and Exposures (CVE) identifier for this issue is on request from mitre.org. Vulnerability details We were notified via an external report that […]

(Comment on this)

Open Source Is Not Just Code: It’s Integrity
The following blog is my personal opinion and view on the world and our company.  Open source is more than just code; it’s a philosophy. It’s about openness, honesty, integrity, and sharing in how we work and communicate, even when no one is watching. The saying “knowledge is power,” often credited to Francis Bacon, captures […]

(Comment on this)

A Guide to Redis Performance Best Practices
Getting started with Redis? Read this first. Redis makes it very easy to get started, but if you want Redis to keep up when things get busy, there’s a bit more to take care of. Anyone can spin up a test server, but production workloads demand reliability and performance planning. That’s where the details matter. […]

(Comment on this)

Celebrating a New Chapter: Percona Welcomes Peter Farkas as its New Chief Executive Officer
Today, we are excited to announce that Peter Farkas will serve as Percona’s new Chief Executive Officer, where he will build on the company’s long-standing track record of success with an eye toward continuous innovation and growth.  As a former Perconian with a wealth of technical expertise and over a decade of experience leading successful […]

(Comment on this)

The Redis License Has Changed: What You Need to Know
Redis has always been the go-to when you need fast, in-memory data storage. You’ll find it everywhere. Big ecommerce sites. Mobile apps. Maybe your own projects, too. But if you’re relying on Redis today, you’re facing a new reality: the licensing terms have changed, and that shift could affect the way you use Redis going […]

(Comment on this)

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 to Phil Karlton, highlights a very real and persistent challenge for software developers. We’re constantly striving to build faster, more responsive systems, and caching is a fundamental strategy for achieving that. But while caching offers […]

(Comment on this)

New File Copy-Based Initial Sync Overwhelms the Logical Initial Sync in Percona Server for MongoDB
In a previous article, Scalability for the Large-Scale: File Copy-Based Initial Sync for Percona Server for MongoDB, we presented some early benchmarks of the new File Copy-Based Initial Sync (FCBIS) available in Percona Server for MongoDB. Those first results already suggested significant improvements compared to the default Logical Initial Sync. In this post, we extend our […]

(Comment on this)

MySQL 8.0 End of Life Support: What Are Your Options?
We’ve mentioned this a few times here on the blog already, but in case you missed it, MySQL 8.0’s end-of-life date is April 2026. This probably sounds forever away, but it’s going to sneak up before you know it. Maybe you’ve been putting off thinking about it, or maybe you’re already weighing your options but […]

(Comment on this)

Choosing the Right Key-Value Store: Redis vs Valkey
Not long ago, picking an in-memory key-value store was easy. Redis was the default. Fast, simple, everywhere. Then the rules changed. Redis moved to a much more restrictive license. Suddenly, many companies had to rethink their plans, especially if they cared about staying open source or needed flexibility for the cloud. That’s when Valkey arrived. […]

(Comment on this)

Announcing OpenBao Support in Percona Server for MongoDB
At Percona, we believe that an open world is a better world. Our mission has always been to empower organizations with secure, scalable, and reliable open source database solutions without locking them into expensive proprietary ecosystems. Today, we’re excited to share another step forward in this journey: Percona Server for MongoDB now supports OpenBao for […]

(Comment on this)

Keep PostgreSQL Secure with TDE and the Latest Updates
This fall feels like a good moment to stop and look at what’s changed in PostgreSQL security over the last months and also what you can use right now to make your PostgreSQL deployments safer. PostgreSQL Transparent Data Encryption (TDE) from Percona For many years, Transparent Data Encryption (TDE) was a missing piece for security […]

(Comment on this)

Help Shape the Future of Vector Search in MySQL
AI and machine learning are seemingly everywhere, and that’s forcing every database company to think about vector search. Companies want to build things like smart search that actually understands what you mean, recommendation systems that know what you’ll like, and tools that can spot when something’s off. To make all of this work at the […]

(Comment on this)

MySQL with Diagrams Part Three: The Life Story of the Writing Process
When you run a simple write, …it may look simple, but under the hood, MySQL’s InnoDB engine kicks off a pretty complex sequence to ensure your data stays safe, consistent, and crash-recoverable. In the top-left corner of the diagram, we see exactly where this begins — the moment the query is executed: [crayon-68cce6dc35952699889562/] The log […]

(Comment on this)

What is Percona’s Transparent Data Encryption Extension for PostgreSQL (pg_tde)?
If you’re running PostgreSQL in a regulated industry, you know the frustration: your compliance auditor demands data-at-rest encryption, but PostgreSQL doesn’t offer it natively. Your only options in the past? Pay premium prices for proprietary forks or accept compliance gaps that keep you awake at night. Percona has changed that. With Percona for PostgreSQL, you […]

(Comment on this)