RDS Read Replicas: 6 Things You Must Know (AWS)

Amazon Relational Database Service or RDS is a fully managed database service in AWS and Read Replicas are a feature of RDS that enables users to create one or more replicas of their primary RDS database instance.
Hi Guys, this is Abi from Gokce DB and in this video you are going to learn 6 things about RDS Read Replicas in AWS. Let's get into it.
1. Read Replicas can be used to improve the performance and durability of your database by offloading read traffic from your primary database instance to one or more replicas. The replicas are exact copies of the primary database instance and are kept in sync with it using asynchronous replication technology.
2. Read replicas are available in RDS for MySQL, MariaDB, PostgreSQL, Oracle, and SQL Server as well as Amazon Aurora.
3. You can reduce the load on your primary database instance by routing read queries from your applications to the read replica instance. Read replicas allow you to elastically scale out beyond the capacity constraints of a single DB instance for read-heavy database workloads.
4. Read Replicas can be promoted to become standalone RDS database instances in their own right, which can be useful for scaling out your database or for disaster recovery purposes.
5. When you create a read replica, Amazon RDS sets up a secure communications channel using public key encryption between the source DB instance and the read replica, even when replicating across different regions.
6. While read replicas can help improve the availability and performance of your database, they are not a substitute for backups. This is because if you run a bad query on your primary instance, your read replica will also sync the bad changes.
There you have it. Make sure you like, subscribe and turn on the notification bell. Until next time.

[@rajrocky8658]

Very Good effort

[@GokceDB]

Thanks! :)

[@wweirii3648]

Agree there are a few too many clips n sound effects, but educational and I’m following for more learning.

[@GokceDB]

Thank you! :)

[@ArielGMachado]

How can be handled read/write splitting using AWS RDS PostgreSQL managed write and read replicas without change your code to manage both endpoints? AWS allow some kind of DB Proxy that manages read/write splitting automatically natively (RDS Proxy support it?) or you have to install 3rd party software like MaxScale, SQLProxy, Heimdall,etc. ?

[@GokceDB]

Yeah, look into AWS RDS Proxy :)

[@corbingrossen]

way too many clips and sound effects, good work tho!

[@GokceDB]

Yeah, I know. I fixed it in the latest videos. Let me know what you think. Thanks.