Tag: MySQL

HAProxy MySQL Lag Awareness via systemd

In one of the projects I have been working on, one requirement was the ability to stop traffic from reaching a MySQL host which has been lagging behind its master for longer than a specific amount of time and then…

Read More >

Log Buffer #547: A Carnival of the Vanities for DBAs

This Log Buffer edition covers Oracle, SQL Server and MySQL.

Read More >

MySQL Streaming Xtrabackup to Slave Recovery

Overview There are times when I need to restore a slave from a backup of a master or another slave, but too many times I have taken the typical approach of taking the backup on the source server and then…

Read More >

Debugging MySQL on Docker

In a recent post, my colleague and teammate Peter Sylvester explained how we could customize MySQL’s configuration when running it as a Docker container. Today I want to show you how to debug a Dockerized MySQL process. Let me start…

Read More >

Backing up your MySQL instance physically with Docker

In a previous post I had mentioned that I was doing a bit of digging into Docker in order to get a better grasp of the technology. Part of that was exploring common administrative tasks. I would venture to say…

Read More >

Configuring MySQL in a Docker Container

In recent weeks I’ve been focusing on Docker in order to get a much better understanding of the containerized world that is materializing in front of us. Containers aren’t just for stateless applications anymore and we’re seeing more cases where…

Read More >

Conference review Percona Live Santa Clara 2018

Percona Live Santa Clara, an annual event where open source database users, developers and enthusiasts come together, was held in April at the Santa-Clara convention centre. Pythian was well represented once more with no less than five presentations and a…

Read More >

Authenticating Vault Against LDAP for Accessing MySQL Through ProxySQL

Earlier this year, I was presented with the challenge of streamlining user access to MySQL, allowing users self-serve access using their LDAP credentials, while logging all access. Of course, various MySQL forks allow for user auditing, but the solution is…

Read More >

MySQL High availability with HAProxy, Consul and Orchestrator

Introduction In this post we will explore one approach to MySQL high availability with HAProxy, Consul and Orchestrator. Let’s briefly go over each piece of the puzzle first: – HAProxy is usually installed on the application servers or an intermediate…

Read More >

Restore a table / database from full backup – Yet another way

Restore requests are common and so are the restores of specific entities: a database, or one or more table(s). This has been discussed a lot and we have plenty of tools and solutions already available. In this blog post we…

Read More >
Page 1 of 7112345...10...Last Page »