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 >

Graceful master switchover with ProxySQL and Orchestrator

Introduction One of the things I like about Continuent Tungsten is how Tungsten Connector can hold traffic while a (graceful) master switch is taking place. This means the application may experience a brief spike in latency, but has not returned…

Read More >

ProxySQL behind a load balancer in Google Cloud

Introduction In this article we will explore one approach for deploying ProxySQL behind a load balancer in Google Cloud. While considering the deployment of ProxySQL, one has basically the following options: Install ProxySQL on existing application server(s) Provision dedicated ProxySQL…

Read More >
Page 4 of 25« First Page...23456...10...Last Page »