AWS RDS Contd
How to make Database Highly Available
- To make Database HA we have multiple use-cases and complications
- Problem: Scaling in Databases in not mereley increasing number of Database instances, Data needs to Consistent
- Solution: The solution to this problem is Replications. There are two types of Replications
- Read-Replica
- Read/Write-Replica
- Overview: Consider the below application with a single database
-
If we create a read-replica, now we have two endpoints
-
If we want to have an additional databases in the Same Region but different AZ, then we use multi-AZ
- Multi AZ Databases can have additional read-replicas in same/different region
Creating a Read Replica
- Lets create read-replica in a different region
- Wait till replication is done
Create Multi-AZ
- When we create a MultiAZ, A stand by instance gets created in different AZ with replications from Master to Standby
- Lets convert the Single-AZ into Multi-AZ
