AWS Announces Amazon Aurora Supports PostgreSQL 12 (opens in new tab)

(infoq.com)

51 pointsarthurz5y ago19 comments

19 comments

I'm just here to say that I took an exam for AWS Solutions Architect last week and I thought Aurora PostgreSQL was a made up service.

I feel like a fool.

iav5y ago

I’ve looked pretty hard at moving my fairly large Postgres RDS to Aurora and the pricing is just very scary. I have a single 100GB instance running on fairly minimal hardware and serving a Django site with 6k monthly visitors. My usage is pretty concentrated during 9-6pm EST as I mainly serve US law firms and investment funds. Any idea if that will end up costing me a fortune to go Aurora? I’m worried about all of those requests in a short amount of time leading to it spinning up a lot of instances.

reilly30005y ago

Aurora's autoscaler is fully in your control. Aurora Serverless is usage-based, but regular Aurora is just an AWS-optimized Postgres distro. You should not receive any surprise billing based on scaling, unless you specifically configure it to do so. Based on those usage patterns you explained you could do a scheduled scaling event that would scale up your Aurora cluster to have more capacity during business hours. If its a read-heavy workload then read replicas are a cheap and easy way to scale.

orf5y ago

‘AWS optimized Postgres distro’ is perhaps underselling it a bit, while being broadly correct. The magic is in the storage engine which powers instantaneous failover, point in time restores and the newly released ‘serverless 2’ product (which would be ideal for the parent has)

1 more reply

kyriakos5y ago

AWS is really expensive as you scale unfortunately.

philliphaydon5y ago

Not really. It very much depends.

x86_64Ubuntu5y ago

I don't think AWS RDS scales like that with "a lot of instances". The only time you would have so many instances is from how many read replicas you setup, and if you have a standby instance. RDS isn't like an EC2 ASG. I might be wrong though ='(

Source: An AWS Certs Scrub

feydaykyn5y ago

At your current scale, just adding a slave for redundancy and hot take over should be enough?

There's also the aurora serverless way which may be interesting since your workload is only a few hours a day. Scale up automatically during the peak and wind down the rest of the time.

pbalau5y ago

> Any idea if that will end up costing me a fortune to go Aurora?

Define a fortune.

chmod7755y ago

Considering you can run a site like his off of a $10 VPS with room to spare for x10 more users, any dollar beyond that better be worth it.

Sure, going to $50 won't matter to most wallets, but at around $100 you're just getting ripped off and someone is having a laugh at your expense.

So I'd put 'paying a fortune' at around $100/month for his case.

1 more reply

alphabettsy5y ago

What’s the reason for using Aurora?

chrishynes5y ago

Where's MySQL 8 for Aurora? :-/

j / k navigate · click thread line to collapse

19 comments

geoduck145y ago

I'm just here to say that I took an exam for AWS Solutions Architect last week and I thought Aurora PostgreSQL was a made up service.

I feel like a fool.

iav5y ago

reilly30005y ago

orf5y ago

1 more reply

kyriakos5y ago

AWS is really expensive as you scale unfortunately.

philliphaydon5y ago

Not really. It very much depends.

x86_64Ubuntu5y ago

Source: An AWS Certs Scrub

feydaykyn5y ago

At your current scale, just adding a slave for redundancy and hot take over should be enough?

There's also the aurora serverless way which may be interesting since your workload is only a few hours a day. Scale up automatically during the peak and wind down the rest of the time.

pbalau5y ago

> Any idea if that will end up costing me a fortune to go Aurora?

Define a fortune.

chmod7755y ago

Considering you can run a site like his off of a $10 VPS with room to spare for x10 more users, any dollar beyond that better be worth it.

Sure, going to $50 won't matter to most wallets, but at around $100 you're just getting ripped off and someone is having a laugh at your expense.

So I'd put 'paying a fortune' at around $100/month for his case.

1 more reply

alphabettsy5y ago

What’s the reason for using Aurora?

chrishynes5y ago

Where's MySQL 8 for Aurora? :-/

j / k navigate · click thread line to collapse