Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

Comparing Database Proxy Failover Times - ProxySQL, MaxScale and HAProxy

This blog describes the failover and switchover operations executed by ClusterControl, and compares failover times when using ProxySQL, MaxScale and HAProxy.

Updated: ClusterControl Tips & Tricks - Transparent Database Failover for your Applications

This blog shows you how to make database failure and failover transparent to your applications, by using HAProxy or ProxySQL.

How ClusterControl Configures Virtual IP and What to Expect During Failover

This blog post covers how ClusterControl helps you to eliminate single point of failure of your database load balancers by using virtual IP address.

Failover for MySQL Replication (and others) - Should it be Automated?

This blog discusses whether automated failover should be used in a MySQL Replication environment setup.

Posted in:

Become a PostgreSQL DBA: Point-in-Time Database Restoration

In this blog post,  we describe how to perform point-in-time recovery in PostgreSQL

Several Ways to Intentionally Fail or Crash your MySQL Instances for Testing

This blog post features some ideas (with examples) on how to crash a MySQL server in a Linux environment.

Manage and Automate Galera Cluster - Why ClusterControl

This blog describes why you should utilize ClusterControl for the management of your Galera Clusters.

Automatic failover of Postgres Replication - New in ClusterControl 1.4.2

This blog post describes new features for PostgreSQL in ClusterControl 1.4.2