Amazon Aurora MySQL Database Engine for Amazon RDS Now Available

Amazon has announced the availability of Amazon Aurora, a MySQL-compatible, highly scalable relational database engine designed to deliver 99.99% availability. Aurora is part of the Amazon Relational Database Service (Amazon RDS), a cloud service that allows users to easily set up and manage relational databases. The Amazon RDS APITrack this API provides programmatic access to database functions including create, delete, and modify database instances and backups.

Amazon RDS is a cloud service that provides access to the capabilities of database management systems such as Aurora, Microsoft SQL Server, MySQL, Oracle, and PostgreSQL. Users can easily set up, manage, and scale relational databases in which routine database tasks such as provisioning, backup, recovery, and failure detection are handled by Amazon RDS. Aurora is the most recent relational database engine to be added to Amazon RDS.

According to Amazon, Amazon Aurora “delivers up to five times the throughput of standard MySQL running on the same hardware.” Amazon Aurora features as-needed storage that is added in 10 GB increments, up to a total of 64 TB. The service also allows users to create up to 15 low-latency read replicas for each Aurora database.

It should be noted that Amazon Aurora is designed to be compatible with MySQL 5.6 only and only supports InnoDB. As a comparison, Amazon RDS for MySQL is compatible with MySQL5.1, 5.5, and 5.6. and both MyISAM and InnoDB are supported.

Amazon Aurora instances generate a wide range of metrics that can be monitored, collected, and tracked using Amazon CloudWatch. Amazon CloudWatch is a cloud-based monitoring service that can be used to analyze application performance, Resource usage, and other metrics. The Amazon CloudWatch API can be used to programmatically access CloudWatch actions and data types.

The Amazon RDS API allows a variety of database functions to be performed programmatically, such as managing database instances, backups, and snapshots. The API can be used to create a snapshot of a database instance or to create a new database instance from a point-in-time backup. Read replicas for database instances can also be created using the Amazon RDS API.

AWS CloudTrail can be used to record Amazon RDS API and other Amazon Web Services API calls associated with an Amazon Web Services (AWS) account. AWS CloudTrail provides a history of AWS API calls that can be used for security analysis, compliance auditing, and more. AWS CloudTrail records the API calls and provides a log file (which is stored in an Amazon S3 bucket) that contains information such as API caller identity, API call time, request parameters, etc.

The announcement post lists quite a few companies already using the Amazon Aurora service such as Tableau, Talend, Alfresco, Navicat, and Nordcloud. Amazon Aurora is being used by these companies for different types of applications such as business intelligence, data Integration, query and monitoring, System Integration (SI) and consulting, as well as content management.

“We ran our compatibility test suites against Amazon Aurora and everything just worked,” stated Dan Jewett, Vice President of Product Management at Tableau, for the press release. “Amazon Aurora paired with Tableau means data users can take advantage of the 5x throughput Amazon Aurora provides and deliver faster analytic insights throughout their organizations. We look forward to offering our Amazon Aurora Tableau connector in the coming weeks.”

Amazon Aurora is now available in three AWS regions: U.S. East (Northern Virginia), U.S. West (Oregon), and EU (Ireland). Amazon plans on expanding the service to other regions in the future. For more information about Amazon RDS for Aurora, visit the official website.

Be sure to read the next Database-as-a-Service article: Realm Launches Version 1.0 Featuring Updated API