Author: Gabriel Ciciliani

After spending four years working with ProxySQL in production, I’ve learned a few interesting lessons about interpreting and processing query rules. I hope to save you some time (and avoid wrong turns) with this summary of ProxySQL query rules. ProxySQL…

When we explore strategies to scale our MySQL-based database layer, we realize that there are many different options. As opposed to proprietary solutions, open-source products nourish themselves from their communities and novel architectures or enhanced versions are generated, often incorporating…

When designing a highly-available MySQL architecture, having a proxy to route the traffic to the appropriate instances is crucial to achieve transparent (or almost) failovers/switchovers. ProxySQL, a popular open source, SQL-level proxy is a great choice for this, and even…

I recently had to compare these two configuration managers to provision MySQL environments in RDS. I had previous Ansible knowledge but I was fairly new to Terraform. With that in mind, I put together a list of resources to see…

Orchestrator is datacenter-aware, meaning that it takes nodes location into consideration when performing a topology change. Let’s explore the options to make Orchestrator automatically detect this configuration.   Using MySQL server One option is to use the monitored database server…

In my previous post, I presented how external persistent volumes were handled by DC/OS on AWS and how persistent services would recover from a node failure. Now let’s review how Kubernetes deals with similar situations, but on Google Cloud.  …

One key factor on running stateful services (i.e., database servers) on container-centric, managed environments is portability: you need the dataset to follow your container instance. I spent some time reviewing how external persistent volumes are handled when working with DC/OS…

Getting a PMM server running on docker is just matter of following a few simple steps. There are, however, some recommended additional steps when implementing a production, long-term deployment. This blog post will try to cover some of the most…

If you are thinking in moving your MySQL databases to AWS, this analysis by Gabriel Ciciliani may help you determine if RDS is the appropriate solution for your data.

Gabriel Ciciliani, MySQL Lead Database Consultant at Pythian, explains how to generate custom MySQL statistics using collectd.