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!
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!
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
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.
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: ua-cam.com/video/buqBSiEEdQc/v-deo.html Daniel
👏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.
After creation is it possible to get terraform/cloud formation. So every time if we want to modify infra we can modify infra using script? or we need to create manually code?
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.
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.
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
Unbelievable! Finally some good video about an AWS service that is clear and easy to understand (including the English voice). Thanks so much.
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!
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!
Thanks so much and glad I could help!
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
I'm having the same issue...
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!
Thanks for confirming steve. I have this topic in my backlog and hope to get to it soon.
Great video! Would love to see your video on bastion host, and how about connecting serverless v2 to a lambda function?
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.
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: ua-cam.com/video/buqBSiEEdQc/v-deo.html
Daniel
Just found that video, thanks Daniel!
👏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.
Already set public accessible to YES but got the error `timeout expired` via pgAdmin
I get the same error. Have you figured it out?
@@augustemmery-funch620 recheck the security group of rds is allow tcp port 3306
@@augustemmery-funch620 port 5432 for postgres
same, how to resolve that? please!
Same issue for me
really helpful, thank u!
You're welcome!
Great one Daniel! I would like to know deeper about VPC settings and IAM authentication.
Thanks zera!
After creation is it possible to get terraform/cloud formation. So every time if we want to modify infra we can modify infra using script? or we need to create manually code?
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
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.
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.
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
Could you please share for aurora serverless v2 for mysql compatible. theres not much resources. through terraform?
i got some error while creating the database in the DB wirter instance like recovery mode is in active (RDS aurora postgres
)
How can i make a stress test to a db in aurora?
Why it is showing as regional cluster
Thanks
Anyone created a reader instance using cloudformation?