RDS Proxy with Prisma
Hey team, I have a question about using RDS proxy with Prisma. This prisma doc https://www.prisma.io/docs/orm/prisma-client/deployment/caveats-when-deploying-to-aws-platforms says that there is no benefit of using RDS proxy with Prisma because of pinning issue, but this AWS post https://aws.amazon.com/blogs/database/amazon-rds-proxy-multiplexing-support-for-postgresql-extended-query-protocol/ says that connection pinning is not an issue anymore because of "PostgreSQL Extended Query Protocol". Can somone plz suggest if connection pinning is not an issue with Prisma+RDS Proxy ? Or what kind of protocol does Prisma use to connect to RDS? If its using "PostgreSQL Extended Query Protocol" then that means pinning is not a problem. Any help??
Caveats when deploying to AWS platforms | Prisma Documentation
Known caveats when deploying to an AWS platform
Amazon Web Services
Amazon RDS Proxy multiplexing support for PostgreSQL Extended Query...
Today, we are announcing Amazon RDS Proxy multiplexing support for PostgreSQL Extended Query Protocol. In this post, you learn about PostgreSQL’s Extended Query Protocol for communication between client and server, its benefits, and how multiplexing support for Extended Query Protocol can improve the connection pooling capability of RDS Proxy, w...
Solution:Jump to solution
GitHub
Better support for AWS RDS Proxy (avoid Connection Pinning) · Issue...
I am using AWS RDS Proxy with Postgres. While investigating the logs for the proxy I saw many warnings with the same message: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/rds-proxy....
3 Replies
Hey @Therealzinx
Thanks for pointing this out. I wasn't aware about this RDS Proxy release. I am checking this with our ORM team. Let me get back to you.
Solution
Here is the latest status:
https://github.com/prisma/prisma/issues/5866#issuecomment-1887963763
GitHub
Better support for AWS RDS Proxy (avoid Connection Pinning) · Issue...
I am using AWS RDS Proxy with Postgres. While investigating the logs for the proxy I saw many warnings with the same message: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/rds-proxy....
Thanks for tghe update @Nurul (Prisma) 🙂 really appreciate it.