Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
46 blog posts in 13 categories

MySQL & MariaDB Query Caching with ProxySQL & ClusterControl

A query cache can greatly improve database performance, and there are various types of mechanisms available - from the inbuilt MySQL query cache to external key value stores like memcached or Redis. In this blog, we’ll show you how to cache your queries via ProxySQL, and avoid the overhead of an additional dedicated caching layer.

SQL Firewalling Made Easy with ClusterControl & ProxySQL

This blog describes how to use ClusterControl and ProxySQL to implement an SQL firewall in front of your database servers. The firewall uses a regular expression matching engine to inspect SQL statements going to the database through the proxy, and determines whether to allow, block, reroute or rewrite the incoming query.

Posted in:

MySQL on Docker: Running ProxySQL as Kubernetes Service

When your application containers are orchestrated and managed by Kubernetes, you might want to use ProxySQL in front of your database servers. In this post, we’ll show you how to configure ProxySQL as a Kubernetes service.

How to Cluster Your ProxySQL Load Balancers

ProxySQL typically sits between the applications and the database servers, so we have to be careful that it does not become a single point of failure (SPOF). In this blog post, we’ll explain how you can set up a ProxySQL cluster for redundancy.

Posted in:

Choosing a Database Proxy for MySQL & MariaDB - New Whitepaper

This whitepaper will discuss what proxies are, what their use is and how to build a highly available and highly controllable MySQL and MariaDB database environment using modern proxies such as HAProxy, ProxySQL and MaxScale.

MySQL on Docker: Running ProxySQL as a Helper Container on Kubernetes

When your application containers are orchestrated and managed by Kubernetes, you might want to use ProxySQL to better take advantage of your distributed database service running on replication or Galera. In this post, we are going to cover how to run ProxySQL on Kubernetes as a helper container in a pod.

How to Monitor Your ProxySQL with Prometheus and ClusterControl

In this blog post, we’ll look into how to monitor your ProxySQL instances in-depth using ClusterControl’s new agent-based monitoring approach with Prometheus.

The Easy Way to Deploy MySQL Replication and ProxySQL with Automatic Failover

This blog post shows you how to easily deploy a highly available MySQL replication setup with ProxySQL and Keepalived using ClusterControl.

MySQL on Docker: Running a MariaDB Galera Cluster without Orchestration Tools - DB Container Management - Part 2

So you’ve deployed MariaDB cluster on Docker, what next? What do you do when containers fail or are rescheduled, and IP addresses change? How do you ensure that the database adapts to changes to the underlying container configurations? In this follow-up blog post, we’ll look into cluster management and orchestration of Galera cluster on Docker.

MySQL on Docker: Running a MariaDB Galera Cluster without Container Orchestration Tools - Part 1

Container orchestration tools do not always play nicely with database clusters. In this blog post, we are going to look into how to run a MariaDB Galera Cluster on Docker containers using the standard Docker image on multiple Docker hosts without the help of orchestration tools like Swarm or Kubernetes.

Pages