2021–2026

2026 152

October 2026

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

September 2026

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

August 2026

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

July 2026

1. 31 JulStored Procedures memory consumption in Percona Server for MySQL
2. 30 JulPercona Server for MongoDB 8.3 Technical Preview Is Now Available
3. 24 JulAlert on CVEs in Your Percona Tools for MongoDB on Day One
4. 23 JulPercona Operator for MongoDB 1.23.0: ClusterSync Migration, Vector Search, and PVC Snapshot Backups
5. 22 JulHow to Migrate from MySQL Galera Cluster to Percona XtraDB Cluster
6. 15 JulPostgreSQL Meta Commands that save time every day
7. 15 JulInside MySQL 9.7 LTS Features
8. 13 JulMyDumper Locking Mechanisms Revisited: Introducing SAFE_NO_LOCK
9. 10 JulRunning DuckDB as a MySQL 9.7 storage engine
10. 7 JulPercona Operator for MySQL 1.2.0: Cross-Site Replication, Encrypted Backups, and Automatic Storage Scaling
11. 7 JulComparing Migration Methods from the Crunchy Data PostgreSQL Operator to the Percona Operator for PostgreSQL
12. 2 JulWhy Percona Backup for MongoDB Is the Right Choice for Production Backups
13. 2 JulStill on MySQL 5.7 or 8.0? Those high-severity CVE fixes are covered

June 2026

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

May 2026

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

April 2026

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

March 2026

1. 27 MarPostgreSQL: Bye-Bye MD5 Authentication. What’s Next?
2. 26 Mar2026 – MySQL Ecosystem Performance Benchmark Report
3. 18 MarRate Limiting Strategies with Valkey/Redis
4. 16 MarWhat Is in pg_gather Version 33 ?
5. 13 MarHow to Customize PagerDuty Custom Details in Grafana: The Hidden Override Method
6. 12 MarA Failing Unit Test, a Mysterious TCMalloc Misconfiguration, and a 60% Performance Gain in Docker
7. 6 MarValkey and Redis Sorted Sets: Leaderboards and Beyond
8. 3 MarWhat Exactly Is the MySQL Ecosystem?

February 2026

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

January 2026

1. 29 JanRebuilding a Replica with MyDumper
2. 28 JanDatabases, Data Lakes, And Encryption
3. 27 JanAutomatic "Multi-Source" Async Replication Failover Using PXC Replication Manager
4. 26 JanBack to Our Open Source Roots: Winding Down Percona ProBuilds
5. 23 JanMySQL January 2026 Performance Review
6. 22 JanSeparating FUD and Reality: Has MySQL Really Been Abandoned?
7. 22 JanFrom Feature Request to Release: How Community Feedback Shaped PBM’s Alibaba Cloud Integration
8. 21 JanThe Evolution of Redis: From Cache to AI-Database (V1.0 to 8.4)
9. 20 JanWhat Oracle Missed, We Fixed: More Performant Query Processing in Percona Server for MySQL, Part 2
10. 16 JanDeploying Percona Operator for MySQL with OpenTaco for IaC Automation
11. 15 JanPercona Operator for PostgreSQL 2025 Wrap Up and What We Are Focusing on Next
12. 15 JanAnnouncing Percona ClusterSync for MongoDB: The Open Source Trail to Freedom
13. 14 JanThe Importance of Realistic Benchmark Workloads
14. 12 JanUsing PXC Replication Manager to Auto Manage Both Source and Replica Failover in Galera-Based Environments
15. 7 JanIntroducing OpenEverest: An Independent Open Source Project for the Future of Data Platforms
16. 6 JanUrgent Security Update: Patching "Mongobleed" (CVE-2025-14847) in Percona Server for MongoDB
17. 6 JanGood Bye Percona Everest, Hello OpenEverest!
18. 5 JanJavaScript Stored Routines in Percona Server for MySQL: A New Era for Database Programmability
19. 2 JanRunning Databases on Kubernetes: A Practical Guide to Risks, Benefits, and Best Practices

2025 219

December 2025

1. 31 DecCVE-2025-14847 (MongoBleed) — A High-Severity Memory Leak in MongoDB
2. 31 DecBuilding a Multi-Cloud Strategy: Cut Costs, Improve Resilience, and Avoid Lock-In
3. 30 DecMigrate to Freedom: Choosing a Truly Open Source PostgreSQL Operator
4. 29 DecUpdate Request! New PostgreSQL RPMs Released to Disable Debug Assertions
5. 29 DecPercona Operator for MongoDB in 2025: Making Distributed MongoDB More Predictable on Kubernetes
6. 24 DecKubernetes Operators Compared: The Key to Scalable, Cost-Efficient Databases
7. 23 DecKubernetes Multi-Cloud Architecture: Building Portable Databases Without Lock-In
8. 22 DecMemory Management in MongoDB 8.0: Testing the New TCMalloc
9. 19 DecImprove Developer Velocity with Kubernetes Databases
10. 18 DecIntroducing Percona Load Generator for MongoDB Clusters: The Benchmark Tool That Simulates Your Actual Application
11. 17 DecBridging the Gap: Querying PostgreSQL Tables from an Oracle Database
12. 16 DecManaged Database vs. Kubernetes: Taking Back Control of Your Cloud Costs and Agility
13. 15 DecPerform Point-In-Time-Recovery (PITR) in Valkey/Redis
14. 12 DecSupport for Crunchy Hardened PostgreSQL Ends Soon: Don’t Get Caught Off Guard.
15. 11 DecA Christmas Carol of Two Databases
16. 10 DecRotate SSL/TLS Certificates in Valkey/Redis Without Downtime
17. 9 DecHow to Turn a MySQL Unique Key Into a Primary Key
18. 8 DecUnlocking Secure Connections: SSL/TLS Support in Percona Toolkit
19. 5 DecCommunity Erosion Post License Change: Quantifying the Power of Open Source
20. 4 DecCloud-Native MySQL High Availability: Understanding Virtually SYNC and ASYNC Replication
21. 3 DecExpanding Our Reach: Percona Server for MongoDB Now Officially Supports Rocky Linux 8 and 9!
22. 2 DecWe Believe in Freedom
23. 1 DecImpact of Starting PostgreSQL Service Manually in an Active Patroni Cluster

November 2025

1. 26 NovLet’s Rebuild the MySQL Community Together
2. 25 NovBuilding the Future of MySQL: Announcing Plans for MySQL Vector Support and a MySQL Binlog Server
3. 24 NovAnalyzing the Heartbeat of the MySQL Server: A Look at Repository Statistics
4. 21 NovHow to Deploy a Stand-By/Ad-Hoc Cluster Based on Percona Operator for PostgreSQL
5. 20 NovPerforming Standby Datacentre Promotions of a Patroni Cluster
6. 19 NovData Retention Policy Implementation – How and Why
7. 18 NovIntroducing the GA Release of the New Percona Operator for MySQL: More Replication Options on Kubernetes
8. 14 NovA Tale of Two Databases: No-Op Updates in PostgreSQL and MySQL
9. 13 NovDistributing Data in a Redis/Valkey Cluster: Slots, Hash Tags, and Hot Spots
10. 12 NovPostgreSQL OIDC Authentication with pg_oidc_validator
11. 7 NovHow to Set Up Valkey, The Alternative to Redis
12. 6 NovPostgreSQL 13 Is Reaching End of Life. The Time to Upgrade is Now!
13. 5 NovSurprise with innodb_doublewrite_pages in MySQL 8.0.20+

October 2025

1. 31 OctHow to Configure pgBackRest Backups and Restores in PostgreSQL (Local/k8s) Using a MinIO Object Store
2. 28 OctPractical Data Masking in Percona Server for MySQL 8.4
3. 27 OctTroubleshooting PostgreSQL Logical Replication, Working with LSNs
4. 22 OctCustomizing the New MongoDB Concurrency Algorithm
5. 14 OctSecurity Advisory: CVE Affecting Percona Monitoring and Management (PMM)
6. 10 OctOpen Source Is Not Just Code: It’s Integrity
7. 9 OctA Guide to Redis Performance Best Practices
8. 7 OctCelebrating a New Chapter: Percona Welcomes Peter Farkas as its New Chief Executive Officer
9. 1 OctThe Redis License Has Changed: What You Need to Know

September 2025

1. 30 SepTackling the Cache Invalidation and Cache Stampede Problem in Valkey with Debezium Platform
2. 29 SepNew File Copy-Based Initial Sync Overwhelms the Logical Initial Sync in Percona Server for MongoDB
3. 26 SepMySQL 8.0 End of Life Support: What Are Your Options?
4. 24 SepChoosing the Right Key-Value Store: Redis vs Valkey
5. 23 SepAnnouncing OpenBao Support in Percona Server for MongoDB
6. 22 SepKeep PostgreSQL Secure with TDE and the Latest Updates
7. 18 SepHelp Shape the Future of Vector Search in MySQL
8. 17 SepMySQL with Diagrams Part Three: The Life Story of the Writing Process
9. 16 SepWhat is Percona’s Transparent Data Encryption Extension for PostgreSQL (pg_tde)?
10. 15 SepDeploying Percona Operator for MongoDB Across GKE Clusters with MCS
11. 9 SepBeyond EOL: The Real Benefits of Upgrading to MySQL 8.4
12. 8 SepSwimming with Sharks: Analyzing Encrypted Database Traffic Using Wireshark

August 2025

1. 28 AugIt’s End of Life for Redis Enterprise 7.2 in Six Months – What Are Your Options?
2. 26 AugValkey 9.0: Enterprise-Ready, Open Source, and Coming September 29, 2025
3. 25 AugDon’t Trust, Verify: How MyDumper’s Checksums Validates Data Consistency
4. 22 AugMySQL 8.0 Deprecated Features: What You Need to Know
5. 21 AugMySQL Router 8.4: How to Deal with Metadata Updates Overhead
6. 20 AugDeep Diving the Citus Distribution Models Along with Shard Balancing/Read Scaling
7. 19 AugSecure, Centralized Authentication Comes to Percona Server for MongoDB with OpenID Connect
8. 14 AugTop 5 Security Risks of Running MySQL 8.0 After Its EOL
9. 13 AugWebinar Q&A: No More Workarounds: Open Source PostgreSQL TDE Is Here
10. 7 AugLDAP Isn’t Going Away, and Neither Is Our Support for Percona Server for MongoDB
11. 6 AugMySQL 8.0 End of Life Date: What Happens Next?
12. 5 AugPlanning Ahead for PostgreSQL 18: What Matters for Your Organization
13. 4 AugIntegrating Citus with Patroni: Sharding and High Availability Together
14. 2 AugEnhancing PostgreSQL Security: How to Encrypt the pgBackRest Repository
15. 2 AugPostgreSQL Database Security: External Server-Based Authentication

July 2025

1. 31 JulSecurity Advisory: CVE Impacting Percona Monitoring and Management (PMM)
2. 31 JulScalability for the Large-Scale: File Copy-Based Initial Sync for Percona Server for MongoDB
3. 30 JulA Practical Guide to PostgreSQL Replication with Both Asynchronous and Synchronous Standbys
4. 29 JulDisaster Recovery for PostgreSQL on Kubernetes
5. 28 JulHow to Perform Rolling Index Builds with Percona Operator for MongoDB
6. 28 JulPublic Schema Security Upgrade in PostgreSQL 15
7. 24 JulIntroduction to Data Importers in Percona Everest
8. 23 JulThe Quirks of Index Maintenance in Open Source Databases
9. 22 JulDiagnosing MySQL Crashes on RHEL with GDB: How to Identify the Database, Table, and Query Involved
10. 21 JulUsing replicaSetHorizons in MongoDB
11. 18 JulHow Can AI Talk to My Database Part Two: MySQL and Gemini
12. 17 JulHow Can AI Talk to My (PostgreSQL) Database?
13. 14 JulMyDumper Refactors Locking Mechanisms
14. 14 JulRunning PostgreSQL on Kubernetes: High Availability, Scaling, and Disaster Recovery
15. 13 JulRun PostgreSQL in Kubernetes: Solutions, Pros and Cons
16. 11 JulPostgreSQL Backup and Restore 101: For Non-Postgres DBAs
17. 10 JulWorking with Geospatial Data? PostGIS Makes PostgreSQL Enterprise-Ready
18. 8 JulTransparent Data Encryption: The Best Way to Secure Your Data in PostgreSQL
19. 7 JulDeploying MongoDB Test Environments with Terraform and Ansible
20. 5 JulEnabling and Enforcing SSL/TLS for PostgreSQL Connections
21. 3 JulA Tale of Two Databases: How PostgreSQL and MySQL Handle Torn Pages
22. 2 JulTesting ReadySet as a Query Cacher for PostgreSQL (Plus ProxySQL and HAproxy) Part 2: Test Results
23. 1 JulTesting ReadySet as a Query Cacher for PostgreSQL (Plus ProxySQL and HAproxy) Part 1: How-To
24. 1 JulMigrating PostgreSQL to Kubernetes

June 2025

1. 30 JunThe PG_TDE Extension Is Now Ready for Production
2. 29 JunBootstrap PostgreSQL on Kubernetes
3. 27 JunManaging PostgreSQL on Kubernetes with Percona Everest’s REST API
4. 26 JunPercona XtraDB Cluster: Our Commitment to Open Source High Availability
5. 26 JunScaling Smarter: What You Have Missed in MongoDB 8.0
6. 25 JunUsing Percona Everest Operator CRDs to Manage Databases in Kubernetes
7. 24 JunOpen Wins Again II: From Fork to Force
8. 24 JunReducing PostgreSQL Costs in the Cloud
9. 20 JunMySQL Orchestrator Failover Behavior During Replication Lag
10. 19 JunLooking Ahead: A Confident New Chapter for Percona
11. 17 JunPercona Software for MongoDB Release Plan Updates
12. 16 JunIntegrating Repmgr with Barman: Managing Backups During Switchovers
13. 16 JunUsing MERGE To Make Your PostgreSQL More Powerful
14. 13 JunPercona Earns Kubernetes Certified Services Provider Status for All Three Major Open Source Databases
15. 11 JunStorage Strategies for PostgreSQL on Kubernetes
16. 10 JunA Practical Guide to PostgreSQL Indexes
17. 10 JunPercona Named to DBTA’s 2025 List of 100 Companies That Matter Most in Data
18. 9 JunHow to Perform a Disaster Recovery Switchover with Patroni for PostgreSQL
19. 6 JunPgBouncer for PostgreSQL: How Connection Pooling Solves Enterprise Slowdowns
20. 5 JunIntroducing Experimental Support for Stored Programs in JS in Percona Server for MySQL
21. 4 JunPostgreSQL Security Missteps and Tips
22. 2 JunUnderstanding the Client-Output Buffer Limit for Replicas in Valkey
23. 1 JunPostgreSQL Backup Strategies for Enterprise-Grade Environments

May 2025

