03 - Multi AZ RDS

Question 1

Multi AZ RDS

Answer 1

• Option to enable
• Uses standby read replica
• CNAME points at the primary instance

Question 2

Costs

Answer 2

• No Free Tier for multi AZ

Question 3

Failover

Answer 3

• Failover brief interruption 60-120 sec. (High Availability)
• Standby cannot be accessed directly
• Same Region Only

Question 4

Replication / Backups / Failover

Answer 4

• Backups taken from Standby Replica
• Synchronous replication between instances
• Failover - AZ outage, Primary failure, manual failover, instance type change and software patching

Question 5

Multi-AZ RDS

Answer 5

• RDS creates an exact copy of your DB in another AZ
• RDS will write automatically and synchronously to the standby DB

Question 6

Which types can be setup as Multi-AZ?

Answer 6

• SQL Server
• MySQL
• MariaDB
• Oracle
• PostgreSQL

Question 7

Exception

Answer 7

• Aurora is always setup as Mulit-AZ, it can not be in a single AZ

Question 8

Unplanned Failover / Maintenance

Answer 8

• AWS will detect the DB failure, and resolve the connection string to the Standby DB automatically (promoted to primary DB)

Question 9

Performance (NOT Enhanced)

Answer 9

• Multi-AZ is for disaster recovery only
• It does not improve performance
• The standby DB will not accept connections if the primary DB is active