Search results for "{{ search.query }}"

No results found for "{{search.query}}". 
View All Results

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. It 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 can send notifications of database events, through SNS. OpsGenie acts as a dispatcher for these notifications, determining the right people to notify based on on-call schedules, notifying them using email, text messages (SMS), phone calls and iPhone & Android push notifications, and escalating alerts until the alert is acknowledged or closed. Simply, 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 already
  2. Go to OpsGenie Amazon RDS Integration page
  3. Specify who should be notified for the RDS alerts using the "Teams" field. Auto-complete suggestions will be provided as you type.
  4. Copy the integration URL by clicking on the copy button or selecting. URL includes OpsGenie endpoint as well as the API key.
  5. Click on "Save Integration"

Setup Subscription on Amazon RDS

  1. Add an HTTPS subscription to your topic with the OpsGenie API endpoint by using the url provided from OpsGenie Integration

Upon successfully configuring SNS subscription to OpsGenie a confirmation alert will be created on OpsGenie:

  1. Create an Event Subscription for your RDS that sends to the topic you created.

Sample payload sent from Amazon RDS

Create Alert payload:

{
  "Type":"Notification",
  "MessageId":"1cf7a0eb-4179-4181-b15b-ea22c5aa0280",
  "TopicArn":"arn:aws:sns:us-east-1:089311581210: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+ofOl1Z85tqLqQn1fMuv07uRttlimTUg+rV4U9RmNSSBEdlmyWvtGgpjebsmNv1wkjUsBQOJZjZnpZp5FBn6quAn3twNdRMmMLf15lv6ESbYF8mpFHwmMhgWVkgq60vmjj/ZLwiH9Pr/cxVYOR0aPQBPDwTYn8w6g=",
  "SigningCertURL":"https://sns.us-east-1.amazonaws.com/SimpleNotificationService-f3ecfb7224c7233fe7bb5f59f96de52f.pem",
  "UnsubscribeURL":"https://sns.us-east-1.amazonaws.com/?Action=Unsubscribe&SubscriptionArn=arn:aws:sns:us-east-1:089311581210:CloudWatchHTTPAlarms:1841c5ca-ddda-450e-bbfb-bf0cf15813db"
}
{
  "TopicArn": "arn:aws:sns:us-east-1:089311581210: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"
}

Amazon RDS Integration