1. 29 MayHow to Safely Upgrade InnoDB Cluster From MySQL 8.0 to 8.4
2. 28 MayThe Open Source Ripple Effect: How Valkey Is Redefining the Future of Caching, and Why It Matters
3. 27 MayBeyond Guesswork: Enterprise-Grade PostgreSQL Tuning with pg_stat_statements
4. 23 MayWhat Oracle Missed, We Fixed: More Performant Query Processing in Percona Server for MySQL
5. 20 MayInnoDB Cluster: Set Up Router and Validate Failover
6. 19 MayAn Introduction to Dictionary Operations in Data Masking Component
7. 16 MayFreedom and Flexibility: Rethinking Your MongoDB Cloud Strategy Beyond Atlas
8. 15 MayNew in Percona Everest 1.6.0: Easily Deploy PMM with a Single Helm Command
9. 14 MayConfiguring PgBouncer auth_type with Trust and HBA: Examples and Known Issues
10. 12 MayInnoDB Cluster Setup: Building a 3-Node High Availability Architecture
11. 9 MayPatroni: The Key PostgreSQL Component for Enterprise High Availability
12. 8 MayDeploying External Read Replica in MySQL InnoDB Cluster
13. 6 MayMongoDB Benchmarking Made Effortless With Workload Generator for MongoDB
14. 2 MayMongoDB Operators Explained: Features, Limitations, and Open Source Alternatives

April 2025

1. 30 AprUseful PostgreSQL Index Maintenance Queries to Improve Performance
2. 30 AprBenchmarking PostgreSQL: The Hidden Cost of Over-Indexing
3. 25 Aprpgvector: The Critical PostgreSQL Component for Your Enterprise AI Strategy
4. 25 AprHow to Upgrade PostgreSQL Extensions (Without Breaking Anything)
5. 23 AprDoes FCV Have Any Impact on MongoDB Performance?
6. 22 AprBehind the Scenes: How Percona Support Diagnosed a MongoDB FTDC Freeze
7. 21 AprSpeeding Up Percona XtraDB Cluster State Transfers with Kubernetes Volume Snapshots
8. 18 AprRun PostgreSQL on Kubernetes: A Practical Guide with Benchmarks and Best Practices
9. 17 AprWhat’s New in MySQL 8.4 LTS: Key Enhancements Explained
10. 16 AprHow to Extend Percona Monitoring and Management to Add Logging Functionality
11. 15 AprPercona Server for MySQL Data Masking Enhanced with Dictionary Term Cache
12. 15 AprAvoiding PostgreSQL Upgrade Errors: A Practical Guide
13. 14 AprMongoDB Pricing Explained: What You’re Really Paying For
14. 9 AprPercona Server for MySQL: Enhanced Encryption UDFs
15. 5 AprTroubleshooting 10 of the Most Common PostgreSQL Errors
16. 5 AprThe PostgreSQL Migration Playbook: What to Plan, Avoid, and Expect
17. 5 AprWhy PostgreSQL NULL Values Break Your Queries (And How to Fix Them)
18. 3 Apr4 Ways to Convert MongoDB BSON to JSON Format
19. 2 AprEssential MongoDB Backup Best Practices for Data Protection
20. 2 AprHow to Migrate From MariaDB to MySQL
21. 2 AprWhat is PostgreSQL? Key Features, Benefits, and Real-World Uses
22. 1 AprChoosing the Right Storage for PostgreSQL on Kubernetes: A Benchmark Analysis
23. 1 AprKubernetes Sidecar Containers Explained: Benefits, Use Cases, and What’s New
24. 1 AprIs MongoDB Truly Open Source? A Critical Look at SSPL
25. 1 AprPostgreSQL Security: A Comprehensive Guide to Hardening Your Database
26. 1 AprPostgreSQL Performance Tuning Guide: Settings That Make a Difference
27. 1 AprHow to Run MongoDB on Kubernetes: Solutions, Pros and Cons

March 2025

1. 28 MarTransparent Data Encryption for PostgreSQL Release Candidate is Here!
2. 26 MarEnhancing Keyhole: Pulling More Metrics from MongoDB’s FTDC
3. 24 MarPercona XtraBackup 8.4 Pro: Reduce Server Locking by up to 4300X
4. 20 MarPercona Monitoring and Management 2: Clarifying the End-of-Life and Transition to PMM 3
5. 19 MarMongoDB Atlas On-Premise: Challenges and Flexible Alternatives
6. 19 MarTroubleshooting Common MySQL Performance Issues
7. 18 MarMigrating from MySQL to PostgreSQL Using pgloader: A Practical Guide
8. 18 MarThe Percona Perspective: A Vision for the Future of Open Source Databases in the Age of AI
9. 17 MarPercona Server for MySQL 8.4.2 vs 8.0.40: Comparison of Variables and Keywords
10. 14 MarEnterprise Readiness with Percona Monitoring and Management: A Look at PMM 3.0.0
11. 13 MarUsing Barman Cloud Utilities for Backups and WAL Archiving in PostgreSQL
12. 12 MarHAProxy-Patroni Setup Using Health Check Endpoints and Debugging
13. 11 MarReady for the Enterprise: New Solution Updates from Percona
14. 10 MarExtending MySQL 5.7: Percona Releases Post-End-of-Life Source Code to the Community
15. 8 MarMongoDB 101: Tuning WiredTiger Cache After a Memory Upgrade
16. 7 MarAchieving PostgreSQL High Availability: Strategies and Setup Guide
17. 6 MarSimplify Valkey Adoption with Percona Support and Services
18. 6 MarEasy Way to Provision a PostgreSQL Cluster on Kubernetes
19. 4 MarMongoDB Partitioning: Best Practices for Scalability and Performance
20. 3 MarWhy Companies Are Saying No to Proprietary Software, Including MongoDB
21. 3 MarCompression Methods in MongoDB: Snappy vs. Zstd
22. 3 MarAutomating MongoDB Log Rotation
23. 3 MarMySQL 101: How to Find and Tune a Slow MySQL Query
24. 1 MarInnoDB Performance Optimization Basics
25. 1 MarEssential Guide to the PostgreSQL VACUUM Command for Performance
26. 1 MarWhy Enterprises are Choosing PostgreSQL (And What They Wish They Knew Sooner)
27. 1 MarA Tutorial on MongoDB Sharding Best Practices & When To Enable It
28. 1 MarMongoDB Docker Installation: Everything You Need to Know
29. 1 Mar5 Effective Strategies for MongoDB Performance Tuning

February 2025

1. 27 FebPostgreSQL Upgrade Using pg_dump/pg_restore: A Step-by-Step Guide
2. 26 FebUsing VS Code and Docker to Debug MySQL Crashes
3. 24 FebUnderstanding trx-consistency-only on MyDumper Before Removal
4. 18 FebAlternatives to MongoDB Atlas: More Control, Lower Costs
5. 14 FebOrchestrator (for Managing MySQL) High Availability Using Raft
6. 13 FebSizing the Replication Backlog Buffer for Valkey
7. 12 FebConsidering Alternatives for Your MySQL Migration? Why Percona Should Be Your First Choice
8. 11 FebSecurity Advisory: CVE Affecting Percona Monitoring and Management (PMM)
9. 7 FebEncrypt PostgreSQL Data at Rest on Kubernetes
10. 4 FebMongoDB 8.0 Performance; Does It Live Up to the Hype?
11. 3 FebMongoDB – Converting Replica Set to Standalone
12. 2 FebMongoDB Indexes Explained: A Comprehensive Guide to Better MongoDB Performance
13. 1 FebHow to Generate an Ansible Inventory with Terraform
14. 1 FebMySQL Performance Tuning: Maximizing Database Efficiency and Speed

January 2025

1. 22 JanPostgreSQL Database Security Best Practices
2. 22 JanUsing Blue/Green Deployment For (near) Zero-Downtime Primary Key Updates in RDS MySQL
3. 21 JanNavigating MongoDB Licensing Challenges: Why Percona is a Game-Changer
4. 17 JanWhat’s the Cost of Counting MySQL Table Rows?
5. 16 JanPercona Everest: An Open Source Solution for MongoDB Sharding and Backups
6. 14 JanWhat Hurts in PostgreSQL Part One: Temporary Tables
7. 13 JanPostgreSQL vs. the Cloud for GenAI? 4 Things to Consider
8. 11 JanEffective PostgreSQL Monitoring: Key Metrics and Tools
9. 10 JanPrevent Encryption Key Loss When Using Percona Server for MongoDB with HashiCorp’s Vault
10. 9 JanYour Data’s Not Safe Until It’s TDE-Safe — Here’s How
11. 8 JanAttaching a Percona Monitoring and Management Graph Image Along with an Alerting Notification
12. 7 JanMySQL with Diagrams Part Two: How KILL Works
13. 6 JanMySQL 8.4.3 and 9.1.0: Major Performance Gains Revealed
14. 3 JanDebugging a Binary Data Oplog Replay Issue in MongoDB
15. 2 JanHow to Replace Patroni and Etcd IP/Host Information in PostgreSQL
16. 1 JanMySQL High CPU Usage: Effective Troubleshooting Methods

2024 245

December 2024

1. 20 DecMySQL Transaction ERROR 1412 and Isolation Levels
2. 19 DecPercona XtraBackup 101: Decompress and Decrypt or Decrypt and Decompress?
3. 19 DecPercona Wins 2024 Digital Innovator Award from Intellyx
4. 18 DecHow To Deal with a AUTO_INCREMENT Max Value Problem in MySQL and MariaDB
5. 17 DecPercona Server for MongoDB 8.0: The Most Performant Ever
6. 13 DecSoftware Licensing and Open Source: Why Definitions Matter
7. 12 DecMySQL with Diagrams Part One: Replication Architecture
8. 10 DecHow to Get Useful Information Out of Valkey/Redis Keys
9. 9 DecPerforming ELT Operations Using DOMAINs
10. 4 DecThe Evolution of Stateful Applications in Kubernetes
11. 3 DecWho Ate My MySQL Table Rows?
12. 2 DecChecking Index Consistency on a Sharded Cluster in MongoDB

November 2024

1. 19 NovUsing Loki and Promtail to Display PostgreSQL Logs From a Kubernetes Cluster in PMM
2. 18 NovPostgreSQL 12 End of Life: Upgrade Now with Percona
3. 14 NovExploring Kubernetes CPU Resources in View of Percona XtraDB Cluster’s Flow Control
4. 12 NovAlternatives to Cloud DBaaS: What to Look For
5. 6 NovAn Elephant in the Cluster: Making PostgreSQL Feel at Home on Kubernetes
6. 5 NovValkey/Redis Key-Specific Dump, Restore, and Migration
7. 4 NovExposing PostgreSQL with NGINX Ingress Controller
8. 1 NovHow Can MySQL Catch Up with PostgreSQL’s Momentum?

October 2024

1. 31 OctTracking Dual Passwords in MySQL
2. 30 OctPercona Backup for MongoDB and Disk Snapshots in Amazon AWS – Part 2
3. 29 OctMigrate from Redis to Valkey Without Downtime
4. 28 OctAbandonware in Popular Open Source Databases
5. 24 OctRedis Users Want a Change
6. 23 OctOpen Source and Flawed Foundations
7. 21 OctPercona Backup for MongoDB and Disk Snapshots in Amazon AWS
8. 15 OctPercona Backup for MongoDB and Disk Snapshots in Google Cloud Platform – Part 2
9. 5 OctUpgrade MySQL to 8.0? Yes, but Avoid Disaster!
10. 2 OctPercona Backup for MongoDB and Disk Snapshots in Google Cloud Platform

September 2024

1. 30 SepMongoDB: New Balancer Policy and Automerger
2. 26 SepDealing with a ‘DatabaseVersion.timestamp’ Error After a MongoDB Upgrade
3. 25 SepHow Network Splits/Partitions Impact Group Replication in MySQL
4. 23 SepUnderstanding MySQL Indexes: Types, Benefits, and Best Practices
5. 17 SepMySQL 8.0 vs. 5.7: Are the Newer Versions More Problematic?
6. 16 SepIntroducing RHEL9-Certified Builds for Percona MySQL: Ensure Maximum Compatibility and Compliance
7. 13 SepAll UUID Functions in Percona Server for MySQL: RFC 9562 Implemented
8. 12 SepSimplify User Management with Percona Operator for MongoDB
9. 11 SepMongoDB: High Availability Topology for a Multi-Region Setting
10. 10 SepHow to Migrate a Production Database to Percona Everest (MySQL) Using Clone
11. 9 SepMongoDB Performance Regression Benchmarking and the Truth Behind Journaling
12. 6 SepPostgreSQL Internals for Newbies: A Guide to Data Storage, Part One
13. 5 SepHow to Upgrade a Kubernetes Cluster
14. 4 SepPercona In-Product Telemetry: Updates, Findings, and News
15. 3 SepWhat are Kubernetes Pods? A Deep Dive

August 2024

1. 30 AugWhen Warnings Deceive: The Curious Case of InnoDB’s Row Size Limitation
2. 27 AugImportant Notice: Update Process for Percona Monitoring and Management 2.38 and Earlier
3. 26 AugPercona Server for MySQL Performance Improvements – August 2024
4. 23 AugAddressing Data Size Differences in MongoDB Replica Set Nodes
5. 20 AugHow to Run Percona Toolkit in Kubernetes
6. 19 AugWhy You Should Consider an External Replica for Your Cloud Environment
7. 15 AugThe Making of an Open Source PostgreSQL TDE Extension
8. 14 AugEffective Strategies for Recovering MySQL Group Replication From Failures
9. 13 AugSolving pg_upgrade and lc_collate Mismatch Issues in PostgreSQL
10. 12 AugHow to Build a PostgreSQL Patch Test Environment on Ubuntu 22.04
11. 9 AugImprove the Security of a Percona Server for MongoDB Deployment with KMIP Key State Polling
12. 8 AugMySQL Router and RestAPI – What Do They Have in Common?
13. 7 AugOpen Source AI Database Agent Part 2: OSADA
14. 6 AugDispelling Myths About PostgreSQL Default Privileges
15. 5 AugOpen Source AI Database Agent Part 1: Introduction
16. 5 AugHow to Upgrade MongoDB Using Backups Through Many Major Versions
17. 2 AugUpdate Your Percona Release Repository (Or Start Using It!)

July 2024

1. 25 JulSevere Instability of MySQL 8.0.38, 8.4.1 and 9.0 Resolved in Upcoming Releases
2. 22 JulOnline Schema Changes on Tables with Foreign Keys in MySQL
3. 19 JulMySQL 9.0 Includes a New Option for Explaining Queries
4. 19 JulHow to Monitor Valkey/Redis with Percona Monitoring and Management
5. 18 JulHow to Have a Single MySQL User Account From Specific Hosts
6. 17 JulUsing Compact in Percona Server for MongoDB From Version 4.4+
7. 17 JulAn Enterprise-Grade MongoDB Alternative Without Licensing or Lock-in
8. 17 JulUltimate Guide to Improving MySQL Query Performance
9. 16 JulNo MySQL 9.x Innovation Releases from Percona
10. 15 JulUsing pt-online-schema-change for Purging Rows and Reclaiming Disk Space in a Single Operation
11. 15 JulPercona Server for MySQL and Percona XtraBackup Now Available for ARM64
12. 12 JulUsing the Percona Audit Logging Plugin on MySQL Community 8.0.x
13. 11 JulDo Not Upgrade to Any Version of MySQL After 8.0.37
14. 10 JulDeploying MongoDB on Kubernetes with Percona Everest
15. 10 JulThe Powerful Features Released in PostgreSQL 17 Beta 2
16. 9 JulMyLoader Is Now Importing at Full Speed
17. 8 JulAutomated Major Version Upgrades in Percona Operator for PostgreSQL
18. 8 JulEnsure the Correct Repositories are Enabled for Percona Packages
19. 3 JulEasy Guide to Switching PostgreSQL Physical Replication to Logical Replication with pg_createsubscriber
20. 3 JulIntroducing Percona Everest: Revolutionizing Cloud-Native Database Management
21. 2 JulSee What’s Inside a WAL File Using pg_waldump and pg_walinspect
22. 2 JulMySQL 9.0 Community Edition: A Quick Peek
23. 1 JulHow to Remove an Orphan Large Object in PostgreSQL With Vacuumlo
24. 1 JulConfiguring Percona Backup for MongoDB in a Multi-Instances Environment

