Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
February 24, 2022
Percona Monthly Bug Report: February 2022
Here at Percona, we operate on the premise that full transparency makes a product better. We strive to build the [...]
February 16, 2022
Monitoring MongoDB Collection Stats with Percona Monitoring and Management
One approach to get to know a MongoDB system we are not familiar with is to start by checking the [...]
February 16, 2022
Economical Comparison of AWS CPUs for MySQL (ARM vs Intel vs AMD)
It is always hard to select a CPU for your own purpose. You could waste hours reviewing different benchmarks, reviews, [...]
February 11, 2022
Incremental Backup in MySQL Using Page Tracking
Incremental backups of MySQL, specifically for the InnoDB engine, are taken by copying modified pages from the previous backup. The [...]
February 9, 2022
Percona Utilities That Make Major MySQL Version Upgrades Easier
It is essential to upgrade MySQL to the most recent version. Do you believe it’s tough to test and upgrade [...]
February 8, 2022
PostgreSQL 14 Predefined Roles – Making Access Control Easy
The PostgreSQL RDBMS has shown rapid growth in terms of adoption and usability for a wide range of industries and [...]
February 7, 2022
Merging Empty Chunks in MongoDB
I recently wrote about one of the problems we can encounter while working with sharded clusters, which is Finding Undetected [...]
February 3, 2022
Optimize SST in Percona XtraDB Cluster with ZSTD Compression
Percona XtraDB Cluster (PXC) offers a great deal of flexibility when it comes to the state transfer (SST) options (used [...]
January 31, 2022
How PostgreSQL Pipeline Mode Works
Note: In the original version of this post, there were some issues missed. These have been addressed at the bottom [...]
January 25, 2022
PostgreSQL 14 and Recent SCRAM Authentication Changes – Should I Migrate to SCRAM?
Recently, a few PostgreSQL users reported that they got connection failures after switching to PostgreSQL 14. “Why do I get [...]
January 13, 2022
How Patroni Addresses the Problem of the Logical Replication Slot Failover in a PostgreSQL Cluster
Failover of the logical replication slot has always been the pain point while using the logical replication in PostgreSQL. This [...]
January 7, 2022
Configure wiredTiger cacheSize Inside Percona Operator for MongoDB
Nowadays we are seeing a lot of customers starting to use our Percona Operator for MongoDB. The Percona Operators are [...]
January 5, 2022
In Application and Database Design, Small Things Can Have a Big Impact
With modern application design, systems are becoming more diverse, varied and have more components than ever before. Developers are often [...]
January 5, 2022
Comparing AMD EPYC Performance with Intel Xeon in GCP
Recently we were asked to check the performance of the new family of AMD EPYC processors when using MySQL in [...]
December 30, 2021
MongoDB Config Server Upgrade From SCCC to CSRS ReplicaSet
Recently, I got some of our customers doing an upgrade to v4.x from v3.0 (Yeah, still could see older MongoDB [...]
December 27, 2021
Backup Performance Comparison: mysqldump vs MySQL Shell Utilities vs mydumper vs mysqlpump vs XtraBackup
In this blog post, we will compare the performance of performing a backup from a MySQL database using mysqldump, MySQL [...]
December 9, 2021
A Look Into Percona XtraDB Cluster Non-Blocking Operation for Online Schema Upgrade
Percona XtraDB Cluster 8.0.25 (PXC) has introduced a new option to perform online schema modifications: NBO (Non-Blocking Operation). When using [...]
December 3, 2021
MyDumper Github Repository Is Now an Organization
For a long time, MyDumper has been in Max Bubenick’s personal GitHub repository. Now, we decided to move to a [...]
December 1, 2021
PXC Scheduler Handler: The Missing Piece for Galera/Percona XtraDB Cluster Puzzle
Working on a real case scenario in a five node Percona XtraDB Cluster (PXC), we were forced to use wsrep_sync_wait [...]
November 29, 2021
PostgreSQL 14 Database Monitoring and Logging Enhancements
PostgreSQL-14 was released in September 2021, and it contained many performance improvements and feature enhancements, including some features from a [...]