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!
@Octopie182 жыл бұрын
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...
@christopher57312 жыл бұрын
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!
@BeABetterDev2 жыл бұрын
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.
@dataforall52302 жыл бұрын
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!
@yubtub88832 жыл бұрын
👏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.
@subtaweehanyut53442 жыл бұрын
Already set public accessible to YES but got the error `timeout expired` via pgAdmin
@augustemmery-funch6202 жыл бұрын
I get the same error. Have you figured it out?
@subtaweehanyut53442 жыл бұрын
@@augustemmery-funch620 recheck the security group of rds is allow tcp port 3306
@subtaweehanyut53442 жыл бұрын
@@augustemmery-funch620 port 5432 for postgres
@marioshimin2 жыл бұрын
same, how to resolve that? please!
@thomaslahore47082 жыл бұрын
Same issue for me
@user-wn3gl8ej8y2 жыл бұрын
really helpful, thank u!
@BeABetterDev2 жыл бұрын
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.
@christianibiri2 жыл бұрын
Thanks
@shrinapatel816320 күн бұрын
Could you please share for aurora serverless v2 for mysql compatible. theres not much resources. through terraform?
@jmsolorzano132 жыл бұрын
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.
@BeABetterDev2 жыл бұрын
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_vstorm2 жыл бұрын
i got some error while creating the database in the DB wirter instance like recovery mode is in active (RDS aurora postgres )
@cenullum2 жыл бұрын
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?
@ExploitsAlphaBeta4 ай бұрын
Anyone created a reader instance using cloudformation?