Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

ClusterControl Tips & Tricks: Manage and Monitor Your Existing MySQL NDB Cluster

NDB Cluster is an advanced storage engine in MySQL, and provides automatic sharding and replication of data. However, it does take quite a bit of effort to administer. This blog post explains how to import MySQL NDB Cluster into ClusterControl so you can manage it from a web interface.

How to Deploy a MySQL NDB Cluster Using ClusterControl

This blog post describes the process of easily deploying MySQL NDB Cluster using ClusterControl.

Posted in:

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.

Monitoring your Databases with ClusterControl

Observability is critical piece of the operations puzzle - you have to be able to tell the state of your systems based on trending data presented in the form of graphs and alerts. Ideally, this data will be available from one single location. This blog explains how ClusterControl can work as a monitoring hub for all your database systems.

Introduction to Failover for MySQL Replication - the 101 Blog

With this blog post we aim to give you an introduction to failover handling in MySQL & MariaDB by discussing what failover is, why it is unavoidable and what the difference is between failover and switchover. We also discuss the failover process in its most generic form and touch a bit on different issues that you will have to deal with in relation to the failover process.

Controlling Replication Failover for MySQL and MariaDB with Pre- or Post-Failover Scripts

Databases are a part of a wider mesh of infrastructure components, and as such, failover usually has some impact on more than just the database. Therefore, the failover software needs a mechanism to orchestrate changes across the infrastructure. This blog post describes how ClusterControl can be integrated with external infrastructure and tools, through the use of scripts executed during failover process.

How to Control Replication Failover for MySQL and MariaDB

Automated failover is a critical functionality in a MySQL or MariaDB replication setup, involving master-promotion and reslaving. Now, not all slaves are good master candidates, so how do you control which node gets picked? This blog introduces whitelists and blacklists.

Schema Management Tips for MySQL & MariaDB

Schema changes are not popular among database ops folks. They can be quite cumbersome in MySQL and MariaDB, and there are risks to the data as well as the availability of the database.

This blog describes the different types of schema change operations you can perform on MySQL and MariaDB, and presents some best practices to minimize disruptions to your operations.

How to Benchmark Performance of MySQL & MariaDB using SysBench

How can you quickly evaluate performance of a database under intensive load? Welcome to sysbench. This blog gives you a good background of sysbench, and how you can use it to benchmark MySQL and MariaDB.

How to Recover Galera Cluster or MySQL Replication from Split Brain Syndrome

Split brain syndrome is a state where a cluster of nodes is partitioned into smaller clusters of equal numbers of nodes, and each cluster believes it is the active cluster. This is a harmful state, as data is changed on a partition, without being replicated to the other. This blog post describes how to prevent a split brain from happening, and what can be done if it does happen.

Pages