🍃 Spring Boot & AWS RDS with Spring Cloud AWS

Wow this video got quite long! It cover lots of things and you'll find it especially valuable if you are new to AWS RDS or if you have never used Spring Cloud AWS to connect to RDS.
Follow me on twitter for more tips, links, articles and just random thoughts about Spring and Java / maciejwalkowiak 😉
0:00 What this video is about?
0:53 What is AWS RDS?
2:27 How to create PostgreSQL instance on RDS
6:51 Connecting to RDS from localhost (don't do it for prod!)
9:00 Connecting to RDS from Spring Boot application
14:10 What are the benefits of RDS integration in Spring Cloud AWS?
16:13 Connecting to RDS from Spring Boot application with Spring Cloud AWS
21:19 Adding read replicas to RDS database
23:24 Connecting to RDS read replicas from Spring Cloud AWS
24:43 When not to use RDS read replicas?

[@lts8683]

You explain very well the topics, could you please make more tutorials.
thank you

[@partyscoutereurope2586]

Another great video 👍🏻
Thanks

[@prime8krish]

Your video is the most clearest source, even compared to Spring docs. Aurora Engine is not supported in spring aws cloud, If you use Aurora with read replicas it "looks works" but the read replica is never used and all queries are sent to the writer instance.

[@Anbu_Sampath]

As usual great content. Thanks

[@SpringAcademy]

Thanks man!

[@pabloezequielsantiagorecag5015]

Awesome video!.Thanks a lot!.

[@najimahmed8923]

cool demo!

[@learningskills9249]

Great content.Thanks👍🏼

[@SpringAcademy]

Thanks for feedback! Glad you liked it!

[@ernanibatista1806]

TKS BRO AMAZING

[@treeeep]

cool man , thank you

[@hyunsoolsong5563]

I've been looking for datasource url format a couple of days. Thanks!

[@kappaj01]

Great feature explanation. Like!
Will there be anything different when using Aurora other than go for the MySQL driver lib vs PostgreSQL lib?

[@asdfasdfasdfasdf219]

Nice video! Can I set different repository classes pointing to different read replicas?

[@kamalhm-dev]

Thanks for this, if I could request, please do reactive repository on relational dbms

[@SpringAcademy]

Thanks! Added to a list

[@samarthurs8000]

Very informative. SpringCloud AWS provides most of the features out-of-the-box. Btw, where is the connection details to your AWS Account? Did you configure the AWS AccountId and Key, Region in the SpringBoot application.properties file? Thank you so much!

[@cloud4java]

You don´t need to care about these details about RDS. Once you configure it, you have an endpoint, then you can treat the connection as any other kind of database, connection by endpoint url.

[@divyaprakashmishra9545]

Great Video! Just a query for my use case, if I am using secrets manager for db credential how can I make connection for read and write replica using the aws-cloud-sdk dependency because I will not be able to add the details in properties file, Can we acheive this using config or bean?

[@pawsdev]

In local env like compose or local network read replicas downgrades perfomance, so with single db perfomance is higer
so i make spring app with two datasources for reads and writes
i tried up to 12 instances of app and 12 instances of postgres, and tried different configs
12X12 one replica per instance, ot 1X4 and other, but no perfomance improvement
used haproxy and pgpool for load balancing and RW segregation
still single DB perfoms faster in common LAN or compose

[@FabioXen]

hello great video.
The version 2.4 works in the same way?
Thx!

[@aronchristensen7792]

Would be interesting how to use Spring Cloud AWS with AWS IAM.

[@SpringAcademy]

Hmmm like what for example?

[@cristiannechita2032]

Won't make a difference, but, you could setup an ingress rule from your local machine IP with a /32 CIDR towards that SG. This way, at least, you won't expose it to the whole world ;) - ofc, you still should not do it in production.