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 of time, but it’s also focused on ProxySQL 2.0. As promised in the previous post,…

Read More >

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 where you can connect directly to the database it works very intuitively, but in more complex environments it might be a…

Read More >

Still have binlog_error_action as IGNORE_ERROR?

Recently, we were affected by an ignored configuration option introduced in MySQL 5.6. This incident caused us to perform extended planning of downtime and the rebuilding of the slave. In this post, we’ll discuss our encounter with binlog_error_action and likely…

Read More >

Orchestrator fails to start after reboot using SystemD

While testing in an orchestrator lab I saw that none of my Orchestrator on-raft nodes were coming online after a reboot. This is the status report from SystemD. $ sudo systemctl status orchestrator * orchestrator.service – orchestrator: MySQL replication management…

Read More >

World Backup Day – The MySQL perspective

Today is World Backup Day, reminding us of the importance of backups. Here at Pythian we LOVE YOUR DATA and as database consultants we are therefore very much focussed on making sure that our client’s data is always secure and…

Read More >

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 consistency is established. In this post, we’re going to take a look at the various cluster consistency levels that you can…

Read More >

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