AWS Aurora - AWS RDS'ten Biraz Daha Gelişmiştir

Giriş

Açıklaması şöyle. AWS RDS'ten Biraz Daha Gelişmiştir. Hem MySQL hem de PostgreSQL olarak kullanılabilir.

- MySQL & PostgresSQL compatible relational database.

- Provides 5x better performance than MySQL

- Provides 3x better performance than Postgres SQL

- Distributed, fault-tolerant, self-healing storage system

- 2 copies of your data is contained in each Availability Zone (AZ) — minimum of 3 AZ’s and 6 copies.

- Can handle the loss of up to 2 copies without affecting write ability.

- Can handle lose of up to 3 copies of data without affecting read ability.

- Automated backups always enabled — doesn’t impact performance.

Açıklaması şöyle

Amazon Aurora is an elevated version of Amazon RDS. Large enterprises use this since their data volume and complexity of operations are much higher. It doesn't support all the same database engines as Amazon RDS, and instead only supports MySQL and PostgreSQL. Aurora scales up and down as the load on your database increases and decreases. Newer providers like PlanetScale also offer this capability with additional schema migration features and lower costs.

Amazon Aurora, like RDS, can perform replication. It actually offers about 15 different types of replications, and one replication can be done within milliseconds. On the other hand, RDS can perform only five types of replications, taking more time.

Some of the use cases that can depict the strength of Amazon Aurora are enterprise applications, SaaS applications, and web/mobile gaming.
Benefits

1. Auto-scaling allows scaling operations to be carried out automatically without affecting the DB performance. It allows up to 128 TB per database instance.
2. Aurora backup operations are automatic, continuous, incremental, and have about 99.99999999% durability.
3. Aurora can detect database failure and recover in less than a minute. Furthermore, in case of a permanent failure, it can automatically move to a replica without data loss.

Replication

Açıklaması şöyle

- It expands the Multi-AZ replicas from 2 to up to 15.

- It automatically copies data across six storage nodes in different AZs of the same region, even if you do not have any read replica.

Having more replicas gives you increased read capacity but also more options when promoting a read replica to become a new primary. The lag between the primary and the replica is usually less than 100 ms, which means there is still a chance of an outdated read after a write.

Even if you decide not to have a replica, the fact that you have copies of data stored automatically in different AZs helps to prevent data loss, albeit at the expense of a longer recovery time, as a new primary will be recreated in the event of failure with the existing one.

Capacity Type Settings in Amazon Aurora

Şu seçenekler mevcut

- Provisioned Capacity

- Serverless Capacity

Upgrade

Burada bir yazı var. Seçenekler şöyle

1. In-place upgrade

2. AWS Database Migration Service

3. Manual migration with PostgreSQL tools