The Curious Engineer

All blogs / Databases

Percona

percona.com/blog

Discover insights from Percona experts on MySQL, MongoDB, PostgreSQL, and open source database management. Access database performance tips, best practices, and tutorials.

DatabasesDevOps / SRE / infrastructure

’10’15’20’25
Posts
6,294 from 3 May 2006 to 30 Oct 2026
Posting
about daily (189 in the last year)
Kind
company blog
Feed
https://www.percona.com/blog/feed/

Latest

October 2026

  1. What’s New in PSMDB Sandbox: Six Months of Updates
  2. Benchmarking Vector search in six database engines
  3. PLGM Has Grown Up: A New UI and Many More Features
  4. Percona Operator for MySQL 1.3.0: autopilot tuning, zero-data-loss async failover, encrypted PITR
  5. Why you should stop using ARBITERS in MongoDB
  6. How to Extract Data from InnoDB, MyISAM, and MyRocks Files Without a Running Server
  7. PHP2Shell Vulnerability: Percona Security Update
  8. “MongoDB was slow on Thursday”: answering the app team with mongo-health
  9. When a Small Change Writes Too Much – How A Linux Kernel Improvement Can Strike You in PXC/Galera Workloads
  10. JavaScript in MySQL: Extending SQL, Not Moving the Application
  11. Thread Pool in Percona Server and MySQL (Part 2)
  12. Meet MySQL 26.7: A New Versioning Era Begins
  13. MongoDB 9.0: More 8.4 than 9.0?
  14. PGO or not PGO this is the dilemma. Step 3
  15. PGO or not PGO this is the dilemma. Step 2
  16. PGO or not PGO this is the dilemma. Step 1
  17. Your Galera cluster’s hardest problem was never the replication library
  18. DBTrail: Analytical Reports on Your MySQL Data, Without Running Them on MySQL – Part 1
  19. Percona ClusterSync for MongoDB 1.0.0 is Generally Available
  20. What Is Running on My MongoDB Right Now? Real-Time Analytics in PMM
  21. Thread Pool in Percona Server and MySQL (Part 1)
  22. Tuning Percona ClusterSync for MongoDB Performance

September 2026

  1. Percona ClusterSync for MongoDB Goes Highly Available: Active-Standby Failover
  2. Valkey Memory Optimization, Version by Version and Encoding: How Many Bytes Did Each Release Actually Save?
  3. PgQ and PgQue: Workflow Engines you might need in PostgreSQL
  4. When pt-online-schema-change “where” Meets Galera: Understanding Chunk Auto-Resize and Flow Control
  5. DISTANCE() and VECTOR_DISTANCE(): Vector Similarity in Percona Server for MySQL 9.7
  6. Evaluating LLM models for DBA tasks
  7. Group Replication Beyond a Single Cluster: DC-DR with Percona (PS MySQL) Operator
  8. Too many GCache Page Files in MySQL Data Directory
  9. pgBackRest Compression: How Much CPU Is a Smaller Backup Worth?
  10. Performance improvements in Percona Server 8.4.11-11
  11. Percona and HexaCluster: Faster, Safer Oracle Migration
  12. Enabling TLS in PXC without Downtime
  13. Percona Operator for PostgreSQL 3.1.0: Transparent Data Encryption, Logical Replicas, and Persistent Logging
  14. Meet pgstef: Why Stefan Fercot Joined Percona, and Why You Should Find Him at Percona Live Amsterdam
  15. Mongorewind: Rewind Your MongoDB Test Data Without Restoring a Backup
  16. OpenID Connect Authentication for MySQL, Now Fully Open Source

August 2026

  1. Rotating Expiring X.509 Certificates in Percona Server for MongoDB with Minimal Service Interruption
  2. Benchmarking vector indexes
  3. Performance Progression of Percona Server for MySQL 8.4
  4. Navigating the Walled Gardens of PostgreSQL: Hidden Risks of Postgres Vendor Lock-in
  5. Replication Lag on AWS FSx: The Hidden EC2 Single-Flow Bandwidth Limit
  6. Software Bill of Materials in Percona Server for MongoDB
  7. Security Advisory: Privileged ClickHouse access through the Grafana data source in PMM
  8. Stop guessing at gcache: inspect Galera/PXC write sets with gcache-inspector
  9. Percona University Comes to Uruguay
  10. Replicating from InnoDB into a DuckDB storage engine
  11. Percona for MongoDB: RHEL 10, Its Derivatives, and Debian 13 – On Both x86_64 and ARM
  12. The open way of Percona Search for MongoDB
  13. The DuckDB MySQL engine at 500 GB
  14. The diagnostic data MongoDB Atlas doesn’t hand you

