Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
October 31, 2022
Coroot – The Next Level in Kubernetes Observability
To follow up on my previous Kubernetes articles: Installed in part one (see Using Percona Kubernetes Operators With K3s Part [...]
October 27, 2022
pt-archiver Misbehaving With Secondary Index
Not long ago, we found a long-running query in one of our clients on Managed Services. While reviewing this long-running [...]
October 25, 2022
Kubernetes: Getting Started With a Minimal MySQL Installation
This week is KubeCon in Detroit, and in preparation for attending I have been polishing up my Kubernetes skills. This [...]
October 14, 2022
Using Percona Kubernetes Operators With K3s Part 3: Monitoring and PMM
As we have Kubernetes installed in part one (see Using Percona Kubernetes Operators With K3s Part 1: Installation) and have [...]
October 13, 2022
Using ClickHouse as an Analytic Extension for MySQL
MySQL is an outstanding database for online transaction processing. With suitable hardware, it is easy to execute more than 1M [...]
October 12, 2022
A Quick Peek at MySQL 8.0.31
Oracle releases updates to MySQL on a quarterly basis and the Release Notes for 8.0.31 arrived just before the software. [...]
October 11, 2022
Using Percona Kubernetes Operators With K3s Part 2: Percona Server for MySQL Operator
As we have Kubernetes installed in part one (see Using Percona Kubernetes Operators With K3s Part 1: Installation), now we [...]
October 5, 2022
When Manipulating MySQL User Tables Goes Wrong: Troubleshooting ERROR 1396
A few weeks back, we faced an issue in a replication environment for a Managed Services client: LAST_ERROR_MESSAGE: Worker 2 [...]
October 4, 2022
Queries for Finding Poorly-Designed MySQL Schemas and How to Fix Them
If you watched Finding Poorly Designed Schemas and How to Fix Them you witnessed Marcos Albe use some very interesting [...]
September 27, 2022
Give Me Some Latitude… and Longitude
Geo locations are a cornerstone of modern applications. Whether you’re a food delivery business or a family photographer, knowing the [...]
September 26, 2022
MySQL in Microservices Environments
The microservice architecture is not a new pattern but has become very popular lately for mainly two reasons: cloud computing [...]
September 23, 2022
Keep Your Data Safe with Percona
September was and is an extremely fruitful month (especially for the black-hat hackers) for news about data leaks and breaches: [...]
September 23, 2022
Scaling MySQL – A Good Problem to Have
When you develop an application you expect success, and often success comes with growth problems. These problems especially show themselves [...]
September 20, 2022
Percona Server for MySQL – Automatic Cloud Deployment with Terraform
We are looking to provide simplified ways to deploy Percona software in cloud environments, especially for more advanced scenarios like [...]
September 20, 2022
Column-Level Encryption in MySQL
In a post written earlier this year – Percona Server for MySQL Encryption Options and Choices – I discussed some [...]
September 15, 2022
Percona XtraDB Cluster on Amazon EC2 and Two Interesting Changes in PXC 8.0
This article outlines the basic configurations for setting up and deploying Percona XtraDB Cluster 8.0 (PXC) on Amazon EC2, as [...]
September 13, 2022
PostgreSQL for MySQL DBAs Episode 11: A Survey of Indexes
First, a big thanks for the kind responses to this series, and, as requested, here is an overview of index [...]
September 9, 2022
Open Source Bait and Switch: Licensing and Beyond
Another day, another company announces it changed its license away from open source while claiming “We Believe In A Model [...]
September 8, 2022
Enabling ProcFS UDF in Percona Monitoring and Management
In my previous blog post, ProcFS UDF: A Different Approach to Agentless Operating System Observability in Your Database, I wrote [...]
September 8, 2022
AWS RDS Backups: What’s the True Cost?
You have your database instance deployed with AWS and you are using AWS RDS for MySQL. All work smoothly in [...]