Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
January 19, 2023
A Quick Peek at MySQL 8.0.32
Recently Oracle released new versions of their software and there are some things of note. MySQL 8.032 is not a [...]
January 19, 2023
Why MySQL Could Be Slow With Large Tables
16 years ago, our founder Peter Zaitsev covered this topic and some of the points described there are still valid, and [...]
January 17, 2023
The Ultimate Guide to Database Corruption: Part 2 – B-Tree Index Corruption
This blog is in continuation of my previous blog on the basic understanding of corruption with the subject line The [...]
January 11, 2023
Save Time and Money With Free-to-Use Incremental Backups for MongoDB
MongoDB is a great database that provides outstanding high availability solutions out of the box. For most Database Administrators (DBAs) [...]
January 9, 2023
COUNT(*) vs COUNT(col) in MySQL
Looking at how people are using COUNT(*) and COUNT(col), it looks like most of them think they are synonyms and [...]
January 5, 2023
Quick Data Archival in MySQL Using Partitions
Space constraint has been an endless and painstaking process for many of us, especially in systems that have a high [...]
January 5, 2023
Tale of a MySQL 8 Upgrade and Implications on Backup
Recently, we performed a database engine major version upgrade in one of our customers’ environments from MySQL 5.7.26 to 8.0.27. [...]
January 4, 2023
Speed Up of the WAL Archiving in PostgreSQL 15
Last time I blogged about the New WAL Archive Module/Library feature available in PostgreSQL 15, which is quite transformative in [...]
January 3, 2023
Table Doesn’t Exist: MySQL lower_case_table_names Problems
In Managed Services, we have many customers, and as each has a different kind of config and environment, working on [...]
December 29, 2022
Missing Library: A pg_upgrade History
While working as a DBA, we perform many regular tasks, and one of them is upgrading our database systems. There [...]
December 28, 2022
A Useful GTID Feature for Migrating to MySQL GTID Replication – ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS
In managed services, we get requests to migrate from traditional to GTID-based replication. However, the customer does not want to [...]
December 28, 2022
Impact of DDL Operations on Aurora MySQL Readers
Recently I came across an interesting investigation about long-running transactions getting killed on an Aurora Reader instance. In this article, [...]
December 27, 2022
How MySQL Uses character_set Configurations
There are eight configuration options related to the character_set in MySQL, as shown below. Without reading the MySQL Character Set [...]
December 23, 2022
Diffing PostgreSQL Schema Changes
One of the routine operations when administering PostgreSQL is periodic updates to the database system’s architecture. PostgreSQL does a good [...]
December 23, 2022
Rebuild Patroni Replica Using pgBackRest
Patroni is one of the most used high availability (HA) solutions with the PostgreSQL database. It uses a Distributed Configuration [...]
December 23, 2022
A MyRocks Use Case
I wrote this post on MyRocks because I believe it is the most interesting new MySQL storage engine to have [...]
December 22, 2022
PostgreSQL Role Inheritance at a Glance
PostgreSQL manages database access permissions using the concept of roles. A role can be either a database user or a [...]
December 19, 2022
PMM V2.33: Offline Metric Collection, Guided Alerting Tour, Security Fixes, and More!
We are excited to announce the latest release of Percona Monitoring and Management (PMM) – V2.33. This release includes several [...]
December 15, 2022
JSON and Relational Databases – Part One
JSON data and relational databases have traditionally been diametric opposites. One is very free form with minimal rules on the [...]
December 14, 2022
Generate a pgBadger Report From PostgreSQL Flexible Server Logs
In one of our previous posts Detailed Logging for Enterprise-Grade PostgreSQL, we discussed parameters to enable detailed logging and use [...]