Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

How to Automate Database Failover with ClusterControl

It might not be possible to avoid disasters, but with some preparation, it is certainly feasible to reduce the impact on your business. Automatic failover is one of those things. The goal of database failover automation is to minimize your downtime and reduce loss of money. However, failover can not always be automated as there are risks; false positives may lead to unnecessary escalations.

In this blog, we’ll have a look components you may use to build an automated stack, and take a closer look at ClusterControl’s failover functionality.

Visualizing your Cluster Topology in ClusterControl

Topology View provides a visual representation of your database nodes and load balancers in real time, in a simple and friendly interface and without the need to install any additional tools.

Top PG Clustering HA Solutions for PostgreSQL

Achieving high availability and clustering in PostgreSQL is not an easy task. In this blog entry we discuss some options for implementing these and not collapsing in the process!

How to Secure your PostgreSQL Database - 10 Tips

Security is not a game, it is a necessity! In this post we will discuss some common attacks against PostgreSQL server, and how to avoid them.

Ten Tips on How to Achieve MySQL and MariaDB Security

This blog gives you 10 suggestions on how to improve the security of your MySQL or MariaDB installations.

Database Cluster Management - Manual vs Automation via ClusterControl

Database Cluster management tasks include restart/recovery of services that fail, topology changes, reconfiguration, rolling upgrades, backups and performing security procedures. Since the tasks usually involve multiple servers, these can be repetitive and error-prone. This blog looks at efficiency gains when using ClusterControl to manage a MySQL Galera cluster as compared to manual ways.

Infrastructure Automation - Deploying ClusterControl and MySQL-based systems on AWS using Ansible

This blog post has the latest updates to our ClusterControl Ansible Role. It now supports automatic deployment of MySQL-based systems (MySQL Replication, Galera Cluster, NDB Cluster).

MySQL on Docker: Single Host Networking for MySQL Containers

This blog covers the basics of how Docker handles single-host networking, and how MySQL containers can leverage that.

MySQL Docker Containers: Understanding the basics

In this post, we will cover some basics around running MySQL in a Docker container. It walks you through how to properly fire up a MySQL container, change configuration parameters, how to connect to the container, and how the data is stored.

Webinar Replay & Slides: How to build scalable database infrastructures with MariaDB & HAProxy

Replay of the webinar with WooServers and Severalnines on how CloudStats.me moved from MySQL to clustered MariaDB with HAProxy and MaxScale for high availability.