New & Featured Articles
Blog articles, announcements, news, updates and more
December 20, 2024
MySQL Transaction ERROR 1412 and Isolation Levels
This blog post explains the cause of “ERROR 1412 (HY000): Table definition has changed, please retry transaction” with the specific [...]
MOST RECENT ARTICLES
December 19, 2024
Percona XtraBackup 101: Decompress and Decrypt or Decrypt and Decompress?
This blog is not intended to offer anything extraordinary; instead, consider it an anecdote, a lesson, or simply a proper [...]
December 19, 2024
Percona Wins 2024 Digital Innovator Award from Intellyx
As organizations turn to the cloud for more and more products and services, many are discovering that the majority of [...]
December 18, 2024
How To Deal with a AUTO_INCREMENT Max Value Problem in MySQL and MariaDB
An application down due to not being able to write into a table anymore due to a maximum allowed auto-increment [...]
December 17, 2024
Percona Server for MongoDB 8.0: The Most Performant Ever
MongoDB Community Edition 8.0 has been available since October. At Percona, we took the time to examine this release carefully, [...]
December 13, 2024
Software Licensing and Open Source: Why Definitions Matter
Over the last few years, there have been many calls to evolve the Open Source Definition (OSD) to fit the [...]
December 12, 2024
MySQL with Diagrams Part One: Replication Architecture
In this series, “MySQL with Diagrams,” I’ll use diagrams to explain internals, architectures, and structures as detailed as possible. In [...]
Want to get weekly updates listing the latest blog posts?
Subscribe now and we'll send you an update every Friday at 1pm ET.
December 10, 2024
How to Get Useful Information Out of Valkey/Redis Keys
In this blog post we will talk about how to get useful information out of the Valkey OR Redis keys. [...]
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 [...]
December 4, 2024
The Evolution of Stateful Applications in Kubernetes
Recently I listened to Lenny Rachitsky’s podcast, where he invited Shreyas Doshi for the second time. The session was titled [...]
December 3, 2024
Who Ate My MySQL Table Rows?
TL;DR ALTER TABLE and OPTIMIZE TABLE on an InnoDB table, which rebuilds the table without blocking concurrent changes to it [...]
December 2, 2024
Checking Index Consistency on a Sharded Cluster in MongoDB
Inconsistent index distribution across shards in a MongoDB sharded cluster is more common than you think, and it occurs because [...]
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 14, 2024
Exploring Kubernetes CPU Resources in View of Percona XtraDB Cluster’s Flow Control
Even though I used a dedicated Kubernetes cluster to host my test database, I had this belief that by not [...]
November 12, 2024
Alternatives to Cloud DBaaS: What to Look For
Originally published on The New Stack. Building a flexible cloud strategy means making decisions that align with operational efficiency, cost [...]
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 5, 2024
Valkey/Redis Key-Specific Dump, Restore, and Migration
Managing keys inside Valkey/Redis is crucial, especially when we need to test in a different environment or restore a partial/specific [...]
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 [...]