RDS

Question 1

Are Aurora replicas synchronous or asynchronous?

Answer 1

Aurora replicas are asynchronous

Question 2

When to use Aurora Cross-region replicas or Global tables?

Answer 2

• Global tables: DR; Subsecond lag
• Cross-region: Can issue writes against replica

Question 3

What are recommendations with regards to capacity for RDS Read Replicas?

Answer 3

The same or larger DB instance class and storage type as the source DB instance for the read replica.

Question 4

In a Multi-AZ deployment RDS applies operating system updates by following these steps:

Answer 4

• Perform maintenance on the standby.
• Promote the standby to primary.
• Perform maintenance on the old primary, which becomes the new standby.

Question 5

In a Multi-AZ deployment RDS applies engine updates by following these steps:

Answer 5

• Amazon RDS modifies both primary and secondary DB instances at the same time.
• Both the primary and secondary DB instances in the Multi-AZ deployment are unavailable during the upgrade. - This operation causes downtime until the upgrade is complete.
• The duration of the downtime varies based on the size of your DB instance.