https://serverless-stack.com/ logo
#random
Title
# random
s

Sam Hulick

05/10/2022, 11:01 PM
so…. Aurora Serverless v2 is kind of a disappointment, isn’t it? it’s expensive.. to be exact, our DB bill would be doubling if we switched. 🤔
because, nobody wants to scale down to 0.5 ACU. that results in a highly underpowered instance, resulting in sluggish response times for your users
t

thdxr

05/10/2022, 11:02 PM
yep we're keeping sst.RDS at v1
s

Sam Hulick

05/10/2022, 11:03 PM
our minimum ACU is 4 (about $175/mo) which I’m comfortable with. we were at 2 ACU minimum before, and it was not as responsive. now it’s blazing fast
too bad Aurora v1 sucks at switching up/down. it’s SO slow. if you’ve got a sudden flood of activity that maxes out your connections, your app is throttled for several minutes while it scales up
I’d use regular Postgres RDS, but I need the Data API which is Aurora only, so… 🤷‍♂️
t

thdxr

05/10/2022, 11:05 PM
how come data api is a requirement?
s

Sam Hulick

05/10/2022, 11:05 PM
Lambda + socket-based Db connections feels weird. I don’t want to have to manage that mess. Data API is much cleaner
t

thdxr

05/10/2022, 11:06 PM
yeah it is more ideal but fwiw I used a normal socket with planetscale and it was fine
which would be a similiar setup to rds proxy
s

Seth Geoghegan

05/10/2022, 11:07 PM
I was surprised to discover that RDS Proxy doesn't support the latest version of Postgres
a

Adam Fanello

05/10/2022, 11:40 PM
FYI: If you're willing to go MySQL and use Node.js Lambda runtime, the serverless-mysql does a wonderful job of managing connections. (Maybe someone has copied the approach for other databases and languages; I haven't looked.)
s

Sam Hulick

05/10/2022, 11:46 PM
Not a fan of MySQL. 🙂
a

Adam Fanello

05/11/2022, 12:14 AM
It isn't that complex. You could probably port the approach to Postgress.
s

Sam Hulick

05/11/2022, 12:25 AM
No, I mean I think MySQL is obsolete 😆
t

thdxr

05/11/2022, 12:25 AM
I think he meant you can port serverless-mysql to postgres
s

Sam Hulick

05/11/2022, 12:26 AM
Oh gotcha
f

François Farge

05/11/2022, 9:48 AM
Hello ! I think this port already exists in https://github.com/MatteoGioioso/serverless-pg
I haven't used it though, so I cannot evaluate it
k

kritstabs

05/11/2022, 12:05 PM
If V2 scales instantly couldn’t it be used with lambdas without proxy? And V1 data API is slow and that makes running simple queries in lambda much more expensive. Also, I found that not many libraries support data API. Proxy expenses + slower lambda expenses may cover V2 0.5 ACU and you get instant scaling and faster response times. Am I wrong?
4 Views