Tag - insight for DBAs

Split-Brain 101: What You Should Know

Split-brain datasets

Disclaimer: The following blog post does not try to provide a solution for split-brain situations, and the example provided is for demonstrative purposes only. Inconsistencies resulting from a split-brain scenario might possibly be more complex than the one shown, so do not use the following example as a complete guide.
What is Split-Brain?
A split-brain scenario […]

Read more

A Tale About Migrating a PostgreSQL Database Between Different DBaaS Providers

Migrating PostgreSQL Between DbaaS Providers

We recently helped migrate a production PostgreSQL database running on a given DBaaS platform… to another DBaaS platform. When it comes to vendor “lock-in”, some providers are easier (and even friendlier) to deal with than others, but it is never a straightforward process. While in a traditional environment we would usually approach this problem […]

Read more

The Changing Face of Enterprise DBAs in Cloud-Driven Environments

DBA in cloud environments

Over the past ten years, those in charge of running enterprise databases saw their focus shift from simply ensuring access and availability to overseeing architecture, design, and scalability.
Site reliability engineers (SREs) and/or DBAs suddenly found themselves responsible for not only ensuring the company’s primary revenue engine stayed up but also for ensuring it could […]

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

DBA Concerns About Next-Gen, Non-Volatile Memory Storage Products

DBA Concerns Memory Storage

Abstract: Storage engine algorithmic gains have mostly settled and Moore’s law for CPU speed is bottoming out, but database performance still stands to increase ~10x thanks to continuing NAND Flash improvement, Optane, Flash-idiomatic SSD drives (e.g. OpenChannel, Zoned Namespaces), KeyValue SSD, etc. The downside is each storage engine revolution historically has broken encapsulation/reuse and […]

Read more