Lessons Learned: Switching from MEM to OEM for MySQL – Summit 2025

Lessons Learned: Switching from MEM to OEM for MySQL – Summit 2025 | Presented by Datavail

As MySQL Enterprise Monitor (MEM) approaches end-of-life in 2025, organizations are exploring robust alternatives for enterprise-grade MySQL monitoring. In this Summit 2025 session, Krishna Mamillapalli, Director & Global Practice Leader for MySQL & MariaDB Services at Datavail, shares real-world insights and lessons learned from transitioning to Oracle Enterprise Manager (OEM) for MySQL.

This presentation walks through the technical, operational, and strategic considerations of switching from MEM to OEM, including plugin configurations, monitoring capabilities, compliance dashboards, and performance analytics.

🔗 View the full presentation here: https://www.datavail.com/resources/lessons-learned-switching-from-mem-to-oem-for-mysql/

🔍 Key Highlights
MEM Overview: Understand the evolution of MEM and its deprecation timeline.
OEM for MySQL: Learn how Oracle Enterprise Manager supports MySQL 5.7 and 8.0, including RDS instances.
Plugin Features: Explore dashboards, health checks, incident management, and query analysis.
Cluster Monitoring: Monitor replication, InnoDB clusters, group replication, and router metrics.
Compliance & Security: Leverage OEM’s compliance dashboards for auditing, schema design, and user activity.
Query Analyzer: Identify top queries, full table scans, and missing indexes with actionable insights.
Log Management: Understand the structure and location of OEM logs for MySQL targets.
🎯 Why Watch This Session?
This session is ideal for:

MySQL DBAs and architects planning for MEM sunset
IT leaders evaluating enterprise monitoring tools
DevOps teams managing hybrid or cloud-native MySQL environments
Organizations seeking better observability, compliance, and automation

1. Lessons Learned: Switching from MEM to OEM for MySQL

2. 18+ years of experience in database architecture and solutions Extensive technical background in database operations, cloud migrations, and modernizations Specialized in MySQL and MariaDB with deep understanding of hybrid data models Extensive experience in database optimization, cloud strategies and supporting open-source database technologies Krishna Mamillapalli Director & Global Practice Leader MySQL & MariaDB Services @ Datavail Connect or follow me on LinkedIn: https://www.linkedin.com/in/srinivasakrishna/

3. Datavail at a Glance Delivering a superior approach to leverage data through application of a tech-enabled global delivery model & deep specialization in databases, data management, and application services. CAB Member Member since 2023 18 + Years building and operating mission critical data and application systems www.datavail.com 3 Global Team 1,300 Employees staffed 24x7, resolving over 2,000,000 incidents per year

4. We operate to higher of Datavail security policy & client controls documented in operational run book. Data & Security Compliance SSAE18 Type II SOC1 & Type II SOC2 Operate and adhere to controls ISO 27001:2019 (Information Security) & ISO 27701 ( Privacy ) PCI SAQ-D Self Assessment Executed and adhere to numerous PHI, HIPAA Business Associate Agreements US only delivery models for ITAR controlled data

5. MEM Overview Part of MySQL Enterprise Edition MEM 2.x MEM 3.x MEM 4.x MEM 5.7 MEM 8.x – EOL and deprecated as of Jan 1 st , 2025

6. MySQL Monitoring Commercial Open Source PMM Grafana Prometheus Zabbix Nagios   Cloud Native Solutions AWS CloudWatch Azure Monitoring OCI Database Management GCP Monitoring OEM IDERA NewRelic DataDog Solarwind s SeveralNines Many options to choose from. This is NOT a comparison of monitoring solutions. Custom Development Tools

7. OEM Overview Oracle Enterprise Manager – Centralized Monitoring and Management Supports a wide variety of services including: Databases Applications Platform Integration Ops Management Non-Oracle Services Cloud Services

8. Leverage OEM for MySQL Monitoring OEM Version: OEM Cloud Control >=13.5.0.0.0 Plugin Version : 13.5.3.0.0 (Jan 2025) License – Included with MySQL Enterprise subscription Supported versions – MySQL 5.7 or higher Only OEM for MySQL Database 13.2.4.0.0, or higher, supports MySQL 8.0 RDS Support – MySQL 5.7 and 8.0 Sys schema version >=1.5.1 DB Process list Metadata Locks Memory OEM for MySQL Database

9. Plugin Screenshots

10. Proactive Management Health Dashboard DB Monitoring Advisors and Graphs Cloud Services Monitoring Monitoring Templates Adjust Thresholds Collection Schedules Implement Custom Metrics Rules and Event Policies Import/Export of Incident Rules Incident Management OEM for MySQL - Benefits

11. Incident Manager Dashboard Create Incident Rules Apply Specific Target Types Define Corrective Actions Event Compression Methods Notifications – Integration with 3 rd Party Services Incidents and Notifications

12. T ypes of log files generated for each target MySQL instance : General Log - Plugin behavior, errors, and status msg. Collection Logs - One log for each collection type. M etrics, r esponse times, etc. Agent Logs – EM Agent behavior, status, errors, etc. ORACLE_HOME=/opt/ mysql_data / oem_monitor /agent_13.5.0.0.0 AGENT_PORT=3872 EM_UPLAOD_PORT=4903 AGENT_INSTANCE_HOME=/opt/ mysql_data / oem_monitor / agent_inst   Agent logs: $ AGENT_INSTANCE_HOME/ sysman /log Plugin L ogs: $ORACLE_HOME/plugins/oracle.mysql.omys.agent.plugin_13.5.2.0.0/scripts/ oracle_omys_database /logs $ORACLE_HOME/plugins/oracle.mysql.omys.discovery.plugin_13.5.2.0.0/logs Log Config: $ORACLE_HOME/plugins/oracle.mysql.omys.agent.plugin_13.5.2.0.0/scripts/ oracle_omys_database / etc OEM for MySQL - Logs

13. Requirements: Sys schema version >=1.5.1 Top queries impacting performance Most frequent queries Queries with Full Table Scans, missing indexes Sample queries and execution plans – Jan 2025 OEM for MySQL – Query Analyzer

14. Replication Monitoring (Source, Replica) InnoDB Cluster Monitoring – Jan 2025 Cluster Status Group Replication Status Transaction Activity ClusterSet Topology Router Monitoring Cluster Specific Metrics TBD: Replica Sets Cluster Monitoring

15. Examples

16. Security Best Practices Administrative Schema Design Performance Reports User Audit Compliance Dashboard

17. Compliance Report

18. Thank You Krishna Mamillapalli Director/Practice Leader of MySQL Services, Datavail www.Datavail.com