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 Monitor MySQL or MariaDB Galera Cluster with Prometheus Using SCUMM

In this blog, we will show you how to monitor Galera Cluster for MySQL or MariaDB using Prometheus. We will have a look at the newly released SCUMM architecture for agent-based monitoring and how ClusterControl deploys Prometheus and exporters to collect database metrics and the graphs available in the different dashboards.

How to Monitor Multiple MySQL Instances Running on the Same Machine - ClusterControl Tips & Tricks

In this blog post, we’ll show you how to use ClusterControl to monitor multiple MySQL instances running on one host.

How to Deploy MongoDB for High Availability

MongoDB provides ReplicaSets to help you address high availability database requirements. Although support for replication and failover is built-in, it is not enough for the database to be considered production-ready. That requires a set of policies and procedures, like getting alerted in case of performance slowdowns, anomalies or failures in a live environment. Backups are essential. Being able to automatically recover from different types of failures can drastically reduce downtime.

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.

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.

6 Common Failure Scenarios for MySQL & MariaDB, and How to Fix Them

Database failures can happen at different levels, from schema corruption on an individual server to hardware or even an entire datacenter going down. So how do we troubleshoot and fix these? In this blogpost, we will walk through 6 different failure scenarios and see how we recovery from them.

How to perform Schema Changes in MySQL & MariaDB in a Safe Way

This blog describes best practices to make your database schema changes in MySQL and MariaDB flawless. We will walk you through different scenarios and recomment some approaches for each.

A Performance Cheat Sheet for MongoDB

Performance tuning is not trivial, but you can go a long way with a few basic guidelines. In this blog, we will discuss how you analyze the workload of your MongoDB production systems, and then we’ll review a list of important configuration parameters that can help you improve performance.

Comparing RDS vs EC2 for Managing MySQL or MariaDB on AWS

When managing MySQL on AWS, one has the choice between convenience of a hosting service like RDS, and the control and flexibility of running MySQL on EC2. This blog discusses the difference, with focus on the tradeoffs when using replication.

Pages