Aurora Quiz
A database is required for a Two-Tier application. The data would go through multiple schema changes. The database needs to be durable, ACID compliant and changes to the database should not result in database downtime. Which of the following is the best option for data storage?
A. AWS S3
B. AWS Redshift
C. AWS DynamoDB
D. AWS Aurora
D. AWS Aurora
As per the AWS documentation Aurora does support Schema changes.
Amazon Aurora is a MySQL-compatible database that combines the speed and availability of high-end commercial databases with the simplicity and cost- effectiveness of open-source databases. Amazon Aurora has taken a common data definition language (DDL) statement that typically requires hours to complete in MySQL and made it near-instantaneous.i.e.0.15 sec for a 100BG table on r3.8xlarge instance.
Note: Amazon DynamoDB is schema-less, in that the data items in a table need not have the same attributes or even the same number of attributes.
Hence it is not a solution.
In Aurora, when a user issues a DDL statement: The database updates the INFORMATION_SCHEMA system table with the new schema. In addition, the database timestamps the operation, records the old schema into a new system table (Schema Version Table), and propagates this change to read replicas.
For more information, please check below AWS Docs:
https://aws.amazon.com/blogs/database/amazon-aurora-under-the-hood-fast-ddl/
