Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
April 8, 2020
The Evolution of the DBA Role
As I interface with large clients as a Technical Account Manager (TAM) at Percona, one thing I have noticed is [...]
April 7, 2020
18 Things You Can Do to Remove MySQL Bottlenecks Caused by High Traffic (Part Three)
This is a three-part blog series that focuses on dealing with an unexpected high traffic event as it is happening. [...]
April 6, 2020
18 Things You Can Do to Remove MySQL Bottlenecks Caused by High Traffic (Part Two)
This is a three-part blog series that focuses on dealing with an unexpected high traffic event as it is happening. [...]
April 3, 2020
18 Things You Can Do to Remove MySQL Bottlenecks Caused by High Traffic (Part One)
This is a three-part blog series. Part two is located here, and part three can be found here. There was [...]
April 1, 2020
Tips for MySQL 5.7 Database Tuning and Performance
While there is no magic bullet for MySQL 5.7 database tuning, there are a few areas that can be focused [...]
March 30, 2020
Which Cloud Provider Performs Better for My Mysql Workload?
More and more people are nowadays thinking of cloud migration. The question of “Which cloud provider performs better for my [...]
March 26, 2020
Split-Brain 101: What You Should Know
Disclaimer: The following blog post does not try to provide a solution for split-brain situations, and the example provided is [...]
March 25, 2020
A Tale About Migrating a PostgreSQL Database Between Different DBaaS Providers
We recently helped migrate a production PostgreSQL database running on a given DBaaS platform… to another DBaaS platform. When it [...]
March 24, 2020
The Changing Face of Enterprise DBAs in Cloud-Driven Environments
Over the past ten years, those in charge of running enterprise databases saw their focus shift from simply ensuring access [...]
March 23, 2020
Setting up a ProxySQL Sidecar Container
Recently, a client of ours, Duolingo, was using Aurora was reaching the max connection limit of 16,000 (that is Aurora’s [...]
March 19, 2020
Help Drive the Future of Percona XtraDB Cluster
Percona is happy to announce the experimental release of Percona XtraDB Cluster 8.0. This is a major step for tuning [...]
March 18, 2020
How Container Networking Affects Database Performance
Percona has been investing in building and releasing Operators for Kubernetes to run traditional databases in a cloud-native fashion. The [...]
March 11, 2020
DBA Concerns About Next-Gen, Non-Volatile Memory Storage Products
Abstract: Storage engine algorithmic gains have mostly settled and Moore’s law for CPU speed is bottoming out, but database performance [...]
March 4, 2020
ClickHouse Versus MySQL Handling of Double Quotes
If you’re a MySQL user trying ClickHouse, one thing which is likely to surprise – and annoy you – is [...]
February 20, 2020
A Hidden Gem in MySQL: MyRocks
In this blog post, we will share some experiences with the hidden gem in MySQL called MyRocks, a storage engine [...]
February 13, 2020
Introduction to MySQL 8.0 Recursive Common Table Expression (Part 2)
This is the second part of a two-articles series. In the first part, we introduced the Common Table Expression (CTE), [...]
February 13, 2020
Compression of PostgreSQL WAL Archives Becoming More Important
As hardware and software evolve, the bottlenecks in a database system also shift. Many old problems might disappear and new [...]
February 10, 2020
Introduction to MySQL 8.0 Common Table Expressions (Part 1)
This blog is the first part of a two-articles series. In this article, I’m going to introduce the Common Table [...]
February 3, 2020
ClickHouse and MySQL – Better Together
It’s been a while since I wrote about ClickHouse, there are a lot of new features that are worth mentioning, [...]
January 22, 2020
InnoDB Flushing in Action for Percona Server for MySQL
As the second part of the earlier post Give Love to Your SSDs – Reduce innodb_io_capacity_max! we wanted to put [...]