AWS Extends Amazon Aurora with PostgreSQL Compatibility Amazon Aurora now fully compatible with both MySQL and PostgreSQL, delivering the performance and availability of high-end commercial databases at one-tenth the cost
Preview starts today; participants include Fannie Mae, Capital One, C3 IoT, Technology One, and FINRA
SEATTLE--(BUSINESS WIRE)--Nov. 30, 2016-- Today at AWS re:Invent, Amazon Web Services, Inc. (AWS), an Amazon.com company (NASDAQ: AMZN), announced it has added full PostgreSQL compatibility to Amazon Aurora, the AWS database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. With Amazon Aurora's new PostgreSQL support, customers can get up to several times better performance than the typical PostgreSQL database and take advantage of the scalability, durability, and security capabilities of Amazon Aurora - all for one-tenth the cost of commercial grade databases. With no upfront costs or commitments required, customers pay a simple hourly charge for each Amazon Aurora database instance they use and can automatically scale storage capacity with no downtime or performance degradation. To learn more about Amazon Aurora, visit https://aws.amazon.com/aurora.
Historically, customers have had to choose between performance and price when evaluating database solutions. Commercial grade databases offer high performance and advanced availability features, but are expensive, complex to manage, have high lock-in, and come with punitive licensing terms. While popular open source databases like MySQL and PostgreSQL require less capital expense, customers often find they require extensive tuning and configuration to come close to commercial grade database performance levels. Because Amazon Aurora offers the best of both worlds - the performance and availability of the highest-grade commercial databases at a cost more commonly associated with open source - customers including GE Oil & Gas, Gumi, NASDAQ, Pearson Education, and Zynga have made it the fastest growing service in the history of AWS. With Amazon Aurora PostgreSQL compatibility, the growing number of enterprises that are embracing PostgreSQL for its user-defined functions and data types, complex SQL support, NoSQL and JSON support, and broad application development language support, now have another reason to bring their production databases to AWS and break free from the cost and complexity of traditional commercial grade databases.
When we made Amazon Aurora available last year, for the first time, customers had a real alternative to commercial databases like Oracle and Microsoft SQL Server. And, our release of the AWS Database Migration Service kicked off a mass migration, as customers have used the service to migrate over 14,000 databases this year, said Raju Gulabani, Vice President, Databases, Analytics, and AI, Amazon Web Services. Today, Amazon Aurora is powering a wide range of production applications for companies of all sizes and industries - from massive Internet of Things (IoT) applications to mission-critical e-commerce sites. Many customers have told us they would migrate even more of their sophisticated enterprise applications if we made Amazon Aurora compatible with PostgreSQL in addition to MySQL. We are excited to provide this choice to help our customers free themselves from the expensive legacy databases they use today.
Amazon Aurora delivers up to several times better performance than standard MySQL and PostgreSQL databases by using a variety of software and hardware techniques to ensure the database engine is able to fully leverage available compute, memory, and networking. In addition, Amazon Aurora storage scales automatically, growing and rebalancing Input and Outputs (I/O) across the fleet to provide consistent performance without over-provisioning. For example, a customer can start with a database of 10GB and have it automatically grow up to 64TB, without requiring any downtime. Highly durable and available, Amazon Aurora automatically replicates data across multiple Availability Zones and continuously backs up data to Amazon Simple Storage Service (Amazon S3), which is designed for 99.999999999 percent durability without performance impact. Amazon Aurora is designed to offer greater than 99.99 percent availability and automatically detect and recover from most database failures in less than 30 seconds, without crashing or the need to rebuild database caches. Amazon Aurora continually monitors instance health and, if there is a failure, it will automatically failover to a read replica without loss of data.
FINRA is the largest independent securities regulator in the U.S., taking in up to 75 billion market events per day that are tracked, aggregated, and analyzed for the purpose of protecting investors in U.S. Markets. FINRA is in the process of migrating most of our relational databases away from Oracle and Microsoft, said Saman Michael Far, Senior Vice President & Chief Technology Officer, FINRA. We're looking forward to using Amazon Aurora with PostgreSQL compatibility because PostgreSQL is the best destination for our Oracle workloads.
Fannie Mae is a source of financing for mortgage lenders, providing access to affordable mortgage financing in all markets at all times. One of our biggest data challenges at Fannie Mae is achieving the fault tolerance and disaster recovery objectives for our databases. The products we use for this in our Oracle environments create maintenance challenges and make our databases less flexible, says Nate Den Herder, Senior Director of Financial Engineering, Fannie Mae. This is the key driver behind our switch to Amazon Aurora for new projects in AWS. We have been eagerly awaiting PostgreSQL compatibility in Amazon Aurora so that we can use
