Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
June 28, 2023
Public Schema Security Upgrade in PostgreSQL 15
In the Postgres database, the application data can be organized in various ways using Postgres schemas. In the Postgres database [...]
June 26, 2023
What To Do When a Data File in PostgreSQL Goes Missing
We have faced different levels of corruption related to databases in PostgreSQL. Our colleague has written multiple blogs on the [...]
June 20, 2023
Deploy Django on Kubernetes With Percona Operator for PostgreSQL
Developers need an efficient, reliable way to run their Django applications with a robust PostgreSQL. Percona Operator for PostgreSQL offers [...]
June 15, 2023
Using PostGIS To Enable Better Performance in PostgreSQL
This post was originally published in 2020 and has been updated in 2023. Mastering Geographical Information Systems, better known simply [...]
June 14, 2023
Should PostgreSQL Become Multi-Threaded?
A few days ago, Heikki Linnakangas posted a message in the PostgreSQL mailing list titled “Let’s make PostgreSQL multi-threaded.” This [...]
June 12, 2023
Ready-to-Use High Availability Architectures for MySQL and PostgreSQL
When it comes to access to their applications, users demand instant, reliable, and secure interactions — and that means databases [...]
June 9, 2023
Monitoring a PostgreSQL Patroni Cluster
Percona Monitoring and Management (PMM) boasts many functionalities that support its extension, be it by using Custom Queries, Custom Scripts, [...]
June 7, 2023
Unleashing the Power of PostgreSQL Event-Based Triggers
PostgreSQL provides a powerful mechanism for implementing event-driven actions using triggers. Triggers on Data Definition Language (DDL) events are a [...]
June 5, 2023
Configuring PgBouncer for Multi-Port Access
From time to time, situations occur where unusual circumstances dictate out-of-the-box thinking. For example, suppose you have a system where [...]
May 8, 2023
How to Start PostgreSQL Logical Replication with pg_dump
In simpler terms, logical replication in PostgreSQL is a way to copy data from one database to another in a [...]
April 20, 2023
Using Encryption-at-Rest for PostgreSQL in Kubernetes
Data-at-rest encryption is essential for compliance with regulations that require the protection of sensitive data. Encryption can help organizations comply [...]
April 13, 2023
PostgreSQL Replication Lag: Everything You Need to Know About Replication Lag in PostgreSQL
This blog was originally published in April 2023 and was updated in April 2024. PostgreSQL is a popular open source [...]
April 6, 2023
Turbocharging Percona Monitoring and Management With Loki’s Log-shipping Functionality
In this blog post, we’ll check how to integrate Percona Monitoring and Management (PMM) with Loki to be able to [...]
April 3, 2023
PostgreSQL Upgrade: Tricks With OID Columns and Extensions
We all know that PostgreSQL 10 has reached end of support, so if you’re still running it, the time to [...]
March 28, 2023
What if the Backup Server Is Down and a Backup Is Needed? (Multi-repo Functionality of PgBackRest)
Our previous blogs discussed configuring and setting up backups using the pgBackRest solution. To briefly explain pgBackRest, it is an [...]
March 21, 2023
Multi-tenants and Branches in Neon Serverless PostgreSQL
Announcement I will be speaking at Percona Live 2023 about serverless PostgreSQL. Join us at this event if you are [...]
March 13, 2023
Using Docker To Deploy Neon Serverless PostgreSQL
Announcement I will be speaking at Percona Live 2023 about serverless PostgreSQL. Join us at this event if you are [...]
February 20, 2023
PostgreSQL Migration From Digital Ocean DBaaS to Digital Ocean Droplet
Recently, one of our customers approached us with a unique challenge: they needed to migrate their entire PostgreSQL cluster from [...]
February 14, 2023
End of Life Notification for PostgreSQL 10
The final PostgreSQL 10 release was published on November 10, 2022, according to the PostgreSQL versioning policy page. Please remember [...]
February 13, 2023
PostgreSQL for MySQL DBAs Episode 12: Transactions
Yes, MySQL DBAs can learn PostgreSQL! This series is for those who know MySQL and want to expand their knowledge, [...]