June 2024

1. 28 JunWhy Are Queries with Many IN Values More Expensive After Upgrading to MySQL 8.x?
2. 27 JunAdding TLS to LDAP Authentication in Percona Operator for MongoDB
3. 26 JunMySQL Performance Monitoring: Best Practices
4. 25 JunMySQL Replication: How To Deal With the ‘Got Fatal Error 1236’ or MY-013114 Error
5. 25 JunExploring the is_template Flag: Simplifying PostgreSQL Template Databases
6. 24 JunUnderstanding Basic Flow Control Activity in MySQL Group Replication: Part One
7. 24 JunUpgrading to the New Etcd Version From 3.3 for Patroni
8. 19 Juneu-stack Support and Other Improvements in pt-pmp of Percona Toolkit
9. 18 JunPartial Data Archiving and Schema Change
10. 18 JunHow to Run Percona Everest Locally in a Dev Environment From Source
11. 18 JunIs Your Database Ready for Black Friday?
12. 17 JunCan Oracle Save MySQL?
13. 14 JunResume Your Failed pt-online-schema-change Job
14. 13 JunSakila, Where Are You Going?
15. 12 JunWhat’s New in Percona Toolkit 3.6.0
16. 12 JunGCache and Record-Set Cache Encryption in Percona XtraDB Cluster – Part Two
17. 11 JunImportant Update: Streamlined Repository Management for Improved Efficiency
18. 10 JunIs Oracle Finally Killing MySQL?
19. 7 JunGCache and Record-Set Cache Encryption in Percona XtraDB Cluster – Part One
20. 6 JunEnd of Life Alert: CentOS 7 and Debian 10 Approaching EOL
21. 5 JunAdministering a Patroni Managed PostgreSQL Cluster
22. 4 JunDownsampling Metrics in Percona Monitoring and Management: Saving Space and Improving Performance
23. 3 JunControlling Resource Consumption on a PostgreSQL Server Using Linux cgroup2
24. 3 JunKeeping an Eye on the Eye: Self-Monitoring for Percona Monitoring and Management
25. 1 JunSQLJoins: A Quick But Comprehensive Guide

May 2024

1. 30 MayPostgreSQL 17: Two Small Improvements That Will Have a Major Impact
2. 30 MayAnnouncing ARM Support in Percona Operator for MongoDB
3. 29 MayValkey/Redis: Setting Up Replication
4. 29 MayBeyond The Horizon: Mastering Percona Server for MongoDB Exposure in Kubernetes – Part Two – Istio
5. 28 MayValkey/Redis Sharding Using the Native Clustering Feature
6. 28 MayBeyond the Horizon: Mastering Percona Server for MongoDB Exposure in Kubernetes – Part One
7. 24 MayValkey/Redis: Migrating to Valkey
8. 24 MayUpcoming Percona University Events – France, Germany, and India
9. 23 MayBeyond Cloud: The Impact of AI Agents on Platform Engineering
10. 22 MayAre Your Backups Able to Pass the Unisuper Test?
11. 21 MayHigh Availability: Choosing the Right Option for Your Percona Monitoring and Management
12. 20 MayNew Valkey Packages by Percona
13. 20 MayCan We Set up a Replicate Filter Within the Percona XtraDB Cluster?
14. 16 MayValkey/Redis: Not-So-Good Practices
15. 16 MayChoosing the Right Database: MariaDB vs. MySQL, PostgreSQL, and MongoDB
16. 15 MayValkey/Redis: Configuration Best Practices
17. 14 MayValkey/Redis: The Hash Datatype
18. 13 MayValkey/Redis Replication and Auto-Failover With Sentinel Service
19. 13 MaySeamless Table Modifications: Leveraging pt-online-schema-change for Online Alterations
20. 9 MayValkey/Redis: Sets and Sorted Sets
21. 9 MaySecuring Your MySQL Database: Essential Best Practices
22. 8 MayTroubleshooting PostgreSQL on Kubernetes With Coroot
23. 8 MayMastering Database Monitoring: Running PMM in High Availability Mode
24. 7 MaySpeed Up Repetitive PostgreSQL Statements With gexec
25. 7 MayHello World… Hello Valkey! Let’s Get Started!
26. 6 MayValkey/Redis Configurations and Persistent Setting of the Key Parameters
27. 6 MaySecuring Your MongoDB Database: Essential Best Practices
28. 1 MayMySQL 8.4 First Peek

April 2024

1. 30 AprLDAP Authentication in PgBouncer Through PAM
2. 30 AprRedis, Valkey, and Percona’s Ongoing Support of Open Source
3. 26 AprTrying out the PostgreSQL pg_tde Tech Preview Release
4. 26 AprBenchmarking MongoDB Performance on Kubernetes
5. 24 AprBringing Percona Experts to a City Near You
6. 23 AprWhy MariaDB Is "Better" Than MySQL
7. 19 AprDid MyDumper LIKE Triggers?
8. 18 AprShould You Deploy Your Databases on Kubernetes? And What Makes StatefulSet Worthwhile?
9. 18 AprHow to Improve Database Performance: The Ultimate Guide
10. 17 AprSwitch PostgreSQL Environments Across AWS, GCP, and k3d Using Kubernetes Contexts
11. 16 AprPercona Stands Firmly on the Side of Open Source
12. 16 AprA Guide to Better Understanding MySQL Charset Levels
13. 15 AprWhy SELECT COUNT(*) FROM TABLE Is Sometimes Very Slow in MySQL or MariaDB
14. 12 AprPartially Rolling Back a Transaction in MySQL or PostgreSQL
15. 11 AprJSON_TABLE() Will Be in PostgreSQL 17
16. 11 AprHow to Replicate and Rename a Database in MariaDB
17. 10 AprMongoDB 4.4 EOL with 5.0 Not Far Behind
18. 10 AprPercona Monitoring and Management Setup on Kubernetes with NGINX Ingress for External Databases
19. 9 AprAsk Me Anything About MySQL 5.7 to 8.0 Post EOL
20. 9 AprProtect Your PostgreSQL Database with pg_tde: Safe and Secure
21. 5 AprQuerying Percona Operator for MongoDB Logs Using LogCLI
22. 4 AprPercona Backup for MongoDB: Restore a Single Collection From Backup
23. 3 AprForeign Data Wrappers in PostgreSQL Databases (postgres_fdw & dblink)
24. 3 AprMongoDB Log and the Message "RSM Not Processing Response"
25. 2 AprPostgreSQL for MySQL DBAs Second Edition Is Now Available
26. 2 AprHow to Find Duplicate, Unused, and Invisible Indexes in MySQL
27. 2 AprFive Reasons Why WAL Segments Accumulate in the pg_wal Directory in PostgreSQL
28. 2 AprHow to Use MySQL Performance Schema to Troubleshoot and Resolve Server Issues
29. 2 AprMySQL Performance Monitoring and Key Performance Indicators (KPI) With PMM
30. 1 Aprcaching_sha2_password Support for ProxySQL Is Finally Available!
31. 1 AprPercona pg_tde Project Keyring Options
32. 1 AprMySQL Configuration Steps: Easily Validate Configuration Settings in MySQL 8
33. 1 AprPostgreSQL Indexes Can Hurt Performance: Exploring the Negative Effects and the Costs Involved
34. 1 AprPostgreSQL Partitioning Using Traditional Methods
35. 1 AprPostgreSQL: Pgpool-II Use Cases and Benefits
36. 1 AprHow to Set and Tune Autovacuum Settings in PostgreSQL to Avoid Performance Issues

March 2024

1. 29 MarA MyLoader Error You Might Face When Restoring Databases
2. 28 MarHow Missing Primary Keys Break Your Galera Cluster
3. 28 MarPercona’s PostgreSQL pg_tde Extension: March Update
4. 27 MarEnhancing PostgreSQL Insights with Percona Monitoring and Management: A Closer Look at Recent Updates
5. 27 MarUsing PAM with SASL in Percona Server for MongoDB
6. 26 MarCopying Alert Rules From One Percona Monitoring and Management Server to Another
7. 26 MarWhy Your Next MySQL Database Should Not Be a MySQL Database
8. 25 MarStages of Index Build in MongoDB
9. 25 MarBest Practices for Database Security
10. 22 MarHow Can I Take a Backup of Configuration Files in PostgreSQL?
11. 21 MarBoosting IT Productivity: The Crucial Role of ITIL Knowledge for DBAs
12. 21 MarEnable Data Checksums With Minimum Downtime in PostgreSQL
13. 20 MarPostgreSQL Monitoring with Percona Monitoring and Management: A Redefined Summary
14. 20 MarDo You Leverage Index-Only Scans in PostgreSQL? Do You Want To?
15. 19 MarPercona Monitoring and Management Database Overview Dashboard, Simplified
16. 18 MarPercona XtraBackup 8.0.28 Supports Encrypted Table Backups with AWS KMS
17. 14 MarThe Challenge with Open Core Software
18. 14 MarAnalyzing Slow Queries After MongoDB 4.4
19. 13 MarUsing Percona Backup for MongoDB in Replica Set and Sharding Environments: Part Two
20. 12 MarManaging Time Series Data Using TimeScaleDB-Powered PostgreSQL
21. 11 MarPercona Operator for MySQL Now Supports Automated Volume Expansion in Technical Preview
22. 7 MarThe Pain of AWS EKS and Stateful Workloads
23. 5 MarHelp Us Improve MySQL Usability and Double Win!
24. 5 MarPercona Backup for MongoDB 2.4.0: New User-Driven Improvements
25. 4 MarPercona Operator for PostgreSQL is Red Hat OpenShift Certified

February 2024

1. 29 FebTransform Cloud-Native Database Management With Percona Everest, Now in Beta
2. 26 FebIs Linkerd Open Source?
3. 22 FebBacking up and Restoring to AWS S3 With Percona Kubernetes Operators
4. 21 FebUsing Percona Backup for MongoDB in Replica Set and Sharding Environments: Part One
5. 21 FebSecuring Percona Everest with Ingress and Cert-Manager
6. 20 FebExploring the Kubernetes Application Lifecycle With Percona
7. 15 FebUnderstanding Cloud-Native Databases: An In-Depth Guide
8. 13 FebPostgreSQL Column Alignment and Padding – How To Improve Performance With Smarter Table Design
9. 9 FebCan Disk Space Be Saved in MySQL by Adding a Primary Key?
10. 8 FebWhy Migrating to Open Source is Essential to Your Business Growth
11. 7 FebDecoupling Backup and Expiry Operations in PostgreSQL With pgBackRest
12. 6 FebMySQL 8.2.0 Community vs. Enterprise; Is There a Winner?
13. 6 FebAre Your MySQL Users Using ‘password’ or ‘thebossisajerk’ as Passwords?
14. 5 FebFive Notable Changes in Percona Everest Alpha
15. 5 FebPercona Monitoring and Management 2.41.1, Percona Distribution for MongoDB 7.0.5: Release Roundup February 5, 2024
16. 2 FebConsidering a MongoDB Migration? Why Percona Should Be Your First Choice
17. 2 FebWhat is Transparent Data Encryption (TDE)? The Ultimate Guide
18. 2 FebSegmentation Fault – A DBA Perspective
19. 1 FebSimplify the Use of ENV Variables in Percona Monitoring and Management AMI
20. 1 FebIn Search of Transparency at FOSDEM
21. 1 FebUnderstanding Replication in PostgreSQL – How to Set Up PostgreSQL Streaming Replication
22. 1 FebMySQL vs PostgreSQL: Key Features and Use Cases
23. 1 FebChoosing the Best MySQL High Availability Solution: 20 Key Questions and Considerations

January 2024

1. 31 JanMySQL Table Size Is Way Bigger After Adding a Simple Index; Why?
2. 30 JanPG_TDE Update: Percona’s Project to Add Transparent Data Encryption to PostgreSQL
3. 30 JanMaster PostgreSQL Upgrades: The Ultimate Checklist
4. 29 JanPercona PG_TDE and Ubuntu: Please Test Transparent Data Encryption for PostgreSQL
5. 26 JanPercona PG_TDE and Docker: Please Test Transparent Data Encryption for PostgreSQL
6. 25 JanDecoding Sequential Scans in PostgreSQL
7. 24 JanAn Introduction to Vector Databases
8. 22 JanPercona Distribution for MongoDB 4.4.27, Updates to Percona Distribution for PostgreSQL, : Release Roundup January 22, 2024
9. 18 JanSyscalls Analysis in MySQL When Using innodb_flush_method and innodb_use_fdatasync
10. 17 JanQuick Peek: MySQL 8.0.36 and 8.3
11. 12 JanCan’t We Assign a Default Value to the BLOB, TEXT, GEOMETRY, and JSON Data Types?
12. 11 JanIs MySQL Router 8.2 Any Better?
13. 9 JanCreate an AI Expert With Open Source Tools and pgvector
14. 9 JanHow to Use Group Replication with Haproxy
15. 8 JanThe Underlying Importance of the server_id Parameter
16. 8 Jan16 Updates and Releases to Start the New Year! Roundup January 8, 2024
17. 5 JanConfiguring Keyring for Encryption Using AWS Key Management Service in Percona Server for MySQL
18. 4 JanMySQL General Tablespaces: A Powerful Storage Option for Your Data
19. 3 JanPMM Dump GUI in Percona Monitoring and Management 2.41.0
20. 3 JanThe Various Methods to Backup and Restore ProxySQL
21. 2 JanIs Thread Pool Plugin the Right Choice for Your Workload?
22. 2 JanAudit DROP Statements in Percona Server for MySQL

2023 292

December 2023

1. 29 DecHuman Factors Behind Incidents: Why Settings Like "idle_session_timeout" Can Be a Bad Idea
2. 28 DecIntroducing the MySQL Audit Log Filter Plugin
3. 27 DecCloud Native Predictions for 2024
4. 26 DecGrafana Dashboards: A PoC Implementing the PostgreSQL Extension pg_stat_monitor
5. 22 DecWhat’s New in Percona Toolkit 3.5.6
6. 22 DecThe Pros and Cons of Wildcard Indexes on MongoDB
7. 21 DecPercona Monitoring and Management High Availability – A Proof of Concept
8. 20 DecUsing Huge Pages with PostgreSQL Running Inside Kubernetes
9. 20 DecHow to Monitor Online InnoDB Buffer Pool Resizing
10. 19 DecUsing the Transparent Data Encryption Extension PG_TDE With PostgreSQL
11. 19 DecSetting Up Percona Monitoring and Management Alerts for External Channels (Telegram, Slack, WebHook)
12. 18 DecPercona Monitoring and Management 2.41.0, Percona Distribution for PostgreSQL 14.10, and More: Release Roundup December 18, 2023
13. 15 DecExploring the Improved CREATEROLE Attribute for User Management in PostgreSQL 16
14. 14 DecHow to Convert PostgreSQL Streaming Replication to Logical Replication
15. 14 DecCan You Trust AI Chatbots When Seeking Help With Databases?
16. 13 DecExploring MySQL 8 Priority-Based Error Log Filtering
17. 12 DecHow to Use Percona Toolkit’s pt-table-sync for Replica Tables With Triggers in MySQL
18. 11 DecMaximizing Performance of AWS RDS for MySQL with Dedicated Log Volumes
19. 8 DecKeepalived for Source Failover: Percona XtraDB Cluster to Percona Server for MySQL
20. 7 DecBackup Mastery: Running Percona XtraBackup in Docker Containers
21. 7 DecHow to Filter or Customize Alert Notifications in Percona Monitoring and Management (Subject and Body)
22. 6 DecMySQL Interview Questions: Wrong Answers Only
23. 6 DecPMM Dump: A New Tool to Support Percona Customers
24. 5 DecThe Magic of PITR, pg_upgrade, and Logical Replication When Used Together for PostgreSQL Version Upgrades
25. 4 DecPercona Distribution for PostgreSQL 16.1, Percona Distribution for MySQL 8.1.0: Release Roundup December 4, 2023
26. 1 DecPartitioning in PostgreSQL With pg_partman (Serial-Based & Trigger-Based)

