Featured
MySQL 5.7
End of Life
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
December 9, 2024
Performing ELT Operations Using DOMAINs
First things first, a couple of definitions to clear up: ETL: Extract, Transform, Load. Transforms data before loading it into [...]
November 19, 2024
Using Loki and Promtail to Display PostgreSQL Logs From a Kubernetes Cluster in PMM
This is a follow-up to my colleagues Nickolay and Phong’s Store and Manage Logs of Percona Operator Pods with PMM [...]
November 18, 2024
PostgreSQL 12 End of Life: Upgrade Now with Percona
PostgreSQL 12 reached its End of Life (EOL) on November 14, 2024. For more information, see the official PostgreSQL versioning [...]
November 6, 2024
An Elephant in the Cluster: Making PostgreSQL Feel at Home on Kubernetes
TL;DR Kubernetes was built for stateless apps, but as more stateful applications (like databases) run on it, operators include quite [...]
November 4, 2024
Exposing PostgreSQL with NGINX Ingress Controller
I wrote a blog post in the past about a generic approach on how to expose databases in Kubernetes with [...]
November 1, 2024
How Can MySQL Catch Up with PostgreSQL’s Momentum?
When I talk to old-timers in the MySQL community, I often hear this question: “How come MySQL is so awesome [...]
September 6, 2024
PostgreSQL Internals for Newbies: A Guide to Data Storage, Part One
Database novices often wonder how ‘things work behind the scenes’ when starting with PostgreSQL. Many things happen when creating a [...]
September 4, 2024
Percona In-Product Telemetry: Updates, Findings, and News
This article is, in fact, two topics merged into one publication. Both are related to anonymous statistical data collection within [...]
August 15, 2024
The Making of an Open Source PostgreSQL TDE Extension
When using a tool for a while, one often becomes patriotic towards it. With your investment, such as your work, [...]
August 13, 2024
Solving pg_upgrade and lc_collate Mismatch Issues in PostgreSQL
Character collations determine the sort order and classification of characters. When creating a database with initdb, PostgreSQL normally sets the [...]
August 12, 2024
How to Build a PostgreSQL Patch Test Environment on Ubuntu 22.04
While the well-established ways of building PostgreSQL from source still work, there are many new options on Linux as well. [...]
August 7, 2024
Open Source AI Database Agent Part 2: OSADA
In the first part of this series, we built a basic AI-powered database agent. Now, it’s time to make a [...]
August 6, 2024
Dispelling Myths About PostgreSQL Default Privileges
The ALTER DEFAULT PRIVILEGES command allows us to set the privileges that will be applied to objects created in the [...]
August 5, 2024
Open Source AI Database Agent Part 1: Introduction
Generative AI is top of mind for many engineers. The questions of how it can be applied to solve business [...]
July 11, 2024
Key Metrics and Tools for Effective PostgreSQL Monitoring
Running a high-performance, reliable PostgreSQL database is crucial for any business and application. However, as workloads grow and database environments [...]
July 10, 2024
The Powerful Features Released in PostgreSQL 17 Beta 2
The PostgreSQL Global Development team released the second beta version of PostgreSQL 17 on June 27th, 2024, and it is [...]
July 8, 2024
Automated Major Version Upgrades in Percona Operator for PostgreSQL
PostgreSQL major versions are released every year, with each release delivering better performance and new features. With such rapid innovation, [...]
July 3, 2024
Easy Guide to Switching PostgreSQL Physical Replication to Logical Replication with pg_createsubscriber
In one of our previous blogs, a custom method for switching from PostgreSQL physical replication to logical replication was discussed, [...]
July 2, 2024
See What’s Inside a WAL File Using pg_waldump and pg_walinspect
In this blog, we will see the concepts for analyzing WAL files, such as pg_waldump (supported versions 12 and above) [...]
July 1, 2024
How to Remove an Orphan Large Object in PostgreSQL With Vacuumlo
In PostgreSQL, an “orphan large object” refers to a large object (LOB) that exists in the pg_largeobject system table but [...]