Posted On: Sep 17, 2020
Amazon Aurora Parallel Query is now available with MySQL 5.7 compatibility. Parallel Query provides faster analytical queries over your transactional data, speeding up your queries by up to 2 orders of magnitude, while maintaining high throughput for your core transactional workload.
With today’s launch, you can use Parallel Query together with other Aurora MySQL 5.7 features such as Global Database. In addition, availability of the feature for the MySQL 5.7 and MySQL 5.6 databases has been expanded to 20 AWS regions. Read more about Parallel Query on the AWS Blog.
Parallel Query takes advantage of Aurora’s architecture by pushing processing down to the Aurora storage layer, spreading computation across thousands of nodes. By pushing query computation down to the storage layer where possible, Parallel Query limits CPU, memory, and network contention with the core workload.
You can enable Parallel Query on a new or existing Aurora cluster with just a few clicks in the Amazon RDS Management Console or by downloading the latest AWS SDK or CLI. Read the Aurora documentation to learn more. For a complete list of regions where Parallel Query is offered, see Aurora Pricing.
Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to five times better throughput than standard MySQL together with increased scalability, durability, and security.