Video

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.

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!

Cloud Blog

4 Ways To Benefit from…

One of the benefits you get when you work with cloud applications is that you often have quarterly updates that are packed with features. This...

Keep Reading

Artificial Intelligence

Data and Analytics: Cross the…

  Artificial intelligence is a manna sent from digital heaven. That’s how blessed your business can get if you immerse into the AI of things....

Keep Reading

Business Intelligence Blog

How Brand Names Survive in…

  The age of digital marketplace has made it possible for unknown and smaller companies to compete with better-known and well-established brands. Take for example...

Keep Reading

Artificial Intelligence

The Phenomenon That Is Artificial…

  Artificial intelligence is when a machine does cognitive functions that are more associated with humans, such as thinking, learning, problem solving, and reasoning. As...

Keep Reading

Cloud

Digital Transformation in Banking: Shift…

  The start of a new decade is already shaping up to be exciting for financial services, especially for banks as they continue to compete...

Keep Reading

Business Intelligence Blog

Data Science and Its Economic…

It would seem that artificial intelligence is the focus of businesses that are looking to future proof their organizations and stay competitive. And why not?...

Keep Reading

Data Blog

Ensure Efficient Data Science and…

In an ever-expanding landscape called Internet of Things and the exploding development of artificial intelligence, we are bombarded with complex methods of integrating data science...

Keep Reading

Business Intelligence Blog

Cybersecurity: The Top 5 Expectations…

  If you think about it, cybersecurity is closely tied to human rights, privacy, freedom, and even basic safety. As a whole, we have become...

Keep Reading

Business Intelligence Blog

Tech Security Should Be Easy…

  IT professionals know that tech security is important in everything that they do. And that there are a lot of products, tools, innovations, and...

Keep Reading

Business Intelligence Blog

The Top 6 Success Stories…

Nearly nine out of 10 digital transformation initiatives fail. Digital transformation projects fail for a variety of reasons. It can be because of a lack...

Keep Reading

Live Chat | Emergency