Amazon RDS - Notes - 03 - Multi-AZ

AWS > Database > Amazon Relational Database Service (RDS):

In a Multi-AZ deployment, Amazon RDS automatically provisions and maintains a synchronous standby replica in a different Availability Zone.

Mutit-AZ is available for the following database:
1. MariaDB DB
2. MySQL
3. Oracle
4. PostgreSQL
5. SQL

In the Event of planned database maintenance, DB instance failure, or an AZ failure, Amazon RDS will automatically failover to the standby so that database operations can resume quickly without administrative intervention.

The primary DB instance switches over automatically to the standby replica if any of the following conditions occur:
1. An Availability Zone outage
2. The primary DB instance fails
3. The DB instance's server type is changed
4. The operating system of the DB instance is undergoing software patching
5. A manual failover of the DB instance was initiated using Reboot with failover

Multi-AZ is for Disaster Recovery (DR) only.
It is not primarily used for improving performance.
For performance improvement, you need Read Replicas.


Reference:
1. AWS Documentation - High Availability (Multi-AZ) for Amazon RDS:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.MultiAZ.html

2. Udemy - AWS Solutions Architect - Associate:
https://www.udemy.com/aws-certified-solutions-architect-associate/


最初發表 / 最後更新: 2020.01.12 / 2020.06.09