Aurora Serverless V2 Setup Tutorial with Postgres

[@shahabqamar13]

Thanks! I’d really like to see a production ready setup that covers Aurora in a VPC and RDS Proxy setup (managed connection pooling when connecting from Lambda; planetscale provides this out of the box). My general advice would be to make more of these tutorials production ready which will set you apart from others instructors on this platform. I do understand that production-ready may mean different things for different businesses but best practices like security is something thats ignored by many tutors. Keep up the great work!

[@Octopie18]

Very helpful video thanks! Although I have no idea how you were able to connect to it through pgadmin, or if they changed something after this video. All connections time out trying to hit it

[@vlad.nicula]

I'm having the same issue...

[@christopher5731]

You have read my mind! I have been messing with aurora v2 for postgres but been looking for someone smarter to explain the ins and outs. Keep up the good work!

[@BeABetterDev]

Thanks so much and glad I could help!

[@sfhaney24]

I would love to see a video on how to setup a bastion host to connect in a private connection locally using PgAdmin. Great videos!

[@BeABetterDev]

Thanks for confirming steve. I have this topic in my backlog and hope to get to it soon.

[@dataforall5230]

Great video! Would love to see your video on bastion host, and how about connecting serverless v2 to a lambda function?

[@marianciortea5606]

Thanks for this video! It's really nice walkthrough setting up Aurora service. I would be interested in seeing how you set up Aurora Serverless without public access and then connect to it through EC2 bastion.

[@BeABetterDev]

Hi Marian, I recently created a video showing exactly that! I don't think I used Aurora Serverless (used RDS instead) but the setup steps are almost exactly the same. Note that this setup does require some additional components like a private subnet to host your DB, and a public subnet to host your bastion host. Here's the link and hope this helps: kzbin.info/www/bejne/mKbUc4afeqqXh8U Daniel

[@marianciortea5606]

Just found that video, thanks Daniel!

[@yubtub8883]

👏Great tutorial. Very informative, perfect pacing, etc. Hope you'll consider following up with a video about how to set up the "jump box" showing how to support admins connecting without making the instance public.

[@subtaweehanyut5344]

Already set public accessible to YES but got the error `timeout expired` via pgAdmin

[@augustemmery-funch620]

I get the same error. Have you figured it out?

[@subtaweehanyut5344]

@@augustemmery-funch620 recheck the security group of rds is allow tcp port 3306

[@subtaweehanyut5344]

@@augustemmery-funch620 port 5432 for postgres

[@marioshimin]

same, how to resolve that? please!

[@thomaslahore4708]

Same issue for me

[@user-wn3gl8ej8y]

really helpful, thank u!

[@BeABetterDev]

You're welcome!

[@zera7922]

Great one Daniel! I would like to know deeper about VPC settings and IAM authentication.

[@BeABetterDev]

Thanks zera!

[@theinnoverse]

I am unable to find the section to enable data API in the new UI, can anyone guide me on this please? I am unable to use database query editor

[@a-a-ron13]

You cannot enable the Data API with Serverless v2. If you want the Data API, you have to choose a version of Postgres that is compatible with v1 when you're creating the cluster.

[@christianibiri]

Thanks

[@shrinapatel8163]

Could you please share for aurora serverless v2 for mysql compatible. theres not much resources. through terraform?

[@jmsolorzano13]

Hello !! Great video!! Do you know any tricks or methodology to export a serverless postgres database from aurora to S3, to prepare a local environment? Please... It is very important for our project.

[@BeABetterDev]

Hi Juan, If you're using Aurora Serverless V2 you can use this method: docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/postgresql-s3-export.html Hope this helps

[@manojkumar_vstorm]

i got some error while creating the database in the DB wirter instance like recovery mode is in active (RDS aurora postgres )

[@cenullum]

Is there a workaround for using cognito on lambda websocket? For now this feature is not available

[@diegogallardosanchez1014]

How can i make a stress test to a db in aurora?

[@ExploitsAlphaBeta]

Anyone created a reader instance using cloudformation?

[@dwarakareddy8327]

Why it is showing as regional cluster