3 ms·
I wonder how this compares to Aurora Serverless Data API. This is an HTTP API that you POST a query to and get results data back. The result format is a bit cl
by nzoschke 7y ago
I wonder how this compares to Aurora Serverless Data API. This is an HTTP API that you POST a query to and get results data back.
The result format is a bit clunky but there's all the column information you'd expect.
I found this golang database interface which ended up dropping in as expected with a few tweaks.
https://github.com/Clever/rds/tree/birthday https://github.com/Clever/rds/tree/birthday
My bill for Aurora Serverless Postgres last month was less than a dollar.
- PetahNZ 7y agoWe use Aurora Serverless and this is a sorely needed feature for us. We get large spikes of traffic that also cause large increases in connections to our DB, but Aurora Serverless cannot scale fast enough to cater for this. Unfortunately it doesn't seem we can enable this proxy for serverless clusters.
- sudhirj 7y agoAurora serverless already has a proxy by default - if it can’t scale fast enough it’s likely because your queries are too long and interleaved to find a logical switchover point. This proxy is probably an offshoot of the serverless proxy.
- PetahNZ 7y agoIt has a hard limit on max_connections based on the "Aurora Capacity Unit", e.g. for 16 ACU's max_connections it is 2,000. We see spikes of 10x to 100x concurrent users in a matter of minutes (think hug of death style). And although our queries run fast and we see limited increase of CPU on the cluster we almost instantly hit the connection limit. https://www.jeremydaly.com/aurora-serverless-the-good-the-bad-and-the-scalable/ https://www.jeremydaly.com/aurora-serverless-the-good-the-ba...