Amazon Aurora makes PostgreSQL Serverless generally available

Yesterday, Danilo Poccia, an Evangelist at Amazon Web Services announced the PostgreSQL-compatible edition of Aurora Serverless will be generally available.

Aurora PostgreSQL Serverless lets customers create database instances that only run when needed and automatically scale up or down based on demand. If a database isn’t needed, it will shut down until it is needed. With Aurora Serverless, users have to pay on a per-second basis for the database capacity one uses when the database is active, plus the usual Aurora storage costs.

Last year, Amazon had made the Aurora Serverless MySQL generally available.

How the Aurora PostgreSQL Serverless storage works

When a database is created with Aurora Serverless, users set the minimum and maximum capacity. The client applications transparently connect to a proxy fleet that routes the workload to a pool of resources that are automatically scaled. Scaling is done quickly, as the resources are ‘warm’ and ready to be added to serve user requests.

Image Source: Amazon blog

The storage layer is independent from the computer resources, used by the database, as the storage is not provisioned in advance. The minimum storage is 10GB, however based on the database usage, the Amazon Aurora storage will automatically grow, up to 64 TB, in 10GB increments with no impact to database performance.

How to create an Aurora Serverless PostgreSQL Database

• Create a database from the Amazon RDS console, using Amazon Aurora as engine.
Unlock access to the largest independent learning library in Tech for FREE!
Get unlimited access to 7500+ expert-authored eBooks and video courses covering every tech area you can think of.
Renews at €18.99/month. Cancel anytime
START FREE TRIAL
• Select the PostgreSQL version compatible with Aurora serverless. After selecting the version, the serverless option becomes available. Currently, its is version 10.5.
• Enter an identifier to the new DB cluster, choose the master username, and let Amazon RDS generate a password. This will let users retrieve their credentials during database creation.
• Select the minimum and maximum capacity for the database, in terms of Aurora Capacity Units (ACUs), and in the additional scaling configuration, choose to pause compute capacity after 5 minutes of inactivity. Based on the setting, Aurora Serverless will automatically create scaling rules for thresholds for CPU utilization, connections, and the available memory.

Aurora Serverless PostgreSQL will now be available in US East (N. Virginia and Ohio), US West (Oregon), EU (Ireland), and Asia Pacific (Tokyo).

Many developers are happy with the announcement.

https://twitter.com/oxbits/status/1148840886224265218

https://twitter.com/sam_jeffress/status/1148845547110854656

https://twitter.com/maciejwalkowiak/status/1148829295948771331

Visit the Amazon blog for more details.

How do AWS developers manage Web apps?

Amazon launches VPC Traffic Mirroring for capturing and inspecting network traffic

Amazon adds UDP load balancing support for Network Load Balancer