AWS now compatible with MySQL, PostgreSQL; offer performance and availability of commercial databases



Amazon Web Services Inc. (AWS), an Amazon.com company announced Wednesday that 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 PostgreSQL support, users 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.

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.

Amazon Aurora provides multiple levels of security for the database. These include network isolation using Amazon VPC, encryption at rest using keys you create and control through AWS Key Management Service (KMS) and encryption of data in transit using SSL. On an encrypted Amazon Aurora instance, data in the underlying storage is encrypted, as are the automated backups, snapshots, and replicas in the same cluster.

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.

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.

As Amazon Aurora offers performance and availability of high-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.

Users can scale their Amazon Aurora database from an instance with 2 vCPUs and 4GiB of memory up to an instance with 32 vCPUs and 244GiB of memory. Consumers can also add up to 15 low latency read replicas across three Availability Zones to further scale read capacity. Amazon Aurora automatically grows storage as needed, from 10GB up to 64TB.

“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, AWS. “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.”

Leave a Reply

WWPI – Covering the best in IT since 1980