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

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.

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

Updated - Full Restore of a MySQL or MariaDB Galera Cluster from Backup

Performing regular backups of your database cluster is imperative for high availability and disaster recovery. This blog post provides a series of best practices on how to fully restore a MySQL or MariaDB Galera Cluster from backup.

MySQL Replication and GTID-based failover - A Deep Dive into Errant Transactions

This blog post covers deployment of replication cluster using ClusterControl. It also discusses in-depth a concept of errant transactions, how to detect them and how to fix issues related to them.