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.
- 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.
PostgreSQL is the greatest database ever created!
Thank for this great gift!
— Alex Clifton (@oxbits) July 10, 2019
fantastic! looking forward to using this
— Sam Jeffress (@sam_jeffress) July 10, 2019
Good news! Aurora Serverless with PostgreSQL compatibility is now available! https://t.co/NGoklpDzrP
— Maciej Walkowiak 🍃 (@maciejwalkowiak) July 10, 2019
Visit the Amazon blog for more details.