November 2023

1. 20 NovIntroducing Percona’s API for Faster Snapshot-Based Backup and Restore for Your MongoDB Environments
2. 13 NovDatabase Upgrades: DIY or Choose a Database Upgrade Consulting Service?
3. 13 NovInnovation Release of Percona XtraBackup, Updated Percona Distribution for PostgreSQL: Release Roundup November 13, 2023
4. 9 NovUnderstanding What Kubernetes Is Used For: The Key to Cloud-Native Efficiency
5. 9 NovPostgreSQL Checkpoints, Buffers, and WAL Usage with Percona Monitoring and Management
6. 8 NovPercona XtraBackup 8.0.34 Removes the Server Version Check
7. 8 NovPostgreSQL 11 Will Soon Reach End of Life
8. 7 NovBook Review: PostgreSQL 14 Internals by Egor Rogov
9. 6 NovQuick Peek: MySQL 8.2 and 8.0.35
10. 6 NovPercona Operators Custom Resource Monitoring With Kube-state-metrics
11. 3 NovWhy Choose a Third-Party Database Migration Service
12. 3 NovHow To Scale a Single-Host PostgreSQL Database With Citus
13. 2 NovBest Practices for a Seamless MongoDB Upgrade
14. 2 NovTop 3 Questions From Percona k8s Squad Ask-Me-Anything Session
15. 2 NovHow to Install and Run PostgreSQL Using Docker
16. 1 NovPercona Operators Deployment Explained: Delving Into Cluster-Wide vs. Namespace-Scoped
17. 1 NovIs ANALYZE TABLE Safe on a Busy MySQL Database Server?
18. 1 NovIntroducing Percona Builds for Serverless PostgreSQL
19. 1 NovMySQL Backup and Recovery Best Practices: The Ultimate Guide

October 2023

1. 31 OctPercona Is Introducing Telemetry Mechanisms Into MySQL, PostgreSQL, and MongoDB
2. 31 OctPercona Monitoring and Management 2.40.1, Percona Distribution for MongoDB 6.0.11: Release Roundup October 31, 2023
3. 31 OctResolving Data Drift in a Dual-Primary Topology With Replica in MySQL/MariaDB
4. 20 OctDatabase Migration Plan: Avoiding Common Pitfalls in Open Source Migration
5. 20 OctScalable Solutions with Percona Distribution for PostgreSQL (Part 2): Using Citus
6. 19 OctScalable Solutions With Percona Distribution for PostgreSQL (Part 1): Set Up Three PostgreSQL Database Instances
7. 19 OctOur Kudos to All Percona Community Contributors
8. 18 OctFrom Proprietary to Open Source: The Complete Guide to Database Migration
9. 18 OctReduce RPO, Encrypt Backups, and More in 1.15.0 Release of Percona Operator for MongoDB
10. 17 Oct5 Changes You Should Know in MongoDB 7.0
11. 17 OctUsing CLONE INSTANCE With DATA DIRECTORY on Replicas With Data
12. 16 OctAdding Transparent Data Encryption to PostgreSQL with pg_tde: Please Test
13. 16 OctPercona Monitoring and Management 2.40.0, Percona Server for MongoDB 7.0.2-1 (RC): Release Roundup October 16, 2023
14. 13 OctDebugging MySQL Core File in Visual Studio Code
15. 13 OctComprehensive Insights Into SDI in MySQL 8.0
16. 12 OctKubernetes Observability: Code Profiling With Flame Graphs
17. 12 OctMongoDB Queries Slow Due to Flow Control but No Replication Lag?
18. 11 OctDeep Dive Into Roles in MySQL 8.0
19. 11 OctMigrate Data From Atlas to Self-Hosted MongoDB
20. 10 OctPercona Server for MongoDB 7 Is Now Available
21. 10 OctUsing Jobs to Perform Schema Changes Against MySQL Databases on K8s
22. 9 OctShare Your DBaaS Opinion, Get Some Swag
23. 9 OctPostgreSQL Tuple-Level Statistics With pgstattuple
24. 5 OctAnnouncing the Alpha Release of Percona Everest: An Open Source Private DBaaS
25. 4 OctPostgreSQL Role Inheritance in Reverse: Discovering Descendant Roles in Reverse Gear
26. 4 OctWhat’s New in Percona Toolkit 3.5.5
27. 3 OctPostgreSQL Job Scheduler: pg_timetable
28. 3 OctTransparent Huge Pages Refresher
29. 2 OctPercona Toolkit – A Quick Introduction to Summary
30. 2 OctPercona Distribution for PostgreSQL 16.0, Percona Backup for MongoDB 2.3.0: Release Roundup October 2, 2023

September 2023

1. 29 SepUsing MySQL Offline Mode To Disconnect All Client Connections
2. 28 SepDon’t Start Using Your MySQL Server Until You’ve Configured Your OS
3. 28 SepReplace a Live Mongo Node With a New Node
4. 27 SepPostgreSQL Partitioning Made Easy Using pg_partman (TimeBased)
5. 26 SepThe MySQL Clone Plugin Is Not Your Backup
6. 26 SepExplore the New Feature of MySQL To Restrict Users From Creating a Table Without a Primary Key
7. 25 SepRestrict MySQL Connections to Broken Replica in ProxySQL
8. 22 SepYou Need to Actively Support Open Source Software or It Will Disappear
9. 21 SepWhy You Need To Be at the Southern California Linux Expo
10. 20 SepHow to Read Simplified SHOW REPLICA STATUS Output
11. 20 SepAvoid Surprises When Restarting MySQL — Ensure Dynamic Changes Won’t Be Lost
12. 19 SepPercona Distribution for PostgreSQL 16 Is Now Available
13. 18 SepNew Versions of Percona Distribution for MongoDB, Percona Operator for MySQL: Release Roundup September 18, 2023
14. 15 SepConvert MariaDB Binary Log File and Position-Based Replication to GTID Replication
15. 14 SepComplete Walkthrough: MySQL to ClickHouse Replication Using MaterializedMySQL Engine
16. 12 SepHow To Make Schema Changes and Not Die Trying
17. 12 SepAuto-Increment Counter Persistence in MySQL 8: Comparing the Evolution From MySQL 5.7
18. 8 SepMySQL 5.7 End of Life Options – Free Course at Percona University Online
19. 6 SepPutting the Fun in MySQL Functional Indexes
20. 4 SepUpdated Versions of Percona Distribution for PostgreSQL, Percona XtraDB Cluster: Release Roundup September 4, 2023
21. 1 SepPostgreSQL for MySQL DBAs Episode 13: Inheritance
22. 1 SepUnderstanding How MySQL Collation and Charset Settings Impact Performance
23. 1 SepUnderstanding MySQL Triggers: Exploring How Triggers Impact MySQL Memory Allocation

August 2023

1. 30 AugPostgreSQL Parameters: Scope and Priority Users Should Know
2. 30 AugBackup and Recovery for Databases: What You Should Know
3. 29 AugData Redundancy With the PostgreSQL Citus Extension
4. 25 AugFailover and Recovery Scenarios in InnoDB Cluster and ClusterSet
5. 24 AugAutomated Percona Monitoring and Management Upgrades
6. 23 AugThe Deprecation of qpress/QuickLZ Compression Algorithm
7. 22 AugHigh Availability vs. Fault Tolerance: Is FT’s 00.001% Edge in Uptime Worth the Headache?
8. 21 AugConfiguring PostgreSQL and LDAP Using StartTLS
9. 21 AugUpdated Percona Distributions for MongoDB, Metadata Table for QAN in PMM: Release Roundup August 21, 2023
10. 18 AugHow To Use systemd in Linux to Configure and Manage Multiple MySQL Instances
11. 18 AugWant to Migrate From MariaDB 10.4 to MySQL 8.0 but Facing Hurdles? MySQL 5.7 to the Rescue!
12. 17 AugInnoDB ClusterSet Deployment With MySQLRouter
13. 16 AugStreamline the SQL Code: Guide to pgFormatter
14. 15 AugThe Future of Open Source is Polarized
15. 15 AugAn Introduction to MySQL Replication: Exploring Different Types of MySQL Replication Solutions
16. 10 AugMySQL 8.0.34 Improved Password Management by Defining the Change Characters Count
17. 9 AugExploring MySQL 8 New Transaction Data Dictionary: Storing Information About Database Objects
18. 8 AugProvisioning Replication With Clone Plugin
19. 8 AugMySQL Capacity Planning
20. 7 AugPercona Backup for MongoDB 2.2.1, Updates to Percona Distribution for MySQL: Release Roundup August 7, 2023
21. 7 AugUnderstanding the Differences Between InnoDB Undo Log and Redo Log
22. 5 AugThe Ultimate Guide to MySQL Partitions
23. 4 AugCustom Percona Monitoring and Management Dashboards
24. 4 AugDatabase Server Lifecycle for MySQL and MariaDB
25. 3 AugThe Invisibilities in MySQL 8.0
26. 2 AugMySQL 5.7 to 8.0 Upgrade – In-Place or Logical Upgrade?
27. 2 AugHow to Monitor Your MySQL Database Restore Progress
28. 1 AugMongoDB Security: Top Security Concerns and Best Practices
29. 1 AugHow to ALTER a VARCHAR Column Online in MySQL: Caveats and Solutions
30. 1 AugMigrating From On-Prem to RDS MySQL/Aurora? DEFINERS Is the Answer

July 2023

1. 31 JulDynamic SQL Workaround in MySQL: Prepared Statements
2. 31 JulShould You Keep Your Business Logic In Your Database?
3. 27 JulLTS and Innovation Releases for Percona Server for MySQL
4. 27 JulA Quick Peek at MySQL 8.0.34 and MySQL 8.1.0
5. 26 JulTen Recommendations for Running Your MongoDB Environment
6. 25 Jul20X Faster Backup Preparation With Percona XtraBackup 8.0.33-28!
7. 25 JulFaster Streaming Backups – Introducing Percona XtraBackup FIFO Parallel Stream
8. 24 JulAnnouncing the Availability of Percona Backup for MongoDB 2.2.0
9. 24 JulUpgrade to Grafana 9.2.20 in PMM 2.38, New Data Sink in Percona XtraBackup 8.0.33-28: Release Roundup July 24, 2023
10. 20 JulHow To Measure the Network Impact on PostgreSQL Performance
11. 19 JulDeploy PostgreSQL on Kubernetes Using GitOps and ArgoCD
12. 19 JulUpdate Percona Monitoring and Management Agent Settings for Already-Added Instances
13. 19 JulExtensibility in MySQL Is Easy
14. 15 JulAn Overview of Indexes in MySQL 8.0: MySQL CREATE INDEX, Functional Indexes, and More
15. 13 JulThe Power of utf8mb4 in MySQL 8.0: Unleashing the Full Potential of Multilingual Data
16. 10 JulMongoDB Version Requirements for Percona Backup for MongoDB
17. 10 JulPercona Monitoring and Management 2.38, Updates to Percona Distribution for PostgreSQL: Release Roundup July 10, 2023
18. 7 JulOnline Data Type Change in PostgreSQL
19. 6 JulOne Index, Three Different PostgreSQL Scan Types: Bitmap, Index, and Index Only
20. 5 JulThe Impacts of Fragmentation in MySQL
21. 3 JulPMM Is Getting a Modernized Enterprise-Grade Foundation
22. 1 JulAurora vs RDS: How to Choose the Right AWS Database Solution

June 2023

1. 30 JunAnnouncing the General Availability of Percona Operator for PostgreSQL Version 2
2. 29 JunFind the WAL Count Between Two Segments in PostgreSQL
3. 29 JunCommitQuorum in Index Creation From Percona Server for MongoDB 4.4
4. 28 JunConsequences of Forcing Bootstrap on Percona XtraDB Cluster
5. 27 JunBackup and Restore Using MySQL Shell
6. 27 JunMongoDB Monitoring With Percona Alerting in PMM
7. 26 JunWhat To Do When a Data File in PostgreSQL Goes Missing
8. 26 JunPercona Distribution for MySQL 8.0.33, Percona Server for MySQL: Release Roundup June 26, 2023
9. 23 JunIs My Backup Stuck? A Quick Guide for Reviewing Percona XtraBackup Threads
10. 22 JunThe Ultimate Guide to Database High Availability
11. 20 JunSetting up Resource Limits on Users in MySQL
12. 20 JunDeploy Django on Kubernetes With Percona Operator for PostgreSQL
13. 19 JunPercona University is Back in Business
14. 15 JunUsing PostGIS To Enable Better Performance in PostgreSQL
15. 15 JunHow to Install or Upgrade Percona Server for MySQL/MySQL 8 to a Specific Version on Debian/Ubuntu
16. 14 JunShould PostgreSQL Become Multi-Threaded?
17. 13 JunDatabase Teams Run Denver Marathon Relay at Percona Live 2023
18. 12 JunReady-to-Use High Availability Architectures for MySQL and PostgreSQL
19. 12 JunCritical CVE Fix in PMM, Updates to Percona Distribution for MySQL: Release Roundup June 12, 2023
20. 9 JunMonitoring a PostgreSQL Patroni Cluster
21. 7 JunUnleashing the Power of PostgreSQL Event-Based Triggers
22. 7 JunConquering Mt. Elbert After Percona Live 2023 in Denver
23. 6 JunFull vs. Incremental vs. Differential Backups: Comparing Backup Types
24. 5 JunPMM Authentication Bypass Vulnerability Fixed in 2.37.1
25. 5 JunConfiguring PgBouncer for Multi-Port Access
26. 4 JunMariaDB vs MySQL: Key Differences and Use Cases
27. 2 JunPowering the Web: Two Decades of Open Source Publishing With WordPress and MySQL
28. 1 JunProcess MySQL LIMIT & ORDER BY for Performance Optimization
29. 1 JunMigrating From MariaDB to Percona Server for MySQL 8: The Security Witchcraft

May 2023

