How To Inject an Empty XA Transaction in MySQL

Sep 15, 2020 | Insight for DBAs, MySQL

If you are using XA transactions, then you’ve likely run into a few replication issues with the 2PCs (2 Phase Commits). Here is a common error we see in Percona’s Managed Services and a few ways to handle it, including injecting an empty XA transaction.

What Does it Mean? It means that replication has tried […]

Prepare MySQL for a Safe Shutdown

May 07, 2020 | Insight for DBAs, MySQL

In Percona’s Managed Services, we start up and shut down MySQL servers all the time.  Over the years, we’ve seen various issues occur due to the way servers are shut down.  No matter if it is a situation where unexpected errors appear in the log or you’re stuck waiting for hours for a server to […]

Setting up a ProxySQL Sidecar Container

Mar 23, 2020 | Insight for DBAs, ProxySQL

Recently, a client of ours, Duolingo, was using Aurora was reaching the max connection limit of 16,000 (that is Aurora’s hard limit for all instance classes). In this case, Percona recommended implementing ProxySQL to manage connections (now their max connections only peak to 6000!). Duolingo’s main application is run in AWS ECS (Elastic Container Service) […]