Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Become a ClusterControl DBA: Operational Reports for MySQL, MariaDB, PostgreSQL & MongoDB

The idea behind ClusterControl operational reporting is to put all of the most relevant data into a single document which can be quickly analyzed in order to get a clear understanding of the status of the databases and its processes. This blog post shows how to leverage the ops report functionality to understand the state of your MySQL, MariaDB, MongoDB and PostgreSQL infrastructure.

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.

Become a ClusterControl DBA: Performance and Health Monitoring

This blog post shows how to leverage ClusterControl performance monitoring and advisors functionality to keep your MySQL, MongoDB and/or PostgreSQL databases and clusters healthy.

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.

How ClusterControl Monitors your Database Servers and Clusters Agentlessly

Agentless monitoring is the collection of performance metrics from databases without installing any agent software on the servers being monitored. This approach is easy to manage and gets you up and running within minutes.

This blog post describes how ClusterControl uses the agentless approach to monitor databases.

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.

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.

ChatOps - Managing MySQL, MongoDB & PostgreSQL from Slack

CCBot helps you monitor and manage your database Infrastructure from Slack. ChatOps is about bringing your DevOps work to your chats and conversations within a team, e.g. Slack. You can deploy database clusters, get status information, trigger backups, add nodes to your cluster or replication setup by talking to a chatbot, which understands ClusterControl commands.

Updated: Become a ClusterControl DBA: Safeguarding your Data

So now that you have your databases up and running and highly available, how do you ensure that you have backups of your data? You can use backups for multiple things: disaster recovery, to provide production data to test against development or even to provision a slave node. This last case is already covered by ClusterControl. When you add a new (replica) node to your replication setup, ClusterControl will make a backup/snapshot of the master node and use it to build the replica. 

Pages