1. 29 MayUpdates to Percona Distributions for PostgreSQL, Percona XtraDB Cluster, Percona XtraBackup: Release Roundup May 29, 2023
2. 16 MayBackup and Restore with MyDumper on Docker
3. 15 MayMongoDB 4.2 EOL… And Its Implications
4. 15 MayProof of Concept: Horizontal Write Scaling for MySQL With Kubernetes Operator
5. 10 MayUnderstanding Linux IOWait
6. 9 MayRestoring a Snapshot of a Sharded MongoDB Cluster to a Kubernetes-Based MongoDB Environment
7. 9 MayVendor Lock-in: What It Is and How To Avoid It
8. 8 MayHow to Start PostgreSQL Logical Replication with pg_dump
9. 8 MayPercona Monitoring and Management 2.37, Percona Distribution for MongoDB 5.0.17: Release Roundup May 8, 2023
10. 8 MayPercona Monitoring and Management 2.37: The Improved Inventory View, New Experimental Dashboards for Kubernetes Monitoring, and More!
11. 2 MayHow To Use pt-secure-collect for Capturing Data in a Secure Way From the OS and Database System
12. 2 MayChatGPT vs. MySQL DBA Challenge
13. 1 MaySave Money in AWS RDS: Don’t Trust the Defaults

April 2023

1. 28 AprAdd More Security to Your Percona Server for MongoDB With AWS IAM integration!
2. 28 AprOpen Source vs. Proprietary Database Software: What To Choose?
3. 26 AprOpen Source Software Security: Is Open Source Software Safe?
4. 26 AprSpeeding Up Restores in Percona Backup for MongoDB
5. 24 AprHow to Persist a Hashed Format Password Inside ProxySQL
6. 24 AprPercona XtraDB Cluster 8.0.32-24, Updated Percona Backup for MongoDB: Release Roundup April 24, 2023
7. 21 AprFixing Errant GTID With Orchestrator: The Easy Way Out
8. 20 AprUpgrading to MySQL 8: Tools That Can Help
9. 20 AprUsing Encryption-at-Rest for PostgreSQL in Kubernetes
10. 19 AprMySQL 8.0.33 – A Quick Peek
11. 17 AprMongoDB Best Practices: Security, Data Modeling, & Schema Design
12. 17 AprPercona Monitoring and Management and Datadog Integration
13. 17 AprMySQL 8 Doesn’t Like Your Groups
14. 14 AprHow To Reduce the Costs of Database Management in Financial Services
15. 14 AprMySQL Data Caching Efficiency
16. 13 AprPostgreSQL Replication Lag: Everything You Need to Know About Replication Lag in PostgreSQL
17. 13 AprMongoDB V4.2 EOL Is Coming: How To Upgrade Now and Watch Out for the Gotchas!
18. 12 AprPercona Live 2023 Tutorials
19. 12 AprDon’t Auto pt-online-schema-change for Tables With Foreign Keys
20. 11 AprTake This Unique Quiz About Duplicate Indexes In MySQL | pt-duplicate-key-checker
21. 10 AprMasquerade Your Backups To Build QA/Testing Environments With MyDumper
22. 10 AprImportant Note for Users and Customers Using the Physical Backup Feature in Percona Backup for MongoDB
23. 10 Apr15 Important Updates, Bug Fixes, and Improvements Across the Board: Release Roundup April 10, 2023
24. 6 AprTurbocharging Percona Monitoring and Management With Loki’s Log-shipping Functionality
25. 4 AprProxySQL for Short-Term Application Fixes
26. 4 AprCreating and Using MySQL 8 User Attributes
27. 4 AprMySQL 5.7 Upgrade Issue: Reserved Words
28. 3 AprDealing With Chunks That "Lost Weight" in MongoDB
29. 3 AprPostgreSQL Upgrade: Tricks With OID Columns and Extensions

March 2023

1. 30 MarThe Ultimate Guide to Open Source Databases
2. 29 MarFixing Misplaced Rows in a Partitioned Table
3. 28 MarWiredTiger Logging and Checkpoint Mechanism
4. 28 MarWhat if the Backup Server Is Down and a Backup Is Needed? (Multi-repo Functionality of PgBackRest)
5. 27 MarHow To Fix Oplog Restore Error: E11000 Duplicate Key Error Collection Using Percona Backup for MongoDB
6. 27 MarImpact of Querying Table Information From information_schema
7. 27 MarUpdated Percona Distributions for MySQL, Percona Distributions for MongoDB: Release Roundup March 27, 2023
8. 24 MarA Workaround for The "RELOAD/FLUSH_TABLES privilege required" Problem When Using Oracle mysqldump 8.0.32
9. 24 MarReplication Issues and Binlog Compressor
10. 22 MarDeploy Percona Monitoring and Management on Amazon EKS With eksctl and Helm
11. 21 MarIncrease the Ability to Securely Replicate Your Data and Restrict Replication To Row-based Events in MySQL
12. 21 MarMulti-tenants and Branches in Neon Serverless PostgreSQL
13. 20 MarComparisons of Proxies for MySQL
14. 17 MarPercona Monitoring and Management 2 Scaling and Capacity Planning
15. 16 MarPercona Labs Presents: Infrastructure Generator for Percona Database as a Service (DBaaS)
16. 15 MarAutomating Physical Backups of MongoDB on Kubernetes
17. 13 MarUsing Docker To Deploy Neon Serverless PostgreSQL
18. 13 MarHow To Set Up MySQL 8 Replica From Existing MySQL 5.7 Server With Percona XtraBackup
19. 13 MarPercona Server for MySQL 5.7.41-44, Percona Distribution for MongoDB 4.2.24: Release Roundup March 13, 2023
20. 10 MarCapped Collection in MongoDB
21. 8 MarDealing With "Too Many Connections" Error in MySQL 8
22. 6 MarHow To Calculate a Good MySQL Redo Log Size in MySQL 8
23. 3 MarUsing Slow Query Log to Find High Load Spots in MySQL
24. 3 MarPurging Data When the Table Is Big and Has Children Tables
25. 1 MarReduce Your Cloud Costs With Percona Kubernetes Operators
26. 1 MarMySQL 5.7 End of Life Six Months Away – Switch to Percona Server for MySQL Today!

February 2023

1. 27 FebRun Percona Server for MongoDB on Your ARM-based MacBooks and More
2. 27 FebPercona Monitoring and Management 2.35, Percona Backup for MongoDB 2.0.4: Release Roundup February 27, 2023
3. 24 FebPMM Access Control: A Comprehensive Guide With Use Cases and Examples
4. 24 FebPMM V2.35: Label-based Access Control, General Availability of Helm Chart, and More!
5. 24 FebPercona Server for MongoDB 6 Adds Support for Red Hat Enterprise Linux 9
6. 23 FebRun For Your Favorite Database at Percona Live 2023
7. 23 FebStreaming MongoDB Backups Directly to S3
8. 20 FebFeedback Wanted: Making EXPLAIN Require Less Privileges for INSERT/UPDATE/DELETE Statements
9. 20 FebPostgreSQL Migration From Digital Ocean DBaaS to Digital Ocean Droplet
10. 16 FebChatGPT Won’t Replace MySQL DBA – An Example of a Question About Encryption at Rest
11. 15 FebDeploying MySQL Group Replication With Terraform
12. 15 FebHow Bloom Filters Work in MyRocks
13. 14 FebEnd of Life Notification for PostgreSQL 10
14. 14 FebDeploying Percona Monitoring and Management With Terraform
15. 13 FebPostgreSQL for MySQL DBAs Episode 12: Transactions
16. 13 FebDiffering MySQL Client Versions Causing Broken Replication and Collations in Aurora
17. 13 FebTech Preview of Percona Operator for MySQL 0.4.0, Percona Distribution for MongoDB 6.0.4: Release Roundup February 13, 2023
18. 10 FebPercona XtraBackup and MySQL 5.7 Queries in Waiting for Table Flush State
19. 10 FebStorage Autoscaling With Percona Operator for MongoDB
20. 10 FebPercona XtraBackup Now Supports IAM Instance Profile
21. 9 FebDatabase Housekeeping in the New Year
22. 2 FebAn Argument for Logical Failover Slots
23. 1 FebUnlocking the Secrets of TOAST: How To Optimize Large Column Storage in PostgreSQL for Top Performance and Scalability

January 2023

1. 30 JanWhy PostgreSQL Needs Transparent Database Encryption (TDE)
2. 30 JanPercona Backup for MongoDB 2.0.3, Updates to Percona Distribution for MySQL: Release Roundup January 30, 2023
3. 26 JanWhy You Need To Keep Track of Bugs
4. 25 JanIdentify Active Databases and Users in MySQL
5. 24 JanWAL Compression in PostgreSQL and Recent Improvements in Version 15
6. 24 JanBackup Databases on Kubernetes With VolumeSnapshots
7. 24 JanPostgreSQL Sharding: An Overview and MongoDB Comparison
8. 23 JanWorking of MySQL Replication Filters When Using Statement-based and Row-based Replication
9. 23 Jan[BUG] Stopping Purge/Resuming Purge in Error Logs After Upgrade to MySQL 5.7.40
10. 20 JanHelp! I Am Out of Disk Space!
11. 19 JanA Quick Peek at MySQL 8.0.32
12. 19 JanWhy MySQL Could Be Slow With Large Tables
13. 17 JanKeep Your Database Secure With Percona Advisors
14. 17 JanThe Ultimate Guide to Database Corruption: Part 2 – B-Tree Index Corruption
15. 11 JanSave Time and Money With Free-to-Use Incremental Backups for MongoDB
16. 10 JanElevate Your Percona Live Experience by Climbing MT. Elbert
17. 9 JanCOUNT(*) vs COUNT(col) in MySQL
18. 9 JanUpdated Percona Distribution for MySQL, Percona XtraDB Cluster: Release Roundup January 9, 2023
19. 5 JanQuick Data Archival in MySQL Using Partitions
20. 5 JanTale of a MySQL 8 Upgrade and Implications on Backup
21. 4 JanSpeed Up of the WAL Archiving in PostgreSQL 15
22. 3 JanTable Doesn’t Exist: MySQL lower_case_table_names Problems

2022 270

December 2022

1. 29 DecMissing Library: A pg_upgrade History
2. 28 DecA Useful GTID Feature for Migrating to MySQL GTID Replication – ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS
3. 28 DecImpact of DDL Operations on Aurora MySQL Readers
4. 27 DecHow MySQL Uses character_set Configurations
5. 27 DecPercona Monitoring and Management 2.33, Percona Distribution for MongoDB 4.4.18: Release Roundup December 27, 2022
6. 23 DecDiffing PostgreSQL Schema Changes
7. 23 DecRebuild Patroni Replica Using pgBackRest
8. 23 DecA MyRocks Use Case
9. 22 DecPostgreSQL Role Inheritance at a Glance
10. 19 DecPMM V2.33: Offline Metric Collection, Guided Alerting Tour, Security Fixes, and More!
11. 15 DecJSON and Relational Databases – Part One
12. 15 DecLeast Privilege for Kubernetes Resources and Percona Operators
13. 14 DecGenerate a pgBadger Report From PostgreSQL Flexible Server Logs
14. 14 DecPowering PostgreSQL 15 With Columnar Tables
15. 12 DecUsing Percona Toolkit to Alter Database Tables Online: A Controlled Approach
16. 12 DecMega List of Updates, Bug Fixes, New Features! Release Roundup December 12, 2022
17. 8 DecHow To Skip Replication Errors in GTID-Based Replication
18. 8 DecPercona Live 2023 Call For Papers Open!
19. 8 DecFIDO Authentication in Percona Server for MySQL 8.0.30-22
20. 7 DecPostgreSQL 14 Internals Book
21. 6 DecLDAP Improvements in Percona Server for MySQL 8.0.30-22
22. 6 DecImportance of Delay Replica in Data Recovery: Recover Deleted Records
23. 5 DecHigh Memory Usage on ProxySQL Server
24. 5 DecPercona’s MySQL Audit Log Plugin – An Enterprise Feature at a Community Price
25. 2 DecUsing Liquibase as a Solution for Deploying and Tracking MySQL Schema Changes
26. 2 DecHacktoberfest Results – Percona Honors the Contributors
27. 2 DecNew WAL Archive Module/Library in PostgreSQL 15
28. 1 DecData Masking With Percona Server for MySQL – An Enterprise Feature at a Community Price

November 2022

1. 30 NovUpload Ongoing MyDumper Backups to S3
2. 30 NovPHP 8.0 Reaches End of Life
3. 29 NovMySQL Data Archival With Minimal Disruption
4. 29 NovPMM, Federated Tables, Table Stats, and Lots of Connections!
5. 28 NovCloud of Serfdom or Cloud of Freedom – What Would You Choose?
6. 28 NovPercona Distribution for PostgreSQL 15.1, 14.6, 13.9; Percona Server for MySQL 8.0.30-22: Release Roundup November 28, 2022
7. 25 NovPercona Operator for MongoDB Backup and Restore on S3-Compatible Storage – Backblaze
8. 25 NovSmall Business Saturday: Supercharging Your Database for the Holiday Shopping Surge
9. 25 NovExploring Data Dump and Load Utility With MySQL Shell
10. 23 NovOnline DDL Tools and Metadata Locks
11. 23 NovMySQL Dual Passwords – How To Manage Them Programmatically
12. 22 NovTroubleshooting Percona Operators With troubleshoot.sh
13. 18 NovMaking Your MySQL Backup Process up to 17X Faster – Introducing Percona XtraBackup Smart Memory Estimation
14. 18 NovRoot Cause Analysis in Quality Engineering
15. 17 NovHow To Get Your Backup to Half of Its Size – Introducing ZSTD Support in Percona XtraBackup
16. 16 NovHow to Generate Test Data for MongoDB With Python
17. 15 NovPMM v2.32: Backup Management for MongoDB in GA, New Home Dashboard, and More!
18. 15 NovpgBackRest Restoration Scenarios
19. 14 NovEnable innodb_print_all_deadlocks Parameter To Get All Deadlock Information in mysqld Error Log
20. 14 NovPercona Monitoring and Management 2.32, Percona Distribution for MongoDB 6.0.2: Release Roundup November 14, 2022
21. 10 NovRun MySQL in Kubernetes: Solutions, Pros and Cons
22. 10 NovProxySQL Support for MySQL caching_sha2_password
23. 9 NovSecuring Patroni REST API End Points Part 2: Using SSL Certificates
24. 9 NovMySQL: Using UNION, INTERSECT, & EXCEPT
25. 4 NovPercona Server for MongoDB 6.0.2 Is Out for Grabs!
26. 4 NovPostgreSQL: Are All NULLs the Same?
27. 3 NovWHAT IF… The User Exists on the Replica and Not in the Primary? (Or Any Other Objects?)
28. 3 NovRaspberry on the Rocks: Build Percona Server for MySQL With MyRocks on Your Raspberry Pi
29. 2 NovSet Theory in MySQL 8.0: UNION and Now INTERSECT and EXCEPT
30. 2 NovFirst PostgreSQL Conference Ever: What You’ve Missed at PGConf.EU 2022
31. 1 NovHow to Generate Test Data for MySQL With Python
32. 1 NovSecuring Patroni REST API End Points – Part 1

October 2022

