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 >

Datascape podcast episode 24 – MariaDB and the MySQL ecosystem

Today on the show, I am joined by my colleagues, John Schulz and Valerie Parham-Thompson. Both John and Valerie just returned from the MariaDB Conference in New York City. As MariaDB is a native, relative and viable option to MySQL,…

Read More >

Why column stores?

Introduction I’ve been working with data in many forms for my entire career. During this time, I have occasionally needed to build or query existing databases to get statistical data. Traditional databases are usually designed to query specific data from…

Read More >

MySQL log rotation

Overview I find far too often that MySQL error and slow query logs are unaccounted for.  Setting up log rotation helps make the logs manageable in the event that they start to fill up and can help make your troubleshooting…

Read More >

The case against auto increment in MySQL

Introduction In my travels to visit many customers over the last few years, I often see my customers creating many or all of their MySQL InnoDB tables using auto-increment primary keys. Many Object Relational Mappers do this by default on…

Read More >

Dockerized PMM in production

Getting a PMM server running on docker is just matter of following a few simple steps. There are, however, some recommended additional steps when implementing a production, long-term deployment. This blog post will try to cover some of the most…

Read More >
Page 5 of 26« First Page...34567...10...Last Page »