In a significant advancement for cloud database management, Danilo Poccia, an Evangelist at Amazon Web Services, recently shared that the PostgreSQL-compatible edition of Aurora Serverless is now generally available. This innovative service allows users to create database instances that operate only when necessary, automatically adjusting their capacity in response to demand. When idle, the database will shut down, ensuring that resources are utilized efficiently. Customers are billed on a per-second basis for the active database capacity, in addition to standard Aurora storage costs.
Last year marked the launch of Aurora Serverless for MySQL, which has already garnered attention for its flexibility and cost-effectiveness.
How the Aurora PostgreSQL Serverless Storage Works
Upon creating a database with Aurora Serverless, users specify both the minimum and maximum capacity. Client applications connect seamlessly to a proxy fleet that directs workloads to a dynamically scaled pool of resources. This scaling occurs rapidly, as the resources remain ‘warm’ and ready to accommodate user requests.
The architecture of Aurora Serverless separates the storage layer from the computational resources utilized by the database. This design eliminates the need for pre-provisioning storage. The minimum storage capacity starts at 10GB, but it can expand automatically based on usage, scaling up to 64 TB in increments of 10GB, all without affecting database performance.
How to Create an Aurora Serverless PostgreSQL Database
- Create a database from the Amazon RDS console, selecting Amazon Aurora as the engine.
- Choose the PostgreSQL version compatible with Aurora Serverless; currently, version 10.5 is available.
- Assign an identifier to the new DB cluster, select a master username, and allow Amazon RDS to generate a password for credential retrieval during the database creation process.
- Determine the minimum and maximum capacity for the database in terms of Aurora Capacity Units (ACUs). Additionally, configure the option to pause compute capacity after 5 minutes of inactivity. Based on these settings, Aurora Serverless will automatically establish scaling rules for CPU utilization, connections, and available memory.
Aurora Serverless PostgreSQL is now accessible in various regions, including US East (N. Virginia and Ohio), US West (Oregon), EU (Ireland), and Asia Pacific (Tokyo). The announcement has been met with enthusiasm from developers across the community.
For further insights and details, visit the Amazon blog.
