A financial institution requires a database that is compliant with strict regulatory standards, offers high availability with automatic failover, and needs to scale storage and compute independently. The database must be fully managed and compatible with existing MySQL applications. Which AWS database service is the MOST appropriate choice?
- AAmazon Aurora MySQL-Compatible Edition
- BAmazon Redshift
- CAmazon DynamoDB
- DAmazon RDS for MySQL
Show answer & explanationAnswer & explanation
Correct answer: A. Amazon Aurora MySQL-Compatible Edition
Amazon Aurora is a MySQL- and PostgreSQL-compatible relational database built for the cloud, combining the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open-source databases. It offers up to 5x the performance of standard MySQL, high availability with automatic failover, and storage that scales automatically, decoupling compute and storage, making it ideal for critical financial applications requiring high performance and compliance.
Why the other options are wrong
- B. Amazon Redshift is a data warehousing service for analytics, not a transactional database compatible with MySQL applications.
- C. Amazon DynamoDB is a NoSQL database and is not compatible with existing MySQL applications.
- D. Amazon RDS for MySQL provides a managed MySQL database, but Aurora offers significantly higher performance, better availability features (like faster failover), and more advanced scaling capabilities, which are crucial for a financial institution.
Amazon Aurora
A MySQL and PostgreSQL-compatible relational database built for the cloud, combining the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open-source databases.
- Up to 5x faster than MySQL, 3x faster than PostgreSQL.
- High availability with automatic failover and up to 15 read replicas.
- Storage scales automatically up to 128TB, decoupled from compute.
Memory trick: Aurora: Always Up, Optimized, Relational, Awesome.