Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
December 1, 2025
Impact of Starting PostgreSQL Service Manually in an Active Patroni Cluster
A Nightmare no DBA wants One day, I had a nightmare, the kind every DBA fears. My manager called me [...]
November 21, 2025
How to Deploy a Stand-By/Ad-Hoc Cluster Based on Percona Operator for PostgreSQL
This short blog post discusses how to use the capabilities of pgBackRest and streaming replication to set up both a [...]
November 20, 2025
Performing Standby Datacentre Promotions of a Patroni Cluster
Unlike the standard multi-node Postgres replication cluster, when managed by Patroni, all failovers are automatically executed. However, this is not [...]
November 19, 2025
Data Retention Policy Implementation – How and Why
Is your PostgreSQL database Feeling Sluggish? Are SQL statements taking more time than in earlier days? Are you experiencing performance [...]
November 14, 2025
A Tale of Two Databases: No-Op Updates in PostgreSQL and MySQL
I’m lazy when I’m speakin’ I’m lazy when I walk I’m lazy when I’m dancin’ I’m lazy when I talk [...]
November 12, 2025
PostgreSQL OIDC Authentication with pg_oidc_validator
Among the new fetures introduced in PostgreSQL 18 is support for OAuth-based authentication. This opened the door for the community to [...]
November 6, 2025
PostgreSQL 13 Is Reaching End of Life. The Time to Upgrade is Now!
PostgreSQL 13 will officially reach End-of-Life (EOL) on November 13, 2025. After this date, the PostgreSQL Global Development Group will [...]
October 31, 2025
How to Configure pgBackRest Backups and Restores in PostgreSQL (Local/k8s) Using a MinIO Object Store
This blog post explains how to configure and use MinIO as S3-compatible storage for managing PostgreSQL backups, and how to [...]
October 27, 2025
Troubleshooting PostgreSQL Logical Replication, Working with LSNs
PostgreSQL logical replication adoption is becoming more popular as significant advances continue to expand its range of capabilities. While quite [...]
September 22, 2025
Keep PostgreSQL Secure with TDE and the Latest Updates
This fall feels like a good moment to stop and look at what’s changed in PostgreSQL security over the last [...]
September 16, 2025
What is Percona’s Transparent Data Encryption Extension for PostgreSQL (pg_tde)?
If you’re running PostgreSQL in a regulated industry, you know the frustration: your compliance auditor demands data-at-rest encryption, but PostgreSQL [...]
September 8, 2025
Swimming with Sharks: Analyzing Encrypted Database Traffic Using Wireshark
Percona has a great set of tools known as the Percona Toolkit, one of which is pt-upgrade. The idea behind [...]
August 20, 2025
Deep Diving the Citus Distribution Models Along with Shard Balancing/Read Scaling
In my previous blog post, Integrating Citus with Patroni: Sharding and High Availability Together, I explored how to integrate Citus [...]
August 13, 2025
Webinar Q&A: No More Workarounds: Open Source PostgreSQL TDE Is Here
I would like to thank everyone who attended my webinar, “No More Workarounds: Open Source PostgreSQL TDE Is Here,” on [...]
August 5, 2025
Planning Ahead for PostgreSQL 18: What Matters for Your Organization
PostgreSQL 18 is on the way, bringing a set of improvements that many organizations will find useful. It’s not a [...]
August 4, 2025
Integrating Citus with Patroni: Sharding and High Availability Together
Citus is a PostgreSQL extension developed with the intention of sharding and distributing the data across multiple machines. It offers [...]
August 2, 2025
Enhancing PostgreSQL Security: How to Encrypt the pgBackRest Repository
This post was originally written in 2023 and was updated in 2025. Encryption protects sensitive information by converting it into [...]
August 2, 2025
PostgreSQL Database Security: External Server-Based Authentication
This post was originally written in 2023 and was updated in 2025. Protecting sensitive information in PostgreSQL starts with strong [...]
July 30, 2025
A Practical Guide to PostgreSQL Replication with Both Asynchronous and Synchronous Standbys
PostgreSQL streaming replication allows a standby server to continuously replicate data from a primary server. It operates by streaming Write-Ahead [...]
July 29, 2025
Disaster Recovery for PostgreSQL on Kubernetes
This post was originally published in 2023, and we’ve updated it in 2025 for clarity and relevance. Downtime is more [...]
