AWS Lambda 👉 RDS Proxy Tutorial 🔥 | IAM Authentication

You have an AWS Lambda function and you want to connect it to Amazon RDS Proxy using IAM Authentication.
Can you do this using the lambda console?
Amazon RDS Proxy is a fully managed, highly available database proxy that makes applications more scalable by pooling and sharing established database connections.
AWS Lambda is a serverless, event-driven compute service that lets you run code for virtually any type of application or backend service without provisioning or managing servers. You can trigger Lambda from over 200 AWS services and software as a service (SaaS) applications, and only pay for what you use.

[@aswanthmadhav4562]

Still it's getting errorMessage": "Error 1045: Access denied for user 'admin'@'IP (using password: YES)" with Golang

[@simcreation9286]

Hey i m using this because AWS Lambda to connect to a database, both within and outside of the AWS network, can be challenging due to the stateless and short-lived nature of Lambda functions. i used this RDS proxy but i need some ans as well like .. I also need the difference in time if you direct create connection from db vs you ask connection from proxy log the end time-start time for get connection call

[@GokceDB]

Going through RDS Proxy will definitely add some latency :)

[@simranverma7480]

@@GokceDB can you please help what can i do

[@GokceDB]

@@simranverma7480 see if this helps: kzbin.info/www/bejne/nYPZimSqadinq9E

[@jack-zf6dv]

Brother need a help iam getting the below error, mysql_clear_password cannot be loaded , plugin not enabled

[@GokceDB]

See if this helps: stackoverflow.com/questions/48813665/aws-rds-using-im-policy-to-be-abbe-to-connect-from-another-user

[@subterrain5293]

Hi, I followed the exact steps and getting the error: Access deined for user (using passwors no) while testing lambda.

[@subterrain5293]

Sorry for replying late, the only thing that was missing was attaching policy to Lambda IAM role. Was able to get it working then. The steps in the video helped a lot, thanks.

[@stuartrose1154]

​@subterrain5293 thanks for the update, I have the same issue... May I ask what policy you are referring to that needs adding?

[@user-zw6fi2te1t]

Hello Abi. Your channel and your content are very interesting. For a few weeks now I have been trying to configure an RDS Proxy with IAM authentication for an Aurora MySQL database. I'm trying this manually, connecting from an EC2 instance. However, I am unable to establish the connection. I would like to know if you can help me since I searched all over the web and I can't find the solution to the issue. Thanks in advance!

[@GokceDB]

Was the tutorial helpful?

[@user-zw6fi2te1t]

Unfortunately it does not apply to my case. I have an RDS AuroraMySQL instance. I already created an RDS proxy to connect to that db through an EC2 instance (they share the same VPC, and the ingress/egress rules are already configured). I have a test IAM user. However, when I generate the TOKEN and try to connect, it does nothing. It's probably a role/policy configuration problem but I can't figure it out. Is there any way can you help me? this is already beyond me.

[@GokceDB]

@@user-zw6fi2te1t Check the RDS proxy logs to see if you can find the error message. That'll help to get to the root cause of the problem. You might also need to check your VPC logs. Thanks.

[@simcreation9286]

i need help can you please share the postgres connection code.

[@GokceDB]

I'll have to look into it.

[@simranverma7480]

@@GokceDB yes please

[@simranverma7480]

can you please help

[@GokceDB]

What's the question?

[@simranverma7480]

@@GokceDB I have got a task in which I have to use rds proxy instead of aws lambda..Now all the database which is there in lambda is written, it has to be connected to rds proxy how to do please help.

[@GokceDB]

@@simranverma7480 see if this helps: kzbin.info/www/bejne/nYPZimSqadinq9E

[@randomperson90962]

stop jumping on your chair...