dcsimg
Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
SQL Scripts & Samples
Tips
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  

By submitting your information, you agree that databasejournal.com may send you databasejournal offers via email, phone and text message, as well as email offers about other products and services that databasejournal believes may be of interest to you. databasejournal will process your information in accordance with the Quinstreet Privacy Policy.

News Via RSS Feed


Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MySQL

Posted May 10, 2018

WEBINAR:
On-Demand

The California Consumer Privacy Act: What You Need to Know


Monitor Your MySQL, MariaDB and Percona Servers with Navicat Monitor - Page 2

By Rob Gravelle

Configuring Navicat Monitor

The rest of the article will explore how to configure Navicat Monitor on Windows 10. You can download the trial version from the Navicat site. It will provide you with 14 days of full functionality to give it a thorough evaluation.

The Navicat Monitor icon is added to the Taskbar during installation. Right-clicking it displays a context menu with several commands, including one to Start monitoring, enable Auto-start, as well as Open Navicat Monitor in the default browser.

Navicat Monitor Context Menu
Navicat Monitor Context Menu

Upon first launching the monitor in the browser, you're greeted by the Welcome Screen. From there, you can either set the Monitor's initial settings or import them from another installation.

Navicat Monitor Welcome Screen
Navicat Monitor Welcome Screen

A wizard guides you through the configuration of the admin account, repository database, and monitor application settings, and then presents a summary of the initial settings.

Navicat Monitor Initial Settings
Navicat Monitor Initial Settings

Clicking the Finish button then configures Navicat Monitor and the launches the Login screen in a new browser tab.

Configuring a New DB Server Instance

You can specify DB servers to monitor via the + New Instance button. Clicking it opens the New Instance dialog.

In the New Instance window, you can enter a name to best describe your instance in Instance Name and select the Group of your instance. Groups include "Production" and "Testing" by default, but you can add a new group by clicking the + New Group button. Then, provide login information to connect your server.

New DB Server Instance
New DB Server Instance

Monitoring CPU and Memory

Navicat Monitor can collect your server's system performance metrics such as CPU and memory resources using SSH (Secure Shell) and SNMP (Simple Network Management Protocol).

Simple Network Management Protocol (SNMP) is an Internet Standard protocol for collecting and organizing information about managed devices on IP networks and for modifying that information to change device behavior. SNMP exposes management data in the form of variables on the managed systems organized in a management information base (MIB) which describe the system status and configuration. These variables can then be remotely queried by applications such as Navicat Monitor.

You don't have to provide the SNMP login information, but you can only monitor your server without CPU or Memory metrics.

As someone who has a fair amount of experience with database monitoring, I know that the operating system has to be configured in order for applications to collect CPU and Memory related metrics. For the purposes of illustration, here are the steps for setting up SNMP in Windows 10:

  1. SNMP is not enabled by default, so you have to activate it by clicking the box on the Windows Features dialog:

    Windows Features
    Windows Features

  2. Next, we need to configure the SNMP service. On the Services dialog, right-click the SNMP Service, and select Propertiesfrom the popup menu.

    SNMP Service
    SNMP Service

  3. On the SNMP Service Properties dialog, click on the Traps tab, provide a name in the Community name combobox, such as "navicat", and click the Add to listbutton. Make sure that the Trap destinations include "localhost".

    SNMP Service Properties
    SNMP Service Properties

    Click Apply to commit your changes.

  4. On the Security tab, check the Send authentication trap box, and add the "navicat" Community name to the Accepted community names list with READ ONLY rights.

    Check the Send Authentication Trap Box
    Check the Send Authentication Trap Box

    Click OK to commit the changes and close the dialog.

Be sure to enter the "navicat" Community name in the Community text field on the New Instance screen to collect CPU and Memory metrics.

You can test your connection settings by clicking the Test Connection button. Watch for the green "Connection success!" confirmation message before proceeding.

Test Connection
Test Connection

Click the New button to add the new instance to the Navicat Monitor Dashboard.

Click the New Button
Click the New Button

Conclusion

In today's article, we got a first look at the new Navicat Monitor by exploring some of its many features and learning how to configure it on Windows 10.

Should you decide to purchase Navicat Monitor at the end of the evaluation period, you can purchase a token for each target server that you'd like to monitor. For example, if you need to monitor three MySQL Servers, you will need to purchase three tokens. If you need to monitor four MySQL Servers and one MariaDB Servers, you will need to purchase a total of five tokens. For each order, you will receive one Navicat Monitor key. Each Navicat Monitor key is for a single machine that has Navicat Monitor installed on it.

Tokens costs $399.00 USD each, but volume discounts are available for multiple licenses:

  • 5-9 licenses: receive a discount of 20% off
  • 10+ licenses: receive a discount of 30% off

A Non-commercial license for Navicat Monitor will also be available soon. It will cost less than half the price of a commercial license at only $159.00 USD per token.

See all articles by Rob Gravelle



MySQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MySQL Forum
Topic By Replies Updated
MySQL in high availability and transction secure banking application klamor 1 August 28th, 10:24 AM
MySQL rollback UAL225 1 August 28th, 10:15 AM
Browsing a DB file that uses MySql finleytech 1 July 26th, 10:51 AM
php cookie won't pass variable to next page ITdevGirl 0 June 22nd, 12:13 PM