AWS Aurora Serverless V2 • Hacker News Board

Re: AWS Aurora Serverless V2

#11

Post by eigilsagafos » Thu, Apr 21, 2022, 9:13 PM UTC

thorum wrote: post #7

Does anyone know if Aurora PostgreSQL is a full drop-in replacement for Postgres, or is it "Postgres compatible" but missing some features (like CockroachDB, for example)? I am very interested in this service but some of my projects depend on Postgres-specific features.

Fully Postgres compatible in my experience. As long as you don’t require extensions that AWS doesn’t support. But I believe AWS has the widest array of extensions for Postgres of any cloud provider.

Re: AWS Aurora Serverless V2

#12

Post by al2o3cr » Thu, Apr 21, 2022, 9:24 PM UTC

tommek4077 wrote: post #4

I write my stuff to /dev/null the databaseless database. Lightning fast, more space than S3.

Does /dev/null support sharding? :P https://www.youtube.com/watch?v=HdnDXsqiPYo#t=2m13s

Re: AWS Aurora Serverless V2

#13

Post by karmakaze » Fri, Apr 22, 2022, 12:26 AM UTC

al2o3cr wrote: post #12

tommek4077 wrote: post #4

I write my stuff to /dev/null the databaseless database. Lightning fast, more space than S3.

Does /dev/null support sharding? :P https://www.youtube.com/watch?v=HdnDXsqiPYo#t=2m13s

You may be looking for http://webscalesql.org/

Re: AWS Aurora Serverless V2

#14

Post by jfbaro » Fri, Apr 22, 2022, 7:52 AM UTC

Great work Amazon Web Services (AWS)! I am already waiting for V3.... Wish list:

- Pay per transaction (Reads, Writes) + Storage, instead of per resource allocation (some competitors are offering this already).

- No need for VPC, just like DynamoDB does today.

- Multi-region sync replication (no data loss in case a region goes down), but on a per-table base.

- Self-tuning capabilities, like ottertune and postgres.ai

- Unlimited Fast Database Cloning copies for non-production environments (COW)

- Transparent connection pooler (useful when using Lambda)

Re: AWS Aurora Serverless V2

#15

Post by lysecret » Thu, May 05, 2022, 1:34 PM UTC

So, I moved one of our Postgres DBs to Aurora Serverless V2 (for testing). First the process is super ridiculous. Anyways I am quite disappointed. One of the main reasons was their "scaling to 0" for some DBs we get close to none and then really spiky traffic. But they removed that! So, that leaves you with .5 ACUs running no matter what. But that is not great! Its 0.07 per hour, a t3.micro is 0.02 an hour. I was looking for a DB that could scale to 0 cost and then ramp up to handle > 10k requests per seconds.