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.

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