3 ms·
> What's the point of Aurora? Aurora does have a couple of positives. You can create additional read replicas virtually instantly, since they're just pointed a
by koolba 9y ago
> What's the point of Aurora? Aurora does have a couple of positives. You can create additional read replicas virtually instantly, since they're just pointed at the same shared block storage.
If I understand this correctly, they're using the same block store backing the primary database for the replicas. If that's the case, then wouldn't an issue with the blocking store hose both simultaneously? Or are they just jump starting the replicas copy of the data from the primary's block store until it's fully replicated?
> And from a management point of view, Aurora makes the database administrator's job far simpler since you no longer have to closely monitor your tablespaces and expand your block storage as needed (and reallocate tables and indexes across multiple tablespaces using pg_repack) in order to handle growing your dataset.
This is indeed very cool. Scaling from 1 MB, to 1 GB, to 1 TB, and beyond with no manual interaction is truly amazing. The storage pricing is a net win for Aurora as you only pay for what you use at the same price as gp2 EBS volumes ($.10/GB/month) whereas the latter has to be preallocated.
- ryanworl 9y agoEvery 10GB chunk of the database is on six different disks in 3 AZs.
- lozenge 9y agoThe block store is related to EBS, which is what AWS's other postgres option, RDS, also uses. An EBS system failure is rare and could potentially take down both services, and EC2 as well.
- _msw_ 9y agohttps://media.amazonwebservices.com/blog/2017/aurora-design-considerations-paper.pdf https://media.amazonwebservices.com/blog/2017/aurora-design-... """ These are each replicated 6 ways into Protection Groups (PGs) so that each PG consists of six 10 GB segments, organized across three AZs, with two segments in each AZ. A storage volume is a concatenated set of PGs, physically implemented using a large fleet of storage nodes that are provisioned as virtual hosts with attached SSDs using Amazon Elastic Compute Cloud (EC2). """ The storage nodes are using local SSD instance storage, not EBS.