Oct
28
2025
--

Practical Data Masking in Percona Server for MySQL 8.4

Practical Data Masking in Percona Server for MySQL 8.4Data 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 […]

Oct
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 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 […]

Oct
22
2025
--

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 […]

Oct
09
2025
--

A Guide to Redis Performance Best Practices

Redis Performance Best PracticesGetting 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. […]

Oct
01
2025
--

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 […]

Sep
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 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 […]

Sep
26
2025
--

MySQL 8.0 End of Life Support: What Are Your Options?

MySQL 8.0 End of Life SupportWe’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 […]

Sep
24
2025
--

Choosing the Right Key-Value Store: Redis vs Valkey

key-value storeNot 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. […]

Sep
22
2025
--

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 […]

Sep
17
2025
--

MySQL with Diagrams Part Three: The Life Story of the Writing Process

How MySQL writes workWhen 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-68cb7b0282a22221090106/] The log […]

Powered by WordPress | Theme: Aeros 2.0 by TheBuckmaker.com