- Newest
- Most votes
- Most comments
A HeatWave Cluster consists of a MySQL DB System and HeatWave nodes. The MySQL DB System includes a HeatWave plugin that is responsible for cluster management, query scheduling, and returning query results to the MySQL DB System. HeatWave nodes store data in memory and process analytics and machine learning queries. Each HeatWave node hosts an instance of the HeatWave query processing engine (RAPID). On AWS, We have the Aurora MySQL parallel query which is an optimization that parallelizes some of the I/O and computation involved in processing data-intensive queries. This data-intensive work is delegated (in database optimization terms, pushed down) to multiple nodes in the Aurora distributed storage layer. Parallel query works best with Aurora MySQL DB clusters that have tables with millions of rows and analytic queries that take minutes or hours to complete. Therefore, we have Parallel Query that works as a query accelerator for Aurora MySQL.
Please refer below document for more details on working with parallel query for Amazon Aurora MySQL:
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-mysql-parallel-query.html
Relevant content
- Accepted Answerasked 7 years ago
- Accepted Answerasked a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 2 years ago