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

Automatic failover of MySQL Replication - New in ClusterControl 1.4

MySQL replication setups are inevitably related to failovers - what do you do when your master fails and your applications are not able to write to the database anymore? Automated failover is required if you need to quickly recover an environment to keep your database up 24x7. This blog post discusses this new replication feature recently introduced in ClusterControl 1.4.

Become a MongoDB DBA: Recovering your Data

This is our sixth post in the “Become a MongoDB DBA” blog series - how do you recover MongoDB using a backup.

MySQL Replication failover: MaxScale vs MHA (part 4)

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

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.

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.

MySQL Replication failover: Maxscale vs MHA (part 1)

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

Become a MySQL DBA blog series - Understanding the MySQL Error Log

We are yet to see a software that runs perfectly, without any issues. MySQL is no exception there. It’s not the software’s fault - we need to be clear about that. We use MySQL in different places, on different hardware and within different environments. It’s also highly configurable. All those features make it great product but they come with a price - sometimes some settings won’t work correctly under certain conditions.

Webinar Replay & Slides: Become a MySQL DBA - Replication Topology Changes for MySQL and MariaDB

Thanks to everyone who joined us for our recent live webinar on ‘Replication Topology Changes for MySQL and MariaDB’ led by Krzysztof Książek, Senior Support Engineer at Severalnines. The replay and slides to the webinar are now available to watch and read online.

Architecting for Failure - Disaster Recovery of MySQL/MariaDB Galera Cluster

Whether you use unbreakable private datacenters or public cloud platforms, Disaster Recovery (DR) is indeed a key issue. This is not about copying your data to a backup site and being able to restore it, this is about business continuity and how fast you can recover services when disaster strikes.

Point-in-time Recovery in MySQL Galera Cluster

Data protection is vital for DB admins, especially when it involves data that is accessed and updated 24 hours a day. Clustering and replication are techniques that provide protection against failures, but what if a user or DBA issues a detrimental command against one of the databases? A user might erroneously delete or update the contents of one or more tables, drop database objects that are still needed during an update to an application, or run a large batch update that fails midway. How do we recover lost data?