Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
November 29, 2021
MyDumper 0.11.3 is Now Available
The new MyDumper 0.11.3 version, which includes many new features and bug fixes, is now available. You can download the [...]
November 26, 2021
Percona Monthly Bug Report: November 2021
Here at Percona, we operate on the premise that full transparency makes a product better. We strive to build the [...]
November 24, 2021
Querying Archived RDS Data Directly From an S3 Bucket
A recommendation we often give to our customers is along the lines of “archive old data” to reduce your database [...]
November 23, 2021
Upgrading PostGIS: A Proof Of Concept
My last blog introduced the issues one can face when upgrading PostGIS and PostgreSQL at the same time. The purpose [...]
November 22, 2021
Temporary Tables in MySQL – Never Ending Story?
If you ever had to deal with performance and/or disk space issues related to temporary tables, I bet you eventually [...]