Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
40 blog posts in 1 category

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.

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.

Galera Cluster Recovery 101 - A Deep Dive into Network Partitioning

Galera automatic node provisioning and membership control simplifies database cluster operation and improves the reliability of its replication technology. In this blog post, we are diving into the Galera recovery process in events where network partitioning happens.

How to Recover MySQL Galera Cluster from an Asynchronous Slave?

What do you do if you lose your Galera Cluster? A simple solution is to failover to an asynchronous slave. The slave would immediately serve up-to-date data to applications, with minimal downtime. But then, with the slave being the new source of truth, how do you recover your Galera Cluster?

New Whitepaper: Disaster Recovery Planning for MySQL & MariaDB

Wondering about disaster recovery (DR) planning for MySQL and MariaDB? Unsure about RTO and RPO? Should you have a secondary datacenter? How about DR in the cloud? Well, this is the resource for you. In this white paper, we’ll explore DR concepts and discuss the different options available from the MySQL & MariaDB ecosystem for meeting different levels of DR requirements.

Cloud Disaster Recovery for MariaDB and MySQL

This blog is a handy survival guide for MySQL & MariaDB (cloud) disaster recovery and how to survive datacenter failures.

My MySQL Database is Corrupted... What Do I Do Now?

Performing regular database backups is imperative for any production system. Usually when MySQL data gets corrupted, the recommendation is to restore it from the last backup, switch to DR server or take down the affected node down, if you have a cluster, to serve data immediately from other nodes. In some cases you can't - if the backup is not there, the cluster was never set up, your replication is down for a very long time, or the DR procedure was never tested.

How to Overcome Accidental Data Deletion in MySQL & MariaDB

Someone accidently deleted part of the database, or forgot to include a WHERE clause in a DELETE query, or dropped the wrong table. Things like that may and will happen, it is inevitable and human. But the impact can be disastrous. What can you do to guard yourself against such situations, and how can you recover your data?

How to do Point-in-Time Recovery of MySQL & MariaDB Data using ClusterControl

Point-in-Time recovery of MySQL & MariaDB involves restoring the database from backups prior to the target time, then uses incremental backups and the binlog to roll the database forward to the target time. This blog provides an overview of this new ClusterControl feature.