1. 31 OctCoroot – The Next Level in Kubernetes Observability
2. 31 OctPercona Distribution for PostgreSQL 15.0, Percona Backup for MongoDB 2.0.2: Release Roundup October 31, 2022
3. 28 OctRestore a Specific MongoDB Collection(s) From a Physical Backup
4. 27 Octpt-archiver Misbehaving With Secondary Index
5. 25 OctKubernetes: Getting Started With a Minimal MySQL Installation
6. 19 OctBackup MongoDB Database Faster With Physical Backups
7. 17 OctMongoDB: Delayed Secondary Member of a Replica Set and How It Can Be Useful
8. 17 OctPercona Distribution for MongoDB 5.0.13, Percona Backup for MongoDB 2.0.1: Release Roundup October 17, 2022
9. 14 OctUsing Percona Kubernetes Operators With K3s Part 3: Monitoring and PMM
10. 13 OctUsing ClickHouse as an Analytic Extension for MySQL
11. 12 OctA Quick Peek at MySQL 8.0.31
12. 11 OctDon’t Forget to Tune Stats Collector for PostgreSQL 14 and Older
13. 11 OctUsing Percona Kubernetes Operators With K3s Part 2: Percona Server for MySQL Operator
14. 10 OctGearing Up for Percona’s Next Great Chapter
15. 10 OctI Am Taking on Founder Role, Ann Schlemmer Takes Over as Percona CEO
16. 7 OctDeploy Percona Server for MongoDB Replica Set With Ansible
17. 6 OctPostgreSQL 15 – New Features to Be Excited About
18. 5 OctWhen Manipulating MySQL User Tables Goes Wrong: Troubleshooting ERROR 1396
19. 5 OctUsing Percona Kubernetes Operators With K3s Part 1: Installation
20. 4 OctQueries for Finding Poorly-Designed MySQL Schemas and How to Fix Them
21. 3 OctMaking Percona Kubernetes Operators More Secure With Trivy
22. 3 OctTech Preview Percona Operator for MySQL 0.3.0, Updated Percona Backup for MongoDB: Release Roundup October 3, 2022

September 2022

1. 28 SepPercona Monthly Bug Report: September 2022
2. 28 SepPMM v2.31: Enhanced Alerting, User-Friendly Main Menu, Prometheus Query Builder, Podman GA, and more!
3. 27 SepGive Me Some Latitude… and Longitude
4. 26 SepMySQL in Microservices Environments
5. 23 SepKeep Your Data Safe with Percona
6. 23 SepScaling MySQL – A Good Problem to Have
7. 21 SepContribute to Open Source With Percona and Hacktoberfest
8. 21 SepMongoDB 6.0: Should You Upgrade Now?
9. 20 SepPercona Server for MySQL – Automatic Cloud Deployment with Terraform
10. 20 SepColumn-Level Encryption in MySQL
11. 19 SepTesting LDAP Authentication and Authorization on Percona Operator for MongoDB
12. 19 SepPercona Distribution for MongoDB 4.2.22, Version updates for Percona Distribution for PostgreSQL: Release Roundup September 19, 2022
13. 16 SepPercona Operator for MongoDB Goes Cluster-Wide, Adds AKS Support, and More!
14. 15 SepPercona XtraDB Cluster on Amazon EC2 and Two Interesting Changes in PXC 8.0
15. 14 SepPercona Monitoring and Management Home Dashboard: What’s New?
16. 13 SepPostgreSQL for MySQL DBAs Episode 11: A Survey of Indexes
17. 13 SepWorking With Snapshots in PostgreSQL
18. 9 SepOpen Source Bait and Switch: Licensing and Beyond
19. 8 SepEnabling ProcFS UDF in Percona Monitoring and Management
20. 8 SepAWS RDS Backups: What’s the True Cost?
21. 7 SepSpeed Up Your Large Table Drops in MySQL
22. 6 SepPercona Private DBaaS API in Action
23. 6 SepMySQL Replicate From Unsigned-int to Unsigned-bigint
24. 6 SepPercona Monitoring and Management 2.30, Updates to Percona Distribution for MongoDB: Release Roundup September 6, 2022
25. 2 SepWorking With PostgreSQL Dump Manifests
26. 2 SepPMM v2.30: New Dashboards, Improved DBaaS Experience, Free K8s Cluster for Testing, and More!
27. 1 SepGetting Started with RocksDB in Percona Server for MySQL
28. 1 SepProcFS UDF: A Different Approach to Agentless Operating System Observability in Your Database

August 2022

1. 30 AugPercona Server for MongoDB Data Directory Resize/Increase
2. 30 AugEfficient Data Archiving in MySQL
3. 29 AugPostgreSQL for MySQL DBAs: Watch Command
4. 29 AugTwo Extremely Useful Tools (pt-upgrade and checkForServerUpgrade) for MySQL Upgrade Testing
5. 26 AugPostgreSQL 15: Stats Collector Gone? What’s New?
6. 25 AugSeven Ways To Reduce MySQL Costs in the Cloud
7. 23 AugInstalling PMM Server from RHEL Repositories
8. 22 AugPrivate DBaaS with Free Kubernetes Cluster
9. 22 AugPercona Distribution for MySQL (PS-Based Variant) 8.0.29, Percona Distribution for MongoDB 5.0.10-9: Release Roundup August 22, 2022
10. 18 AugPostgreSQL For MySQL DBAs Episode 9: References
11. 17 AugFTWRL on MyDumper Removed
12. 17 AugMyRocks Use Case: Big Dataset
13. 11 AugHow to Build Percona XtraDB Cluster From Sources
14. 11 AugWindow Functions in MySQL 8.0
15. 10 AugBuilding Percona Server for MySQL 8.0 with RocksDB Storage Engine on macOS
16. 10 AugMySQL 8.0 Dynamic Redo Log Sizing
17. 8 AugAnti-Affinity Configuration in Percona Operator for PostgreSQL, Updated Grafana in PMM: Release Roundup August 8, 2022
18. 5 AugAn Illustration of PostgreSQL Bloat
19. 4 AugIntroducing Performance Improvement of Window Functions in PostgreSQL 15
20. 3 AugManaging MySQL Configurations with the PXC Kubernetes Operator V1.10.0 Part 3: Conclusion
21. 3 AugOS Platform End of Life (EOL) Announcement for Debian Linux 9
22. 2 AugTales From the MongoDB Field: When stepDown() Goes Wrong
23. 1 AugManaging MySQL Configurations with the PXC Kubernetes Operator V1.10.0 Part 2: Walkthrough
24. 1 AugHow to Reclaim Disk Space in Percona Server for MongoDB

July 2022

1. 29 JulHow to Benchmark Replication Performance in MySQL
2. 28 JulPostgreSQL for MySQL DBAs Episode 8: Materialized Views
3. 27 JulA Quick Peek At MySQL 8.0.30
4. 25 JulManaging MySQL Configurations with the PXC Kubernetes Operator V1.10.0 Part 1: Introduction
5. 25 JulHelm Chart in Percona Monitoring and Management, Percona Distribution for MongoDB 4.4.15-15: Release Roundup July 25, 2022
6. 21 JulPreventing Stale Reads on Percona XtraDB Cluster by Enforcing Causality Checks on a Per-Query Basis
7. 21 JulHow to Resolve "Error Reading Relay Log Event" After Relay Log Corruption
8. 19 JulPercona XtraBackup 8.0.29 and INSTANT ADD/DROP Columns
9. 18 JulPostgreSQL for MySQL DBAs Episode 7: Vacuuming Tables
10. 15 JulPostgreSQL for MySQL DBAs Episode 6 – Explaining EXPLAIN (And an Answer to a Bonus Question)
11. 14 JulParallel Commits for Transactions Using postgres_fdw on PostgreSQL 15
12. 14 JulExploring MySQL on Kubernetes With Minikube
13. 13 JulHow Percona Monitoring and Management Helps You Find Out Why Your MySQL Server Is Stalling
14. 13 JulIntroducing PostgreSQL 15: Working with SELECT DISTINCT
15. 13 JulTags and FullText indexes in MySQL
16. 11 JulHow to Manage Complex Database Environments Effectively
17. 11 JulPercona Operator for MySQL Supports Group Replication
18. 11 JulPercona Distribution for MongoDB 4.2.21, Tech Preview of Percona Operator for MySQL 0.2.0: Release Roundup July 11, 2022
19. 8 JulHappy National Video Game Day! Is Your Database Ready?
20. 8 JulMySQL: Compression, Indexes, and Two Smoking Barrels
21. 7 JulMongoDB Index Building on ReplicaSet and Shard Cluster
22. 7 JulPostgreSQL Replication and Conflicts
23. 7 JulAutomate the SSL Certificate Lifecycle of your Percona Monitoring and Management Server
24. 6 JulPercona Operator Volume Expansion Without Downtime
25. 6 JulUsing Percona Server for MySQL with Amazon KMS as Keyring
26. 5 JulIntroducing Buffered Error Logging in Percona Server for MySQL

June 2022

1. 30 JunUnderstanding Database High Availability
2. 30 JunPostgreSQL Sequences – Episode 5 of PostgreSQL for MySQL DBAs
3. 30 JunDigital Signatures: Another Layer of Data Protection in Percona Server for MySQL
4. 30 JunThe Ultimate Guide to Database Corruption: Part 1 – An Overview
5. 29 JunPercona Operator for MongoDB and LDAP: How Hard Can it Be?
6. 29 JunWindow Functions in MongoDB 5.0
7. 28 JunUpgrade Process of Percona Server for MongoDB (Replica Set and Shard Cluster)
8. 28 JunEncryption Functions in Percona Server for MySQL 8.0.28, Multiple KMIP Servers in Percona Distribution for MongoDB 5.0.9: Release Roundup June 28, 2022
9. 24 JunDebug Symbols for Percona Server for MongoDB and MongoDB
10. 24 JunPercona Monthly Bug Report: June 2022
11. 22 JunMissed Percona Live 2022? Watch It On Demand Now
12. 22 JunPercona Monitoring and Management in Kubernetes is now in Tech Preview
13. 21 JunPostgreSQL for MySQL Database Administrators: Episodes 3 and 4
14. 15 JunMoving MongoDB Cluster to a Different Environment with Percona Backup for MongoDB
15. 13 JunNew Percona Distributions for PostgreSQL, Percona Server for MySQL 5.7.38-41: Release Roundup June 13, 2022
16. 7 JunMigration of MongoDB Enterprise/Community Edition to Percona Server for MongoDB
17. 3 JunMyDumper’s Stream Implementation
18. 3 JunMigration of a MongoDB Replica Set to a Sharded Cluster
19. 2 JunHow Three Companies Used Percona to Boost Performance, Availability, and Market Value
20. 1 JunSession Temporary Tablespaces and Disk Space Usage in MySQL

May 2022

1. 31 MayKMIP in Percona Distribution for MongoDB, Amazon KMS in Percona XtraBackup: Release Roundup May 31, 2022
2. 27 MayPhysical Backup Support in Percona Backup for MongoDB
3. 26 MayIs MySQL Statement-Based / Mixed Replication Really Safe?
4. 26 MayLooking for an Excellent MySQL Book for Beginners? The MySQL Workshop is a Great Choice
5. 25 MaySecuring Dynamic Log File Locations in MySQL
6. 25 MayJoin a New Virtual Event This June – Percona Community Live!
7. 24 MayStore and Manage Logs of Percona Operator Pods with PMM and Grafana Loki
8. 24 MayPercona Honors Top Partners at Percona Live 2022
9. 24 MayA Quick Peek at the PostgreSQL 15 Beta 1
10. 16 MayRunning Rocket.Chat with Percona Server for MongoDB on Kubernetes
11. 16 MayKMIP in Percona Distribution for MongoDB, Preview Release of PMM 2.28.0: Release Roundup May 16, 2022
12. 12 MayPercona Operator for MongoDB and Kubernetes MCS: The Story of One Improvement
13. 10 MaySpring Cleaning: Discontinuing RHEL 6/CentOS 6 (glibc 2.12) and 32-bit Binary Builds of Percona Software
14. 9 MayMySQL 8.0.29 and Percona XtraBackup Incompatibilities
15. 9 MayMyDumper 0.12.3-1 is Now Available
16. 5 MayUnderstand Your PostgreSQL Workloads Better with pg_stat_monitor
17. 2 MayKMIP for Percona Distribution for MongoDB, Updates to Percona XtraBackup: Release Roundup May 2, 2022

April 2022

1. 27 AprA Quick Peek At MySQL 8.0.29
2. 27 AprWorking With Large PostgreSQL Databases
3. 22 AprZero Impact on Index Creation with Amazon Aurora 3
4. 21 AprSome Things to Consider Before Moving Your Database to the Cloud
5. 20 AprFinding Differences Between MySQL Servers
6. 19 Aprpt-archiver with Auto-Increment Column – Debunking a Blame
7. 19 AprPostgreSQL 14 B-Tree Index: Reduced Bloat with Bottom-Up Deletion
8. 18 AprExpose Databases on Kubernetes with Ingress
9. 18 AprThe Newest Percona Monitoring and Management, Percona Distribution for PostgreSQL Version Updates: Release Roundup April 18, 2022
10. 15 AprWhat Else Do You Need To Learn at Percona Live?
11. 15 AprCorrecting MySQL Inaccurate Table Statistics for Better Execution Plan
12. 13 AprUsing PostgreSQL Tablespaces with Percona Operator for PostgreSQL
13. 13 AprOvercoming VACUUM WRAPAROUND
14. 12 Apr11 Sessions Not to Miss at Percona Live 2022
15. 12 AprFace to Face with Semi-Synchronous Replication
16. 8 AprA Story of a Failed Percona Monitoring and Management Update
17. 6 AprUpgrade your Libraries: Authentication Plugin ‘caching_sha2_password’ Cannot be Loaded
18. 5 AprHidden Cost of Foreign Key Constraints in MySQL
19. 4 AprPercona Distributions for MongoDB 4.4.13, PostgreSQL 13.6: Release Roundup April 4, 2022

March 2022

1. 30 MarMySQL Shell For VS Code – Your New GUI?
2. 29 MarMigrating to utf8mb4: Things to Consider
3. 28 MarMariaDB 10.9 Quick Peek
4. 25 MarOkta – Percona’s statement
5. 25 MarPercona Monitoring and Management Security Threat Tool
6. 24 MarPostgreSQL From the Perspective of a MySQL DBA
7. 24 MarA Dive Into MySQL Multi-Threaded Replication
8. 23 MarMySQL 8: Multi-Factor Authentication Overview
9. 22 MarMySQL 8: Password Verification Policy
10. 22 MarAuthentication Plugin ‘***’ Cannot Be Loaded: How MySQL Searches Client-Side Plugins
11. 21 MarPercona Distribution for PostgreSQL 14.2: Release Roundup March 21, 2022
12. 16 MarMySQL 8.0.28 Quick Peek
13. 15 MarRun PostgreSQL on Kubernetes with Percona Operator & Pulumi
14. 15 MarGet Your Swag For a Review Right Now – New Giveaway Campaign!
15. 10 MarUsing Percona Server for MySQL 8.0 and Percona XtraBackup 8.0 with HashiCorp Vault Enterprise KMIP Secrets Engine
16. 10 MarPowerOn Your Voice at Percona Live 2022
17. 9 MarPercona’s Stance on Ukraine
18. 8 MarIdeas, Topics, and Suggested Topics for Percona Live 2022
19. 7 MarManage Your Data with Mingo.io and Percona Operator for MongoDB
20. 7 MarUpdated Percona Distribution for MySQL, Percona Server for MongoDB 4.0.28-23: Release Roundup March 7, 2022
21. 4 MarDBaaS in Under 20 Min!

February 2022

