Live data from Hacker News

Data API for Amazon Aurora Serverless

aws.amazon.com

21–23 of 23 posts

Re: Data API for Amazon Aurora Serverless

#21

With this, VPC is no longer needed from lambda call to RDS, and this means that cold start time will be lowered from seconds to milliseconds. I made a ready to use recipe (source code+deployment script+demo included) here https://coderecipe.ai/architectures/77374273 hopefully this help others to easily onboard to this new API.

This only works for Aurora Serverless, not regular Aurora or any other managed databases.

Re: Data API for Amazon Aurora Serverless

#22

The beta version seemed like it had pretty poor performance: https://www.jeremydaly.com/aurora-serverless-data-api-a-firs... Does anyone have performance feedback now that it is no longer beta?

Jeremy has updated the post in response to the announcement.

- Lots of improvements & better documentation

- Smaller response size, but can be cut down a lot more

- Sub 100ms query performance

> I’m really impressed by the updates that have been made. I do want to reiterate that this isn’t an easy problem to solve, so I think the strides they’ve made are quite good. I’m not sure how connection management works under the hood, so I’ll likely need to experiment with that a bit to measure concurrent connection performance.

edit: formatting

Re: Data API for Amazon Aurora Serverless

#23
post #5

Another cool thing about this is it avoids the connection pool issue with Lambda (where concurrent requests cant reuse connections). Aurora is already pretty good at handling a lot of connections but this is even better.

You can create a connection pool in a static context that lives throughout the lifetime of the JVM. Although admittedly if Lambda scales to multiple JVMs as request rate increases, you'll have multiple pools. Or if your request rate is low you'll not get much benefit

Lambda containers serve 1 request at a time, so the number of JVM's tends to scale out a lot quicker than you would expect. This is more of a broader problem with Java on lambda, as the classic Java way of creating a bunch of singletons on startup and accessing them from multiple threads doesn't work, you just get a really slow cold start time and some near empty connection pools.
Post reply on HN