Hacker News Reader

Comment by 2-m3m3n70 | Hacker News Reader

What's the advantage to using this over RDS?

(From AWS Aurora's website)

We’re now previewing the addition of PostgreSQL compatibility to Amazon Aurora. This edition has the benefits customers have come to expect from Aurora, including high durability, high availability, and the ability to quickly deploy low latency read replicas while supporting the full SQL dialect and functionality of PostgreSQL 9.6.

Storage cost, performance and auto-scaling are also big advantages.

Auto scaling in RDS? That'd require a multi-master cluster. As far as I know, that's impossible on RDS, Aurora or not.

Autoscaling of storage at least (up to 64 TB).

I should have been more clear. I was referring to storage auto-scaling. Aurora gives you access to up to 64TB of disk billed in 10GB increments. You don't need to preallocate and manage the scaling of your disk as you do with RDS.

nitpick: Aurora is RDS (an available engine alongside standard MySQL/Postgres/etc)

I'm also interested in whether this ends up being competitive with AWS Redshift for large-scale data warehousing.

It could be a very performant transparent caching layer when combined with the fdw extension[1]. You can push down the true analytics queries down to Redshift, but cache the resultsets, rollups, facts tables, etc, in materialized views. Then have the full power of modern Postgres available for exposing your data warehouse. The more predictable performance and auto-scaling storage makes it much better than the standard RDS for that setup.

https://aws.amazon.com/blogs/big-data/join-amazon-redshift-a...

Better performance, lower jitter, easy scalability. There's really no reason to not use Aurora.

Aurora is more expensive, more so on the high-end, so it's not entirely clear that it is the best choice for all applications:

db.r3.8xlarge: RDS Aurora $4.640/h, RDS MySQL $3.780/h, RDS PostgreSQL $3.980/h

For many installations, an Aurora read replica can eliminate the need for a multi-AZ master instance which cuts the cost of your master instance in half.

> Aurora is more expensive, more so on the high-end, so it's not entirely clear that it is the best choice for all applications:

> db.r3.8xlarge: RDS Aurora $4.640/h, RDS MySQL $3.780/h, RDS PostgreSQL $3.980/h

Based on your numbers the difference in pricing between Aurora and Postgres ($4.64 - $3.98) x 24 * 30 = $475/mo. To the company using a db.r3.8xlarge, which has 32-cores and 244 GB of RAM, that's not even a rounding error.

The failover guarantees with RDS Aurora are substantially better as long as you have 1+ read replicas.

That alone is worth the difference imo.

Reply on news.ycombinator.com