High Availability, Fault Tolerance and Disaster Recovery

Question 1

What are the databases supported in RDS?

Answer 1

MariaDB, SQLServer, Aurora, MySql, Postgres, Oracle

Question 2

What does AWS Administer in RDS?

Answer 2

Provision infrastructure, database install

Question 3

How can you scale RDS?

Answer 3

Supports both Vertical and Horizontal scaling. (Vertical) You can scale up the instance type. Data can be scaled live except for MSSQL. (Horizontal) Read replicas which can be promoted to master for DR purposes.

Question 4

What is Amazon Aurora?

Answer 4

A MySQL and PostgreSql compatible database built for the cloud. It’s a relational DB. Simple and cost effective. Can deliver up to 5x the throughput of MySql, Compatible with My Sql 5.7.

Question 5

Can Auroroa be backed up?

Answer 5

Automatic contious

Question 6

Is Aurora fault tolerant?

Answer 6

Aurora provides automatic, continous and incremental backups. Provides point-in-time restore within a second. Provides up to a 35 day rention period, stored in S3. No impact

Question 7

Can Aurora recover from failure?

Answer 7

Aurora creates 6 copies of you data built into 3 availability zones. Data divided into 10Gb segments across many disks. Aurora can support

Question 8

Amazon Aurora Replica

Answer 8

Can have up to 15

Question 9

What are some Aurora Security Features?

Answer 9

All aurora must be created in a VPC. You CANNOT encrypt an unencrypted adatabes You can encrypt storage.

Question 10

What are some Aurora Connection Metods.

Answer 10

Cluster Endpoint - Connects to the current primary DB instance for that DB cluster
Reader Endpoint - Provides load- balancing support for read-only connections.
Custom Endpoint
Represents a set of DB instances you choose.
Instance Enpoint - Allows a fine grain to control a spific instance to talk to a specific cluster.

Question 11

What is DynamoDB?

Answer 11

Is a fully managed NoSql that supports key/values and document value structure . It is predictable, fully manage. No visibile servers and works with auto-scaling. Works with no practical storage limitations. It is fully resilient and highly available.

Question 12

How is DynamoDB operate and what are RCU and WCU?

Answer 12

It’s on the table level that performance requirements are made. There are WCU - 1KB blocks per second. There are RCU - 4KB blocks