July 2026

  1. Stored Procedures memory consumption in Percona Server for MySQL
  2. Percona Server for MongoDB 8.3 Technical Preview Is Now Available
  3. Alert on CVEs in Your Percona Tools for MongoDB on Day One
  4. Percona Operator for MongoDB 1.23.0: ClusterSync Migration, Vector Search, and PVC Snapshot Backups
  5. How to Migrate from MySQL Galera Cluster to Percona XtraDB Cluster
  6. PostgreSQL Meta Commands that save time every day
  7. Inside MySQL 9.7 LTS Features
  8. MyDumper Locking Mechanisms Revisited: Introducing SAFE_NO_LOCK
  9. Running DuckDB as a MySQL 9.7 storage engine
  10. Percona Operator for MySQL 1.2.0: Cross-Site Replication, Encrypted Backups, and Automatic Storage Scaling
  11. Comparing Migration Methods from the Crunchy Data PostgreSQL Operator to the Percona Operator for PostgreSQL
  12. Why Percona Backup for MongoDB Is the Right Choice for Production Backups
  13. Still on MySQL 5.7 or 8.0? Those high-severity CVE fixes are covered

June 2026

  1. Community Docker Images: keeping the operator open without a vendor registry lock-in
  2. Debugging with Ephemeral Containers
  3. Why I haven’t run my databases on Kubernetes
  4. Skipping Percona Server for MySQL 8.4.9 and 9.7.0
  5. Security advisory: CVE-2026-9740 and CVE-2026-11933 in Percona Server for MongoDB
  6. Extending pt-archiver with a Partition-Aware Plug-in for Fast Retention Policy Enforcement
  7. Group Replication VS Percona XtraDB Cluster: The True Cost of Consistency
  8. The Failover Brownout: Rethinking High Availability in MySQL Group Replication
  9. Percona Operator for MySQL (PXC) 1.20.0: Automatic Storage Resizing, TLS Certificate Rotation, and ARM64 Support
  10. Migrating from MongoDB 6.0 to 8.0: How Percona ClusterSync Handles Cross-Version Replication

May 2026

  1. Percona Operator for PostgreSQL 3.0.0: Hard Fork, OLM Scoping, Major Upgrades
  2. Migrate from Crunchy Data PostgreSQL Operator to Percona PostgreSQL Operator: Backup-Restore and PV Reuse
  3. How Procurement Leaders Realize ROI from Open Source Databases
  4. Running TidesDB as a MySQL 9.7 storage engine
  5. Migrate from Crunchy Data PostgreSQL Operator to Percona PostgreSQL Operator: Standby Cluster Method
  6. Why Modern Finance Runs on Open Source
  7. MySQL 9.7.0 PGO Benchmark Analysis
  8. CVE-2026-8053: “We don’t use time-series” is not a mitigation
  9. Manually Migrate Hash Slots in a Valkey/Redis Cluster
  10. Not All Open Source Is Equal: Choosing a PostgreSQL Operator for Kubernetes in 2026
  11. Keeping pgBackRest Open, Healthy, and Community Driven
  12. Modern Financial Database Operations: Secure, Scalable, and Continuously Available
  13. What You’re Really Paying for With Proprietary Databases
  14. Proactive Database Performance: How to Keep Financial Systems Online and Fast
  15. Bringing pt-query-digest-Style Slow Query Analysis to PostgreSQL with pg_enhanced_query_logging
  16. PSMDB Sandbox: A Browser-Based UI for Deploying MongoDB with Terraform and Ansible
  17. I Know Kung Fu
  18. Curious case of PXC node that refused to start due to SSL
  19. Building Query Analysis and Insights Dashboard in PMM
  20. Running Databases Reliably at Scale: Reduce Operational Risk and Maintain Performance Across Hybrid Environments
  21. Run an ALTER TABLE for a huge table in Aurora

