Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
February 24, 2025
Understanding trx-consistency-only on MyDumper Before Removal
I have been working on MyDumper for over three years now, and I usually don’t use the tax-consistency-only feature during backups because [...]
February 18, 2025
Alternatives to MongoDB Atlas: More Control, Lower Costs
At first glance, MongoDB Atlas seems like the perfect solution—an easy-to-use, fully managed cloud database that takes the hassle out [...]
February 14, 2025
Orchestrator (for Managing MySQL) High Availability Using Raft
As we know, Orchestrator is a MySQL high availability and replication management tool that aids in managing farms of MySQL servers. [...]
February 12, 2025
Considering Alternatives for Your MySQL Migration? Why Percona Should Be Your First Choice
You know about MySQL; we know about MySQL. After all, it’s been the most popular database system for years now. [...]
February 3, 2025
MongoDB – Converting Replica Set to Standalone
This post was originally published in January 2022 and was updated in February 2025. One of the reasons for using [...]
February 2, 2025
MongoDB Indexes Explained: A Comprehensive Guide to Better MongoDB Performance
This blog was originally published in March 2021 and was updated in February 2025. Good intentions can sometimes end up [...]
February 1, 2025
How to Generate an Ansible Inventory with Terraform
This post was originally published in June 2021 and was updated in February 2025. Creating and maintaining Ansible inventory files [...]
February 1, 2025
MySQL Performance Tuning: Maximizing Database Efficiency and Speed
This post was originally published in June 2020 and was updated in February 2025. While there is no magic bullet [...]
January 22, 2025
Using Blue/Green Deployment For (near) Zero-Downtime Primary Key Updates in RDS MySQL
Large tables can pose challenges for many operations when working with a database. Occasionally, we may need to modify the [...]
January 21, 2025
Navigating MongoDB Licensing Challenges: Why Percona is a Game-Changer
MongoDB has long been a favorite in the database community and is renowned for its flexibility and performance as a [...]
January 17, 2025
What’s the Cost of Counting MySQL Table Rows?
What index will be used when you count all rows in a table? Well, the MySQL documentation provides a straightforward [...]
January 14, 2025
What Hurts in PostgreSQL Part One: Temporary Tables
PostgreSQL is one of the most powerful database systems in the world. I have always been passionate about its great [...]
January 11, 2025
Effective PostgreSQL Monitoring: Key Metrics and Tools
Maybe queries that used to finish in milliseconds are now taking seconds. Perhaps your application is timing out during peak [...]
January 10, 2025
Prevent Encryption Key Loss When Using Percona Server for MongoDB with HashiCorp’s Vault
When setting up data-at-rest encryption (also known as transparent data encryption) in Percona Server for MongoDB, one has three options [...]
January 8, 2025
Attaching a Percona Monitoring and Management Graph Image Along with an Alerting Notification
This article will be helpful if you use the Percona Monitoring and Management (PMM) instance and alert notifications, as it [...]
January 7, 2025
MySQL with Diagrams Part Two: How KILL Works
Here is part two of my MySQL with Diagrams series (Here’s part one – MySQL with Diagrams Part One: Replication [...]
January 6, 2025
MySQL 8.4.3 and 9.1.0: Major Performance Gains Revealed
At Percona, we’ve always prioritized performance, and recent trends in MySQL’s development have been a point of concern for us. [...]
January 3, 2025
Debugging a Binary Data Oplog Replay Issue in MongoDB
This blog post follows up on my previous one, How to Upgrade MongoDB Using Backups Through Many Major Versions, in [...]
January 2, 2025
How to Replace Patroni and Etcd IP/Host Information in PostgreSQL
As we know, Patroni is a well-established standard for an HA framework for PostgreSQL clusters. From time to time, we [...]
January 1, 2025
MySQL High CPU Usage: Effective Troubleshooting Methods
This post was originally published in April 2020 and was updated in January 2025. One of our customers recently asked [...]