Skip to content

MySQL Family Plugin

The MySQL Family plugin registers MySQL and MariaDB servers through one common resource model. It exposes connection state, connection pressure, slow queries, InnoDB buffer pool behavior, and replication lag through dashboards and alert rules.

Highlights

  • Detects MySQL or MariaDB with engine=auto for display and mapping compatibility.
  • Supports both Prometheus mysqld_exporter-style metrics and Konduo-managed metric collection.
  • Managed collection reads SHOW GLOBAL STATUS, SHOW GLOBAL VARIABLES, and replica status evidence with read-only queries.
  • Alert packs cover connection pressure, slow-query growth, buffer pool efficiency, replication lag, and scrape coverage.

Before Registration

  • Prepare host, port, database, username, password, TLS, and connection/query timeouts.
  • Use a least-privilege account for managed collection status queries.
  • MySQL and MariaDB share many metric prefixes, but replication metric names can vary; review panel coverage after applying the mapping pack.

Operations Tips

  • engine=auto is for display and mapping compatibility; it does not enable risky engine-specific mutation.
  • Interpret slow queries and buffer pool efficiency with workload changes, cache warm-up, and batch windows.
  • Arbitrary SQL execution, backup/restore, user management, and schema/table changes are outside the current CE operating boundary.

MySQL Family Enterprise Overlay

The MySQL Family Enterprise overlay adds MCP descriptors, advanced diagnostics, metric mapping, and anomaly detectors to MySQL and MariaDB resources. It correlates connection pressure, InnoDB, replication, workload quality, and metric coverage.

Highlights

  • Provides metadata, dashboards, monitoring overview, diagnostics, metrics catalog, and alert/anomaly rules through MCP.
  • Uses both declarative metric rules and plugin-executed detectors.
  • Plugin detectors collect bounded operational snapshots and evaluate only plugin-mode rules.
  • Diagnostics cover connectivity, engine identity, workload, InnoDB, replication, metric coverage, and alert readiness.

Before Registration

  • Community MySQL or MariaDB connectivity and permissions must be healthy.
  • Connect Prometheus exporter metrics and the mapping pack.
  • Confirm read permissions and topology access required for replication diagnostics.

Operations Tips

  • Review slow queries, connection saturation, and InnoDB pressure together with workload changes and deployment events.
  • Plugin-mode detectors and metric-mode rules use different inputs; compare snapshot evidence with metric coverage when results differ.