Monyog Usage Questions

[pinestream]

A few Monyog questions:

1. How would I use Monyog to monitor a hosted MySQL server residing on a dedicated server where I have networking (port 3306) disabled and port 3306 disabled on the firewall. Access is only available via SSH?

2. Is there a live demo on Monyog available?

3. What is it doing/not doing versus an admin tool like phpmyadmin or MySQL's own gui admin tool? Is it really providing actionable results?

4. How does it compare with MySQL's new enterprise monitoring service?

[peterlaursen]

1)

We will provide SSH tunnelling to MySQL on the remote host soon. Untill then you will have to use a 3rd party application to establish a SSH-tunnel. But with a 'dedicated server' I think it should be possible to open a MySQL port and allow in MySQL configuration to use it!

2)

Trial available from http://webyog.com/en/downloads.php

3)

You should not compare MONyog with phpMyAdmin (or 'Query Browser' from MySQL AB or our own SQLyog for that sake). Those are for managing DATA primarily – not the server ENVIRONMENT. 'MySQL Administrator' from MySQL AB does display server configuration variables and status but only statically and provides no advisors (but it is a nice program to have for not so experienced users who want to change configuration – and most of all to get an overview of what configuration parameters are available!). Also MONyog lets you view and EXPLAIN queries in real time and more like that (including analyzing the SLOW QUERY LOG) will be added in the next about 2 months.

4)

MONyog is preferable for

1) performance and architectural simplicity

2) pricing and license terms (perpetual license – no annual/periodic subscription fee)

3) configurability

Please refer to

http://webyog.com/en/whitepapers/MONyogWhitePaper.pdf

http://www.webyog.com/blogs/peterlaursen/i…hp?showentry=84

[Rohit]

@pinestream:

Alternate deployment option to address your Question No. 1:

You can install MONyog on your dedicated MySQL server. In that case MONyog connects locally to MySQL and you then access MONyog using normal HTTP (Port 80).

[Author]

Posts