Tag: MySQL

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 introduced the topic.)  “Who are you?” said the Caterpillar. This was not an encouraging opening for a conversation. Alice…

Read More >

MariaDB Temporal Tables: Uncut & Uncensored (Part II)

(This is the second of a series of blog posts covering MariaDB Temporal Tables. The first blog post can be found here.) There are really four dimensions, three which we call the three planes of Space, and a fourth, Time….

Read More >

MariaDB Temporal Tables: Uncut & Uncensored (Part I)

(This is the first of a series of blog posts covering MariaDB Temporal Tables.) “You must remember this, a kiss is still a kiss. A sigh is just a sigh; the fundamental things apply, as time goes by.” Sam (Dooley…

Read More >

Scaling ProxySQL rapidly in Kubernetes

It’s not uncommon these days for us to use a high availability stack for MySQL consisting of Orchestrator, Consul, and ProxySQL. You can read more details about this stack by reading Matthias Crauwels’ blog post How To Autoscale ProxySQL In…

Read More >

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 follow up to my previous post about a similar architecture but using HAProxy instead. I’ve re-used some of the content…

Read More >

Join Pythian for Percona Live Europe 2019 Amsterdam

Percona Live is always a great opportunity to learn from the best and brightest in the open-source database community. This time, Percona Live Europe is being held at the Hilton Amsterdam Airport Schiphol, The Netherlands from September 30 to October…

Read More >

What to expect at ProxySQL Technology Day in Ghent

On October 3rd ProxySQL will have it’s very first technology day. They have chosen the lovely city of Ghent, Belgium, my home town, as the place to be. For those attending Percona Live Europe in Amsterdam, this is a great…

Read More >

How to get the most out of your EBS performance

A commonly encountered scenario is when EBS volumes are not performing at the expected theoretical performance. Let’s look at some of the potential reasons for that and how we can “fix” it. (When I say EBS volume, I am talking…

Read More >

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 advise just disabling it, but that may not be acceptable from a security point of view in your organization. In…

Read More >

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 >
Page 1 of 7512345...10...Last Page »