Monitoring MySQL and MariaDB databases without a powerful tool like MONyog can be challenging. However, if you already use MONyog you might not be using it to it’s full potential. In this webinar, we will introduce you to the entire feature set of MONyog followed by a Q&A session.

You’ll also be delighted to know that one lucky winner gets MONyog Ultimate worth $399 for free. So, make sure you book your spot.

Date: Tuesday, July 8, 2014
Time: 10:00 am PT
Presenter: Rohit Nadhani (CEO, Webyog)
Register your spot for free

Update: Congratulations to Vandana Sharma on …

Changes (as compared to 5.72) include:

Features:
* The MONyog API is enhanced with more options to manage servers registered in MONyog. Options now include calls to add/edit/remove servers. Refer documentation for full details.
* MONyog now supports Query analysis using Performance Schema tables (events_statements_summary_by_digest and events_statements_history_long tables). This feature is supported only for MySQL 5.6.14 and MariaDB 10.0 and above.
* Explain plan is available in Query analyzer for Slow_log table based logging and Processlist sniffer.
* An example query is now shown in detailed query view in Query analyzer if queries replaced with literals is selected.
* MONyog now has a configurable option to define the max. query length displayed. …

This is the current (and supposed to be the last) MONyog release in the 5.5x series.  Refer online documentation for details of changes in this and previous releases.  The major scope of all releases in 5.5x series has been improving stability, performance and responsiveness under heavy load -  such as large number of servers both registered and displayed at the same time, user activity by multiple users at the same time, ‘query sniffer’ running in the background etc.  We have worked with a number of customers using MONyog in such demanding environments during the 5.5x development phase.

Changes in this 5.57 release (as compared to 5.56) include:

Bug fixes:
* The rendering of Monitors and Dashboard …

Just setting up MySQL replication is not enough, you would need to periodically monitor your slaves to ensure they continue to work seamlessly. Here is a basic overview of the Slave variables to monitor and the tools that will help you monitor those with ease.

Top variables to monitor on your slaves

Replication is best monitored by checking the following variables-

1. SLAVE_RUNNING: This is a global status variable and its value can be checked using SHOW GLOBAL STATUS like 'slave_running'. It can either be ‘ON’ or ‘OFF’.

   If slave_running is ‘ON’, then the slave is up and working fine, which means both the SQL thread and the IO thread are running. If either the SQL thread or the IO thread is not running then this variable would be ‘OFF’. Use SHOW SLAVE STATUS and try to determine whether there was an error or the slave was stopped manually. Check …

Hi,

You have been using MONyog to monitor your MySQL servers. You connected your servers with MONyog and collected data to analyse later. MONyog did a great job analyzing past performance. If you know something is wrong and don’t have MONyog monitoring your MySQL, you cannot do much to fix things right then. You’ll have to first add your MySQL to MONyog and wait till data collects.

Not any more. Introducing real-time monitoring with MONyog 5.5. It tells you what’s happening on your MySQL server RIGHT NOW. It details key metrics like top 200 queries, slow queries, locked queries, locking queries, tables, databases, users, hosts and thread states, all of this in real-time as it happens. Information is retrieved from the server every one second. And the best part is that you can get started with real-time with just a click of a button without the overhead of enabling logs.

Please refer to …

Security is always a major concern in an application. But when an application attempts data communication over a network, it becomes even tougher ordeal to keep the connection secure. In this post we will discuss about Secure Shell (SSH) to add an extra security edge to your application when it communicates over a network.

What is SSH Tunnel?

SSH is an encrypted network protocol generally used for remote shell service, secure data communication, command execution etc. In SSH tunneling, a payload protocol is wrapped around the SSH protocol (the delivery protocol) and sent over the network.

When is SSH tunneling useful?

SSH tunneling is great if you don’t want any changes on the server, say when creating an agent-less monitoring tool or as a replacement for VPN. As SSH is the hub for remote system login, you can assume that a SSH daemon is running in the remote server, if not it can be easily installed …

Monitoring MySQL servers is no rocket science provided you know what to monitor. MySQL gives a comprehensive list of variables to check your server’s health and performance. Let me walk you through the crucial variables you should be monitoring. Lets assume that you have one or more MySQL servers, which have been setup and running fine. Here are the top 10 things to monitor on your MySQL.

1. MySQL availability

Yes, this is the first thing you should be looking at! It would not make sense to monitor your MySQL if its not even available. MySQL downtime is simply not acceptable in production. At the same time ensuring zero downtime does not guarantee maximum performance.
You can execute

-mysqladmin -h 192.168.1.95 -u root -p status

to know if MySQL is running or you can just ping MySQL using service mysqld status if you are using RedHat Linux.

2. Presence of insecure users and …

Please note that users upgrading from a version before 5.2 will need a new registration code. Registered customers will get the new code from our Customer Portal. Please have the new code available before installing. Until MONyog is registered with the new key, it will not be collecting data from your servers.

Changes (as compared to 5.21) include.

Features:
* Introduced support for ‘native’ MySQL SSL-encryption with direct MySQL connections.
* MONyog now fully supports IPv6 (Internet Protocol Version 6).
* History-trends have been optimized to retrieve data faster than it was before. With large data sets this results in a speed improvement in the range of a factor ~25 .
* Passwords for MONyog users are no longer stored in clear text. A hash is stored (for admin user in MONyog.ini – for other users in the embedded database). Also MySQL passwords as …

Hi,

Amazon Elastic Compute Cloud (Amazon EC2) is a web service that provides resizable compute capacity in the cloud. Amazon EC2 is known for its uptime, thereby making it the right candidate for running monitoring tools like MONyog. You cannot monitor something effectively, unless the monitoring system is available almost all the time.

We are happy to introduce pre-configured Amazon Machine Image (AMI) which runs MONyog on an Amazon Linux instance of EC2. Launching this AMI would create an EC2 instance and starts the trial version of MONyog. In short, with just a click of a button you get your favorite MySQL monitoring tool on a trusted platform that is available almost all the time. MONyog can monitor MySQL servers running on Amazon RDS, Amazon EC2 or any other remote machine.

Additionally, popular cloud database services like …

New quick-start guide for MySQL DBAs: SkySQL™ Enterprise Monitor makes managing your MySQL & MariaDB databases that much easier

We’ve just published a new Quick Start Guide to SkySQL™ Enterprise Monitor for all MySQL & MariaDB DBAs out there, who are looking for ways to manage their databases more easily.

read more