Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
May 6, 2024
Valkey/Redis Configurations and Persistent Setting of the Key Parameters
Since Valkey (a fork of Redis) is around the corner, I thought to write a short blog post about some [...]
April 30, 2024
LDAP Authentication in PgBouncer Through PAM
There are many cases where external connection poolers like pgBouncer become unavoidable despite the costs and complexities associated with them. [...]
April 17, 2024
Switch PostgreSQL Environments Across AWS, GCP, and k3d Using Kubernetes Contexts
This article explains how to install the Percona Distribution for PostgreSQL on Kubernetes using “context”. We will show you how [...]
April 1, 2024
PostgreSQL Indexes Can Hurt Performance: Exploring the Negative Effects and the Costs Involved
This blog was originally published in April 2023 and was updated in April 2024. Indexes are generally considered to be [...]
March 28, 2024
How Missing Primary Keys Break Your Galera Cluster
Any Galera documentation about limitations will state that tables must have primary keys. They state that DELETEs are unsupported and [...]
March 12, 2024
Managing Time Series Data Using TimeScaleDB-Powered PostgreSQL
PostgreSQL extensions are great! Simply by adding an extension, one transforms what is an otherwise vanilla general-purpose database management system [...]
February 6, 2024
MySQL 8.2.0 Community vs. Enterprise; Is There a Winner?
To be honest, the comparison between the two MySQL distributions is not something that excited me a lot. Mainly because [...]
January 31, 2024
MySQL Table Size Is Way Bigger After Adding a Simple Index; Why?
It is a known good practice to keep only necessary indexes to reduce the write performance and disk space overhead. [...]
January 25, 2024
Decoding Sequential Scans in PostgreSQL
In every database product, sequential scans or full table scans are often resource consuming, so almost all the developers and [...]
January 12, 2024
Can’t We Assign a Default Value to the BLOB, TEXT, GEOMETRY, and JSON Data Types?
One of our customers wants to create a table having a column of data type TEXT with the default value, [...]
December 22, 2023
What’s New in Percona Toolkit 3.5.6
Percona Toolkit 3.5.6 was released on December 21, 2023. This blog post covers the main changes in this release. New [...]
December 22, 2023
The Pros and Cons of Wildcard Indexes on MongoDB
MongoDB is a schemaless database that is extremely flexible. When you create a collection, you don’t have to specify a [...]
December 21, 2023
Percona Monitoring and Management High Availability – A Proof of Concept
Percona Monitoring and Management (PMM) is a state-of-the-art piece of software that exists in part thanks to great open source [...]
November 13, 2023
Database Upgrades: DIY or Choose a Database Upgrade Consulting Service?
To maintain competitiveness and operational efficiency — not to mention ensure security and compliance when your database version reaches End [...]
November 7, 2023
Book Review: PostgreSQL 14 Internals by Egor Rogov
The book PostgreSQL 14 Internals has been available in PDF format for quite a while, but recently, the ability to [...]
November 6, 2023
Quick Peek: MySQL 8.2 and 8.0.35
Oracle recently made their quarterly releases with MySQL 8.0.35 and MySQL 8.2. This blog post is a quick look at [...]
November 3, 2023
How To Scale a Single-Host PostgreSQL Database With Citus
When it comes to Citus, successfully building out and scaling a PostgreSQL cluster across multiple nodes and even across data [...]
October 31, 2023
Percona Is Introducing Telemetry Mechanisms Into MySQL, PostgreSQL, and MongoDB
Percona has a mission to provide the best open source database software, support, and services so our users can innovate [...]
October 5, 2023
Announcing the Alpha Release of Percona Everest: An Open Source Private DBaaS
Today’s businesses face two major challenges when it comes to managing databases: vendor lock-in of public cloud providers and the [...]
October 4, 2023
What’s New in Percona Toolkit 3.5.5
Percona Toolkit 3.5.5 was released on October 3, 2023. This blog post covers the main changes in this release. pt-online-schema-change [...]