MySQL Enterprise Monitor


MySQL Enterprise Monitor or MEM is a tool to watch over one instance to a farm of MySQL servers, to warn you of problems, and can advise you on fixing problems.

MEM Enterprise Dashboard

The is the MySQL Enterprise Monitor Dashboard

But what does it take it get it running? How much can it show me about my server?

Start by downloading MEM from the Oracle Software Delivery Cloud (And it is still free for a 30 day trial). In addition to the monitor, make sure you download the monitor agent. For my 32-bit Ubuntu test box, there were named mysqlmonitor-2.3.7.2104-linux-x86-installer.bin and mysqlmonitoragent-2.3.7.2104-linux-x86-installer.bin.

Executing mysqlmonitor-2.3.7.2104-linux-x86-installer.bin will get the monitor software installed. You can pick to use an existing database instance or a new one that comes with MEM. Please note the installer was picky and did not want to work with my 5.6 Instance previously installed. Be sure to note down the answers you enter to the install screens.

Then run mysqlmonitoragent-2.3.7.2104-linux-x86-installer.bin and start it as per the directions. And you should end up with a display like you see above.

Ideally you would run the agent on the system you want to watch and the monitor on a dedicated box.

Next time: What is MEM trying to tell me??

About these ads

Leave a Comment

Filed under MySQL Enterprise

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s