so…. Aurora Serverless v2 is kind of a disappointm...
# randoms
Sam Hulick
05/10/2022, 11:01 PMso…. 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. 🤔
Sam Hulick
05/10/2022, 11:02 PMbecause, 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 PMyep we're keeping sst.RDS at v1
s
Sam Hulick
05/10/2022, 11:03 PMour 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
Sam Hulick
05/10/2022, 11:04 PMtoo 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
Sam Hulick
05/10/2022, 11:04 PMI’d use regular Postgres RDS, but I need the Data API which is Aurora only, so… 🤷♂️
t
thdxr
05/10/2022, 11:05 PMhow come data api is a requirement?
s
Sam Hulick
05/10/2022, 11:05 PMLambda + 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 PMyeah it is more ideal but fwiw I used a normal socket with planetscale and it was fine
thdxr
05/10/2022, 11:06 PMwhich would be a similiar setup to rds proxy
s
Seth Geoghegan
05/10/2022, 11:07 PMI was surprised to discover that RDS Proxy doesn't support the latest version of Postgres
a
Adam Fanello
05/10/2022, 11:40 PMFYI: 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 PMNot a fan of MySQL. 🙂
a
Adam Fanello
05/11/2022, 12:14 AMIt isn't that complex. You could probably port the approach to Postgress.
s
Sam Hulick
05/11/2022, 12:25 AMNo, I mean I think MySQL is obsolete 😆
t
thdxr
05/11/2022, 12:25 AMI think he meant you can port serverless-mysql to postgres
s
Sam Hulick
05/11/2022, 12:26 AMOh gotcha
f
François Farge
05/11/2022, 9:48 AMHello ! I think this port already exists in https://github.com/MatteoGioioso/serverless-pg
François Farge
05/11/2022, 9:48 AMI haven't used it though, so I cannot evaluate it
k
kritstabs
05/11/2022, 12:05 PMIf 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