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
질문됨 3달 전265회 조회
1개 답변
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
답변함 3달 전
profile picture
전문가
검토됨 2달 전
  • 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.

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