Aurora database analytics engine

Amazon Aurora is a hosted relational database service developed and offered by Amazon.[1] Aurora is available as part of the Amazon Relational Database Service (RDS). Although it is a proprietary technology,[2] it is based on the open-source MySQL database.

Key features

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.[3] 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.[4]

Comparison and compatibility with MySQL

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.[5]

Performance

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".[5] Other independent tests have shown that Aurora performs better than competing technologies on some, but not all, combinations of workload and instance type.[6]

References

  1. Preimesberger, Chris (2014-11-12). "Amazon Claims New Aurora DB Engine Screams With Speed". eweek.com. Retrieved 2014-11-13.
  2. Hiltbrand, Troy. "Analysis: Aurora Is Amazon's Answer for Forgotten DBMS Users". Upside. TDWI. Retrieved 14 September 2016.
  3. "Amazon Aurora FAQs". Amazon.com. Retrieved 14 September 2016.
  4. "Monitoring Amazon Aurora performance metrics". Datadog. Retrieved 15 September 2016.
  5. 1 2 "Amazon Aurora Product Details". Amazon.com. Retrieved 15 September 2016.
  6. Tusa, Marco. "AWS Aurora Benchmarking part 2". Percona. Retrieved 15 September 2016.

External links


This article is issued from Wikipedia - version of the 11/15/2016. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.