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 how WALs are archived today in PostgreSQL. PostgreSQL 15... Read more »

Deep Dive into MySQL’s Performance Schema

Recently I was working with a customer wherein our focus was to carry out a performance audit of their multiple MySQL database nodes. We started looking into the stats... Read more »

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 their environment is always fun and interesting. In this... Read more »

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 are some techniques to perform a PostgreSQL database upgrade,... Read more »

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, I will explain why it is advisable to avoid... Read more »

Transparent Data Encryption (TDE)

Encrypting data at rest in a database management system (DBMS) refers to securing data by encrypting it when it is not being used or accessed. This is often done... Read more »

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 documentation carefully, it could be hard to know what... Read more »

Percona Monitoring and Management 2.33, Percona Distribution for MongoDB 4.4.18: Release Roundup December 27, 2022

It’s time for the release roundup! Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize... Read more »

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 job of allowing one to update a schema, add... Read more »

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 Store (DCS) to keep the configuration in a centralized... Read more »
Subscribe to our Newsletter