Configuring MySQL databases for monitoring in vRealize Operations

If MySQL has become mission critical to your organization, you’ve probably invested heavily into one of the many server technologies and/or management tools for MySQL. From commercial solutions to open source options like MySQL Workbench, HeidiSQL, Navicat, phpmyadmin, or SQLPro, specialized management tools help scale the use of MySQL to the reliability and agility requirements of modern production environments. But when MySQL grows within an organization, teams well beyond DataOps need contextual visibility, especially when things go wrong.

Blue Medora helps virtualization and DataOps teams work better together to monitor and troubleshoot instances so everything stays up and running, even as the complexity and criticality of MySQL grows. If you run MySQL workloads on Azure VMs, check out BindPlane. If you’re a VMware shop managing your environment with vRealize®, the MySQL management pack from Blue Medora is certainly worth taking a few minutes to evaluate. Either way, you’ll get over 800 metrics including instance, database, table, index, replication, and query details. Out-of-the-box dashboards, reporting and alerts expertly guide optimization and root cause analysis.

Here you can see how vRealize Operations™ powered by Blue Medora simplifies query analysis with heatmap functionality that visually shows which queries run most frequently, and which run slowest. Interactive drill-downs yield response time, lock wait times, and affected row KPIs.

VM, host system, or datastore KPIs from vCenter can also be related from query performance to quickly understand infrastructure dependencies like memory and disk contention, or overall health. Customizable dashboards allow you to tailor observability to the behavior of your applications.

Setting up the MySQL management pack from Blue Medora takes just a few minutes. Watch this video to see how easy it is to configure a monitoring user for your MySQL databases, along with tips on using this management pack to its fullest.

Like what you see? Reach out to sales@bluemedora.com for a personalized demo of all the features this management pack. You’re sure to see how Blue Medora gives you the data and peace of mind to continue scaling MySQL in your organization efficiently and reliably.