- https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.html
- Amazon RDS uses the Amazon
Simple Notification Service (Amazon SNS) to provide notification when an Amazon
RDS event occurs. These notifications can be in any notification form supported
by Amazon SNS for an AWS Region, such as an email, a text message, or a call to
an HTTP endpoint.
- Amazon RDS groups these events into categories that you can subscribe to so that you can be notified when an event in that category occurs. You can subscribe to an event category for a DB instance, DB snapshot, DB parameter group, or DB security group. For example, if you subscribe to the Backup category for a given DB instance, you are notified whenever a backup-related event occurs that affects the DB instance. If you subscribe to a configuration change category for a DB security group, you are notified when the DB security group is changed. You also receive notification when an event notification subscription changes.
Failover
Roll-Out and Upgrade
- Apply changes to standby then promote Standby to become the new Primary. Do not fail back to the original primary.
- AWS patching of OS, DB scaling etc. is done on StandBy
- Major DB version upgrades and most minor ones – prompted for when to upgrade
- Major upgrades – need to manually upgrade RDS to another supported version
- By default, config changes to current RDS are rolled out during next maintenance window; can force an immediate roll out
- If Multi-AZ- Primary & StdBy are upgraded at the same time = Outage unless during Maintenance Window (30 min)
- Multi-AZ : make sure Security Group and NACL's allow for inter-subnet communication
- Amazon RDS groups these events into categories that you can subscribe to so that you can be notified when an event in that category occurs. You can subscribe to an event category for a DB instance, DB snapshot, DB parameter group, or DB security group. For example, if you subscribe to the Backup category for a given DB instance, you are notified whenever a backup-related event occurs that affects the DB instance. If you subscribe to a configuration change category for a DB security group, you are notified when the DB security group is changed. You also receive notification when an event notification subscription changes.
- Amazon RDS uses several different technologies to provide failover support. Multi-AZ deployments for MariaDB, MySQL, Oracle, and PostgreSQL DB instances use Amazon's failover technology. SQL Server DB instances use SQL Server Database Mirroring (DBM) or Always On Availability Groups (AGs).
- AWS SNS is used to send events via SNS notification
- Need to subscribe to specific RDS events on SNS to get a notification: DB Cluster, DB snapshot, DB parameter group, DB sec group
- CloudTrail logs all API calls
- Can view 14 days of events via CLI / API, but only 24 hrs on Console
- AWS SNS is used to send events via SNS notification
- Need to subscribe to specific RDS events on SNS to get a notification: DB Cluster, DB snapshot, DB parameter group, DB sec group
- CloudTrail logs all API calls
- Can view 14 days of events via CLI / API, but only 24 hrs on Console
- Apply changes to standby then promote Standby to become the new Primary. Do not fail back to the original primary.
- AWS patching of OS, DB scaling etc. is done on StandBy
- Major DB version upgrades and most minor ones – prompted for when to upgrade
- Major upgrades – need to manually upgrade RDS to another supported version
- By default, config changes to current RDS are rolled out during next maintenance window; can force an immediate roll out
- If Multi-AZ- Primary & StdBy are upgraded at the same time = Outage unless during Maintenance Window (30 min)
- Multi-AZ : make sure Security Group and NACL's allow for inter-subnet communication
No comments:
Post a Comment