Author: Gabriel Ciciliani

Addressing common challenges when scaling out MySQL horizontally

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…

Read More >

Obtaining an active-passive ProxySQL on FreeBSD

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…

Read More >

RDS provisioning: A comparision between Ansible and Terraform

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…

Read More >

Orchestrator datacenter detection

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…

Read More >

Container orchestrators and persistent volumes: part 2: Kubernetes

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.  …

Read More >

Container orchestrators and persistent volumes – part 1: DC/OS

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…

Read More >

Dockerized PMM in production

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…

Read More >

MySQL on AWS: RDS vs EC2

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.

Read More >

Custom MySQL statistics with collectd

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

Read More >

DECIMAL columns and a non-expected replication error

Gabriel Ciciliani, MySQL Lead Database Consultant at Pythian, provides a guideline to analyzing a replication issues involving decimal columns and RBR, and how to deal with the problem without reseeding the slave.

Read More >
Page 1 of 212