AWS RDS
What is Discovered and Monitored
Type | Protocol | Information Discovered | Metrics Collected | Used For |
---|---|---|---|---|
Relational Database Storage (RDS) | CloudWatch API |
|
Performance Monitoring |
Event Types
- PH_DEV_MON_RDS_METRIC captures RDS metrics
Configuration
If you have not already configured Access Keys and permissions in AWS, please follow the steps outlined in AWS Access Key IAM Permissions and IAM Policies.
Discovering AWS RDS
- Go to the ADMIN > Setup > Credentials tab.
- In Step 1: Enter Credentials:
- Follow the instructions in “Setting Credentials“ in the User's Guide to create a new credential.
- Enter these settings in the Access Method Definition dialog box and click Save:
Settings Description Name Enter a name for the credential Device Type Amazon AWS RDS Access Protocol AWS SDK Region Set Region as the region in which your AWS instance is located. Password Config See Password Configuration. Access Key ID Access key for your EC2 instance. Secret Key Secret key for your EC2 instance Organization Select an Organization from the drop-down list. Description Description of the device.
- In Step 2: Enter IP Range to Credential Associations, click New.
- Set IP/Host Name to amazon.com.
- Select the name of your AWS RDS credential from the Credentials drop-down list.
- Click Save.
- Click the Test drop-down list and select Test Connectivity to test the connection to AWS RDS.
- Go to ADMIN > Setup > Discovery.
- Click New.
- Fill out the information in the Discovery Definition window, ensuring you set Discovery Type as AWS Scan.
- When done, click Save.
- Select the entry and click Discover.
- After Discovery finishes, check CMDB > Devices > Amazon Web Services > AWS Database.
Sample Events
[PH_DEV_MON_RDS_METRIC]:[eventSeverity]=PHL_INFO,[fileName]=deviceAwsRDS.cpp,[lineNumber]=104,[hostName]=mysql1.cmdzvvce07ar.ap-northeast-1.rds.amazonaws.com,[hostIpAddr]=54.64.131.93,[dbCpuTimeRatio]=1.207500,[dbUserConn]=0,[dbEnqueueDeadlocksPerSec]=0.000587,[freeMemKB]=489,[freeDiskMB]=4555,[swapMemUtil]=0.000000,[ioReadsPerSec]=0.219985,[ioWritesPerSec]=0.213329,[devDiskRdLatency]=0.08,[devDiskWrLatency]=0.4029,[phLogDetail]=