Author - Jake Davis

How To Inject an Empty XA Transaction in MySQL

Inject an Empty XA Transaction in 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.

Shell

Last_Error: Error ‘XAER_NOTA: Unknown XID’ on query. Default database: ‘punisher’. Query: […]

Read more

Setting up a ProxySQL Sidecar Container

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 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) […]

Read more