New Amazon Aurora PostgreSQL is now fully compatible with MySQL and PostgreSQL



Amazon Web Services, an Amazon.com company, announced on Wednesday general availability for Amazon Aurora with PostgreSQL compatibility. Amazon Aurora is a cloud-optimized relational database that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases.

Now, customers who use PostgreSQL databases can get up to several times better performance with scalability, durability, availability, and security as good as or better than commercial databases—at one-tenth the cost.

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. AWS also announced that customers migrating to Amazon Aurora from another database can use the AWS Database Migration Service (DMS) free of charge for the next six months.

Amazon Aurora delivers up to several times better performance compared to standard MySQL and PostgreSQL by using a variety of software and hardware techniques to ensure the database is able to fully leverage available compute, memory, and networking resources. Amazon Aurora storage scales automatically, growing and rebalancing Input and Outputs (I/O) across the fleet to provide consistent performance.

For example, a customer can start with a database of 10GB and have it automatically grow up to 64TB, without requiring any downtime. Amazon Aurora is highly available and durable, automatically replicating data across multiple Availability Zones and continuously backing up data to Amazon Simple Storage Service (Amazon S3), which is designed for 99.999999999 percent durability.

Amazon Aurora is designed to offer greater than 99.99 percent availability and to 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.

Historically, customers have had to choose between performance and price when evaluating database solutions. Commercial databases offer high performance and advanced availability features, but are expensive, complex to manage, have high lock-in, and come with punitive licensing terms.

Open source databases such as PostgreSQL and MySQL require less capital expense, but customers often find they cannot achieve the performance or availability of commercial databases. Amazon Aurora offers both performance and availability of the highest-grade commercial databases at a cost more commonly associated with open source.

With more and more enterprises embracing PostgreSQL for its user-defined functions and data types, complex SQL support, NoSQL and JSON support, broad application language support, and closer semantics to some of the old guard databases, Amazon Aurora’s PostgreSQL launch comes at a great time for customers looking to break free of the cost and complexity of traditional commercial databases.

“When we made Amazon Aurora available in 2015, for the first time, customers had a cost-effective and high performance alternative to commercial databases like Oracle and SQL Server—and this is a big part of why Amazon Aurora is the fastest-growing service in the history of AWS,” said Raju Gulabani, vice president, databases, analytics and machine learning, AWS. “While we’ve been amazed at the growth of Amazon Aurora’s MySQL-compatible edition, many of our enterprise customers anxious to move on from their old world database providers have been waiting for Amazon Aurora’s PostgreSQL-compatible edition to launch into general availability. We’re excited to help these customers take another step toward database freedom.”

Verizon is a vendor delivering communications and technology solutions.

“Verizon is helping our customers build a better, more connected life. As part of this journey, we are undergoing a major transformation in our database management approach, moving away from expensive, legacy commercial database solutions to more efficient and cost-effective options,” said Shashidhar Sureban, Associate Director, Database Engineering, Verizon. “Testing of Amazon Aurora PostgreSQL showed better performance over standard PostgreSQL residing on Amazon EC2 instances, and the AWS Database Migration Service and Schema Conversion Tool were found effective at identifying areas for data-conversion that required special attention during migration.”

FantasyDraft is a daily fantasy sports site offering fantasy play across multiple sports and contest formats including leagues, head-to-head contests and tournaments.

“We’ve been extensively testing the preview of the new Amazon Aurora PostgreSQL engine, and have been very impressed with overall compatibility with standard PostgreSQL, along with the ease of migrating our data and applications to Amazon Aurora’s new engine to obtain improved performance, scalability and resiliency,” said Tim Weisbrod, FantasyDraft Co-Founder and President. “We are most excited about improved performance under high concurrency workloads to ensure our users have the best experience possible in the final minutes leading up to when contests start. We’re also looking forward to the rapid crash recovery and fast failover capabilities of Amazon Aurora PostgreSQL to ensure any potential disruptions to our customers are minimized, and to Amazon Aurora read replica scale-out and dynamic auto-scaling storage to help us dynamically add resources to cover the busiest times and reduce costs when they aren’t needed.”

OpenSCG is a solutions partner in the PostgreSQL community.

“We have been testing the preview of Amazon Aurora’s PostgreSQL compatibility as part of our goal of helping enterprises successfully move from expensive on-premises commercial relational databases to PostgreSQL,” said Denis Lussier, CEO of OpenSCG. “We are impressed with the PostgreSQL compatibility, the performance, and the high availability, and we are working with multiple customers to give them all the assistance they need to move their Oracle database workloads to Amazon Aurora. It is truly amazing how quickly people are moving past the Oracle RAC objection that I’ve seen for the last 15 years when they hear how Amazon Aurora works. It’s a game changer for sure.”

SRA OSS is part of SRA Inc., one of Japan’s oldest and largest systems integration companies. “In our performance testing of Amazon Aurora’s PostgreSQL compatibility, we found that the performance was three times better than standard PostgreSQL,” said Tatsuo Ishii, SRA OSS Japan President. “Our testing also showed that Amazon Aurora is fully compatible with PostgreSQL 9.6, and we believe customers will be able to move large enterprise workloads from on-premises commercial databases to Amazon Aurora because of its high performance, high availability, and PostgreSQL compatibility. SRA OSS will add support for Amazon Aurora to the next version of pgpool-II, which provides clustering management middleware for PostgreSQL.”

PostgreSQL compatibility for Amazon Aurora is available as a database engine for Amazon RDS in the US East (N. Virginia), US East (Ohio), US West (Oregon), and EU (Ireland) Regions, and will expand to additional Regions in the coming months.

Leave a Reply

WWPI – Covering the best in IT since 1980