MongoDB Query Plan Cache Explained: Performance, Pitfalls, and Re-Planning
When MongoDB receives a query, it performs the following steps: Evaluate the available indexes that could be used. Generate and test multiple execution plans using candidate indexes. Measure their performance during a trial phase. Select the fastest plan (the winning plan) and execute the query. These steps are known as query planning, and they are […]

(Comment on this)

Rate Limiting Strategies with Valkey/Redis
Rate limiting is one of those topics that looks simple until you’re actually doing it in production. Implement a counter with the INCR command and a TTL and away you go. But when you ask questions like “what happens at the boundary?”, “should I use a Valkey/Redis cluster?”, or “why are we getting twice the […]

(Comment on this)

What Is in pg_gather Version 33 ?
It started as a humble personal project, few years back. The objective was to convert all my PostgreSQL notes and learning into a automatic diagnostic tool, such that even a new DBA can easily spot the problems. The idea was simple, a simple tool which don’t need any installation but do all possible analysis and […]

(Comment on this)

How to Customize PagerDuty Custom Details in Grafana: The Hidden Override Method
The Problem If you’ve integrated Grafana Alerting with PagerDuty, you’ve probably noticed something frustrating: the PagerDuty incident details are cluttered with every single label and annotation from your alerts. Here’s what you typically see: [crayon-69b85470ca345554481662/] This wall of text makes it hard for your on-call engineers to quickly identify what’s wrong. And actually, this was […]

(Comment on this)

A Failing Unit Test, a Mysterious TCMalloc Misconfiguration, and a 60% Performance Gain in Docker
We are pleased to share the news of a recent fix, tracked as PSMDB-1824/PSMDB-1868, that has delivered significant, quantifiable performance enhancements for Percona Server for MongoDB instances, particularly when running in containerized environments like Docker. Percona Server for MongoDB version 8.0.16-5, featuring this improvement, was made available on December 2, 2025. Investigation The initial issue […]

(Comment on this)

Valkey and Redis Sorted Sets: Leaderboards and Beyond
  This blog post covers the details about sorted set use cases as discussed in this video. Sorted sets are one of the most powerful data structures in Valkey and Redis. While most developers immediately think about “gaming leaderboards” when they hear about sorted sets, this versatile data type can solve many problems, from task […]

(Comment on this)

What Exactly Is the MySQL Ecosystem? 
As we set out to help the MySQL ecosystem assert greater independence from Oracle by establishing a vendor-neutral industry association, we had to confront a deceptively simple question: What exactly is the MySQL ecosystem? There are many views on this question. Some argue it should revolve strictly around the MySQL brand—meaning MariaDB would be excluded. […]

(Comment on this)

Security Advisory: A Series of CVEs Affecting Valkey
A series of vulnerabilities has been identified that affect all versions of Valkey. Below is the summary of each vulnerability: The patches for these CVEs had been released in newer versions of valkey-server and valkey-bloom. Please consider upgrading to these versions as soon as possible: valkey-server 9.0.3 valkey-server 8.1.6 valkey-server 8.0.7 valkey-server 7.2.12 valkey-bloom 1.0.1 […]

(Comment on this)

Percona Operator for MongoDB 1.22.0: Automatic Storage Resizing, Vault Integration, Service Mesh Support, and More!
The latest release of the Percona Operator for MongoDB, 1.22.0 is here. It brings automatic storage resizing, HashiCorp Vault integration for system user credentials, better integration with service meshes, improved backup and restore options, and more. This post walks through the highlights and how they can help your MongoDB deployments on Kubernetes. Percona Operator for MongoDB […]

(Comment on this)

A Guide to Accelerating Your Application with Valkey: Caching Database Queries and Sessions
Modern applications often rely on multiple services to provide fast, reliable, and scalable responses. A common and highly effective architecture involves an application, a persistent database (like MySQL), and a high-speed cache service (like Valkey). In this guide, we’ll explore how to integrate these components effectively using Python to dramatically improve your application’s performance. Understanding […]

(Comment on this)

An Open Letter to Oracle: Let’s Talk About MySQL’s Future
What Happened at the Summits We just wrapped up two MySQL Community Summits – one in San Francisco in January, and one in Brussels right before FOSDEM. The energy in the rooms: a lot of people who care deeply about MySQL got together, exchanged ideas, and left with a clear sense that we need to […]

(Comment on this)

Semantic Caching for LLM Apps: Reduce Costs by 40-80% and Speed up by 250x
This post covers the topic of the video in more detail and includes some code samples. The $9,000 Problem You launch a chatbot powered by one of the popular LLMs like Gemini, Claude or GPT-4. It’s amazing and your users love it. Then you check your API bill at the end of the month: $15,000. […]

(Comment on this)

Percona at 20: Why Our Open Source, Services-Led Model Still Works
In 2026, Percona turns 20. That milestone offers a good opportunity to pause and reflect, not just on where we have been, but on why our business model has worked for two decades in an industry that has seen constant change. From the beginning, Percona has followed a model that is sometimes misunderstood, occasionally questioned, […]

(Comment on this)

Importance of Tuning Checkpoint in PostgreSQL
The topic of checkpoint tuning is frequently discussed in many blogs. However, I keep coming across cases where it is kept untuned, resulting in huge wastage of server resources, struggling with poor performance and other issues. So it’s time to reiterate the importance again with more details, especially for new users. What is a checkpoint? […]

(Comment on this)

Rebuilding a Replica with MyDumper
When a replica fails due to corruption or drift, the standard solution is to rebuild it from a fresh copy of the master when pt-table-sync is not an option. Traditionally, when we need to build a new replica, we use a physical backup for speed, but there are some cases where you still need logical […]

(Comment on this)

Databases, Data Lakes, And Encryption
The Evolution of Object Storage Let’s start by stating something really obvious; object storage has become the preeminent storage system in the world today. Initially created to satisfy a need to store large amounts of infrequently accessed data, it has since grown to the point of becoming the dominant archival medium for unstructured content. Its […]

(Comment on this)

Automatic “Multi-Source” Async Replication Failover Using PXC Replication Manager
The replication  manager script can be particularly useful in complex PXC/Galera topologies that require Async/Multi-source replication. This will ease the auto source and replica failover to ensure all replication channels are healthy and in sync. If certain nodes shouldn’t  be part of a async/multi-source replication, we can disable the replication manager script there to tightly controlled the flow. Alternatively, node participation can be controlled by adjusting the weights in the percona.weight table, allowing replication behavior to be managed more precisely.

(Comment on this)

Back to Our Open Source Roots: Winding Down Percona ProBuilds
At Percona, open source is not just something we use. It is who we are. From our earliest days, our mission has been simple and consistent: make open source databases better for everyone. That mission guides our product decisions, our business model, and how we engage with the community. Today, I want to share an […]

(Comment on this)

MySQL January 2026 Performance Review
This article is focused on describing the latest performance benchmarking executed on the latest releases of Community MySQL, Percona Server for MySQL and MariaDB.  In this set of tests I have used the machine described here.  Assumptions There are many ways to run tests, and we know that results may vary depending on how you […]

(Comment on this)

Separating FUD and Reality: Has MySQL Really Been Abandoned?
Over the past weeks, we have seen renewed discussion/concern in the MySQL community around claims that “Oracle has stopped developing MySQL” or that “MySQL is being abandoned.” These concerns were amplified by graphs showing an apparent halt in GitHub commits after October 2025, as well as by blog posts and forum discussions that interpreted these […]

(Comment on this)