1. 28 FebBackup/Restore Performance Conclusion: mysqldump vs MySQL Shell Utilities vs mydumper vs mysqlpump vs XtraBackup
2. 25 FebLogical Replication/Decoding Improvements in PostgreSQL 13 and 14
3. 24 FebPercona Monthly Bug Report: February 2022
4. 21 FebUpdated Percona Distributions for MongoDB, PMM 2.26.0: Release Roundup February 21, 2022
5. 16 FebMonitoring MongoDB Collection Stats with Percona Monitoring and Management
6. 16 FebEconomical Comparison of AWS CPUs for MySQL (ARM vs Intel vs AMD)
7. 11 FebIncremental Backup in MySQL Using Page Tracking
8. 9 FebPercona Utilities That Make Major MySQL Version Upgrades Easier
9. 8 FebPostgreSQL 14 Predefined Roles – Making Access Control Easy
10. 8 FebIntroducing xbcloud: Azure Blob Storage Support in Percona XtraBackup
11. 7 FebMerging Empty Chunks in MongoDB
12. 7 FebPercona Distribution for MySQL Operator 2.0.0-alpha Preview: Release Roundup February 7, 2022
13. 3 FebOptimize SST in Percona XtraDB Cluster with ZSTD Compression

January 2022

1. 31 JanHow PostgreSQL Pipeline Mode Works
2. 27 JanPercona Operator for MySQL – Alpha Release
3. 27 JanAuthenticating Your Clients to MongoDB on Kubernetes Using x509 Certificates
4. 25 JanPostgreSQL 14 and Recent SCRAM Authentication Changes – Should I Migrate to SCRAM?
5. 24 JanPercona Operator for MongoDB with Local Storage and OpenEBS
6. 24 JanUpdated Percona Distributions for MySQL and MongoDB: Release Roundup January 24, 2022
7. 20 JanPercona XtraBackup Changing to Strict by Default
8. 18 JanAttack No-PK Replication Lag with MySQL/Percona Server 8 Invisible Columns!
9. 17 JanComparing Graviton (ARM) Performance to Intel and AMD for MySQL (Part 3)
10. 14 JanDBaaS and the Enterprise
11. 14 JanHelp Percona Make Better Databases
12. 13 JanHow Patroni Addresses the Problem of the Logical Replication Slot Failover in a PostgreSQL Cluster
13. 11 JanCreating a Standby Cluster With the Percona Operator for PostgreSQL
14. 11 JanOnline DDL With Group Replication in MySQL 8.0.27
15. 7 JanConfigure wiredTiger cacheSize Inside Percona Operator for MongoDB
16. 5 JanIn Application and Database Design, Small Things Can Have a Big Impact
17. 5 JanComparing AMD EPYC Performance with Intel Xeon in GCP
18. 4 JanPercona Server for MySQL Encryption Options and Choices
19. 4 JanTaking a Look at BTRFS for MySQL
20. 3 JanUpdated Percona Distribution for MongoDB, Bug Fixes in Percona Server for MySQL: Release Roundup January 3, 2022

2021 316

December 2021

1. 31 DecPercona Support Team New Year Greetings!
2. 30 DecMongoDB Config Server Upgrade From SCCC to CSRS ReplicaSet
3. 30 DecPercona Monitoring and Management 2 Test Drive Using VirtualBox and SSH Tunnels
4. 29 DecQ & A on Webinar "MySQL Performance for DevOps"
5. 27 DecBackup Performance Comparison: mysqldump vs MySQL Shell Utilities vs mydumper vs mysqlpump vs XtraBackup
6. 21 DecQuick Guide on Azure Blob Storage Support for Percona Distribution for MongoDB Operator
7. 21 DecData at Rest Encryption Support in Percona Distribution for MongoDB Operator
8. 20 DecPMM Now Supports Monitoring of PostgreSQL Instances Connecting With Any Database (Name)
9. 20 DecPercona Distribution for PostgreSQL Operator 1.1.0, Updated Percona Monitoring and Management: Release Roundup December 20, 2021
10. 14 Dec2021 Digest: The HOSS Talks FOSS Most Popular Episodes
11. 14 DecLog4JShell Vulnerability Update
12. 9 DecA Look Into Percona XtraDB Cluster Non-Blocking Operation for Online Schema Upgrade
13. 9 DecTesting Percona Distribution for MySQL Operator Locally with Kind
14. 8 DecPercona Distribution for PostgreSQL Operator 1.1.0 – Notable Features
15. 7 DecPercona’s Most Popular Posts on Open Source Database Technologies
16. 6 DecPercona Distribution for MySQL Operator 1.10.0 Preview, and More: Release Roundup December 6, 2021
17. 3 DecMyDumper Github Repository Is Now an Organization
18. 2 DecQ&A on the Webinar "Introduction to MySQL Query Tuning for Dev[Op]s"
19. 1 DecPXC Scheduler Handler: The Missing Piece for Galera/Percona XtraDB Cluster Puzzle

November 2021

1. 29 NovPostgreSQL 14 Database Monitoring and Logging Enhancements
2. 29 NovMyDumper 0.11.3 is Now Available
3. 26 NovPercona Monthly Bug Report: November 2021
4. 24 NovQuerying Archived RDS Data Directly From an S3 Bucket
5. 23 NovMulti-Tenant Kubernetes Cluster with Percona Operators
6. 23 NovUpgrading PostGIS: A Proof Of Concept
7. 22 NovTemporary Tables in MySQL – Never Ending Story?
8. 22 NovPostgreSQL 14 Monitoring in PMM, Improvements in Percona Backup for MongoDB: Release Roundup November 22, 2021
9. 18 NovShould I Create an Index on Foreign Keys in PostgreSQL?
10. 16 NovPercona Sponsors Conferences and Supports Community
11. 10 NovCommunity Meetup Schedule Till the End of the Year
12. 10 NovIssues Upgrading PostGIS and PostgreSQL
13. 9 NovWhat if … MySQL’s Repeatable Reads Cause You to Lose Money?
14. 8 NovImproved Percona Backup for MongoDB, ProxySQL 2.3.2 and proxysql-admin: Release Roundup November 8, 2021
15. 5 NovUpcoming End of Life for PMM v1 and MongoDB 4.0, Ubuntu 16.04 End of Support
16. 4 NovExternally Sourced Configuration File Values in MongoDB

October 2021

1. 25 OctComparing Graviton (ARM) Performance to Intel and AMD for MySQL (Part 2)
2. 25 OctPercona Server for MongoDB 5.0.3-2 Release Candidate, Updated Percona Server for MySQL: Release Roundup October 25, 2021
3. 20 OctMongoDB 5.0 Time Series Collections
4. 19 OctHow to Build Percona Server for MongoDB for Various Operating Systems
5. 18 OctCloud-Native Through the Prism of Percona: Episode 1
6. 15 OctComparing Graviton (ARM) Performance to Intel and AMD for MySQL
7. 14 OctPercona Is a Finalist for Best Use of Open Source Technologies in 2021!
8. 14 OctCustom Percona Monitoring and Management Metrics in MySQL and PostgreSQL
9. 13 OctMigrating MongoDB to Kubernetes
10. 12 OctWhy Linux HugePages are Super Important for Database Servers: A Case with PostgreSQL
11. 12 OctProxySQL 2.3.0: Enhanced Support for MySQL Group Replication
12. 11 OctUpgrade Fix in Percona Distribution for PostgreSQL, Percona Server for MongoDB Updates: Release Roundup October 11, 2021
13. 8 OctDisaster Recovery for MongoDB on Kubernetes
14. 8 OctMySQL 8: Random Password Generator
15. 7 OctUsing the Range and the New Multirange Data Type in PostgreSQL 14
16. 7 OctGetting Started with ProxySQL in Kubernetes
17. 6 OctHow to Hide Credentials from Percona Monitoring and Management Client Commands
18. 6 OctReminder: TokuDB Storage Engine Will Be Disabled by Default in Percona Server for MySQL 8.0.26
19. 5 OctMySQL 8: Account Locking
20. 5 OctUsing New JSON Syntax in PostgreSQL 14 – Update
21. 5 OctConfiguring a MongoDB Sharded Cluster with PMM2 – Part 2
22. 4 OctSynchronize Tables on the Same Server with pt-table-sync
23. 4 OctDo You Believe in the Future of Open Source Databases? Tell Us Your Views!
24. 1 OctLessons From Peter Zaitsev…
25. 1 OctJoin Community MeetUps for MySQL, PostgreSQL, MongoDB, or PMM

September 2021

1. 30 SepPostgreSQL 14 – Performance, Security, Usability, and Observability
2. 29 SepPercona Monthly Bug Report: September 2021
3. 29 SepNew Experimental Environment Dashboards for Percona Monitoring and Management
4. 28 SepHorizontal Scaling in MySQL – Sharding Followup
5. 28 SepPercona Software Recognized with Product Awards
6. 27 SepA Horizontal Scalability Mindset for MySQL
7. 27 SepPercona and PostgreSQL: Better Together
8. 27 SepPercona Distribution for MySQL, DBaaS in Percona Monitoring and Management: Release Roundup September 27, 2021
9. 22 SepEnhanced Password Management Systems in MySQL 8: Part 1
10. 22 SepModern Web-Based Application Architecture 101
11. 21 SepMaking Aurora Write Latency 15x Higher (or More!) by Choosing a Bad Primary Key
12. 21 SepMyDumper 0.11.1 is Now Available
13. 17 SepMigration of a MySQL Database to a Kubernetes Cluster Using Asynchronous Replication
14. 16 SepRepoint Replica Servers in MySQL/Percona Server for MySQL 8.0
15. 14 SepOctober 13, 2021: Open Mic on Open Source Takes on MongoDB
16. 13 SepMySQL/ZFS in the Cloud, Leveraging Ephemeral Storage
17. 13 SepPercona Distribution for PostgreSQL Updates, Improvements to Percona XtraBackup: Release Roundup September 13, 2021
18. 10 SepFinding Undetected Jumbo Chunks in MongoDB
19. 9 SepQ&A on Webinar "Using Open Source Software to Optimize and Troubleshoot Your MySQL Environment"
20. 8 SepStoring and Using JSON Within PostgreSQL Part Two
21. 3 SepStoring and Using JSON Within PostgreSQL Part One
22. 2 SepIntroducing xbcloud: Exponential Backoff Feature in Percona XtraBackup
23. 1 SepCongratulating Marcelo Altmann on his Promotion to Oracle ACE!

August 2021

1. 31 AugMy Favorite Percona Monitoring and Management Additional Dashboards
2. 30 AugPercona Server for MongoDB 5.0.2-1 Release Candidate, Updated Percona Backup for MongoDB: Release Roundup August 30, 2021
3. 24 AugResharding in MongoDB 5.0
4. 24 AugPostgreSQL Custom Dashboards Ported to Percona Monitoring and Management 2
5. 23 Augmyloader Stops Causing Data Fragmentation
6. 23 AugPostgreSQL Database Security: OS – Authentication
7. 23 AugAugust Is Hot, but Not as Hot as Our Next Community Engineering Meeting!
8. 20 AugUnderstanding EBS Latency: Storage Type Performance in AWS
9. 20 AugStoring JSON in Your Databases: Tips and Tricks For MySQL Part Two
10. 19 AugDynamic User Creation with MySQL on Kubernetes and Hashicorp Cloud Platform Vault
11. 19 AugStoring JSON in Your Databases: Tips and Tricks For MySQL Part One
12. 17 AugFirst Packages for Debian 11 "bullseye" Now Available
13. 17 AugPercona Server for MongoDB 5.0.2 Release Candidate Is Now Available
14. 16 AugNew Features in Percona Distribution for MySQL Operator, Beta Percona Distribution for PostgreSQL Operator 0.2.0: Release Roundup August 16, 2021
15. 13 AugGet an Amazon Gift Card for a Review!
16. 11 AugPros and Cons: When You Should and Should Not Use MongoDB
17. 10 AugPostgreSQL PL/Java – A How-To, Part 2: How to Manipulate and Return Tuples
18. 10 AugImpact of Network and Cursor on Query Performance of PostgreSQL
19. 2 AugNew Features and Improvements in Percona Server for MongoDB: Release Roundup August 2, 2021

July 2021

1. 30 JulImprove PostgreSQL Query Performance Insights with pg_stat_monitor
2. 30 JulPercona Monthly Bug Report: July 2021
3. 29 JulPostgreSQL PL/Java – A How-To, Part 1
4. 28 JulMongoDB: Modifying Documents Using Aggregation Pipelines and Update Expressions
5. 28 JulBuilding and Testing Percona Distribution for MongoDB Operator
6. 26 JulThe 1-2-3 for PostgreSQL Logical Replication Using an RDS Snapshot
7. 23 JulFree Webinar July 27: Why Fiserv Moved to Percona to Run MongoDB
8. 19 JulPerforming ETL Using Inheritance in PostgreSQL
9. 19 JulNew Features in Percona Server for MySQL, Updated Percona Distribution for PostgreSQL: Release Roundup July 19, 2021
10. 13 JulCluster Statuses in Percona Kubernetes Operators
11. 12 JulHow To Recover Percona XtraDB Cluster 5.7 Node Without SST
12. 9 JulStreaming MySQL Binlogs to S3 (or Any Object Storage)
13. 9 JulMySQL/ZFS Performance Update
14. 8 JulAuthenticate Percona Server for MongoDB Users via Native LDAP
15. 8 JulRefining Shard Keys in MongoDB 4.4 and Above
16. 8 JulBREAKING NEWS: Take a Sneak Peek Into MongoDB 5.0 With Percona!
17. 7 JulMigrating Ownership of Your Stored Routines, Views, and Triggers in MySQL
18. 7 JulInspecting MySQL Servers Part 5: Percona Monitoring and Management
19. 6 JulSharding With Zones Based on Compound Shard-Keys on MongoDB 4.4
20. 6 JulMove Percona Monitoring and Management Server Data From One Instance Type to Another
21. 6 JulMyDumper 0.10.7 is Now Available
22. 5 JulMongoDB 5.0 Is Coming in Hot! What Do Database Experts Across the Community Think?
23. 5 JulMySQL Shell 101 – System Log
24. 5 JulPercona Distribution for MongoDB Operator 1.9, Updated Percona Distribution for PostgreSQL: Release Roundup July 5, 2021
25. 1 JulUsing MySQL 8 Dual Passwords
26. 1 JulInstalling Percona Server for MySQL on Rocky Linux 8
27. 1 JulPercona Monitoring and Management – MySQL Semi-Sync Summary Dashboard

June 2021

