Skip to content

Database Status & Health Checks

There are several ways to perform database health checks to ensure it runs correctly. ClusterControl provides comprehensive features to monitor your database clusters. Here's how to effectively check database health and status:

Cluster Summary

The Cluster Summary page appears after login into the ClusterControl UI. The Cluster Summary describe the status of each cluster database either it is in Operational, Failed, Offline, Shutdown, Recovering or Unreachable/Unknown. There is also information about global alert in Cluster Summary which give information about Critical alerts across all clusters, Warning notifications, Informational messages.

There is a filter on the right side in Cluster Summary which you can filter the status of Cluster either Operational, Unknown State, Failed, or All.

How to access the Cluster Summary:

  1. Login into the ClusterControl UI.

  2. The landing page will go to the Home menu and you will see the status of each database cluster, nodes, and alarms too.

  1. Check status of the cluster.

    s9s cluster --list --long

  2. Filter the cluster specific by clusterID.

    s9s cluster --cluster-id=<clusterID> --list --long

Dashboard Metrics

The dashboard metrics provides a comprehensive set of real-time and historical metrics on its dashboard to monitor your database clusters from system-level metrics, database specific, cluster health status, performance advisors.

Cluster Load

The cluster-wide load metrics to help monitor the overall performance and health of entire database cluster (not just individual nodes). These metrics give a high-level view of how well the cluster is handling workloads and whether it's operating efficiently. It give insight related to Total Queries Per Second (QPS), Read vs. Write Ratio (%), Slow Queries Count, Connection, Active Connections.

Monitor the Cluster Load in ClusterControl:

  1. Login into the ClusterControl UI.

  2. Go to specific cluster, and choose the Dashboard.

  3. Choose the Cluster Overview, and you will see the Cluster Load metrics.

Cluster Health Status

The Cluster Health metrics provide a holistic view of the database cluster's operational state, ensuring high availability and quick issue detection. The node status metrics display real-time condition on each servers, clearly indicating roles (primary/master for write operation or secondary/slave for read scaling), the replication status, and health states (online, offline, recovery).

Utilize the Cluster Health Metrics in ClusterControl using statistics information in the database overview:

  1. Login into the ClusterControl UI.

  2. Go to specific cluster, and choose the Dashboard.

  3. Choose the Cluster Overview, and you will see information about status of Primary & Secondary nodes status of database. Hover the pointer into the each column will describe the ToolTip which describe information about the column.

  4. The statistics can be expanded, there is icon in the right side to expand the data. For example in MariaDB/MySQL-based, information available in Primary Node are: Instance, ServerID, ExecutedGTID, Binlog File, Binlog Pos, Binlog do DB and Binlog ignore DB, Semisync status.

Note

Available in MySQL/MariaDB and PostgreSQL

There is information to check the status database.

  1. Login into the ClusterControl UI.

  2. Go to specific cluster, and choose the Dashboard.

  3. Choose the MySQL Server - General or MongoDB Server, and it will see information about database Uptime, queries per second, percentage of connection used, and buffer hit ratio.

Note

Available in MySQL and MongoDB

Another metric that can be used to check the database status and health is the Load Average Ratio. The Load Average refers to the average number of processes that are either running on the CPU or waiting for CPU time.

  1. Login into the ClusterControl UI.

  2. Go to specific cluster, and choose the Dashboard.

  3. Choose the Cluster Overview, and it will see information Load Average in 1 minute, 5 minutes, and 15 minutes. The default range of time metrics is 15 minutes.

Performance Advisors

The Performance Advisor in ClusterControl is an intelligent monitoring feature that automatically analyzes database clusters to detect performance issues, configuration problems, and potential risks, providing actionable recommendations for optimization.

There are a number of metrics monitored by the advisors, such as:

  • CPU usage
  • Disk Space usage
  • Connection used
  • Connection ever used
  • InnoDB Dirty Pages
  • Top Queries
  • Numa checks
  • Replication check

The thresholds, justifications, and advice are based on a custom configuration, which is flexible to manage. The advisors can be managed through:

  1. Login into the ClusterControl UI.

  2. Go to specific cluster, and choose the Manage → Advisors.

  3. There is Action on each type of Advisories and some menu such as Edit scripts (modify the advisors script based on JavaScript), Edit Param (change the schedule and parameter argument), and Disable the advisor.

Monitor the Performance Advisors can be accessed in ClusterControl

  1. Login into the ClusterControl UI.

  2. Go to specific cluster, and choose the Performance → Advisors.

  3. There will be information about type of Advisories, Host, Status, Justification, and Advice.

Copyright © 2014-2025 Severalnines AB. All rights reserved.

Severalnines and ClusterControl are registered trademarks in the US, UK, and EU. The 3rd-party trademarks on this site are property of their respective owners and are used for referential purposes only.

Made with Material for MkDocs