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)

Deploying Percona Operator for MongoDB Across GKE Clusters with MCS
Ever needed a robust, highly available MongoDB setup that spans multiple Kubernetes clusters on GCP? This step-by-step guide shows you how to deploy the Percona Operator for MongoDB in two GKE clusters, linking them using Multi-Cluster Services (MCS) for seamless cross-cluster discovery and connectivity. Step 1: Prepare your GKE clusters & enable MCS 1. Prepare […]

(Comment on this)

Beyond EOL: The Real Benefits of Upgrading to MySQL 8.4
Right now, you’re probably hoping someone else will deal with this MySQL 8.0 end-of-life situation. Maybe your team can squeeze another few months out of it. Maybe Oracle will extend support. Maybe it won’t be as bad as everyone says. We get it.  You’ve got enough things going on without adding “major database upgrade” to […]

(Comment on this)

Swimming with Sharks: Analyzing Encrypted Database Traffic Using Wireshark
Percona has a great set of tools known as the Percona Toolkit, one of which is pt-upgrade. The idea behind this tool is to replay a captured sequence of queries that were executed on a different database server. This is very useful to validate if a new version of the database server works as expected […]

(Comment on this)

It’s End of Life for Redis Enterprise 7.2 in Six Months – What Are Your Options?
From a technology perspective, Redis does a great job as a database and data cache. According to 6Sense, Redis is currently the number one product as an in-memory data cache. It just works. However, that position is also a potential challenge. Redis does its job so well that, well, why should you change it? One […]

(Comment on this)

Valkey 9.0: Enterprise-Ready, Open Source, and Coming September 15, 2025
Circle September 15 on your calendar! That’s when Valkey 9.0 officially drops, bringing enterprise-grade features that solve real operational headaches without the licensing restrictions or unpredictable costs you face with Redis. If you’ve been following Valkey since it forked from Redis, this release represents a major milestone. The same engineers who built Redis now work […]

(Comment on this)

Don’t Trust, Verify: How MyDumper’s Checksums Validates Data Consistency
How do you know if your backup is truly reliable? The last thing you want is to discover your data is corrupted during a critical restore or during a migration. While MyDumper is a powerful tool for logical backups, its -M option takes backup integrity to the next level by creating checksums. This often-overlooked feature […]

(Comment on this)

MySQL 8.0 Deprecated Features: What You Need to Know
If you manage a MySQL database, you’ve probably heard the news: MySQL 8.0 is heading for its End of Life (EOL), and taking center stage is MySQL 8.4, the first-ever Long-Term Support (LTS) release. This is great news for all of us who value stability, as it means a more predictable, enterprise-ready platform for the […]

(Comment on this)

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, it manifests a significant amount of writes visible in growing binary logs. This effect became much more spectacular after MySQL version 8.4. In this write-up, I will explain why it happens and how to address […]

(Comment on this)

Deep Diving the Citus Distribution Models Along with Shard Balancing/Read Scaling
In my previous blog post, Integrating Citus with Patroni: Sharding and High Availability Together, I explored how to integrate Citus with Patroni and demonstrated how basic table distribution works. In this follow-up post, I will discuss various other Citus distribution models. We will also explore how shard rebalancing and data movement are handled and further […]

(Comment on this)

Secure, Centralized Authentication Comes to Percona Server for MongoDB with OpenID Connect
Today, Percona is proud to announce the release of OpenID Connect (OIDC) support for Percona Server for MongoDB, the source-available, enterprise-grade MongoDB-compatible database solution trusted by developers and IT leaders globally. With this new capability, Percona customers can integrate with leading identity providers (IdPs) like Okta, Microsoft Entra, Ping Identity, Keycloak, and others to simplify […]

(Comment on this)

Top 5 Security Risks of Running MySQL 8.0 After Its EOL
Your MySQL database has been running smoothly for years. Your team knows it inside and out. Everything just… works. Why rock the boat with an upgrade? Here’s why: MySQL 8.0 reaches its end-of-life date in April 2026. After this date, there’s no safety net; staying on end-of-life software means you’re taking on all the responsibility […]

(Comment on this)

Webinar Q&A: No More Workarounds: Open Source PostgreSQL TDE Is Here
I would like to thank everyone who attended my webinar, “No More Workarounds: Open Source PostgreSQL TDE Is Here,” on July 23, 2025. If you missed it, you can view the recording and slides. Here are the questions I had no time to answer during the live session. If you have more questions, post them in […]

(Comment on this)

LDAP Isn’t Going Away, and Neither Is Our Support for Percona Server for MongoDB
As enterprise software vendors race toward proprietary cloud ecosystems, some features long relied upon by businesses are being quietly deprecated. One recent example is MongoDB Enterprise Advanced and Atlas dropping support for LDAP authentication, a foundational identity protocol for countless organizations. At Percona, we’re taking a different path. We’ve supported LDAP in Percona Server for MongoDB for […]

(Comment on this)

MySQL 8.0 End of Life Date: What Happens Next?
If you’re running MySQL 8.0 databases, you need to know this: Oracle will stop supporting them in April 2026. That means no more security patches, bug fixes, or help when things go wrong. Maybe you’re thinking, “But April 2026 feels far away!“. But once that date hits, every day you keep running MySQL 8.0 makes […]

(Comment on this)

Planning Ahead for PostgreSQL 18: What Matters for Your Organization
PostgreSQL 18 is on the way, bringing a set of improvements that many organizations will find useful. It’s not a revolutionary release, but it does move things in a good direction, especially in performance, replication, and simplifying daily operations. For teams already using PostgreSQL, it’s a good time to look into what’s new. For others […]

(Comment on this)

Integrating Citus with Patroni: Sharding and High Availability Together
Citus is a robust PostgreSQL extension that aids in scaling data distribution and provides a solid sharding mechanism. It enriches features like distributed tables, reference tables, columnar storage, schema-based sharding, etc. We have already covered the basics of Citus and the initial setup part in some earlier blog posts: How To Scale a Single-Host PostgreSQL […]

(Comment on this)