Amazon Aurora

From Wikipedia, the free encyclopedia
  (Redirected from Aurora database analytics engine)
Jump to navigation Jump to search
Amazon Aurora
Developer(s)Amazon.com
Initial releaseOctober 2014; 4 years ago (2014-10) [1]
Operating systemCross-platform
Available inEnglish
Typerelational database SaaS
LicenseProprietary
Websiteaws.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] and it is also possible to stop and start Aurora Clusters since September 2018 [5]. Since August 2018 Amazon also offers a serverless version of AWS Aurora. [6]

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.[7] 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.[8], since August 2017 also provided fast database cloning feature[9].

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

Performance[edit]

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

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. ^ https://aws.amazon.com/about-aws/whats-new/2018/09/amazon-aurora-stop-and-start/
  6. ^ https://aws.amazon.com/blogs/aws/aurora-serverless-ga/
  7. ^ "Amazon Aurora FAQs". Amazon.com. Retrieved 14 September 2016.
  8. ^ "Monitoring Amazon Aurora performance metrics". Datadog. Retrieved 15 September 2016.
  9. ^ https://aws.amazon.com/blogs/aws/amazon-aurora-fast-database-cloning/
  10. ^ a b "Amazon Aurora Product Details". Amazon.com. Retrieved 15 September 2016.
  11. ^ Tusa, Marco. "AWS Aurora Benchmarking part 2". Percona. Retrieved 15 September 2016.

External links[edit]