Bitzu

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

Single choice

Which Amazon RDS feature is designed mainly to keep the database available if the primary instance's Availability Zone fails?

  1. Read replicas in the same Availability Zone
  2. Multi-AZ deployment
  3. Manual DB snapshots
  4. 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.

Select all that apply

Which database engines can you choose when creating an Amazon RDS DB instance (outside Aurora)?

  1. MariaDB
  2. MongoDB
  3. Microsoft SQL Server
  4. Apache Cassandra
  5. 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.

True or false

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.

Download on the App StoreGet it on Google Play

More CLF-C02 topics in this module