Videos
amazon web services - AWS Aurora: upgrading to serverless v2 from v1 - Stack Overflow
Aurora Serverless V1 vs V2
Migration from Aurora Serverless v1 to v2: Key Questions and Clarifications
Issue in Performance between Aurora Serverles V1 and Serverless v2
Hi,
Which option is suggested for a new deployment in 2023. Use case is multi-tenant e-commerce SAAS (think shopify for specific industry).
We use AppSync and lambda resolvers to connect to Postgres:
-
Aurora Serverless V1 using Data API
-
Aurora provisioned, V2 serverless, and RDS Proxy. Lambdas get access to VPC and connect to database via RDS Proxy.
-
Aurora or RDS provisioned, RDS proxy for connection pooling
We’ve been developing with option 1 but seeing some latency on the frontend so considering option 2 which avoids connecting to database over https data API.
Frontend is a Remix app deployed using SST framework. Their remix construct is a lambda fronted by cloudfront. We deploy backend separately through CDK.
Maybe there is a better way to speed up? A page load goes through Remix cloudfront plus lambda, then AppSync, AppSync lambda resolver, database call via data API, then back to user.
Theoretically we could skip the AppSync and call the database directly from remix but we’re concerned with security since AppSync does auth checks.
Frontend and backend are in separate AWS accounts.
edited to add a 3rd option
Thoughts?
Thanks