MySQL Monitoring
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
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.
Apply Monitoring to MySQL
Log on to Germain Workspace > left menu > Wizards >Standard HTML

MySQL Wizard - Germain UX
Add Database as Data Source
Germain workspace > Left Menu > Data Sources > Database > Add New Configuration

Add MySQL Database as Data Source - Germain UX
Add DB Credentials
Germain Workspace > Left Menu > Data Sources > Credentials

Add MySQL Database Credentials for MySQL- Germain UX
Add Database Query Monitor
Germain Workspace > Left Menu > Wizards > Database Query Monitor Deployment

Add MySQL Database Query Monitor for MySQL - Germain UX
Enter Database details

Enter MySQL Database Details - Germain UX

Add MySQL database Query Monitor - Germain UX

MySQL Database Query Monitor - Germain UX

Add MySQL Database Query Monitor Component - Germain UX
Add KPI

Add KPI for your MySQL database- Germain UX

Add KPI for MySQL - Germain UX
Create the base SLA for the new KPI. Choose Fact-based SLA

Add SLA for MySQL - Germain UX
Add SLA
Alert Template: SLA.
Choose one or more of your actions (Alerts, Reports, Scripts, ect..)

Add SLA Alert Template - Germain UX
Set KPI

Configure KPI for MySQL - Germain UX

Add SLA Threshold for MySQL - Germain UX
Deployment details
Monitoring Node: The Node that the Engine runs from
Engine: The engine you want to run the Monitor on
Fill in the schedule you would like the Monitor to run on

Deploy Database Query Monitor for MySQL - Germain UX
Verify the Monitor by finding in “Germain State”

Check Running State of Database Query Monitor
For more detailed information, please reach out to us. We will provide you with further guidance and assistance tailored to your needs
Component: Engine
Feature Availability: 8.0 or later