Introduction to RDS Proxy

RDS Proxy is a fully managed database proxy for Amazon Relational Database Service (RDS) that makes applications more scalable, more resilient to database failures, and more secure. This video provides an overview of RDS Proxy and demos setting up the proxy and using it from a Lambda function using a sample Serverless application architecture.

Subscribe:

#AWS #AWSDemo

[robroos]

Very very good video. This should be an example for other tutorials. It combines a introduction with a demo and with performance analytics, in just 12 minutes. And everything is very clear. Thank you !

[niranjang]

Best Intro Video Ever Made By AWS....Period.... 👍🙏

[saikumarnandam]

Best demo video from amazon 😍👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻

[rolandglee]

An alternative "AWS approved" proxy, is the Heimdall Proxy. It includes features as query caching, read/write split, and connection pooling. Heimdall supports all database types in RDS.

[easyappscompany]

Best Regards From Mexico City. Manuel Silva

[ashutosh_tripathi]

Can we have java example for connection to RDS proxy ?

[BobD]

This was very helpful, but I'm struggling to find a way to do the part from 9 minutes in C#. Please can someone point me in the right direction?

[FaithfulAnere]

Is RDS proxy out of preview? as the document says its currently in preview

[marcinrabenda]

Are you planning to release Proxy only for Read instances (autoscale cluster)?

[samiyakhan]

How to connect when IAM Authentication is disabled, is there any tutorial or documentation for that.Please help

[ionscorobogaci]

would believe you if you would at least create the database connection outside of handler function ))) when using lambdas is always good thing to establish connection outside of handler function. Did not get what problem the RDS Proxy is solving, especially the token used and so on. In traditional way of establishing connections we anyway used to store the credentials in secret manager and even rotate those, nothing changed (it seems in this video). Having additional role added to the lambda just to communicate with RDS proxy, can you elaborate on latency ? What is the latency ? Why in each lambda you need to pass the token?

In short, does this RDS proxy solves the problem of many connections established from lambdas ? Or a simple use and correct approach which you did not respect in this video, which is creating connections outside of handler function solves the problem ?

[yesiamnotviral]

Is this proxy endpoint we can also use to connect to my DB from PgAdmin client ?

[kritikamishra]

Is proxy is specific to user like dbuser here? If we create another user we cannot use proxy?

[marcosmussio]

Awesome presentation! BTW, I can see you are not closing the connection, is that ok? are you waiting for RDS proxy to do that for you? thx

[toddfisher]

So is this just aws hosted version of proxysql?

[Toramt]

As of today the docs say "Amazon RDS Proxy is available in preview for Aurora MySQL, RDS MySQL, Aurora PostgreSQL, and RDS PostgreSQL."

[OBGynKenobi]

This is good, but how would this work, if say, your RDS db needs to connect o Redshift? More specifically, an RDS postgres db connects to redshift though Foreign Servers, how does proxy handle the credentials to connect to redshift of the redshift credentials are rotated?

[DavidLopez-jbtz]

my application uploads a file to s3, this triggers a lambda function that transforms the file and uploads it as a record to an RDS Database. With this approach I'm exausthing my database allowed concurrent connections. Using an RDS proxy endpoint instead of a direct database connection will help me with that?

[cheftimbob]

Has anyone been able to get this working with Aurora Postgres? I've followed the exact same pattern using pg and keep getting MD5 errors. Connection succeeds when using the cluster host value but not the proxy endpoint. Spent half the day on with AWS tech support and they can't figure it out. This was a great video btw. Unfortunate that AWS tech support is so lacking though.

[BR-lxpy]

Is failover really 25 seconds with RDS proxy and 40 seconds without? That's really long.