Amazon Aurora is a MySQL and PostgreSQL-compatible relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to five times better performance than MySQL with the security, availability, and reliability of a commercial database at one tenth the cost.
Amazon Aurora is a managed database service, built on a fully distributed and self-healing storage system that keeps your data safe. It provides enterprise-level capabilities including database monitoring, database cloning, cross-region copying and replication, AWS Identity and Access Management integration, and much more. You can use the AWS Database Migration Service to easily migrate or replicate your existing databases to Amazon Aurora.
You can now launch Amazon Aurora database instances with either MySQL or PostgreSQL compatibility. PostgreSQL compatibility is available in preview. Sign up here.
Adobe Flash Player or a modern browser is required to view videos on this site.
Amazon Aurora is a great option for any enterprise application that can use a relational database. Compared to commercial databases, Amazon Aurora can help cut down your database costs by 90% or more while improving reliability and availability of the database. Amazon Aurora being a fully managed service helps you save time by automating time consuming tasks such as provisioning, patching, backup, recovery, failure detection, and repair.
Expedia, one of the largest travel companies in the world, uses Amazon Aurora for their Travel Data Application that inserts 300 millions rows of data per day, at a peak 70,000 rows per second with 17 millisecond average response time for read and 30 millisecond average response time for write.
SaaS applications often use architectures that are multi-tenant, which requires a great deal of flexibility in instance and storage scaling along with high performance and reliability. Amazon Aurora provides all of these features in a managed database offering, helping SaaS companies focus on building high quality applications without worrying about the underlying database that powers the application.
"Amazon Aurora was able to satisfy all of our scale requirements with no degradation in performance. With Alfresco on Amazon Aurora we scaled to one billion documents with a throughput of three million per hour, which is ten times faster than our MySQL environment. It just works!" - John Newton, Founder and CTO of Alfresco
Web and mobile games are built to operate at very large scale need a database with high throughput, massive storage scalability, and high availability. Amazon Aurora fulfills the needs of such highly demanding applications with enough room for future growth. Since Amazon Aurora does not have any licensing constraints, it perfectly fits the variable usage pattern of these applications.
“Aurora has been nothing short of impressive… Most of the automation we’re enjoying has long been standard for RDS, but using Aurora has delivered the automation of RDS along with the performance of self-managed i2 instances. Aurora is now our first choice for new services using relational databases.” - Chris Broglie, Architect, Zynga
Amazon Aurora can provide a significant performance increase to your application while improving reliability and availability, and reducing cost at the same time. Internal testing using SysBench on r3.8xlarge instances show that Amazon Aurora delivers over 500,000 reads and 100,000 writes per second with a high level of consistency, irrespective of the size of the database and object count. You can easily run benchmark tests against an Amazon Aurora instance to compare it to the performance of your existing database or to evaluate peformance needs for a new application you are building. Detailed instructions on how to perform benchmarking are provided in the Amazon Aurora Performance Benchmarking Guide.
InfoWorld performed extensive benchmarking tests on Amazon Aurora concluding that "Amazon's revved-up database service offers five times the throughput of MySQL and a formidable alternative to Oracle and SQL Server" and giving Amazon Aurora their "Editor's Choice" award. Download the Full InfoWorld Review >>
If you are currently using Amazon RDS for MySQL or Amazon RDS for PostgreSQL, migrating to Aurora will be as simple as creating a snapshot and launching an Aurora instance from that snapshot. You can follow the simple, step by step instructions in the user guide to perform a migration from Amazon RDS for MySQL or Amazon RDS for PostgreSQL. Since Amazon Aurora is fully MySQL and PostgreSQL compatible, your applications can simply be reconnected to the new Amazon Aurora instance without any changes. Migrating to Amazon Aurora from
MySQL databases running on Amazon EC2 or on-premises also can be easily done. You can create a snapshot backup of your existing database, upload it to Amazon S3, and use it to directly create an Amazon Aurora cluster. You can also import data stored in an Amazon S3 bucket into a table in an Amazon Aurora database.Using standard MySQL import and export tools or mysql binlog replication are also supported. Migrating to Amazon Aurora from PostgeSQL databases running on Amazon EC2 or on-premises can be done using AWS Database Migration Service.
The AWS Schema Conversion Tool simplifies migration from Oracle and Microsoft SQL Server to Amazon Aurora by automatically converting the source database schema and a majority of the custom code - including views, stored procedures, and functions - to a format compatible with Amazon Aurora. Any code that cannot be automatically converted is clearly marked so that it can be manually converted. Learn more and download the AWS Schema Conversion Tool >>
Migrating data from Oracle and Microsoft SQL Server databases to Amazon Aurora can be easily done using AWS Database Migration Service. You can begin a data migration with just a few clicks, the source database remains fully operational during the migration, minimizing downtime to applications using that database. Learn more about AWS Database Migration Service >>
Thomas Publishing is a 100 year old company that began publishing the Thomas Register of American Manufacturers in 1898. Thomas Publishing migrated their production database from Oracle to Amazon Aurora using the AWS Database Migration Service and Schema Conversion Tool. The entire migration process was completed in less than 4 weeks.
Earth Networks operates the world’s largest and most comprehensive weather observation, lightning detection, and climate (GHG) networks. “We were very impressed with how easy it was to move from our current SQL Server databases to Amazon Aurora; all with only a few changes." - Eddie Dingels, Lead Architect at Earth Networks
It's easy to get started. Follow our Amazon RDS Getting Started Guide to create your first Amazon Aurora instance with just a few clicks.
To find more resources, visit our Getting Started with Aurora page.
Want to know more?
Drop our AWS experts a line.
Drop our AWS experts a line
Drop our AWS experts a line
Drop our AWS experts a line
Drop our AWS experts a line
Drop our AWS experts a line
Drop our AWS experts a line
Drop our AWS experts a line
Drop our AWS experts a line
Drop our AWS experts a line
Drop our AWS experts a line
Drop our AWS experts a line