High Availability Flashcards
EC2
Scalability and Elasticity
Scalability
* Increase Instance Size as required, using reserved instances
Elasticity
* Increase the number of EC2 instances, based on autoscaling
DynamoDB
Scalability and Elasticity
Scalability * Unlimited amount of storage Elasticity * Increase additional IOPS for additional spikes in traffic * Decrease that IOPS after the spike
RDS
Scalability and Elasticity
Scalability
* Increase Instance Size as required. * from small to medium * There is a small downtime, do it during maintenance window
Elasticity
* Can’t scale RDS based on demand
Aurora
Scalability and Elasticity
Scalability
* Modify instace type, small to large
Elasticity
* Aurora Serverless
Multi-AZ
- Used for Failover
- Having a synchronized copy of your Primary DB in another AZ
- It gets the endpoint and points to your other AZ
Multi-AZ for SQL Server
- Engine uses synchronous logical replication
* It uses SQL Server-native Mirroring technology
Multi-AZ for MySQL, Oracle, and PostgreSQL
- Engine uses synchronous physical replication
You are doing a backup and restore, it’s affecting your production database, how can you avoid that?
- By enabling Multi-AZ:
* Backups and restores are taken from secondary DB which avoids I/O suspension to the primary
Read Replicas
It’s a read-only database.
When would you use Read Replicas?
- Scaling beyond the compute or I/O capacity of a single DB instance for read heavy workloads.
- Serving read traffic while the source DB Instance is unavailable.
- Business reporting or data warehousing scenarios:
- Run your BI queries against Read Replicas, rather than primary DB Instance
- Or use redshift to run these queries
What happens when you create a new Read Replica?
- AWS takes a snapshot of your db
- Multi-AZ enabled: NO downtime
- MUlti-AZ not enabled: Downtime
- RDS manages endpoints and all
True or False
You can have read replicas in different Regions for all engines
True
True or False
Read Replicas cannot be multi-AZ
False - Read Replicas can be multi-AZ
What is a key metric to look for using Read Replicas?
REPLICA LAG
The higher, the worst
When is a good use case for promoting read replicas into its own DB instance?
- When you want to test, develop, run BI queries on your DB
* It’s like cloning your DB instance.