Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Basic Administration Comparison Between Oracle, MSSQL, MySQL, PostgreSQL

Supporting different types of databases in a mixed environment is not an easy task. In this blog post we will compare different types of RDBMS systems from the DBA/DevOps administration perspective.

SCUMM: the agent-based database monitoring infrastructure in ClusterControl

Please meet SCUMM - Severalnines CMON Unified Monitoring and Management - our agent-based monitoring infrastructure, which is the cornerstone of our latest ClusterControl release.

Top GUI Tools for PostgreSQL

Using a GUI is not a must, but it can be useful in some cases. In this blog, we'll see some advantages and warnings about the use of these tools, as well as do a short review of some of the most commons GUI tools for PostgreSQL.

Monitoring & Ops Management of MongoDB 4.0 with ClusterControl

MongoDB 4.0 added support for multi-document ACID transactions, which brings it closer to the relational world. But how can you manage it, along with other relational open source databases like MySQL, MariaDB and PostgreSQL? In this blog post, we look at the challenges of operating a MongoDB database, and see how important tasks like monitoring, alerting, backups and failover can be handled with ClusterControl.

Monitoring HAProxy Metrics And How They Change With Time

There is a lot information on the traffic that is routed through HAProxy, as well as the state of the backends. This blog post discusses different HAProxy metrics, which ClusterControl collects and presents in the agent-based monitoring mode with Prometheus.

How to Monitor MongoDB with Prometheus & ClusterControl

ClusterControl’s new agent-based monitoring of MongoDB with Prometheus offers dashboards with graphs of high resolution metrics data. In this blog, we will have a look at the different graphs that are available to users.

PostgreSQL Replication for Disaster Recovery

This blog explains how to utilize streaming replication and point in time recovery to achieve high availability using failover.

Database Monitoring - Troubleshooting Prometheus with SCUMM Dashboards

Our SCUMM dashboards rely on Prometheus and exporters to provide high-resolution monitoring data. However, there are cases when dashboards may not load. This blog goes through some troubleshooting guidelines.

Effective Monitoring of MySQL With SCUMM Dashboards - Part 3

In this 3rd part of the blog series, we’ll discuss what ClusterControl’s new InnoDB Metrics and MySQL Performance dashboards have to offer. These dashboards provide a pretty in-depth view of MySQL performance. We’ll go through the different graphs, and see how a DBA can leverage them.

Simple Scheduling of Maintenance Windows across your Database Clusters

Maintenance is something that an operation team can not avoid. ClusterControl can be configured to simplify your maintenance routines. In this post, we’ll show you some advanced use cases of cluster-wide maintenance with iterations using ClusterControl CLI.