{"id":2202,"date":"2011-04-04T08:39:00","date_gmt":"2011-04-04T06:39:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/"},"modified":"2011-04-04T08:39:00","modified_gmt":"2011-04-04T06:39:00","slug":"saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/","title":{"rendered":"Saving time and increasing service availability with MySQL Enterprise Monitor 2.3"},"content":{"rendered":"<p>Nowadays, MySQL Databases are encapsulated into many mission critical software solutions. Lots of companies host one or many MySQL databases in their data center, sometimes even without knowing it except when the MySQL service is not available anymore. In order to increase the service availability, it is mandatory to have a monitoring solution. Regardless of if you are using MySQL Server, MySQL replication or cluster, the Oracle\/MySQL monitoring solution is called MySQL Enterprise Monitor.<\/p>\n<h3>MySQL Enterprise Monitor 2.3<\/h3>\n<p>MySQL Enterprise Monitor 2.3 provides a &#8220;health view&#8221; of MySQL servers by monitoring them continuously. MySQL Enterprise Monitor does not only alert database administrators by SNMP or SMTP when errors occur, but also really helps them in their daily business: It provides real-time advice regarding performances, security vulnerabilities and availability based on best practices settings. With MySQL Query Analyzer, MySQL Enterprise Monitor provides all necessary tools to improve application performance. Besides monitoring, MySQL Enterprise Monitor provides a graphical overview of key system resources such as network IO, disk IO, and CPU usage. All this statistical information is stored in the MySQL Enterprise Monitor repository, making it easy to consult historical data and perform trend analysis.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"MySQL Enterprise Monitor Dashboard\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/mysqlenterprisedashboard_tumb.png\" alt=\"mysqlenterprisedashboard_tumb\" width=\"619\" height=\"350\" \/><\/p>\n<h3>How does MySQL Enterprise Monitor work?<\/h3>\n<p>Like several monitoring tools such as Oracle Grid Control, MySQL Enterprise Monitor works with a repository, with agents installed on monitored servers, and a web interface. The schema of a typical MySQL Enterprise setup is shown below:<\/p>\n<p><img decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"MySQL Enterprise Monitor Architecture\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/mysqlenterprisemonitor_001.png\" alt=\"\" \/><\/p>\n<p>The core system, called MySQL Enterprise Manager, is built with a Tomcat web server. It is in charge of collecting data from MySQL Enterprise Agents. This collected data is stored in the MySQL Enterprise Monitor repository which is nothing more than a MySQL database. The web interface, MySQL Enterprise Dashboard, is realized with JSP pages. The installation of MySQL Enterprise Edition is a straightforward process thanks to a nice and clear installation utility and a good documentation guide. However, having an easy to maintain and efficient setup needs the application of best practices and deeper knowledge.<\/p>\n<h3>MySQL Monitor main features:<\/h3>\n<p>The MySQL Monitor web interface is provided by MySQL Enterprise Dashboard. MySQL Enterprise Dashboard provides a nice view of the current server status and historical events, and allows setting up the monitoring behavior. Here are the main features of MySQL Enterprise Monitor:<\/p>\n<ul>\n<li>Ability to monitor MySQL Database running MySQL 4.1 or higher<\/li>\n<li>Global overview through a nice web interface<\/li>\n<li>Proactive monitoring<\/li>\n<li>Alerting tool on three levels (Critical alerts, warnings, info) through SMTP and SNMP<\/li>\n<li>Historical Data Collection and Query Analyzer Data kept up to 24 months<\/li>\n<li>MySQL Query Analysis with MySQL Query Analyzer<\/li>\n<li>MySQL Cluster and MySQL replication performance monitoring<\/li>\n<\/ul>\n<h3>MySQL Agents setup<\/h3>\n<p>MySQL Agent is in charge of monitoring MySQL Server. This task includes checking the server accessibility but also more detailed information such as the load of the MySQL Server, variables status, operating system information and finally communicating all this information to the MySQL Enterprise Service Manager. In case of disrupted communication between these two components, MySQL Enterprise Agent is able to store data locally and send it back once the communication is re-established.<\/p>\n<p>MySQL Agent can also act as proxy service; the main purpose of this architecture is to analyze queries. In this context, MySQL Agent gets queries from applications and forwards them to the MySQL Server. An agent can act as proxy server for only one server. That is why it is mandatory to setup several agents in order to do query analyses of several MySQL Server on the same physical server.<\/p>\n<p><img decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"MySQL Enteprise Monitor Agent\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/mysqlenterprisearchitecture.png\" alt=\"\" \/><\/p>\n<p>MySQL Enterprise Agent configuration is described in a single ini file as shown below:<\/p>\n<div>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">[mysql-proxy]\n# Common Parameters\n plugins=proxy,agent\n keepalive = true\nlog-file = mysql-mysqld4-agent.log\n pid-file=\/u00\/app\/mysql\/product\/agent-2.3.1\/mysql-mysqld4-agent.pid\n# Agent Parameters\n agent-mgmt-hostname = <a href=\"http:\/\/localhost:18080\/heartbeat\">http:\/\/localhost:18080\/heartbeat<\/a>\n agent-mgmt-username = agent\n agent-mgmt-password = manager\n mysqld-instance-dir= etc\/mysqld4\n agent-item-files = share\/mysql-monitor-agent\/items\/quan.lua,share\/mysql-monitor-agent\/items\/items-mysql-monitor.xml,share\/mysql-monitor-agent\/items\/items-mysql-cluster.xml,share\/mysql-monitor-agent\/items\/custom.xml\n agent-uuid = 7f5475a8-1694-448e-b100-302451a9ca5d\n#aggr-mem-baseurl=<a href=\"http:\/\/localhost:18080\/v2\/rest\">http:\/\/localhost:18080\/v2\/rest<\/a>\n# Proxy Parameters\n proxy-address=:33004\n proxy-backend-addresses = \/u00\/app\/mysql\/admin\/mysqld4\/socket\/mysqld4.sock\n proxy-lua-script = lib\/mysql-monitor-agent\/lua\/quan.lua<\/pre>\n<\/div>\n<h3>MySQL Enterprise Monitor strengths and weaknesses<\/h3>\n<p>MySQL Enterprise Monitor is a great tool providing lots of possibilities in terms of monitoring as already described. The main assets are the following:<\/p>\n<ul>\n<li>Monitoring MySQL Server from version 4.1 to 5.x, MySQL Query optimizer only for version 5.x<\/li>\n<li>Full support of MySQL Cluster and MySQL Replication, including MySQL Query Analyzer functionalities<\/li>\n<li>Plenty of monitored metrics including MySQL and operating system metrics<\/li>\n<li>Nice web interface providing a quick global overview of services availability<\/li>\n<li>Straightforward and intuitive usage<\/li>\n<\/ul>\n<p>Among the main weaknesses:<\/p>\n<ul>\n<li>Only included as part of a MySQL Enterprise subscription (30 days trial)<\/li>\n<li>In order to use Query analyzing it is mandatory to go through a MySQL Proxy which can slow down performances<\/li>\n<li>If multiple MySQL instances are installed on the same server, it is mandatory to have several agents installed for query analyzing purposes.<\/li>\n<\/ul>\n<p>I recommend the usage of MySQL Enterprise Monitor for any productive and potentially sensitive MySQL Server. This tool can of course monitor MySQL Service and therefore improve service availability. It can also help developers to improve code through the query analyzer service and therefore save significant amount of time for business activities.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Nowadays MySQL Databases are encapsulated into many mission critical software solutions. Lots of companies host one or many MySQL databases in their data center, sometimes even without knowing it except when the MySQL service is no more available. In order to increase this service availability it is mandatory to have a monitoring solution. Regardles of you are using MySQL Server, MySQL replication or cluster the Oracle\/MySQL monitoring solution is called MySQL Enterprise Monitor.<\/p>\n","protected":false},"author":10,"featured_media":2203,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[199],"tags":[143,144,256,67,257,255],"type_dbi":[],"class_list":["post-2202","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-hardware-storage","tag-monitoring","tag-mysql","tag-mysql-enterprise-monitor","tag-performance","tag-query-analyzer","tag-statistics"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Saving time and increasing service availability with MySQL Enterprise Monitor 2.3 - dbi Blog<\/title>\n<meta name=\"description\" content=\"MySQL Enterprise Monitor 2.3 provides a health view of MySQL servers by monitoring them continuously. MySQL Enterprise Monitor does not only alert database administrators by SNMP or SMTP when errors occur but it really helps them in their daily business. Therefore it provides real-time advices regarding performances, security vulnerabilities and availability based on best practices settings.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Saving time and increasing service availability with MySQL Enterprise Monitor 2.3\" \/>\n<meta property=\"og:description\" content=\"MySQL Enterprise Monitor 2.3 provides a health view of MySQL servers by monitoring them continuously. MySQL Enterprise Monitor does not only alert database administrators by SNMP or SMTP when errors occur but it really helps them in their daily business. Therefore it provides real-time advices regarding performances, security vulnerabilities and availability based on best practices settings.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2011-04-04T06:39:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/mysqlenterprisedashboard_tumb.png\" \/>\n\t<meta property=\"og:image:width\" content=\"780\" \/>\n\t<meta property=\"og:image:height\" content=\"441\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Gr\u00e9gory Steulet\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Gr\u00e9gory Steulet\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/\"},\"author\":{\"name\":\"Gr\u00e9gory Steulet\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098\"},\"headline\":\"Saving time and increasing service availability with MySQL Enterprise Monitor 2.3\",\"datePublished\":\"2011-04-04T06:39:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/\"},\"wordCount\":794,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/mysqlenterprisedashboard_tumb.png\",\"keywords\":[\"Monitoring\",\"MySQL\",\"MySQL enterprise monitor\",\"Performance\",\"Query analyzer\",\"Statistics\"],\"articleSection\":[\"Hardware &amp; Storage\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/\",\"name\":\"Saving time and increasing service availability with MySQL Enterprise Monitor 2.3 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/mysqlenterprisedashboard_tumb.png\",\"datePublished\":\"2011-04-04T06:39:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098\"},\"description\":\"MySQL Enterprise Monitor 2.3 provides a health view of MySQL servers by monitoring them continuously. MySQL Enterprise Monitor does not only alert database administrators by SNMP or SMTP when errors occur but it really helps them in their daily business. Therefore it provides real-time advices regarding performances, security vulnerabilities and availability based on best practices settings.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/mysqlenterprisedashboard_tumb.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/mysqlenterprisedashboard_tumb.png\",\"width\":780,\"height\":441},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Saving time and increasing service availability with MySQL Enterprise Monitor 2.3\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098\",\"name\":\"Gr\u00e9gory Steulet\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g\",\"caption\":\"Gr\u00e9gory Steulet\"},\"description\":\"Gr\u00e9gory Steulet has more than ten years of experience in database and infrastructure management, engineering, and optimization. He is specialized in Oracle technologies and high availability solutions (Oracle DataGuard, Data Replication Block Device). His expertise also includes Avaloq banking applications, as well as the open source field (MySQL, Unix\/Linux, etc.). Gr\u00e9gory Steulet is \\\"Oracle Certified Professional 10g\\\", \\\"MySQL Cluster 5.1 Certified\\\", and \\\"Avaloq Certified Professional 2.6\\\". Prior to joining dbi services, Gr\u00e9gory Steulet was Senior Consultant at Trivadis in Lausanne. He also worked as IT Administrator at Box Telecom in Miami Beach, Florida (USA). Gr\u00e9gory Steulet has an Executive MBA from the International Institute of Management in Technology, Fribourg (CH). He also holds a Bachelor's Degree in Business Administration and Computer Science from the University of Applied Sciences Western Switzerland. His branch-related experience covers Telecommunications, Financial Services \/ Banking, Logistics, Pharma etc.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/gregory-steulet\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Saving time and increasing service availability with MySQL Enterprise Monitor 2.3 - dbi Blog","description":"MySQL Enterprise Monitor 2.3 provides a health view of MySQL servers by monitoring them continuously. MySQL Enterprise Monitor does not only alert database administrators by SNMP or SMTP when errors occur but it really helps them in their daily business. Therefore it provides real-time advices regarding performances, security vulnerabilities and availability based on best practices settings.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/","og_locale":"en_US","og_type":"article","og_title":"Saving time and increasing service availability with MySQL Enterprise Monitor 2.3","og_description":"MySQL Enterprise Monitor 2.3 provides a health view of MySQL servers by monitoring them continuously. MySQL Enterprise Monitor does not only alert database administrators by SNMP or SMTP when errors occur but it really helps them in their daily business. Therefore it provides real-time advices regarding performances, security vulnerabilities and availability based on best practices settings.","og_url":"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/","og_site_name":"dbi Blog","article_published_time":"2011-04-04T06:39:00+00:00","og_image":[{"width":780,"height":441,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/mysqlenterprisedashboard_tumb.png","type":"image\/png"}],"author":"Gr\u00e9gory Steulet","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Gr\u00e9gory Steulet","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/"},"author":{"name":"Gr\u00e9gory Steulet","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098"},"headline":"Saving time and increasing service availability with MySQL Enterprise Monitor 2.3","datePublished":"2011-04-04T06:39:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/"},"wordCount":794,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/mysqlenterprisedashboard_tumb.png","keywords":["Monitoring","MySQL","MySQL enterprise monitor","Performance","Query analyzer","Statistics"],"articleSection":["Hardware &amp; Storage"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/","url":"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/","name":"Saving time and increasing service availability with MySQL Enterprise Monitor 2.3 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/mysqlenterprisedashboard_tumb.png","datePublished":"2011-04-04T06:39:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098"},"description":"MySQL Enterprise Monitor 2.3 provides a health view of MySQL servers by monitoring them continuously. MySQL Enterprise Monitor does not only alert database administrators by SNMP or SMTP when errors occur but it really helps them in their daily business. Therefore it provides real-time advices regarding performances, security vulnerabilities and availability based on best practices settings.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/mysqlenterprisedashboard_tumb.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/mysqlenterprisedashboard_tumb.png","width":780,"height":441},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/saving-time-and-increasing-service-availability-with-mysql-enterprise-monitor-23\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Saving time and increasing service availability with MySQL Enterprise Monitor 2.3"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098","name":"Gr\u00e9gory Steulet","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g","caption":"Gr\u00e9gory Steulet"},"description":"Gr\u00e9gory Steulet has more than ten years of experience in database and infrastructure management, engineering, and optimization. He is specialized in Oracle technologies and high availability solutions (Oracle DataGuard, Data Replication Block Device). His expertise also includes Avaloq banking applications, as well as the open source field (MySQL, Unix\/Linux, etc.). Gr\u00e9gory Steulet is \"Oracle Certified Professional 10g\", \"MySQL Cluster 5.1 Certified\", and \"Avaloq Certified Professional 2.6\". Prior to joining dbi services, Gr\u00e9gory Steulet was Senior Consultant at Trivadis in Lausanne. He also worked as IT Administrator at Box Telecom in Miami Beach, Florida (USA). Gr\u00e9gory Steulet has an Executive MBA from the International Institute of Management in Technology, Fribourg (CH). He also holds a Bachelor's Degree in Business Administration and Computer Science from the University of Applied Sciences Western Switzerland. His branch-related experience covers Telecommunications, Financial Services \/ Banking, Logistics, Pharma etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/gregory-steulet\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2202","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2202"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2202\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2203"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2202"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}