Amazon RDS Integration

Amazon RDS (Relational Database Service) is a web service that makes it easier to set up, operate, and scale a relational database in the cloud and can send notifications of database events through SNS.

Amazon RDS (Relational Database Service) provides cost-efficient, resizeable capacity for an industry-standard relational database and manages common database administration tasks.

​What does Opsgenie offer Amazon RDS users?

Amazon RDS sends notifications of database events through SNS. Opsgenie acts as a dispatcher for these notifications, determines the right people to notify based on on-call schedules– notifies them using email, text messages (SMS), phone calls and iPhone & Android push notifications, and escalates alerts until the alert is acknowledged or closed. RDS sends DB notifications like shutdown or backup etc., and Opsgenie ensures the right people are notified.

Functionality of the integration

When an alert is created in RDS, an alert is created in Opsgenie automatically through the integration.

Add Amazon RDS Integration in Opsgenie

  1. Please create an Opsgenie account if you haven't done so already.
  2. Go to Opsgenie Amazon RDS Integration page.

🚧

For Free and Essentials plans, you can only add the integrations from the Team Dashboards, please use the alternative instructions given below to add this integration.

  1. Specify who is notified of RDS alerts using the Teams field. Auto-complete suggestions are provided as you type.

📘

An alternative for Step 2) and Step 3) is to add the integration from the Team Dashboard of the team which will own the integration. To add an integration directly to a team, navigate to the Team Dashboard and open Integrations tab. Click Add Integration and select the integration that you would like to add.

  1. Copy the integration URL which includes Opsgenie endpoint as well as the API key.
  2. Click Save Integration.
2264

Setup Subscription on Amazon RDS

  1. Create an SNS topic.
641
  1. Add an HTTPS subscription to your topic with the Opsgenie API endpoint by using the URL provided from Opsgenie Integration.
638

Upon successfully configuring the SNS subscription to Opsgenie, a confirmation alert is created on Opsgenie:

537
  1. Create an Event Subscription for the RDS that sends to the topic previously created.
960

Sample payload sent from Amazon RDS

Create Alert payload:

{
  "Type":"Notification",
  "MessageId":"1cf7a0eb-4179-4181-b15b-ea22c5axxx",
  "TopicArn":"arn:aws:sns:us-east-1:08931xxxxxx:CloudWatchHTTPAlarms",
  "Subject":"ALARM: \"cpuUtilTest\" in US - N. Virginia",
  "Message":"{\"Event Source\":\"db-instance\",\"Event Time\":\"2014-10-28 08:13:15.339\",\"Identifier Link\":\"https://console.aws.amazon.com/rds/home?region=us-east-1#\\nSourceId: aydentifayir \",\"Event ID\":\"http://docs.amazonwebservices.com/AmazonRDS/latest/UserGuide/USER_Events.html#RDS-EVENT-0019\",\"Event Message\":\"Restored from DB instance mydbinstins to 2014-10-28 08:00:00.0\"}",
  "Timestamp":"2012-08-05T22:31:30.673Z",
  "SignatureVersion":"1",
  "Signature":"XrsO2wtE0b+xxxxxxxxxlimTUg+rV4U9RmNSSBEdlmyWvtGgpjebsmNv1wkjUsBQOJZjZnpZp5FBn6quAn3twNdRMmMLf15lv6ESbxxxxxxxxxxxx/ZLwiH9Pr/cxVYOR0aPQBPDwTYn8w6g=",
  "SigningCertURL":"https://sns.us-east-1.amazonaws.com/SimpleNotificationService-f3ecfb7224c7233fexxxxxxf.pem",
  "UnsubscribeURL":"https://sns.us-east-1.amazonaws.com/?Action=Unsubscribe&SubscriptionArn=arn:aws:sns:us-east-1:08931xxxxxxx:CloudWatchHTTPAlarms:1841c5ca-ddda-xxxxxxbfb-bf0cf15813db"
}
{
  "TopicArn": "arn:aws:sns:us-east-1:089xxxxxxxxx:CloudWatchHTTPAlarms",
  "Subject": "ALARM: \"cpuUtilTest\" in US - N. Virginia",
  "Event Source": "db-instance",
  "Event ID": "http://docs.amazonwebservices.com/AmazonRDS/latest/UserGuide/USER_Events.html#RDS-EVENT-0019",
  "Event Message": "Restored from DB instance mydbinstins to 2014-10-28 08:00:00.0",
  "Identifier Link": "https://console.aws.amazon.com/rds/home?region=us-east-1#",
  "SourceId": "sourceID"
}