• Products
  • Get started
  • Documentation
  • Resources

Integrate Opsgenie with Amazon RDS

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. Amazon 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 Amazon RDS, an alert is created in Opsgenie automatically through the integration.

Add Amazon RDS Integration in Opsgenie

You can add this integration from your team dashboard

If you're using Opsgenie's Free or Essentials plan, or if you’re using Opsgenie with Jira Service Management's Standard plan, you can only add this integration from your team dashboard as the Integrations page under Settings is not available in your plan.

Adding the integration from your team dashboard will make your team the owner of the integration. This means Opsgenie will assign the alerts received through this integration to your team only.

To do that,

  1. Go to your team’s dashboard from Teams,

  2. Select Integrations, and select Add integration.

Follow the rest of the steps to complete the integration.

  1. Go to Settings > Integrations. Search for Amazon RDS and select Add

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

  3. Copy the integration URL which includes Opsgenie endpoint as well as the API key.

  4. Click Save Integration.

Set up Subscription on Amazon RDS

  1. Create an SNS topic.

Amazon RDS SNS Topic

2. Add an HTTPS subscription to your topic with the Opsgenie API endpoint by using the URL provided from Opsgenie Integration.

Amazon RDS Create Subscription

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

Amazon RDS Confirmation Alert

3. Create an Event Subscription for the RDS that sends to the topic previously created.

Amazon RDS Event Subscription

Sample payload sent from Amazon RDS

Create Alert payload:

JSON

1 2 3 4 5 6 7 8 9 10 11 12 { "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" }

JSON

1 2 3 4 5 6 7 8 9 { "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" }

 

Additional Help