AWS RDS Read Replica Complete DEMO | Cross-Region Read Replica | RDS Storage Auto-Scaling

[@sanketh768]

keep up your good work knowledge India. I really appreciate all the hard work you put into by making all these videos and sharing your knowledge. Really proud of you.

[@shubhadip87]

Explained nicely, easy to understand..hard to find demonstration like this in other training videos..

[@knowledgeindia]

Glad it was helpful! Do show your support by sharing these videos with your friends.

[@sanketh768]

Had one thing in my mind to ask you. We all know that you have a very good knowledge of AWS. You can join AWS and work in AWS, I mean you can work in Amazon. I'm sure that you will be a great team player for amazon and will have a great future ahead.

[@knowledgeindia]

😄😄😄😄

[@suriya650]

0:59 Why can't we do horizontal scaling for RDS like EC2. Is it because of license issue for commercial database engines(Oracle, Microsoft SQL)

[@tejakirankumarjami9993]

As always Brilliant Stuff :)

[@knowledgeindia]

Thanks again! Continue to support us by sharing..

[@charleskamalanand8644]

Great video again. I have a question here. What happens to the master database when you promote your read replica to master, presume that master database was functional when promoting read replica.

[@knowledgeindia]

Good question! then the RR would become an independent master. first master remains an independent one.

[@vaiibhavshirodkar1902]

@@knowledgeindia again we have to create a read replica for the DB that was used as read replica earlier??

[@harshwardhankakra4684]

@KnowledgeIndia AWS Azure Tutorials please can you tell me in different region what is vpc, subnet and subnetgroup configuration. So we can access it publicly? Thank you

[@dharmendersingh7165]

Good presentation , but i have one doubt as you have created read replica in a different region so i believe you must have a different VPC network apart from primary DB instance in a different region . then how these two databases created in a different VPN interact each other i.e. do i need to do additional setting to make it working ?

[@knowledgeindia]

yes there is a different VPC in the other region. Good thing is Read Replica would take care of connectivity, you do not need to do any peering.. If you go with DB on EC2, then you will have to do VPC peering.. Please SHARE this video if it has helped you.

[@durgarasane-kolapkar1842]

Thank you the explanation. I need your help - I tried to follow same steps for launching an Oracle RDS instance, but it doesn't work. It works only for MySQL RDS DB. What needs to change if we want to launch Oracle DB on RDS? Also, I didn't find any videos which explain how to launch Oracle RDS in private subnet. Can you please create a video for this?

[@dilmangeymore3039]

Please make a video on how to recover only some particular schema Or tables from the snapshot in case of oracle rds database

[@abhinavpaul5960]

how traffic is differentiated which will go to read replica and which will go to master DB ? which service is behind this ?

[@knowledgeindia]

You need to handle at your application level

[@srb1855]

Excellent! 👍

[@sriranjithshanmugham6192]

I want to thank you for your efforts in sharing valuable knowledge to all of us. Your videos are Great!! I have query on this topic, When RR becomes Primary DB 1, will there be another new RR instance created to replicate data from new Primary DB? 2, how this switching from initial Primary DB to RR as new Primary DB is notified to App server? Thanks in advance for your reply.

[@YoursTrulyAKK]

After we converted RR to master database, can we demote it later to functional as earlier after DR?

[@gigacloudz]

I was wondering if there are any other methods to backup a database across regions aside from using a cross read replica? Do you happen to know of any other options or techniques? Thank you.

[@knowledgeindia]

Create snapshot in region 1 and copy that to region 2

[@gigacloudz]

@@knowledgeindia I have a problem i cannot copy the snapshot that i created from region 1 to region 2. All of the actions under the snapshot is blocked. Thank you.

[@knowledgeindia]

@@gigacloudz resolve your IAM permissions then..

[@ketanambekar31]

This is great video. Can I ask one thing if my application needs to read and write both into RDS , then can I use Read replica when I am just reading/viewing the information and when user tries to write anything from application then it should point to master database for writing. Any better way?

[@abdul9910]

Very nice explanation

[@pratibhay07]

can we do failover with read replica.

[@knowledgeindia]

Yes, it is explained in the video.

[@rajarshijana9233]

Hi Sir, there is one question... In RDS storage auto-scaling, is scale-in scaling possible??

[@yustiono]

How can we have the read replica be promoted automatically to master role when the original master failed?

[@knowledgeindia]

You will have to write a script and use this - docs.aws.amazon.com/cli/latest/reference/rds/promote-read-replica.html .. SUBSCRIBE & SHARE to support us..

[@giriprasadh686]

@@knowledgeindia can you provide some sample for this script ?

[@kapilkaushal6178]

Great explanation ...

[@kishorekumar-md7yy]

Good Job bro ...👏

[@omarsalam7586]

thank you that's was really helpful

[@knowledgeindia]

Thanks.. please share and support us

[@varunjoshi4410]

Such a nice video

[@knowledgeindia]

Thank you 😊

[@sanketh768]

can you please explain what is an assume role and 1.why it is required and so important? 2.Where it is used This is a question that is confusing me as we all know about IAM role. So what exactly is the difference between IAM role and Assume role. Would be helpful if you can answer this

[@knowledgeindia]

We have a video on IAM role. Check our playlist on security

[@Niruukumar]

Does read replica supported cross-account as well..?

[@knowledgeindia]

No.

[@nazmashaik1228]

KnowledgeIndia AWS Azure Tutorials Had it to be done read replica support cross account then would it be through SCP?