Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Database Security Monitoring for MySQL and MariaDB

The purpose of database security monitoring is twofold. One, to identify security breaches or any unauthorized or undesirable activity on the database. And two, to ensure that  databases comply with policies and security standards set by the organisation.

How to Monitor your Database Servers using ClusterControl CLI

In this blog post, we will show you how you can monitoring your database clusters using your terminal and the s9s Command Line Interface.

MySQL on Docker: How to Monitor MySQL Containers with Prometheus - Part 1 - Deployment on Standalone and Swarm

Prometheus is an open-source software for monitoring and alerting, it depends on exporters to ‘scrape’ information from e.g., MySQL running on Docker. In this blog, we’ll see how to deploy the database as well as the monitoring stack with Prometheus and its components. We’ll do this for both MySQL running on standalone Docker containers as well as a Galera Cluster running on Docker Swarm.

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.

Watch the Webinar Replay: Disaster Recovery Planning for MySQL & MariaDB with ClusterControl

Watch the replay of this webinar with Vinay Joosery, CEO at Severalnines, during which he explains key disaster recovery concepts and walks us through the relevant options from the MySQL & MariaDB ecosystem in order to meet different tiers of disaster recovery requirements; and learn how ClusterControl can help user fully automate an appropriate disaster recovery plan.

Asynchronous Replication Between MySQL Galera Clusters - Failover and Failback

Asynchronous replication places no low latency demands on the network, so it is possible to keep Galera Clusters in sync even when they are thousands of miles apart and utilise low-cost connections. We effectively can achieve a global system of loosely-coupled clusters. However, managing the global state translates into managing failover and failback operations at both node and cluster level.

6 Common Failure Scenarios for MySQL & MariaDB, and How to Fix Them

Database failures can happen at different levels, from schema corruption on an individual server to hardware or even an entire datacenter going down. So how do we troubleshoot and fix these? In this blogpost, we will walk through 6 different failure scenarios and see how we recovery from them.

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.

ClusterControl Release 1.6.2: New Backup Management and Security Features for MySQL & PostgreSQL

This blog provides an overview of the new Backup Management and Security & Compliance features for MySQL & PostgreSQL in the ClusterControl 1.6.2 release.

Posted in:

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.