RDS/Aurora OS monitoring feature introduced with Monyog-8.1.0. SQL DM for MySQL 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
Go to Servers, select Edit server, and choose Advanced of the RDS/Aurora instance and Enable System Metrics. Once enabled, the user should enter the following four parameters:
Once the System metrics is enabled, you 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, select RDS/Aurora Instance Metrics, click theicon, select Manage RDS/Aurora Custom Objects, and select Yes for the Enabled option for any of the listed custom objects.
Apart from the default metrics shipped with SQL DM for MySQL, any user can also add an RDS/Aurora Custom Object from the list of available CloudWatch metrics (Refer here for the
metrics available for RDS and here for the ). Adding RDS/Aurora Custom Objects is a 2-step process:
Enter a simple JavaScript function in the Value field using the Cloudwatch metric like:
function() { return GetAWSMetricVal("NetworkReceiveThroughput"); } |
Go to Dashboard, select Manage Dashboard, and Enable the listed RDS/Aurora charts under System Charts. The 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.
To add a RDS/Aurora chart in the dashboard page, the corresponding RDS/Aurora custom objects should be defined and enabled at Monitors -> RDS/Aurora Instance Metrics -> click theicon -> select Manage RDS/Aurora Objects. Once enabled, follow the steps below to add the chart:
SQL Diagnostic Manager for MySQL agentless and cost-effective performance monitoring for MySQL and MariaDB. | | | | | | | |