Amazon Aurora

From Wikipedia, the free encyclopedia
Jump to navigation Jump to search
Amazon Aurora
Developer(s) Amazon.com
Initial release October 2014; 3 years ago (2014-10) [1]
Operating system Cross-platform
Available in English
Type relational database SaaS
License Proprietary
Website aws.amazon.com/rds/aurora/

Amazon Aurora is a hosted relational database service developed and offered by Amazon since October 2014.[1][2] Aurora is available as part of the Amazon Relational Database Service (RDS). Although it is a proprietary technology,[3] it offers MySQL compatible service since its release and PostgreSQL compatible since October 2017 [4].

Key features[edit]

Aurora does not require the user to provision database storage, as it automatically allocates storage in 10-gigabyte increments, as needed, up to a maximum of 64 terabytes.[5] Aurora offers automatic, six-way replication of those 10-gigabyte chunks across multiple locations for improved availability and fault-tolerance. Aurora also provides users with more comprehensive performance metrics, such as query throughput and latency, as compared to other RDS database engines.[6]

Compatibility limitations with MySQL[edit]

Amazon designed Aurora to be compatible with MySQL, meaning that tools for querying or managing MySQL databases (such as the mysql command-line client and the MySQL Workbench graphical user-interface) work with Amazon Aurora databases as well. Not all MySQL options and features are available, however: as of September  2016, Amazon Aurora is only compatible with one version of MySQL (5.6), and supports only InnoDB as a storage engine.[7]

Performance[edit]

Amazon claims fivefold performance improvements on benchmarking tests, due to "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".[7] Other independent tests have shown that Aurora performs better than competing technologies on some, but not all, combinations of workload and instance type.[8]

See also[edit]

References[edit]

  1. ^ a b https://aws.amazon.com/blogs/aws/highly-scalable-mysql-compat-rds-db-engine/
  2. ^ Preimesberger, Chris (2014-11-12). "Amazon Claims New Aurora DB Engine Screams With Speed". eweek.com. Retrieved 2014-11-13. 
  3. ^ Hiltbrand, Troy. "Analysis: Aurora Is Amazon's Answer for Forgotten DBMS Users". Upside. TDWI. Retrieved 14 September 2016. 
  4. ^ https://aws.amazon.com/blogs/aws/now-available-amazon-aurora-with-postgresql-compatibility/
  5. ^ "Amazon Aurora FAQs". Amazon.com. Retrieved 14 September 2016. 
  6. ^ "Monitoring Amazon Aurora performance metrics". Datadog. Retrieved 15 September 2016. 
  7. ^ a b "Amazon Aurora Product Details". Amazon.com. Retrieved 15 September 2016. 
  8. ^ Tusa, Marco. "AWS Aurora Benchmarking part 2". Percona. Retrieved 15 September 2016. 

External links[edit]