Monitoring

Overview

SkySQL Observability provides robust monitoring features in the PortalPortal for cloud database launched in SkySQL as well as MariaDB databases outside SkySQL.

  • Monitoring metrics are provided for the entire service and for individual servers

  • Server logs can be viewed and downloaded

  • MariaDB Agent Manager can be used to configure flow of metrics and logs to SkySQL Observability for MariaDB databases on-premises or in private clouds

Compatibility

SkySQL Services

  • Enterprise Server Single Node

  • Enterprise Server With Replica(s)

  • Xpand Distributed SQL

  • ColumnStore Data Warehouse

MariaDB Products Outside SkySQL

  • MariaDB Community Server 10.3

  • MariaDB Community Server 10.4

  • MariaDB Community Server 10.5

  • MariaDB Community Server 10.6

  • MariaDB Enterprise ColumnStore 5

  • MariaDB Enterprise ColumnStore 6

  • MariaDB Enterprise ColumnStore 22.08

  • MariaDB Enterprise ColumnStore 23.02

  • MariaDB Enterprise Server 10.3

  • MariaDB Enterprise Server 10.4

  • MariaDB Enterprise Server 10.5

  • MariaDB Enterprise Server 10.6

  • MariaDB MaxScale 2.4

  • MariaDB MaxScale 2.5

  • MariaDB MaxScale 6

  • MariaDB MaxScale 22.08

  • MariaDB MaxScale 23.02

  • MariaDB Xpand 5.3

  • MariaDB Xpand 6.0

  • MariaDB Xpand 6.1

Metrics

Database server (node) and service (cluster) metrics are collected automatically. The metrics collected are optimized for MariaDB databases.

Summary Information

A high-level summary of service and server status is presented on the PortalPortal Dashboard. Mouseover on each element provides fine-grained detail. Click any element to access expanded monitoring detail.

Available summary information:

Portal Dashboard

Portal Dashboard
https://skysql.mariadb.com/dashboard

Monitoring Dashboards

To access expanded Monitoring dashboards:

  1. Log in to the PortalPortal.

  2. From the Dashboard, click the service name of the desired service.

  3. Choose the "Monitoring" tab (the default).

Dashboards and gauges are topology-specific.

Monitoring

Monitoring
https://skysql.mariadb.com/service/DBID/monitoring/overview

Alerts

Policies (alerting rules) identify "warning" and "critical" events within status and metrics.

For additional information, see "AlertsAlerts".

Notifications

Service AlertsAlerts are communicated using NotificationsNotifications.

By default, notification occurs in the PortalPortal.

Optionally, Notification Channels can be configured for email-based delivery of notifications.

For additional information, see "NotificationsNotifications".

MariaDB Agent Manager

MariaDB Agent Manager can be used to configure flow of metrics and logs to SkySQL Observability for MariaDB databases on-premises or in private clouds.

For the full instructions, see "SkySQL Observability service".