Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
December 14, 2022
Powering PostgreSQL 15 With Columnar Tables
Prologue This blog is the result of my investigation into column-wise tables. Hopefully, you will find it useful in your [...]
December 12, 2022
Using Percona Toolkit to Alter Database Tables Online: A Controlled Approach
Table modifications are a common task for database administrators. In this blog, I’ll explain how to alter tables online in [...]
December 8, 2022
How To Skip Replication Errors in GTID-Based Replication
In this blog, I’m going to discuss how to easily skip the replication errors in GTID (Global Transaction Identifier)-based replication. [...]
December 8, 2022
Percona Live 2023 Call For Papers Open!
Percona Live 2023 will be in Denver Colorado May 22nd through the 24th. This is the premier open source database [...]
December 6, 2022
LDAP Improvements in Percona Server for MySQL 8.0.30-22
Percona Server for MySQL 8.0.30-22 introduces several improvements for the LDAP plugin: SASL support, support for fallback servers, and support [...]
December 6, 2022
Importance of Delay Replica in Data Recovery: Recover Deleted Records
What is a Delay Replica and how does it help? MySQL Replication is useful, easy to set up, and used [...]
December 5, 2022
Percona’s MySQL Audit Log Plugin – An Enterprise Feature at a Community Price
The need to audit who is using a database and their activities is crucial in many environments. This functionality is [...]
December 2, 2022
New WAL Archive Module/Library in PostgreSQL 15
PostgreSQL traditionally uses shell commands to achieve continuous WAL archiving, which is essential for backups and stable standby replication. In [...]
December 1, 2022
Data Masking With Percona Server for MySQL – An Enterprise Feature at a Community Price
Data masking is a handy tool to obscure sensitive information. Percona Server for MySQL is a free, fully compatible, enhanced, [...]