Aurora MySQL version 8.0.32 is available but not the latest 8.0.36

0

I want to upgrade Aurora MySQL version 8.0.32 to 8.0.36. Please help me with the process.

Amit
gefragt vor 3 Monaten265 Aufrufe
1 Antwort
0

Amazon RDS for MySQL supports new minor version 8.0.36 - announced 12-Feb-2024 https://aws.amazon.com/about-aws/whats-new/2024/02/amazon-rds-mysql-new-minor-version-8-0-36/

Here are the steps to upgrade Aurora MySQL from version 8.0.32 to 8.0.36:

  1. Check the Aurora MySQL version compatibility matrix to ensure 8.0.36 is compatible with 8.0.32. In this case, it is compatible.
  2. Modify the DB instance to enable upgrades. This can be done from the RDS console or using the AWS CLI:

You can follow this guide: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Updates.Patching.html

AWS
Fizza_A
beantwortet vor 3 Monaten
profile picture
EXPERTE
überprüft vor 2 Monaten
  • https://aws.amazon.com/about-aws/whats-new/2024/02/amazon-rds-mysql-new-minor-version-8-0-36/ The mentioned document is suggesting for Amazon RDS for MySQL not for Aurora MySQL. The question is specific to Aurora MySQL. As of now, I don't see an option to upgrade Aurora MySQL minor version to latest MySQL minor version i.e. 8.0.36. In case the latest MySQL minor version is not available then by when we can expect it to be available as the current MySQL minor version 8.0.32 is causing performance degradation in our SQL queries. As per the MySQL release notes - https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-33.html, "When the MySQL 5.7 Optimizer has 2 choices for an index to filter rows, one primary and one secondary, it picks a range scan on the secondary index because the range scan uses more key parts. MySQL 8.0 did not use this logic, instead choosing the primary index to filter rows with WHERE clause filtering. Primary key use is not suitable in such cases due to the presence of LIMIT, and due to the nature of data distribution. The secondary index was not considered while resolving order by due to constant elimination. This resulted in much different query plans in MySQL 5.7 and MySQL 8.0 for the same query. We solve this issue in MySQL 8.0 by skipping the constant key parts of the index during order-by evaluation only if the query is constant-optimized, which can be done at this time, but not during LIMIT analysis. (Bug #34291261)". We need this fix in Aurora.

  • I hope the above comment is explanatory. So requesting the experts to have look into it and kindly revert.

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen