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.