Installing MySQL Enterprise Monitor (with video demo)

MySQL Enterprise Monitor can help you by giving you real time information about the availability and performance of all of your SQL databases.  But what makes it even better is that it is very easy to install.

This is because there are absolutely no configurations involved and no agents are needed.  You would also be able to log into the Enterprise dashboard and configure the settings you need in order to get updates from MySQL Enterprise.

All you need to have are the MySQL Enterprise Service Manager, the MySQL Enterprise Advisors and a MySQL Enterprise Monitor Agent.  All of these, however, may be installed even when unattended.  In fact, you can install and upgrade MySQL Enterprise Service Manager and MySQL Enterprise Monitor Agent on several machines without needing user interaction. You can leave it and then just finish up afterwards.

But even without opting for an unattended installation, getting MySQL Enterprise Monitor up and running on your server is a breeze.  In fact, you can install it in ten minutes or even less.

With the ease and convenience in installing MySQL Monitor, there really is no excuse why you should not get all the benefits of installing, deploying and using MySQL Enterprise Monitor on all of your databases.

Here’s the video demo with its script below it:

Welcome! In this presentation I’ll demonstrate just how quick and easy it is to get up and running with MySQL Enterprise Monitor or MEM version 3.0. Here, I have a simple shell script, which I’ll be running, and in it I’m creating three test MySQLd instances. I’m installing the MEM agent using unattended installation mode and then installing them on server using the same installation mode. And now I actually run the scripts so you get an idea of how long it actually takes and I’m skipping ahead in time but you can see that took about 90 seconds to do the actual installation.

Click here to read more about this article

The next step is completing the installation with a one-time setup screen when you first log in. I’m gonna specify the same manager and agent credentials that I used for the installation. Then I will quickly say “Yes” to the default time zone, which is correct for me. The next thing is actually tell the MEM server to begin monitoring my three test instances in MySQLd. Here you can see that it’s already picked up on the fact that I have three running but unmonitored instances. Now you can simply tell to begin monitoring them in bulk. The root password is the same for all of them and I’ll tell MEM to create the secondary user accounts that it uses for less privileged jobs.

 

Now we can see that the MEM servers are monitoring my three instances and if we look at the adviser’s configuration, we can see that it actually already scheduled all the advisers for each of them as well.

 

And we are already done. So you can see just how easy it is to get up and running with 3.0 – get everything installed, setup and actually begin monitoring MySQL.

 

That’s all for this video. Thank you for watching and please be sure to look for our other video demos on MEM 3.0!

Four Cornerstone

Leave a Reply

Your email address will not be published. Required fields are marked *

© 2016 Oracle Consulting Fort Worth – Four Cornerstone. All rights reserved.