Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

ClusterControl Tips & Tricks: How to Manage Configuration Templates for your databases

ClusterControl comes with a set of configuration template files to simplify deployments. This blog post provides an overview of these configuration templates, and how to best make use of them.

Database Cluster Management - Manual vs Automation via ClusterControl

Database Cluster management tasks include restart/recovery of services that fail, topology changes, reconfiguration, rolling upgrades, backups and performing security procedures. Since the tasks usually involve multiple servers, these can be repetitive and error-prone. This blog looks at efficiency gains when using ClusterControl to manage a MySQL Galera cluster as compared to manual ways.

Posted in:

MySQL Replication failover: MaxScale vs MHA (part 4)

This post is an addendum on the MariaDB Replication Manager covering the new improved features

Posted in:

How ProxySQL adds Failover and Query Control to your MySQL Replication Setup

An overview of ProxySQL in a MySQL replication environment, and how ProxySQL adds features like failover and query control to the setup.

Posted in:

MySQL Replication failover: Maxscale vs MHA (part 3)

This post describes how you can implement automated failover with MariaDB using Maxscale and MHA and compares the two with each other.

Posted in:

MySQL Replication failover: Maxscale vs MHA (part 2)

This post describes how you can implement automated failover with MariaDB using Maxscale and MariaDB Replication Manager.

Posted in:

MySQL Replication failover: Maxscale vs MHA (part 1)

This post describes how you can implement automated failover with MariaDB MHA.

Posted in:

Become a ClusterControl DBA: Managing your Database Configurations

Learn about how to manage, alter and template your database configurations in ClusterControl for MySQL, MongoDB & PostgreSQL.

Become a ClusterControl DBA: Making your DB components HA via Load Balancers

There are various ways to retain high availability with databases. You can use Virtual IPs (VRRP) to manage host availability, you can use resource managers like Zookeeper and Etcd to (re)configure your applications or use load balancers/proxies to distribute the workload over all available hosts.

Wordpress Application Clustering using Kubernetes with HAProxy and Keepalived

In this blog post, we’re going to play with Kubernetes application clustering and pods. We’ll use Wordpress as the application, with a single MySQL server. We will also have HAProxy and Keepalived to provide simple packet forwarding (for external network) with high availability capability.

Posted in:

Pages