Comprehensive Monitoring and Compliance Management for MySQL Databases using Enterprise Manager

December 5, 2023 | 5 minute read
Desiree Abrokwa
Product Manager, Enterprise and Cloud Manageability
Text Size 100%:

Looking for a monitoring and compliance management solution for MySQL databases? Then Oracle Enterprise Manager (EM) is your answer. EM provides market-leading monitoring and comprehensive management support for Oracle applications and technologies such as Oracle Database, Oracle WebLogic Server, and Exadata. With EM 13.5, you can monitor your MySQL databases for availability and performance, find slow-running queries using Query Analyzer, and validate compliance with performance and security best practices. This blog reviews EM’s robust capabilities to streamline these monitoring and compliance management tasks across a fleet of MySQL databases.

 

Discover MySQL with Auto-Discovery 

The first step is to discover MySQL in EM. You can discover databases automatically or manually. Auto-Discovery automatically searches for databases on managed hosts to easily add databases for monitoring. This is useful when dealing with a fleet of databases as it simplifies target discovery. You can also utilize manual discovery and specify the details (e.g., target name, MySQL credentials, host, port, etc.) needed to discover your database. Note that monitoring MySQL automatically begins after discovery.

 

Set up MySQL alerting for your specific environment

Once the database is being monitored, the next step is to set up alerting. EM collects hundreds of metrics for your MySQL database such as InnoDB activity and firewall activity. Using EM, you can complete the following:

  • Specify warning or critical thresholds to get alerts whenever a metric violates these thresholds.
  • Extend monitoring to conditions specific to your environment using Metric Extensions.
  • Automate responses to alerts using Corrective Actions. For example, create a Corrective Action to start the MySQL database when it is down.
  • Standardize metric threshold settings across a fleet of MySQL databases using Monitoring Templates.
  • Use Administration Groups and Template Collections to automate the application of monitoring settings and compliance standards to a fleet of MySQL databases.

 

Get quick insight into MySQL's health and performance

Use the MySQL homepage to get a holistic summary of the overall health and performance of your database. Review the availability history to see the status and its status over the last 24 hours. Monitor key performance metrics such as connections to MySQL and InnoDB buffer pool usage. These performance metrics allow you to quickly view unusual spikes in the number of connections to your database and view the percentage of dirty buffer pool pages to see when it is close to capacity. Lastly, track critical incidents and drill down to the Incident Manager to further triage. For instance, track the percentage of failed attempted connections to MySQL which could indicate a denial-of-service attack.

Figure 1: MySQL Homepage
Figure 1:  MySQL Homepage

 

Monitor slow-running queries using Query Analyzer

Query Analyzer is a point-in-time snapshot of the top 100 queries and statements on your MySQL database. This is useful to pinpoint any slow-running queries based on the total latency. View additional details such as number of executions, average latency, and number of rows returned.

Figure 2: Query Analyzer
Figure 2:  Query Analyzer

 

Manage MySQL alerts

Let’s look at ways to manage these MySQL alerts after you have set them up.

  • Note: As a best practice, we recommend creating incidents in Enterprise Manager for actionable alerts and other events.

Use Incident Rules to create incidents and specify actions to take when incidents occur. For instance, specify a rule to notify your database administrator through email or Slack when a MySQL database is down so they can take respective actions. Use the Webhooks notification method to send notifications to external applications such as Microsoft Teams.  

As your enterprise grows, so may the volume of incidents received, which often becomes difficult to manage. To reduce this volume use Event Compression Policies, which automatically group sets of related events into a smaller and manageable set of actionable incidents. For MySQL, you can author custom policies to group related events into a single incident. Also, test your policy’s effectiveness with the Event Compression Analysis tool before publishing it for use.

Incident Manager is the single location to manage the lifecycle of all your MySQL incidents, acknowledge the incident, run Corrective Actions, and more. Also, access in-context recommendations to resolve your incident.

Figure 3: Use Incident Manager to manage incidents such as database down incidents
Figure 3:  Use Incident Manager to manage incidents such as database-down incidents

If your enterprise relies on third-party systems for incident management, integrate EM with them using management connectors. These connectors can be used to share events and incidents with event and ticketing systems such as Microsoft SCOM and ServiceNow.

 

Ensure compliance with performance and security best practices

Use out-of-box MySQL Compliance Standards to evaluate the compliance of your databases as it relates to security and performance best practices. For instance, use the compliance standards to verify your firewall is enabled to guard against cyber security threats. Manage the overall compliance of your fleet of MySQL databases through the Compliance Dashboard. From the Compliance Dashboard, track the percentages of critical and warning violations for the out-of-box standards. Use EM for guidance on why your MySQL databases are in violation and for recommendations on how to bring their settings into compliance. Gain access to a full evaluation report that enumerates each violation for a standard and the remediation process. This report greatly reduces administrative time spent on problem identification and can easily be saved and shared within your organization for further triaging. In addition to Oracle’s out-of-box standards, custom standards can be defined to evaluate across a fleet of MySQL databases.

Figure 4: View Compliance Dashboard and Evaluation Report for MySQL
Figure 4:  View Compliance Dashboard and Evaluation Report for MySQL

 

Get started with EM for MySQL today!

Enterprise Manager is Oracle’s flagship on-premises systems management solution to monitor and manage heterogeneous environments at scale. EM provides comprehensive monitoring and compliance management for MySQL. Take advantage of EM’s capabilities for your fleet of MySQL databases now.  

For more information on Enterprise Manager, refer to the following below:

 

Desiree Abrokwa

Product Manager, Enterprise and Cloud Manageability

Desiree is a Product Manager in the Enterprise and Cloud Manageability organization at Oracle Corporation. She currently focuses on the monitoring space of Enterprise Manager. She has a Bachelor of Science degree in Computer Science from the University of Maryland, College Park.


Previous Post

OCI Observability and Management for Multi-Cloud Database: Amazon RDS

Next Post


Analyze SQL faster and optimize data analysis with new OCI Operations Insights enhancements

Daniela Hansell | 7 min read