MySQL Enterprise Monitor gives real-time monitoring of the availability and performance of all of your MySQL databases. Start monitoring MySQL in less than 10 minutes without configuration and with no agents.
A new user interface offers the user a significantly improved experience. The visible changes - the layout, icons, and overall design are more natural and easy experience. Views are dynamically updated and change according to your current situation. The resources you've chosen range from single MySQL hosts or instances to custom Groups to your complicated topologies for clustering and replication. Other improvements include a more responsive user interface and more prominent capacity to scale, allowing you to manage the thousands of MySQL-related assets more efficiently.
MySQL Enterprise Monitor automatically discovers the MySQL Cluster installations and gives you insight into the performance of availability, health, and performance for each MySQL instance as well as NDB process and also the overall health of the MySQL Cluster instance as a single virtual system. The Overview dashboard shows the detailed instruments available for every MySQL Cluster and the Topology dashboard shows the present setting of your MySQL Cluster enabling you to quickly assess the health for each MySQL Cluster instance as a as a whole and for each individual process. The Topology dashboard lets you quickly check how your MySQL Cluster installations are currently working.
MySQL Enterprise Monitor auto-discovers your MySQL topologies of replication and gives an overview of the availability, health, and performance of every MySQL instance involved and the topology's overall status as a whole virtual system. Replication Status view: The Replication Status view provides a detailed overview of the instruments available in MySQL. The Topology view also shows how your Replication topologies allow users to quickly assess the state of the replication topology in general and each node and every subsystem of the replication. It doesn't matter if you are using Group Replication, InnoDB clusters, or any other type of Source/Replica configuration, such as a single source tree structure, circular replication or a complex multi-level and multi-source structure, or any combination of these and more, the Topology view lets you quickly see the way the Replication topologies are functioning.
The brand-new Backup Dashboard brings deeper integration with MySQL Enterprise Backup. It provides crucial insight into critical backup processes that allow you to assure that valuable data is secure against loss of data. Monitor high-level backup metrics for your complete MySQL topology or specific groups, and drill down to see all the key parameters and details for particular backups for particular instances. Best Practice Advisors can also aid in ensuring that your backups are working as planned by alerting you whenever any potential issues are discovered.
Role and group-based access controls are a simple way to allow MySQL DBAs to establish specific security rules for their servers. Access Control Lists simplify the management of accounts for companies that use MySQL Enterprise Monitor in multi-tenant and cloud-based environments.
Graphs and Reports make it easy to keep track of MySQL Enterprise Firewall activity and ensure the security of your MySQL servers from database-specific attacks. Best Practice Advisors notify you when a security risk has been discovered and suggest modifications to your Firewall and security settings.
Monitor and enforce MySQL Enterprise Audit use across all Your MySQL servers. Best Practice Advisors ensure that companies follow the required security policies for their business to meet legal requirements like HIPAA, Sarbanes-Oxley, and the PCI Data Security Standard.
MySQL Enterprise Monitor constantly keeps track of MySQL queries and performance-related server metrics. Alerts are sent when significant deviations from the performance trends are baseline, and Best Practice Advisors recommend modifications to configuration and variable settings that can improve performance.
Monitoring and measuring availability in databases allows developers and DBAs to know if they comply with the Service Level Agreement (SLA) obligations.
Visual Dashboard Visual Dashboard is a web-based interface that gives you a complete overview of the database's capacity, reliability, important events, and more. You can visualize the performance of a single server, a customized group, and all the servers. A wide array of historical and real-time graphs allows you to look into server statistics specifics.
Check the performance of your query in real-time and the execution stats, and find and eliminate SQL code that may be causing the slowdown. Using Performance Schema with MySQL Server 5.6, the data is pulled straight from the MySQL server without requiring extra software or setup.
Correlated graphs permit developers and DBAs to evaluate execution parameters like the load on the server and thread statistics or RAM usage with the queries that were running at the time. Highlight a slice on a graph, and you can identify the most costly queries and identify a possible cause for the performance issue that is more significant.
Check the essential InnoDB parameters that affect MySQL performance. Get alerts about the inefficient use of indexes and locking issues—InnoDB utilization of the buffer pool. You will also receive hints and suggestions on improving your InnoDB configuration based on actual performance and analyzed trends.
Analysis of trends and forecasts enables administrators to predict the future requirements for capacity. MySQL Enterprise Monitor delivers predictive alerts to the operations team according to user-defined thresholds, like "Notify me if disk space runs out in 12 months".
The monitor was operating system-level performance metrics, such as the load average, CPU utilization swap usage, RAM utilization, Filesystem usage, and Disk IO in real-time.
MySQL Enterprise Monitor protects MySQL Servers and assists developers and DBAs in identifying and fixing security weaknesses. The Advisors supply the rules to ensure MySQL safety best practices and alert you to possible weaknesses before they can affect your system.
Accelerate the time to production of your apps by drastically reducing the time required to identify performance issues while developing and testing. Fix performance issues before your customers notice.
