Amazon Aurora DSQL FAQs
General
Open allWhat is Amazon Aurora DSQL?
Aurora DSQL is a serverless distributed SQL database designed to scale to meet any workload demand with up to 99.999% multi-Region availability and no infrastructure management. It is PostgreSQL-compatible and provides an easy-to-use developer experience. With Aurora DSQL, you only pay for what you use.
What type of workload does Aurora DSQL support?
Aurora DSQL is optimized for transactional (OLTP) workloads.
How do I get started with Aurora DSQL?
In only a few steps in the Aurora DSQL console, you can create a new database. For more details, go to the user guide.
Is Aurora DSQL generally available in all AWS Regions?
Aurora DSQL is currently available in preview in the following AWS Regions: US East (N. Virginia), US East (Ohio), and US West (Oregon). US West (Oregon) is only available as the witness Region for multi-Region configurations.
How does virtually unlimited scaling work for Aurora DSQL?
The Aurora DSQL distributed architecture is designed to automatically scale each component—compute, commit, and storage—independently to meet any workload demand and with no single leader. This reduces dependencies and allows reads and writes to dynamically scale up/down and out/in to virtually no limit. It also means Aurora DSQL can quickly deploy each component with no impact on performance.
How do infrastructure upgrades and migrations work with Aurora DSQL?
Aurora DSQL removes the need to upgrade or migrate your database to larger instances. It automatically scales out to virtually no limit to meet any workload demand.
Is Aurora DSQL PostgreSQL-compatible?
Yes, Aurora DSQL is PostgreSQL-compatible. To learn more, visit the Aurora DSQL PostgreSQL-compatible page for details on what is and is not supported.
Is Aurora DSQL MySQL-compatible?
No, Aurora DSQL is not available with MySQL compatibility.
Is Aurora DSQL a feature of Amazon Aurora PostgreSQL-Compatible Edition?
No, Aurora DSQL is a new database option under Amazon Aurora. Aurora PostgreSQL and Aurora MySQL provide the choice of add-on features, such as Aurora Serverless v2, Aurora Global Database, and Aurora Limitless Database, to enhance the open source engines. With Aurora DSQL, serverless, high-availability, and scaling features come built in.
High availability
Open allWhat does highest availability mean for Aurora DSQL?
Highest availability means Aurora DSQL provides up to 99.99% single-Region and 99.999% multi-Region availability to help ensure your applications are always available.
What does active-active mean for Aurora DSQL?
Active-active refers to the high-availability features of Aurora DSQL that provide up to 99.999% multi-Region availability. With active-active high availability, Aurora DSQL provides a fully managed, redundant Regional endpoint per cluster. This means that your applications can continue to read and write with strong consistency, even in the rare case an application is unable to connect to a multi-Region cluster endpoint.
What does automatic failure recovery mean for Aurora DSQL?
With Aurora DSQL, there are no primary or secondary nodes to configure and no failover procedures to manage. It has built-in fault tolerance, featuring automatic load balancing that routes your requests to healthy components and automated self-healing to correct component-level failures.
Easy to use
Open allWhat user management and permission features work with Aurora DSQL?
Aurora DSQL uses AWS Identity and Access Management (IAM) policies to define permissions and user roles.
What does it mean that Aurora DSQL is PostgreSQL-compatible?
This means Aurora DSQL supports many of the commonly used PostgreSQL queries and popular features. It will return identical query results for all supported features, provide identical behavior for most supported features, and support many popular PG drivers and tools with minor configuration changes. Visit the Aurora DSQL PostgreSQL-compatible page for more details.
No infrastructure management
Open allHow do minor and major versions work with Aurora DSQL?
Aurora DSQL automatically manages minor version updates. All supported major versions are available for use with no database downtime. You simply choose which version your application will use when connecting.
How does patching work with Aurora DSQL?
Aurora DSQL automatically handles patching with no downtime.
Billing
Open allWhat is the cost of Aurora DSQL?
Aurora DSQL is currently available in preview at no charge. To get started, sign in to the Aurora DSQL console.
How does billing work with Aurora DSQL?
More information will be available when Aurora DSQL is generally available.