Please enter a valid email address. The download links will be emailed to you.
The download links for
MONyog have been sent to
Back to Topics

How to do RDS/Aurora OS monitoring in Monyog

RDS/Aurora OS monitoring feature introduced with Monyog-8.1.0. Monyog makes use of the CloudWatch API and uses the different OS metrics available with the API to fetch and display the data. All the RDS/Aurora OS monitors are shown under the monitor group "RDS/Aurora Instance Metrics" in Monitors page and the corresponding charts are available on the Dashboard page. In order to be able to see the OS data, you should first enable system metric for the RDS/Aurora instance

Enabling System Metrics

Go to "Servers -> Edit server -> Advanced" of the RDS/Aurora instance and enable the system metrics. Once enabled, the user should enter the following 4 parameters:

  1. DB instance identifier: A unique name to identify your RDS/Aurora instance.
  2. Instance region: The region in which your instance is hosted, for e.g: us-east-1
  3. Access key ID: It is a 20 character long key ID which can be created from the AWS Management Console. It is used to make a programmatic request to AWS.
  4. Secret access key: It is 40 characters long and can be created from the AWS Management Console. You can refer to the documentation, on how to generate credential keys here >> Getting your Access Key ID and Secret Access Key

image

Enabling RDS/Aurora Custom Objects

Once the System metrics is enabled, you will start getting OS data in the monitor group "RDS/Aurora Instance Metrics". The custom objects CPU Utilization, Freeable memory, Read IOPS and Write IOPS are enabled by default, while rest are disabled. In order to enable the others:

Go to "Monitors -> RDS/Aurora Instance Metrics -> click on the plus (+) icon -> select "Manage RDS/Aurora Objects" and select "Yes" for the option "Enabled?" for any of the listed custom objects.

image

Adding New RDS/Aurora Custom Objects

Apart from the default metrics shipped with Monyog, any user can also add an RDS/Aurora Custom Object from the list of available CloudWatch metrics (Refer here for the CloudWatch metrics available for RDS and here for Aurora instances). Adding RDS/Aurora Custom Objects is a 2-step process:

1. Adding a Custom Object

  • Go to "Monitors -> RDS/Aurora Instance Metrics -> click on the plus (+) icon -> select 'Manage RDS/Aurora Objects' -> Click on 'Add new RDS/Aurora custom object (+)'
  • Enter the name of the CloudWatch Metric which you want to add under the field "Name". You can also give the name of the servers comma separated for which you want this metric to be evaluated for.

image

2. Adding the Monitor

  • Go to "Monitors -> RDS/Aurora Instance Metrics -> click on the plus (+) icon -> select 'Add new monitor'
  • Enter Monitor name and the Monitor group name in which you want to add this new monitor to (use "RDS/Aurora Instance metrics" if you want to add it in this group). Select "System" as "Type of counter" if you are adding a system metric.
  • Enter a simple Javascript function in the "Value" field using the Cloudwatch metric like:
    function()
    
    {
    
     return GetAWSMetricVal("NetworkReceiveThroughput");
    
    }
    

image

Enabling RDS/Aurora Dashboard charts

Go to "Dashboard -> Manage Dashboard -> Enable the listed RDS/Aurora charts" under 'System Charts'. Dashboard page gives the flexibility to create a dashboard with a particular set of charts, so a user can create a dashboard with only RDS OS metrics charts for ease of monitoring.

Adding New RDS/Aurora Dashboard charts

In order to add a RDS/Aurora chart in the dashboard page, the corresponding RDS/Aurora custom objects should be defined and enabled first at 'Monitors -> RDS/Aurora Instance Metrics -> click on the plus (+) icon -> select 'Manage RDS/Aurora Objects'. Once enabled, follow below steps in order to add the chart:

  • Go to "Dashboard -> Manage Dashboard -> Click on "Add new chart" (+ icon)
  • Select "System" as the "Type of counter" and give a proper chart name.
  • Enter the "RDS/Aurora custom object" in the series caption field and the corresponding MOM (Monyog Object Model) variable in Series values field

image