MySQL high availability with ProxySQL, Consul and Orchestrator

In this post, we will explore one approach to MySQL high availability with ProxySQL, Consul and Orchestrator. This is a ...

Setting up MySQL Monitoring With New Relic Infrastructure Pro

Intro If you have a New Relic Infrastructure Pro license, and unmonitored MySQL servers, there's now an easy solution ...

ProxySQL Query Rules: Notes From Production

Query Statspack's "SQL ordered by" Sections Over a Time Period

In this post, I'll present the statspack_top_sqls.sql script, which returns SQL performance statistics by mining the ...

Using MySQL Workbench to Connect Through ProxySQL 2

So, I admit the title for this post is a bit ambiguous. Not only is it the second post I've written in a short period ...

ProxySQL configuration file & startup process explained

When learning ProxySQL, we have seen some confusion around the configuration and especially around the usage of the ...

Using MySQL Workbench to Connect Through ProxySQL

MySQL Workbench is a popular tool for many developers working with a MySQL backend database. In a simple environment ...

How to Test MySQL Server Hostname with ProxySQL Multiplexing

Overview While working on a MySQL Galera cluster with ProxySQL, I was in the process of testing traffic going to the ...

How to solve SELinux and MySQL log rotation issue

Disable SELinux? Think again! SELinux is always a complicated topic. If you search this on the web, most people will ...

How Cloud Computing Has Transformed Over the Last Decade

As we look back on the past ten years, cloud computing may be considered one of the largest transformations in ...

Configuring MySQL in a Docker Container

Editor's Note: Because our bloggers have lots of useful tips, every now and then we update and bring forward a popular ...

Ansible Inventory Automation Using Consul and Orchestrator

Here at Pythian we get a lot of exposure to new technologies and implementation strategies via the work we do ...

An overview of best practices for implementing ML systems - Part 1

In this series of blog posts, we will recommend some best practices identified from our own failures and successes ...

Exposing MyRocks internals via system variables: Part 5, Data Reads

(In the previous post, Part 4, we covered Compression and Bloom Filters) In this blog post, we continue on our series ...

Exposing MyRocks Internals Via System Variables: Part 3, Compaction

(In the previous post, Part 2, we covered Initial Data Flushing.) In this blog post, we continue our series of ...

MariaDB Temporal Tables: Uncut & Uncensored (Part III)

(This is the third of a series of blog posts covering MariaDB Temporal Tables. The first and second in the series ...

Cluster Level Consistency in InnoDB Group Replication

When you have multiple database servers working together as nodes in a cluster, it’s beneficial to understand how data ...

Watch Out When Running Out of Disk Space With InnoDB Group Replication Cluster

Oracle MySQL Community Edition comes with a native, virtually synchronous, clustering solution called InnoDB Cluster. ...

pt-online -schema corner case: When you don’t want to replicate your alter activities across the whole cluster.

Intro When we want to perform a heavy ALTER TABLE against a several gigabytes table the options are quite a few but the ...

Replicating MySQL to Snowflake with Kafka and Debezium—Part One: Data Extraction

What, Snowflake? Yes, Snowflake. While my core skills are based on the Oracle database, lately I’ve been working more ...