Stack Overflow
Stack Overflow

Questions tagged [amazon-rds-proxy]

89 questions
12
votes
1 answer

Connect to Amazon RDS PostgresQL Proxy with IAM Credentials using TypeORM

I'm trying to figure out how to connect to a RDS PG Proxy within a lambda function using TypeORM (so there's no issues establishing connections). I'm able to connect to the RDS instance with the Lambda function successfully - however, when I point…
jengel
  • 323
  • 4
  • 10
10
votes
4 answers

What is the purpose of database proxy in AWS Lambda?

I'm working on AWS Lambda and I have integrated the SQL server using node.js. Here is its example. Now, my question is, what is the database proxy in AWS lambda and how I can get benefit from this? Thanks
Rafaqat Ali
  • 676
  • 7
  • 26
9
votes
1 answer

Should I close an RDS Proxy connection inside an AWS Lambda function?

I'm using Lambda with RDS Proxy to be able to reuse DB connections to a MySQL database. Should I close the connection after executing my queries or leave it open for the RDS Proxy to handle? And if I should close the connection, then what's the…
Ahmad Nabil
  • 305
  • 2
  • 12
9
votes
1 answer

Does RDS proxy affects current application side pooling?

I have a Saas application on AWS ECS and databases on AWS RDS. We are planning to implement AWS RDS Proxy for pooling implementation. From the RDS proxy documentation, I saw that we don't need to make any changes to the application code. Currently,…
Neron Joseph
  • 1,675
  • 22
  • 39
9
votes
1 answer

Can't connect to RDS PostgreSQL DB instance through an RDS proxy

I'm trying to put use an RDS proxy to pool and share connections established with an RDS database with a PostgreSQL engine. The problem is I'm able to open a connection to the DB, both through an ECS instance or in PgAdmin, however, I'm not able to…
Strokes
  • 157
  • 7
  • 23
8
votes
2 answers

AWS Lambda Function Timeout on Connecting To RDS Database through RDS Proxy

I'm trying to test AWS RDS proxy so I created a lambda function and done all steps that are present in this official link https://aws.amazon.com/blogs/compute/using-amazon-rds-proxy-with-aws-lambda store RDS credentials in Secret Manager create new…
danish
  • 125
  • 1
  • 14
6
votes
4 answers

How can I add database proxy in lambda via cloudformation?

I am using cloudformation to provision lambda and RDS on AWS. But I don't know how to add database proxy on lambda. Below screenshot is from lambda console: Does cloudformation support adding this? I can't see it in lambda and db proxy template.
Joey Yi Zhao
  • 37,514
  • 71
  • 268
  • 523
6
votes
3 answers

Can AWS RDS Proxy be paired with read replication instance directly?

I created an RDS Proxy with existing Aurora PostgreSQL cluster. But I want to pair the proxy with specific read replica instance of the cluster. Is that possible?
Kim-Jimin
  • 674
  • 2
  • 9
  • 19
6
votes
3 answers

Which RDS DB instances are supported for DB Proxy?

I'm trying to create a RDS DB Proxy for a Postgres 12.3 RDS instance (not Aurora) via CloudFormation. Stack creation fails with the following message: Database engine POSTGRES 12.3 for DB Instance db-name is not supported. Register the DB cluster…
tomfumb
  • 3,669
  • 3
  • 34
  • 50
6
votes
2 answers

Alternative to prepared statement when using AWS RDS proxy

It says in the documentation of RDS proxy that the connection is automaticaly pinned when the application uses a prepared statement: Prepared statements cause the proxy to pin the session. This rule applies whether the prepared statement uses SQL…
Clément Bisaillon
  • 5,037
  • 8
  • 32
  • 53
5
votes
2 answers

Handling AWS RDS Connection Pooling (with POSTGRES 13) and Node Lambdas

We are using an RDS instance in AWS, it is POSTGRES 13. We have Node-based Lambdas that return and post data to the database. Currently they are opening and closing a single connection per transaction and we want to optimise this by implementing…
SamBrick
  • 681
  • 1
  • 8
  • 33
5
votes
0 answers

Why does RDS proxy make performance worse?

I deployed a RDS Aurora cluster for postgresql 11 in AWS. My lambda is talking to this cluster via IAM authentication. Since lambda is serverless, I have to create a connection to database every time my lambda is triggered and close the connection…
Joey Yi Zhao
  • 37,514
  • 71
  • 268
  • 523
5
votes
1 answer

Do you still need an AWS RDS proxy when you already have an application side pooling in place?

As a follow-through on this question Do you still need an AWS RDS proxy when you already have an application side pooling in place? I have a Springboot application which uses the default HikariDataSource to manage the db connection pool. For the…
dionned
  • 85
  • 5
5
votes
2 answers

RDS Proxy: Database menu is empty, can't create proxy

I need my lambda to connect to an Aurora Serverless cluster, through an RDS Proxy. But I can't create the proxy because the Database dropdown menu - in the section under Target group configuration - is empty. I have several databases. I have access…
tvanc
  • 3,807
  • 3
  • 25
  • 40
5
votes
3 answers

Connection error when using AWS RDS proxy

I had setup RDS proxy for an Aurora DB cluster and I am getting the following error while connecting. Note that I am able to connect to the original DB cluster without any issue. I checked the security groups, they look fine (Both proxy and DB are…
ajith633
  • 161
  • 1
  • 4
1
2 3 4 5 6