Skip navigation

MySQL Enterprise Monitor is the best way to monitor MySQL databases from a single to multiple instances on your network or in the cloud. Period. This, to me at least, is the core tool that comes with an Enterprise Subscription. You can use it to monitor the free Community Edition of the MySQL Server but you do need to purchase the subscription.

MEM monitors of MySQL instances (and their hosts), gives notification of potential issues or problems, and it will also provide advice on how to correct issues.

 

The MySQL Enterprise Monitor Agent monitors the MySQL server, including checking the server accessibility, configuration, obtains the server ID, and the environment to enable collecting more detailed information. In addition to the information accessible by accessing variable and configuration information within the server, other configuration parameters, such as the replication topology, are also collected from the server.

 

The collected data is sent to MySQL Enterprise Service Manager for analysis and presentation. The MySQL Enterprise Service Manager analyzes, stores and presents the data collected by the agent. And you can view all this information from a web browser with an easy to use and understand interface. And yes, there are demos https://www.mysql.com/products/enterprise/demo.html

 

Improve Your Queries

MEM does more than just watch the server. The MySQL Enterprise Monitor Proxy and Aggregator intercepts queries as they are transmitted from client applications to the monitored MySQL instance and transmits them to the MySQL Enterprise Service Manager for analysis by the Query Analyzer.

This data is from Performance Schema, rather than at the wire protocol to provide data about what the statements do to generate their result sets that other sources cannot provide such as table lock time, how many rows were examined versus returned, how many temporary tables were created ( and whether any were created on disk), whether range scans were done, whether sorting happened, how many rows were sorted, and what form the sort took.  You also get histograms of response times, standard deviation of response times, and other valuable information. 

 

Learn More Today

You can find out more about MySQL Enterprise Monitor and how to try it free at https://www.mysql.com/downloads/enterprise/

The old adage that time is money does not give any hints about buying more time. A MySQL Enterprise subscription does allow you to purchase time. Your technical staff has to do more with less time than ever before and operational delays add up extremely quickly.  Having the right tools when things go critical means staff can do what they need to do, when they need to do it.

 

So how does MySQL Enterprise Edition buy you more time?

 

When things inevitably go wrong, searching for free answers to problems on web sites with many dubious or flat out wrong solutions is a waste of precious timeInformational websites like are fine sources of general information for researching technical issues but not when mission critical services are degraded or down.  An online recommendation to do what very large Enterprise Company does may not make sense for your company if you are not doing exactly what they are doing, at their scale. Getting the right help at crucial moments gets your business back on track faster.

A MySQL Enterprise Support Contract brings you the best technical support on the MySQL Database products by highly trained Oracle MySQL Engineers. You get the right answers to your questions.

 

Tools That Really Help

 

MySQL Enterprise Monitor is included in Enterprise Edition and is the best tool to monitor all your instances and report issues before they escalate.  MEM can make recommendations about your schemas and systems to achieve better performance and provide better understanding of what is really happening to your data. Fixing potential issues before they can blossom is much less expensive.  And you get proactive monitoring to keep on track of you databases instances that will inform your staff how your data is doing letting them concentrate on other issues.

 

Keeping your data safe is a major concern these days in a world with ever shrinking privacy.  MySQL Enterprise Backup ensures that your data is properly archived in case of accident by staff or hardware failure. Data losses are almost inevitable and you need to be able to quickly restore that data and MySQL Enterprise Backup is designed to do just that.

 

By default, MySQL 8.0 encrypts data between server and clients with TLS. But to keep your on-disk data safe from prying eyes, it helps to have at rest encryption paired with Oracle Key Vault to manage encryption key. The auditors doing your PCI or GDPR inspections will know Oracle Key Vault from thousands of other customers and will also recognize the Oracle Audit Vault for its deep reporting capabilities.  Enterprise Authentication can mask designated fields from those not authorized to view that data.  And Enterprise Firewall learns the patterns of your Structured Query Language traffic and can block malicious queries before they reach your database server. Outside software bolt-ons to manage your database security can be found but are not integrated to work together for your protection and managing all those desperate pieces is a drain of your staff’s time, often laborious to maintain and can draw unwanted attention from your auditors.

 

You will receive regular updates of the MySQL Enterprise Software directly from Oracle where the code is written.  It is easy to miss releases of software in the Open Source world and find yourself vulnerable to an exploit in security or missing features in later releases. The vulnerability is identified when the patch is released.

 

Conclusion

 

A MySQL Enterprise Subscription allows you and your staff to concentrate on the issues your business is facing.  It provides the tools you need for oversight, management, security, and safety of your critical data and “buys you more time” to work on delivering value to your enterprise.

 

sakilajpg.jpg

This and the next few posts will be on the basics of MySQL for my MySQL 101 presentation at the Rocky Mountain Oracle User Groups Training Days.Training Days 2016 : Rocky Mountain Oracle Users Group

 

MySQL is available from multiple sources.  It might be a part of your Linux distributions available software or already built into your virtual image if you are using something like Laravel's Homestead.  MySQL runs on most of the popular operating systems.  And it is highly recommended to start off at MySQL :: MySQL Downloads to get the latest and greatest. Don't be intimidated by the man options available to you. Most people start with the MySQL Community Edition server MySQL :: MySQL Community Downloads

 

The MySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts.  So you can try it without a financial investment.  If you later determine that MySQL is not for you then you can easily delete it without a twinge of pain in your wallet.


As of the writing of this post (Early December 2015) the latest release of the Community Server is 5.7.10.  Download the binaries for your operating system.  The source code is also available for those who want to compile their own server complete with detailed instructions.   The WIndows version comes as a MSI installer,  my preference, or a zipped file and comes with tools like MySQL Workbench.


Be sure to read the installation instructions as know as chapter two in the MySQL Manual MySQL :: MySQL 5.7 Reference Manual :: 2 Installing and Upgrading MySQL

This will save you time and frustration later on and helps avoid problems like running out of disk space or trying to install on a very old operating system version.  This is also a wonderful introduction to the amazing MySQL Manual.

 

So go download and install.  Next time we will load some test databases and start to use MySQL.