April 2026

  1. Managing Valkey Cluster in Kubernetes
  2. Continued Commitment to Percona XtraDB Cluster
  3. Troubleshooting logical replication delay made easy
  4. XtraBackup incremental prepare phase is 2x-3x faster!
  5. Orchestrator’s Next Chapter: What It Means for Percona Customers
  6. Ensuring PostgreSQL Backup Continuity: A pgBackRest Update
  7. Achieving High Availability with Valkey Sentinel
  8. Innovation From Every Corner: Inside Percona’s Build with AI Competition
  9. Scaling Your Cache: A Step-by-Step Guide to Setting Up Valkey Replication
  10. Percona Live 2026 is Back in the Bay Area — Here’s Why You Don’t Want to Miss It
  11. Impacts of updates in open-source databases
  12. Percona Operator for MySQL 1.1.0: PITR, Incremental Backups, and Compression
  13. PostgreSQL Performance: Is Your Query Slow or Just Long-Running?
  14. Deploying Cross-Site Replication in Percona Operator for MySQL (PXC)
  15. MariaDB’s Snapshot Isolation: A Fix That Breaks More Than It Fixes
  16. Why A Goat?
  17. Pipelining and Transactions in Redis and Valkey
  18. MongoDB Query Plan Cache Explained: Performance, Pitfalls, and Re-Planning
  19. Auditing Login Attempts in MySQL and MariaDB
  20. Percona ClusterSync for MongoDB 0.8.0: Up to 18x Faster Change Replication
  21. Percona Operator for PostgreSQL 2.9.0: PostgreSQL 18 Default, PVC Snapshot Backups, LDAP Support, and More!
  22. Benchmarking MyRocks vs. InnoDB in Memory-Constrained Environments

March 2026

  1. PostgreSQL: Bye-Bye MD5 Authentication. What’s Next?
  2. 2026 – MySQL Ecosystem Performance Benchmark Report
  3. Rate Limiting Strategies with Valkey/Redis
  4. What Is in pg_gather Version 33 ?
  5. How to Customize PagerDuty Custom Details in Grafana: The Hidden Override Method
  6. A Failing Unit Test, a Mysterious TCMalloc Misconfiguration, and a 60% Performance Gain in Docker
  7. Valkey and Redis Sorted Sets: Leaderboards and Beyond
  8. What Exactly Is the MySQL Ecosystem?

February 2026

  1. Security Advisory: A Series of CVEs Affecting Valkey
  2. Percona Operator for MongoDB 1.22.0: Automatic Storage Resizing, Vault Integration, Service Mesh Support, and More!
  3. A Guide to Accelerating Your Application with Valkey: Caching Database Queries and Sessions
  4. An Open Letter to Oracle: Let’s Talk About MySQL’s Future
  5. Semantic Caching for LLM Apps: Reduce Costs by 40-80% and Speed up by 250x
  6. Percona at 20: Why Our Open Source, Services-Led Model Still Works
  7. Importance of Tuning Checkpoint in PostgreSQL

January 2026

  1. Rebuilding a Replica with MyDumper
  2. Databases, Data Lakes, And Encryption
  3. Automatic "Multi-Source" Async Replication Failover Using PXC Replication Manager
  4. Back to Our Open Source Roots: Winding Down Percona ProBuilds
  5. MySQL January 2026 Performance Review
  6. Separating FUD and Reality: Has MySQL Really Been Abandoned?
  7. From Feature Request to Release: How Community Feedback Shaped PBM’s Alibaba Cloud Integration
  8. The Evolution of Redis: From Cache to AI-Database (V1.0 to 8.4)
  9. What Oracle Missed, We Fixed: More Performant Query Processing in Percona Server for MySQL, Part 2
  10. Deploying Percona Operator for MySQL with OpenTaco for IaC Automation
  11. Percona Operator for PostgreSQL 2025 Wrap Up and What We Are Focusing on Next
  12. Announcing Percona ClusterSync for MongoDB: The Open Source Trail to Freedom
  13. The Importance of Realistic Benchmark Workloads
  14. Using PXC Replication Manager to Auto Manage Both Source and Replica Failover in Galera-Based Environments
  15. Introducing OpenEverest: An Independent Open Source Project for the Future of Data Platforms
  16. Urgent Security Update: Patching "Mongobleed" (CVE-2025-14847) in Percona Server for MongoDB
  17. Good Bye Percona Everest, Hello OpenEverest!

Every year

2026 1522025 2192024 2452023 2922022 2702021 3162020 4202019 3462018 4772017 4282016 4262015 2522014 3852013 4102012 3702011 3302010 2172009 2402008 2212007 1732006 105