MySQL Observability | Germain Documentation

📊 Monitor MySQL Availability, Performance & Reliability with GermainUX

GermainUX provides real-time Observability, Performance Monitoring, Analytics, Alerting, and Automation for MySQL databases.

Monitor MySQL availability, performance, queries, connections, storage, backups, errors, and supporting infrastructure to quickly identify conditions affecting application performance and reliability.

GermainUX provides visibility across:

Application → SQL Query → MySQL → Database → Infrastructure

🛰️ Database Availability Monitoring

Continuously monitor the availability of MySQL database instances.

GermainUX can help teams:

Monitor database uptime
Detect connectivity issues
Identify database availability problems
Track availability over time
Alert teams when MySQL becomes unavailable

Availability can be analyzed alongside other MySQL and application telemetry to understand the operational impact of outages or degraded connectivity.

📈 MySQL Performance Monitoring

Monitor key MySQL and infrastructure performance indicators to identify resource constraints and performance degradation.

Depending on the monitored environment, analyze metrics such as:

CPU usage
Memory utilization
Disk I/O
Network traffic
Database performance metrics

Historical analytics help identify recurring bottlenecks and performance trends.

⏱️ Query Performance

Monitor SQL queries executed against MySQL to identify slow or inefficient database operations.

Analyze information such as:

Query response time
Query execution
Execution plans
Index usage
Slow-running queries

Query performance can be tracked over time to identify recurring database bottlenecks and optimization opportunities.

🔗 Database Connection Monitoring

Monitor active MySQL database connections and connection usage.

GermainUX can help identify:

Active connections
Connection utilization
Excessive connection counts
Potential connection leaks
Changes in connection activity

Connection monitoring helps identify application or database conditions that may affect scalability and performance.

💽 Disk Space & Tablespace Utilization

Monitor MySQL database storage to identify capacity conditions before they affect database operation.

Monitor:

Database disk usage
Tablespace utilization
Available storage
Data-storage capacity
Log-storage capacity

Alerts can be configured before storage reaches critical thresholds.

🛡️ Backup & Recovery Monitoring

Monitor MySQL backup and recovery processes.

GermainUX can help monitor:

Backup activity
Backup completion status
Backup failures
Recovery activity
Recovery time

Backup monitoring helps teams identify failed or missing backups before they become a recovery risk.

🚨 Error & Event Log Monitoring

Monitor MySQL error and event logs to identify database issues.

GermainUX can help teams analyze:

Errors
Warnings
Informational events
Recurring database issues
Operational trends

Log events can be analyzed alongside performance and availability telemetry to accelerate troubleshooting.

⚙️ Server & Database Configuration Monitoring

Monitor MySQL server and database configuration settings relevant to performance, reliability, and security.

Configuration monitoring can help teams identify changes and understand whether those changes correlate with changes in database behavior or performance.

🔍 Custom MySQL Query Monitoring

GermainUX can execute configurable SQL queries against MySQL and use the returned information as monitoring data.

This allows monitoring to extend beyond standard database metrics.

Custom Query Monitors can be used to monitor:

MySQL system tables
Application tables
Business data
Operational conditions
Application-specific database states
Custom KPIs

GermainUX is not limited to a predefined set of MySQL system tables.

🔎 Detect MySQL Issues in Real Time

GermainUX can detect conditions such as:

MySQL unavailable
Slow queries
Performance degradation
Resource constraints
Excessive connections
Storage capacity issues
Backup failures
Database errors
Application-specific database conditions

Detected conditions can be analyzed, alerted on, reported, or used to trigger automated actions.

📊 Real-Time Dashboards & Automated Reports

Analyze MySQL telemetry through customizable real-time dashboards and automated reports.

Examples include:

MySQL availability
Database performance
Query performance
Connections
Storage utilization
Backup status
Errors
Custom database KPIs
Historical trends

MySQL telemetry can also be combined with other technologies monitored by GermainUX to provide broader operational context.

🔔 Alerts & SLA Monitoring

Configure SLAs and alerts for MySQL conditions requiring attention.

For example:

MySQL unavailable
Query response time exceeds threshold
Performance degradation
Excessive connections
Storage threshold exceeded
Backup failure
Critical database error
Custom database condition detected

Fact-based SLAs can trigger configured actions such as alerts, reports, or scripts.

⚙️ Automation

MySQL monitoring conditions can trigger GermainUX automation.

For example:

Monitor → Detect → Analyze → Alert → Automate

Depending on the use case, automation can include:

Alerts and notifications
Reports
Scripts
Operational workflows
Remediation actions where appropriate

🔗 Correlate MySQL with Applications & Infrastructure

MySQL monitoring can be combined with telemetry from applications, services, operating systems, containers, and infrastructure.

This provides broader visibility across:

User / Application → Transaction → SQL Query → MySQL → Infrastructure

This helps teams determine whether an issue originates in the application, database query, MySQL instance, or supporting infrastructure.

🔧 Deployment

MySQL monitoring is executed by the GermainUX Engine.

A MySQL database account is used to establish the connection and execute the queries required for monitoring.

See Deploy Monitoring for MySQL for deployment instructions.

ℹ️ Get More Information

GermainUX MySQL monitoring can be extended to additional system tables, application tables, and custom database conditions according to your environment.

The GermainUX team can help configure monitoring, analytics, SLAs, alerts, and automation for your MySQL environment.

Please contact us for any help.

Component: Engine

Feature Availability: 2017.1 or later

✨ Feature

Germain is configured to monitor the uptime and performance of MySQL database instances and servers.

💡 Database availability

Monitor the availability of the MySQL database to ensure it is up and running. Track uptime and receive alerts if the database goes down or experiences any connectivity issues.

🚤 Performance metrics

Monitor key performance metrics of the MySQL database, including CPU usage, memory utilization, disk I/O, and network traffic. These metrics help identify any bottlenecks or resource constraints that could impact the performance of the database.

🔍 Query performance

Monitor the performance of SQL queries executed against the MySQL database. Track metrics such as query response time, execution plans, and index usage. Identify slow-running queries and optimize their performance to improve overall database efficiency.

🔗 Database connections

Monitor the number of active database connections and track connection usage. Identify any connection leaks or excessive connections that could impact the performance and scalability of the database.

💽 Disk space and tablespace utilization

Disk space and tablespace utilization

Monitor the disk space usage of the MySQL database and its tablespaces. Ensure that there is sufficient disk space available for data storage and log files. Identify any tablespaces that are running out of space and take necessary actions to prevent data issues.

🛡️ Backup and recovery

Monitor the backup and recovery processes of the MySQL database. Ensure that regular backups are performed successfully and monitor the backup completion status. Track recovery times in case of any database failures or data corruption.

Error and event logs

Monitor MySQL error logs and event logs to identify and resolve any issues or errors that occur within the database. Log and track error messages, warnings, and informational events for troubleshooting and proactive maintenance.

⚙️ Server and database configuration

Monitor server and database configuration settings to ensure they are optimized for performance and security. Keep track of any changes made to the configuration and validate their impact on the database.

🔧 Configuration

For basic monitoring of a single instance, Germain utilizes a regular database user account with CONNECT permissions.

MySQL (version 5.7.16) requires specific system parameters to be set using the RDS console. Please note that Germain has the capability to monitor any other MySQL tables, whether they are system tables or data tables. The requirements mentioned below represent the bare minimum requirements, but they can be extended to include monitoring of any other tables.