CLF-C02 ยท Database services
Amazon RDS, Multi-AZ, read replicas and Aurora
Amazon RDS engines, Multi-AZ deployments and read replicas, Amazon Aurora and its compatibility with MySQL and PostgreSQL, and Amazon Redshift as a data warehouse contrast.
Key points
- Amazon RDS engines: IBM Db2, MariaDB, Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL.
- Multi-AZ: synchronous standby in another AZ, automatic failover; in a Multi-AZ DB instance it serves no reads.
- Read replica: asynchronous read-only copy, offloads reads; can be in another Region.
- Aurora: compatible with MySQL and PostgreSQL; storage in three AZs, grows automatically.
- Redshift: petabyte-scale analytics data warehouse.
Source: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html
Practice questions
Which Amazon RDS feature is designed mainly to keep the database available if the primary instance's Availability Zone fails?
- Read replicas in the same Availability Zone
- Multi-AZ deployment
- Manual DB snapshots
- A larger DB instance class
Show answer
Answer: B. Multi-AZ deployment
A Multi-AZ deployment keeps a standby in a different AZ and fails over to it. Read replicas mainly scale reads, and snapshots are backups that need a restore.
Which database engines can you choose when creating an Amazon RDS DB instance (outside Aurora)?
- MariaDB
- MongoDB
- Microsoft SQL Server
- Apache Cassandra
- Oracle Database
Show answer
Answer: A. MariaDB, C. Microsoft SQL Server, E. Oracle Database
Amazon RDS supports IBM Db2, MariaDB, Microsoft SQL Server, MySQL, Oracle Database and PostgreSQL. MongoDB-compatible workloads use Amazon DocumentDB, and Cassandra is not an RDS engine.
In an Amazon RDS Multi-AZ DB instance deployment, the standby replica can be used to serve read queries.
Show answer
Answer: False
False. In a Multi-AZ DB instance deployment the synchronous standby exists only for failover and does not serve reads. For read scaling you add read replicas (or use a Multi-AZ DB cluster, whose readers do serve reads).
Practice 8 questions on this topic in Bitzu
Short lessons, instant explanations and spaced review of what you get wrong. Free on iOS and Android.
