No image

Overview of Amazon Aurora

Let's learn about Amazon Aurora

What is Amazon Aurora?

Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases.

Amazon Aurora features a distributed, fault-tolerant, self-healing storage system that auto-scales up to 64TB per database instance. It delivers high performance and availability with up to 15 low-latency read replicas, point-in-time recovery, continuous backup to Amazon S3, and replication across three Availability Zones (AZs).

Amazon Aurora is designed for the cloud. Amazon Aurora provides a very robust and highly available database engine by distributing data across multiple AZs. Many innovations in how and where data is stored have significantly improved read and write throughput over other relational database engines. The same is true of the speed at which database restore operations occur. Because Amazon Aurora is a managed service, AWS handles undifferentiated heavy lifting, such as backup, patch, and storage management.

Storage features of Amazon Aurora:

The biggest feature of the Aurora is storage. Aurora uses shared storage rather than single storage. The Amazon Aurora storage engine is a distributed SAN across multiple AWS availability zones in a Region. AZ is a logical data center consisting of a single or multiple physical data centers. Each AZ is completely isolated from other AZs except for low latency links that enable rapid communication with other AZs in that revolution. At the heart of Amazon Aurora, the distributed low-latency storage engine is configured across multiple AZs.

Amazon Aurora builds storage volumes in 10GB logical blocks called protection groups. The data in each protection group is replicated to six storage nodes. The storage nodes are then assigned to the 3 AZs in the Region where the Amazon Aurora cluster operates.

When you write data to Amazon Aurora, it is sent in parallel to the 6 storage nodes. These storage nodes are distributed across the 3 AZs to significantly improve durability and availability. Aurora looks for the nearest storage node to perform the reads. Each read request relates to a timestamp, or LSN. The storage nodes can perform reads if they catch up to LSN (i.e., if they receive all updates to that LSN).

With Amazon Aurora, data is continuously backed up to S3 in real time without impacting end-user performance. This eliminates the need for backup windows and automated backup scripts. You can also restore a user to any point in their custom backup retention period.

Advantages of the Amazon Aurora:

1) Automatic failover : Like RDS-MySQL, Aurora also has auto failover. Automatic failover is the process of automatically moving an application to a standby server during a failure or service event to preserve its uptime. If RDS-MySQL took 30 to 60 seconds, RDS-Aurora took approximately 30 seconds. Aurora says failure is possible within 15 minutes if there is no read replication.

2) short replication delay : Aurora is the way to use shared storage. As a result, there is no replication delay compared to MySQL, which replicates with existing binlogs.

3) Cache Warm : IO occurs whenever a new query comes in to cache data in memory. The process of loading data present on the disk into memory is called cache warmUp. During WarmUp, data on the disk is accessed, resulting in poor performance. Aurora is a structure that separates the cache from the instance. Therefore, the cached data remains when the instance is restarted. In other words, Aurora does not have to do cache warm-up.

4) Infinite Storage (64TB) : Aurora automatically allocates up to 64TB of storage and charges as much as you use it.

5) Point in time recovery (Restore) : Aurora can recover from any point in time if you recover from a backup copy.

6) Fast Crash Recovery : Aurora plays the redo log in parallel, distributed, and asynchronous manner for quick recovery.

7) Increase storage security : Encryption at the storage level is possible.

Oracle 19c Global partner :

1) 8x8

8x8 is transforming the future of business communications as a leading Software-as-a-Service provider of voice, video, chat, contact center, and enterprise-class API solutions powered by one global cloud communications platform. They built their multi-cloud storage (MCS) solution on Amazon Aurora. 

2) Autodesk

Autodesk makes software for people who make things like high-performance cars, towering skyscrapers and great films.Amazon Aurora allowed us to increase our database connections and greatly improve our scalability, response times, and CPU utilization.

3) Intuit

Intuit, maker of TurboTax, QuickBooks, Mint and Turbo, provides financial management solutions to approximately 50 million consumers, self-employed and small businesses around the world. Intuit recently migrated their commerce platform to Amazon Aurora MySQL to support increasing global demand.

Do you need database performance monitoring? Contact us and we will send you a free quote
[email protected]