Showing entries 31 to 40 of 98
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: MONyog (reset)
Introducing actionable charts in MONyog MySQL Monitor

While MONyog MySQL Monitor is being embraced by DBAs and DevOps around the world, we are constantly adding more features to make MONyog the most complete MySQL monitoring tool.

MONyog ships 40+ MySQL and system metric charts. It also lets you add custom charts. With the latest update, we have made Charts more powerful by adding few important features to help you find problem queries with ease.

Here’s a 1 minute video to walk you through the new features.

Existing customers can download MONyog 6.33 from Customer Area. To evaluate MONyog 6.33, please download a 14-day trial.

We are really excited about this update and we hope you like the new features. Please feel free to share your feedback.

Team MONyog

The post …

[Read more]
Rockstar DBA: An Interview with Manojit Paul

This article is a part of our Rockstar DBA initiative, a platform for thought leaders to share their knowledge and make a positive contribution towards the database management community.

Manojit Paul, with more than 19 years of professional DBA experience in enterprise database solutions, especially Sybase product set and database infrastructure is our first Rockstar DBA.

Let’s hear from Manojit about how he manages MySQL databases, why he loves MONyog, his advice to young DBA’s and more.

How do you manage your MySQL databases?
We presently have 9 MySQL servers in production trading environment, all being managed via a host of automated scripts which I’ve created and manual intervention when issues are reported. We deploy MONyog for managing 5 of these critical MySQL instances. …

[Read more]
Webinar – Monitoring MySQL and MariaDB databases with MONyog. Register now

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 …

[Read more]
MONyog MySQL Monitor 6.0 Has Been Released

Changes (as compared to 5.72) include:

* 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. …

[Read more]
MONyog MySQL Monitor 5.57 Has Been Released

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 …

[Read more]
How to Monitor MySQL Replication?

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 …

[Read more]
What’s happening on your MySQL server right now? Real-time monitoring has the answer!


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 …

[Read more]
HOWTO: Integrating SSH tunneling inside your application

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 …

[Read more]
Top 10 things to monitor on your MySQL

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 -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 …

[Read more]
MONyog MySQL Monitor 5.3 Has Been Released

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.

* 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 …

[Read more]
Showing entries 31 to 40 of 98
« 10 Newer Entries | 10 Older Entries »