Questions tagged [amazon-rds-proxy]

89 questions
1
vote
1 answer

RDS Proxy vs Application Side Proxy (eg. C3P0)

Let's say I want to use RDS Proxy for my Spring Boot application running in EC2/ECS/EKS, I have everything working as expected using standard JDBC connection configuration. Do I still need to configure application side connection pooling using…
1
vote
1 answer

Connect to AWS RDS Proxy from Java

In an EC2 instance, I have succeed connecting to "AWS MySQL RDS" from Java, since the typical jdbc technique has been used for that purpose. However, I cannot be able to use the Preview of "Mysql RDS Proxy" from my java code, because no…
Goose
  • 351
  • 4
  • 15
0
votes
0 answers

RDS Proxy giving error after few minutes of successful connection

I have created AWS RDS proxy for python project. The RDS has been built on Postgres database. After successful connection and working, our python project gives error mentioned below. sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) SSL…
Roman
  • 2,464
  • 2
  • 17
  • 21
0
votes
1 answer

Lambda Database Connections - Best Practices

I've been looking over Lambdas for this new code base I'm working in. We're currently connecting directly to our RDS Aurora instances in our Lambdas, and I was looking into the best practices and started noticing areas that I think could be…
kenshin9
  • 2,215
  • 4
  • 23
  • 38
0
votes
0 answers

Database testing tool for AWS RDS proxy

I'm trying to use some automated database testing tool to run tests against RDS proxy, which is connected to an RDS database. I wonder if there is automated database testing tool that would be suitable for running tests against RDS proxy. Thank you…
0
votes
0 answers

Locally test and modify a Lambda function that needs to access a RDS database through a RDS Proxy using IAM

So here is the current architecture: I have a RDS Instance (my-db) that is not publicly accessible and that is in a private subnet of my VPC I have set up a RDS Proxy (my-proxy) that is in the same VPC as the RDS instance and only accepts…
0
votes
0 answers

What does this ActiveRecord error: "Cannot expire connection, it is not currently leased." mean?

Stack: ActiveRecord / Rails 7 Sidekiq Enterprise makara Amazon RDS Proxy to manage connection pooling for a Rails application. Occasionally, we get the following error…
0
votes
0 answers

Worpress throwing connection pinning warning while using AWS RDS proxy

We have recently deployed horizontally scaled wordpress instances on AWS EC2. Currently we have just 1 MySQL instance. To handle surge of connections we introduced RDS Proxy. While this has been largely successful, users are intermittently seeing…
raj
  • 471
  • 1
  • 5
  • 12
0
votes
0 answers

AWS CreateDBProxy is not supported

I tried to create RDS Proxy for Aurora Cluster in the AWS Console and got the next Error: We're sorry, your request to create DB proxy credible-dev has failed. CreateDBProxy is not supported. In the Chrome Developer tools I can see the following…
WWTLF
  • 440
  • 1
  • 5
  • 13
0
votes
1 answer

RDS proxy error : ERROR 2026 (HY000): TLS/SSL error: unable to get local issuer certificate

I have RDS proxy setup with ssl required. I am trying to connnect to RDS proxy with mysql client like mysql -h host -u user -p"password" --ssl_ca=global-bundle.pem I am getting below error, ERROR 2026 (HY000): TLS/SSL error: unable to get local…
0
votes
0 answers

SQLAlchemy and RDS Proxy & Lambda randomly cannot establish a connection

I'm using SQLAlchemy inside a Lambda with RDS Proxy (PostgreSQL). This configuration works, but when I'm invoking about 100 lambdas at the same time some lambdas receive a timeout (3 seconds) even when I'm increasing the timeout for 30 seconds I…
T.sagiv
  • 325
  • 2
  • 9
0
votes
2 answers

RDS Proxy IAM Authentication from Python Lambda

I am trying to connect to an RDS Proxy with IAM authentication and getting invalid credentials error. Error: Proxy authentication with IAM authentication failed for user "lambda_user" with TLS on. Reason: Invalid credentials. If you provide an IAM…
0
votes
0 answers

Engine not supported for RDS proxy - Postgresql

I have a cloudformation stack where i have deployed an RDS serverless v2 cluster and i am trying to connect an RDS proxy to it. The engine is postgres and version is 14.4. When i deploy the proxy target group i get this error: "Unsupported Database…
0
votes
1 answer

Connect to RDS Proxy from EC2 using IAM role

I want to create a passwordless setup for connecting to RDS proxy from EC2 (e.g. using an IAM role instead of db username & pwd credentials). E.g. code running on EC2 (e.g. php, or java etc..) wouldn't have to explicitly provide a db connection…
0
votes
0 answers

Spring Boot doesn't release DB connection

We user AWS RDS Proxy to connect postgres database from Spring Boot.I assume RDS proxy is configured with session pooling. As RDS proxy is alternative for pgBouncer Spring boot application doesn't worry about connection pool. So it uses…
Selvakumar Ponnusamy
  • 5,363
  • 7
  • 40
  • 78