Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
16 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.

Monitoring your Databases with ClusterControl

Observability is critical piece of the operations puzzle - you have to be able to tell the state of your systems based on trending data presented in the form of graphs and alerts. Ideally, this data will be available from one single location. This blog explains how ClusterControl can work as a monitoring hub for all your database systems.

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.

ClusterControl Tips & Tricks: Securing your MySQL Installation (Updated)

During the life cycle of Database installation it is common that new user accounts are created. It is a good practice to once in a while verify that the security is up to standards. That is, there should at least not be any accounts with global access rights, or accounts without password. Using ClusterControl, you can at any time perform a security audit.

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.

Automating and Managing Open Source Databases for Streaming Video Applications

StreamAMG is Europe’s largest player in online video solutions, helping football teams such as Liverpool FC, Aston Villa, Sunderland AFC and the BBC keep fans watching from across the world. Here we discuss their database challenges with them and how ClusterControl helps them overcome these.

DIY Cloud Database on Amazon Web Services - New Whitepaper

This new whitepaper provides a step-by-step guide to setup your AWS environments and how-to configure it for optimal database operations; incl. an example overview of how to automate the deployment and management of a MongoDB cluster using ClusterControl.

About Cloud Lock-in and Open Source Databases

Severalnines CEO Vinay Joosery discusses key considerations to take when choosing cloud providers to host and manage mission critical data; and thus avoid cloud lock-in.

Pages