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 Risposta
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
TECNICO DI SUPPORTO
con risposta 2 anni fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande