Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
September 7, 2022
Speed Up Your Large Table Drops in MySQL
A large table is a pain for many reasons as long as it is in a system. And as if [...]
September 6, 2022
Percona Private DBaaS API in Action
Percona Monitoring and Management (PMM) comes with Database as a Service (DBaaS) functionality that allows you to deploy highly-available databases [...]
September 6, 2022
MySQL Replicate From Unsigned-int to Unsigned-bigint
We often see an int column of a table that needs to be changed to unsigned-int and then unsigned-bigint due [...]
September 1, 2022
Getting Started with RocksDB in Percona Server for MySQL
You may have read MyRocks Use Case: Big Dataset and been intrigued enough to want to evaluate RocksDB with InnoDB. [...]
September 1, 2022
ProcFS UDF: A Different Approach to Agentless Operating System Observability in Your Database
When you look at database performance, it does not only depend on internal database operations but also on things going [...]
August 30, 2022
Efficient Data Archiving in MySQL
Recently I have been working with a few customers with multiple terabytes of transactional data on their MySQL clusters. These [...]
August 29, 2022
PostgreSQL for MySQL DBAs: Watch Command
Those new to the realm of PostgreSQL from other databases will find little gems sprinkled liberally through the software. One [...]
August 29, 2022
Two Extremely Useful Tools (pt-upgrade and checkForServerUpgrade) for MySQL Upgrade Testing
My last blog, Percona Utilities That Make Major MySQL Version Upgrades Easier, detailed the tools available from the Percona toolkit [...]
August 25, 2022
Seven Ways To Reduce MySQL Costs in the Cloud
With the economy slowing down and inflation raging in many parts of the world, your organization will love you if [...]
August 22, 2022
Private DBaaS with Free Kubernetes Cluster
We at Percona are committed to delivering software that enables users to run databases anywhere. Our Operators for databases and [...]
August 18, 2022
PostgreSQL For MySQL DBAs Episode 9: References
Thank you for the many kind responses to this series. There are many out there who have MySQL experience and [...]
August 17, 2022
FTWRL on MyDumper Removed
The title is not entirely true, but ‘FTWRL on MyDumper is not needed anymore for consistent backups’ was a long [...]
August 17, 2022
MyRocks Use Case: Big Dataset
One of the questions I am often asked is in what cases I would prefer MyRocks over InnoDB. We have [...]