Prisma-client-js: Investigate Amazon RDS Proxy

Created on 4 May 2020 · 11Comments · Source: prisma/prisma-client-js

RDS Proxy, which is in preview now has Postgres support https://aws.amazon.com/about-aws/whats-new/2020/04/amazon-rds-proxy-with-postgresql-compatibility-preview/

We should investigate if Prisma Client works with RDS Proxy.

kindiscussion tectypescript

Source

timsuchanek

👍2

Most helpful comment

We tested this from AWS Lambda and Prisma Client 2.2.2 and it works.
We will as a further task run our full test suite against it to make sure all edge cases are covered.

timsuchanek on 21 Jul 2020

🎉2 ❤1

All 11 comments

I'm able to run prisma with RDS proxy.

Caveats:

Migrations don't work
Also: This might be out of scope, but running a lot of queries causes this error:

PrismaClientUnknownRequestError:
Invalid `prisma.product.findMany()` invocation in
/home/ubuntu/blitz-perftest/.blitz/caches/dev/.next/server/static/development/pages/api/test.js:131:79

Error in connector: Error creating a database connection.

For context, I'm running Prisma through a blitz.js app on EC2 in the same VPC as the RDS Proxy, with 100% of the 80 something max connections given to the proxy. I'm using this repo https://github.com/dajinchu/blitz-perftest/ I'm using artillery to send 20 req/s for 10 seconds. Using regular RDS w/o proxy at the same load does not cause this error.

dajinchu on 13 May 2020

RDS proxy is fine, I just finished automated migrations on deploy on Cloud Build for a client.

Sytten on 13 May 2020

@Sytten Would you mind elaborating on your setup? I'm not sure why mine isn't working. How are you accessing RDS Proxy from Cloud Build? I thought RDS Proxy only worked within the same VPC.

dajinchu on 14 May 2020

You need a public IP to make it work because cloud build is not in the same vpc. This was fine with my client since the firewall denies all external connections except those from the proxy.

Sytten on 14 May 2020

@Sytten Hi, sorry I'm still struggling with this. Do you mean the RDS Proxy has a public IP or Cloud Build has a public IP? Thanks.

dajinchu on 21 May 2020

Your Cloud SQL instance needs a public IP.

Sytten on 21 May 2020

Ah ok, I think I may be thinking about AWS RDS and you are referring to GCP Cloud SQL?

dajinchu on 21 May 2020

My bad, I probably misread the first time and thought about GCP since thats what I am currently working with.

Sytten on 21 May 2020

We tested this from AWS Lambda and Prisma Client 2.2.2 and it works.
We will as a further task run our full test suite against it to make sure all edge cases are covered.

timsuchanek on 21 Jul 2020

🎉2 ❤1

Awesome!