Amazon Aurora | Performance Flashcards

1
Q

How can I get started with Amazon Aurora Serverless?

Performance

Amazon Aurora | Database

A

Amazon Aurora Serverless is now available in Preview for the MySQL-compatible edition of Amazon Aurora. You can sign up to request participation. We will announce general availability at a future date.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What does “five times the performance of MySQL” mean?

Performance

Amazon Aurora | Database

A

Amazon Aurora delivers significant increases over MySQL performance by tightly integrating the database engine with an SSD-based virtualized storage layer purpose-built for database workloads, reducing writes to the storage system, minimizing lock contention and eliminating delays created by database process threads. Our tests with SysBench on r3.8xlarge instances show that Amazon Aurora delivers over 500,000 SELECTs/sec and 100,000 UPDATEs/sec, five times higher than MySQL running the same benchmark on the same hardware. Detailed instructions on this benchmark and how to replicate it yourself are provided in the Amazon Aurora MySQL Performance Benchmarking Guide.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What does “three times the performance of PostgreSQL” mean?

Performance

Amazon Aurora | Database

A

Amazon Aurora delivers significant increases over PostgreSQL performance by tightly integrating the database engine with an SSD-based virtualized storage layer purpose-built for database workloads, reducing writes to the storage system, minimizing lock contention and eliminating delays created by database process threads. Our tests with SysBench on r4.16xlarge instances show that Amazon Aurora delivers SELECTs/sec and UPDATEs/sec over three times higher than PostgreSQL running the same benchmark on the same hardware. Detailed instructions on this benchmark and how to replicate it yourself are provided in the Amazon Aurora PostgreSQL Performance Benchmarking Guide.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

How do I optimize my database workload for Amazon Aurora MySQL?

Performance

Amazon Aurora | Database

A

Amazon Aurora is designed to be compatible with MySQL 5.6, so that existing MySQL applications and tools can run without requiring modification. However, one area where Amazon Aurora improves upon MySQL is with highly concurrent workloads. In order to maximize your workload’s throughput on Amazon Aurora, we recommend building your applications to drive a large number of concurrent queries and transactions.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly