Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

How to Deploy PostgreSQL for High Availability

In this blog, we will review some important concepts of High Availability, possible database HA architectures and useful components when implementing PostgreSQL HA. Then we will see how to use ClusterControl to deploy an entire high availability stack for PostgreSQL.

How to Automate Database Workload Analysis with ClusterControl Performance Advisors

ClusterControl provides you with a set of monitoring and performance advisors to add stability to your database infrastructures. It enables you to detect and solve unique problems in your environments. In this blog, you will see how you can also create custom advisors to extend your database environment monitoring with ClusterControl for free.

The Easy Way to Deploy MySQL Replication and ProxySQL with Automatic Failover

This blog post shows you how to easily deploy a highly available MySQL replication setup with ProxySQL and Keepalived using ClusterControl.

Watch the Webinar Replay: An Introduction to Performance Monitoring for PostgreSQL

Watch the replay of our webinar on Performance Monitoring for PostgreSQL. Sebastian Insausti, Support Engineer at Severalnines, introduces us to the PostgreSQL monitoring and performance world with an end-to-end approach as well as some tips and tricks on how to use ClusterControl to monitor PostgreSQL for performance.

Database Security Monitoring for MySQL and MariaDB

The purpose of database security monitoring is twofold. One, to identify security breaches or any unauthorized or undesirable activity on the database. And two, to ensure that  databases comply with policies and security standards set by the organisation.

An Overview of Database Operational Reporting in ClusterControl

It is difficult to measure and report on all database infrastructure components manually. In this article, we discuss the different operational reports available in ClusterControl. ClusterControl operational reports will help you to automate your daily cluster auditings tasks like database backups, operating system workload or instance and schema security.

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.

Introduction to Failover for MySQL Replication - the 101 Blog

With this blog post we aim to give you an introduction to failover handling in MySQL & MariaDB by discussing what failover is, why it is unavoidable and what the difference is between failover and switchover. We also discuss the failover process in its most generic form and touch a bit on different issues that you will have to deal with in relation to the failover process.

Failover for PostgreSQL Replication 101

Failover is a procedure that we hope we won’t have to use, but we must know how it works. In this blog, we will be cover the basic definitions of failover in PostgreSQL replication, and some example scenarios where failover can be useful.

Controlling Replication Failover for MySQL and MariaDB with Pre- or Post-Failover Scripts

Databases are a part of a wider mesh of infrastructure components, and as such, failover usually has some impact on more than just the database. Therefore, the failover software needs a mechanism to orchestrate changes across the infrastructure. This blog post describes how ClusterControl can be integrated with external infrastructure and tools, through the use of scripts executed during failover process.