AWS Read Replications
- For the RDS instance created which supports all the operations (CRUD), a Read Replica can be created in the same / different region which supports only read operations
- Read replica can be promoted at any time to become primary database.
- Generally read replicas have two primary use-cases
- Business Intelligence Systems: Reporting /BI systems will use the data from database to generate reports and if we have applications which write to database and BI systems which read from db on same db, database performance might be degraded. Since BI Requires only read operations, we can use Read replica for all the retrievals
- To have a disaster recovery
- Lets create a mysql database in free tier (db.t2.micro) with automatic backups
- Now lets create read replica in the same region
- Now connect to the write database after replication is setup
- Let create employees database Refer Here
- if we promote read replica then write operations also can be performed
Exercises
- Cloud Essentials Refer Here
- Windows Powershell Refer Here
- Active Directory Refer Here
- Linux Classroom Refer Here
- Watch 1-7 videos of DevOPs Essentials Refer Here