1. 30 JunComplex Archival with Percona Toolkit’s pt-archiver
2. 30 JunMongoDB Multi-Document Transaction Fails When getLastErrorDefaults is Changed
3. 30 JunPercona Monthly Bug Report: June 2021
4. 28 JunEnabling SSL/TLS Sessions In PgBouncer
5. 25 JunPercona XtraBackup for Windows
6. 24 JunDeploy a Dedicated Percona Server for MySQL 8.0 in Azure
7. 24 JunUnderstanding pg_repack: What Can Go Wrong – and How to Avoid It
8. 23 JunBoosting Percona Distribution for MySQL Operator Efficiency
9. 23 JunAutoscaling Databases in Kubernetes for MongoDB, MySQL, and PostgreSQL
10. 23 JunMySQL on Kubernetes with GitOps
11. 22 JunWiredTiger File Forensics Part 3: Viewing all the MongoDB Data
12. 21 JunDiscover Why MongoDB Runs Better With Percona
13. 21 JunUpdated Percona Distribution for PostgreSQL Versions, Percona Distribution for MySQL 8.0.23: Release Roundup June 21, 2021
14. 18 JunProxySQL-Admin 2.x: Encryption of Credential Information
15. 17 JunChaos Testing Leads to More Stable Percona XtraDB Cluster
16. 15 JunWebinar July 6: Converting MongoDB to Percona Server for MongoDB
17. 15 JunMySQL Static and Dynamic Privileges (Part 2)
18. 15 JunMySQL Static and Dynamic Privileges (Part 1)
19. 14 JunMongoDB Integrated Alerting in Percona Monitoring and Management
20. 14 JunMigrating Into Kubernetes Running the Percona Distribution for MySQL Operator
21. 11 JunPostgreSQL HA with Patroni: Your Turn to Test Failure Scenarios
22. 10 JunDistributed Grant Management Using MongoDBAuthorizationGrant
23. 10 JunSelf-Healing Feature in Percona Distribution for MySQL Operator
24. 8 JunRestore Strategies with MyDumper
25. 7 JunExperimental Feature: $backupCursorExtend in Percona Server for MongoDB
26. 7 JunCompleted Features in Percona Monitoring and Management, Updated Percona Distribution for MongoDB: Release Roundup June 7, 2021
27. 4 JunInspecting MySQL Servers Part 4: An Engine in Motion
28. 3 JunWebinar June 17: Open Mic on Open Source – Percona Monitoring and Management
29. 3 JunThe (In)famous MongoDB Message: Cannot Add Session Into the Cache – TooManyLogicalSessions
30. 3 JunInspecting MySQL Servers Part 3: What MySQL?
31. 2 Junpostgres_fdw Enhancement in PostgreSQL 14
32. 2 JunInspecting MySQL Servers Part 2: Knowing the Server
33. 2 JunUsing the MongoDB Field Encryption Feature
34. 1 JunSkipping Percona Server for MySQL Version 8.0.24 and Releasing 8.0.25 Next
35. 1 JunInspecting MySQL Servers Part 1: The Percona Support Way

May 2021

1. 27 MayNew Features in PostgreSQL 14: Bulk Inserts for Foreign Data Wrappers
2. 27 MayHow InnoDB Handles TEXT/BLOB Columns
3. 27 MayWebinar June 29: Unlocking the Mystery of MongoDB Shard Key Selection
4. 26 MayCompiling a Percona Monitoring and Management v2 Client in ARM: Raspberry Pi 3 Reprise
5. 26 MayPercona Operator for PostgreSQL Technical Preview Released
6. 24 MayMongoDB Tuning Anti-Patterns: How Tuning Memory Can Make Things Much Worse
7. 24 MayNew Percona Distribution for PostgreSQL Versions, Percona Server for MySQL 8.0.23-14: Release Roundup May 24, 2021
8. 21 MayHeads-Up: TokuDB Support Changes and Future Removal from Percona Server for MySQL 8.0
9. 20 MayManage MySQL Users with Kubernetes
10. 20 MayNew Features in Percona Server for MySQL 8.0.23-14
11. 19 MayPercona Monitoring and Management DBaaS Overview and Technical Details
12. 19 MayRefreshing Test/Dev Environments With Prod Data Using Percona Backup for MongoDB
13. 19 MayUsing Sidecars with Percona Operators
14. 18 MayWiredTiger File Forensics Part 2: wt dump
15. 18 MayWiredTiger File Forensics Part 1: Building "wt"
16. 13 MayPercona Backup for MongoDB v1.5 Released
17. 12 MayNew Survey Shows Enterprises Increasing Their Reliance on Open Source Software
18. 12 MayPercona Live ONLINE: Percona Previews Open Source Database as a Service
19. 10 MayPoint-in-Time Recovery for MongoDB on Kubernetes
20. 10 MayNew Extensions in Percona Distribution for PostgreSQL, Updated Percona Kubernetes Operators: Release Roundup May 10, 2021
21. 10 MayWar Stories and Learning From Others – Percona Live
22. 7 MayMyDumper 0.10.5 is Now Available
23. 7 MayCool New Projects, Technology, and Broadening My Horizons at Percona Live
24. 7 MayWebinar June 8: The Pros and Cons of AWS, Azure, and Google Cloud – Which Cloud Provider is Right for Your Business?
25. 6 MayPercona Live Sessions for Engineers Working on Building and Developing Databases!
26. 4 MayInconsistent Voting in Percona XtraDB Cluster
27. 4 MayInnoDB File Growth Weirdness
28. 3 MayChanges to Percona Monitoring and Management on AWS Marketplace

April 2021

1. 29 AprImproving Percona Monitoring and Management EC2 Instance Resilience Using CloudWatch Alarm Actions
2. 29 AprPercona Live ONLINE: How Companies Manage Customer & Data Volume Rises While Staying Performant
3. 28 AprRunning Percona Monitoring and Management v2 on Windows with Docker
4. 28 AprCompiling Percona XtraBackup for ARM
5. 28 AprResolving the MySQL Active-Active Replication Dilemma
6. 27 AprPercona Monthly Bug Report: April 2021
7. 27 AprPercona Monitoring and Management Meetup on May 6th: Join Us for Live Tuning and Roadmap Talk
8. 27 AprMySQL 101: 10 Great MySQL DBA Interview Questions (and Answers)
9. 26 AprTons of New Features in Percona Monitoring and Management 2.16.0, Updated Percona Distribution for MongoDB: Release Roundup April 26, 2021
10. 23 AprYearly Reminder: DDLs That Fail to Propagate May Cause Percona XtraDB Cluster Inconsistencies
11. 22 AprUnderstanding Processes Running on Linux Host with Percona Monitoring and Management
12. 22 AprDemonstrating pg_rewind Using Linux Containers in PostgreSQL
13. 22 AprPercona Live ONLINE: Keynotes Now Live!
14. 21 AprBack From a Long Sleep, MyDumper Lives!
15. 20 AprChange Storage Class on Kubernetes on the Fly
16. 19 AprMySQL Group Replication: Conversion of GR Member to Async Replica (and Back) In the Same Cluster
17. 16 AprIntegrated Alerting Design in Percona Monitoring and Management
18. 16 AprAdd Microsoft Azure Monitoring Within Percona Monitoring and Management 2.16.0
19. 16 AprPercona Monitoring and Management 2.16 Brings Microsoft Azure Monitoring via a Technical Preview
20. 15 AprPlatform End of Support Announcement for Ubuntu 16.04 LTS
21. 15 AprOnline DDL with Group Replication In Percona Server for MySQL 8.0.22 (and MySQL 8.0.23)
22. 14 AprWin Percona Swag for Technical Product Reviews!
23. 14 AprWhat You Can Do With Auto-Failover and Percona Distribution for MySQL (8.0.x)
24. 14 AprPercona Distribution for MySQL: High Availability with Group Replication Solution
25. 14 AprPercona Live ONLINE: Focus on Unprecedented Demand for Scale
26. 12 AprReplay the Execution of MySQL With RR (Record and Replay)
27. 12 AprLatest Version of pg_stat_monitor in Percona Distribution for PostgreSQL, Bug Fix in Percona Server for MongoDB: Release Roundup April 12, 2021
28. 9 AprDeploying a MongoDB Proof of Concept on Google Cloud Platform
29. 7 AprMySQL 101: Basic MySQL Server Triage
30. 7 AprPercona Kubernetes Operators and Azure Blob Storage
31. 6 AprWhat’s New at Percona Live ONLINE 2021?
32. 6 AprMonitoring OPNSense Firewall with Percona Monitoring and Management
33. 6 AprWhich Version of MySQL Should I Use for MyRocks?
34. 2 AprPercona XtraBackup Point-In-Time Recovery for the Single Database
35. 2 AprUpgrading to MySQL 8: Embrace the Challenge
36. 1 AprWorking to Validate MyRocks in the Enterprise with Dropbox
37. 1 AprInfinitely Scalable Storage with High Compression Feature

March 2021

1. 31 MarWebinar April 14: Optimize and Troubleshoot MySQL Using Percona Monitoring and Management
2. 31 MarMySQL 101: Using super_read_only
3. 30 MarHow To Automate Dashboard Importing in Percona Monitoring and Management
4. 30 MarWhat’s Running in My DB? A Journey with currentOp() in MongoDB
5. 29 MarSecurity Fixes for Percona XtraDB Cluster, Updated Percona Distribution for MySQL: Release Roundup March 29, 2021
6. 26 MarOverview of MySQL Alternative Storage Engines
7. 25 MarThe Steps Involved in Creating a Percona Product Release
8. 24 MarImporting an Encrypted InnoDB Tablespace into MySQL
9. 23 MarIs a Session Analyzer a Good Tool to Simulate Real Traffic?
10. 23 MarCVE-2020-29488: Changes in How Absolute Paths are Handled in Percona XtraBackup xbstream
11. 22 MarStoring Kubernetes Operator for Percona Server for MongoDB Secrets in Github
12. 15 MarKubernetes Operator for Percona Server for MongoDB Sharding, Bug Fixes for Percona Server for MySQL 5.7: Release Roundup March 15, 2021
13. 11 MarWebinar March 26: MongoDB Backups Overview
14. 10 MarA Peek at Percona Operator for MongoDB New Features
15. 10 MarHow to Build Percona Server for MySQL From Sources
16. 9 Mar3 Percona Software Products Take the SourceForge Leader Award!
17. 9 MarWebinar March 24: Introduction to pg_stat_monitor
18. 8 MarTesting the Value of ScaleFlux Computational Storage Drive (CSD) for PostgreSQL
19. 2 MarPercona Monitoring and Management 2.15 Brings Even MORE Reasons to Upgrade to PMM v2!
20. 1 MarPercona Distribution for MongoDB 4.4.4, Bug Fix in Percona Server for MongoDB: Release Roundup March 1, 2021

February 2021

1. 26 FebConnection Queuing in pgBouncer: Is it a Magical Remedy?
2. 26 FebWebinar March 18: Moving Your Database to the Cloud – Top 3 Things to Consider
3. 25 FebMySQL Monitoring and Reporting Using the MySQL Shell
4. 25 FebPercona Monthly Bug Report: February 2021
5. 24 FebPoint-In-Time Recovery in Percona Operator for MySQL Based on Percona XtraDB Cluster – Architecture Decisions
6. 24 FebHoss Talks Foss: The Podcast is Now Available
7. 17 FebThe Most Important Skills for an SRE, DBRE, or DBA
8. 16 FebMySQL 5.6 and Percona Server for MySQL 5.6 are End of Life
9. 15 FebBare Systemd Method to Create an XFS Mount
10. 15 FebImprovements to Percona Server for MongoDB, Final Release of Percona Server for MySQL 5.6 Series: Release Roundup February 15, 2021
11. 15 FebTop 5 Features Developers Love About MongoDB
12. 12 FebTame Kubernetes Costs with Percona Monitoring and Management and Prometheus Operator
13. 12 FebRequest for Comments: Global Processlist in Percona Monitoring and Management
14. 11 FebVarious Types of InnoDB Transaction Isolation Levels Explained Using Terminal
15. 9 FebMonitoring a TP-Link Switch with Percona Monitoring and Management
16. 9 FebMongoDB Sharding & Replication 101 – The Community’s Questions Answered!
17. 8 FebDBaaS on Kubernetes: Under the Hood
18. 8 FebInstalling Percona Monitoring and Management v2 on Linode
19. 5 FebWebinar February 24: What’s Old Is New, What’s Coming Is Here – Percona Offerings for MySQL 5.6 and DBaaS in PMM
20. 5 FebFOSDEM Is This Weekend – Matt Yonkovit’s Must-See Sessions!
21. 3 FebQ&A on Webinar "Using PMM to Identify and Troubleshoot Problematic MySQL Queries"
22. 3 FebIntroducing: Percona Live Community Rooms!
23. 2 FebWhy SSPL is Bad For You, Part 2
24. 2 FebPercona Software Feedback – Help Us, Help You!
25. 1 FebPostgreSQL Database Security: Authentication
26. 1 FebPush Metrics for Percona Monitoring and Management, Percona Distribution for MongoDB 4.4.3: Release Roundup February 1, 2021

January 2021

1. 29 JanPercona Monitoring and Management 2.14: Moving to a Push Model for VictoriaMetrics
2. 29 JanWebinar February 10: Kubernetes – The Path to Open Source DBaaS
3. 28 JanHow to Create PostgreSQL Custom Builds and Debian Packages
4. 28 JanLoad Balancing ProxySQL in AWS
5. 27 JanPercona XtraBackup 8 Enables –lock-ddl by Default
6. 27 JanPercona Live ONLINE 2021 Call for Papers!
7. 27 JanDeploying Any Version of Leading Open Source Databases for Tests and Experiments
8. 26 JanAchieving a More Secure MongoDB with Percona Monitoring and Management’s Security Tool
9. 22 JanGetting Started with MongoDB in OpenShift Using the Percona Operator for MongoDB
10. 22 JanPostgreSQL on ARM-based AWS EC2 Instances: Is It Any Good?
11. 21 JanLow Value in range_optimizer_max_mem_size Might Cause Full Table Scan
12. 20 JanDrain Kubernetes Nodes… Wisely
13. 20 JanKeeping Open Source Open, or, Why Open is Better
14. 20 JanMySQL 8.0.23 Is Available: Highlighting Some Important Points
15. 19 JanThe MySQL Clone Wars: Plugin vs. Percona XtraBackup
16. 19 Janpg_stat_monitor: A New Way Of Looking At PostgreSQL Metrics
17. 18 JanUpdates to Percona XtraDB Cluster, New Features in Percona Toolkit 3.3.0: Release Roundup January 18, 2021
18. 15 JanMySQL 8.0.22: SHOW PROCESSLIST Version 2 – Now Available From PERFORMANCE_SCHEMA
19. 14 JanHow to Store MySQL Audit Logs in MongoDB in a Maintenance-Free Setup
20. 14 JanThinking About Deploying MongoDB? Read This First.
21. 14 JanWebinar January 28: Tuning PostgreSQL for High Performance and Optimization
22. 13 JanRunning Kubernetes on the Edge
23. 13 JanPercona 2020 Recap: Great Content and Software Releases
24. 12 JanWebinar January 26: Using Percona Monitoring and Management to Identify and Troubleshoot Problematic MySQL Queries
25. 12 JanThe Preview of Database as a Service (DBaaS) in Percona Monitoring and Management is Now Live!
26. 11 JanA Snippet of Features: Reviewing PostgreSQL Version 13
27. 11 JanMySQL Group Replication – How to Elect the New Primary Node
28. 11 JanFull Read Consistency Within Percona Operator for MySQL Based on Percona XtraDB Cluster
29. 11 JanPercona Operator for MySQL Based on Percona XtraDB Cluster: HAProxy or ProxySQL?
30. 8 JanStreaming MySQL Backups with Percona XtraBackup – Another Alternative
31. 8 JanUpdated MySQL OSMetrics Plugins
32. 7 JanTAM Enterprise Experiences – Data Encryption
33. 7 JanPostgreSQL: DB-Engines.com’s Database of the Year
34. 7 JanWebinar January 19: Maximize the Benefits of Using Open Source MongoDB with Percona Distribution for MongoDB
35. 6 JanGoogle Cloud Platform: MySQL at Scale with Reliable HA Webinar Q&A
36. 6 JanOne Shard Support in Kubernetes Operator for Percona Server for MongoDB
37. 6 JanWebinar January 20: MariaDB Observability
38. 5 JanTAM Enterprise Experiences – Troubleshooting Methodology
39. 4 JanConverting MongoDB to Percona Server for MongoDB Webinar Q&A
40. 4 JanPercona Monthly Bug Report: December 2020
41. 4 JanTech Previews in Percona Monitoring and Management, Percona Distribution for MySQL 8.0.21: Release Roundup January 4, 2021