Will RDS add a query accelerator like Heatwave to MySQL

0

Will Amazon add or even give the option to include a query accelerator like Heatwave which improves MySQL performance more than considerably and is way faster than Aurora?

1 Answer
0

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

AWS
SUPPORT ENGINEER
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions