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 <a href="https://coderecipe.ai/architectures/77374273" rel="nofollow">https://coderecipe.ai/architectures/77374273</a> hopefully this help others to easily onboard to this new API.
I told my AWS account manager today that this is what I wanted to see on Aurora Serverless:<p>- mysql 5.7 compatibility<p>- acting as replication master or slave<p>- faster upscaling, more likes 5s instead of 30s<p>- publicly accessible over internet (the rest of RDS has this)<p>- aurora parallel query built in<p>- aurora multi master built in<p>Basically, I asked for one product to merge all their interesting features. That sounds nice and like a one-size-fits all database. I would very much like to use it in production. It would require very little maintenance.
I wonder what effect this may have for AWS Lambdas connecting to a DB for synchronous calls (e.g. through API gateway). The biggest issue with Lambdas IMO is the cold start time. If your Lambda is in a VPC the cold start time is around 8-10 <i>seconds</i>, and if you have decent security practices your database will be in a VPC. I know AWS said they would be working on improving Lambda VPC cold start times, but would like to know if using Aurora Serverless with these kind of "connectionless connections" would also get rid of the need to be in a VPC. I've used Aurora (and really, really liked it) but I haven't used Aurora Serverless.
Another cool thing about this is it avoids the connection pool issue with Lambda (where concurrent requests cant reuse connections).<p>Aurora is already pretty good at handling a lot of connections but this is even better.
The beta version seemed like it had pretty poor performance: <a href="https://www.jeremydaly.com/aurora-serverless-data-api-a-first-look/" rel="nofollow">https://www.jeremydaly.com/aurora-serverless-data-api-a-firs...</a><p>Does anyone have performance feedback now that it is no longer beta?
... Don't you have to establish an HTTPS connection to use this API? Is that really easier than using the existing MySQL protocol? Or is it really so horrible that HTTPS is faster?<p>Things establishing new connections will never be as fast as things reusing existing connections. It seems wasteful to ignore this.