[AWS] Aurora MySQL database engine version in Terraform config

[roger2hk]

Description

We used to define the Aurora MySQL minor version in aws_rds_cluster resource. The minor version was removed in #532 due to the unexpected behavior of OpenTofu/Terraform when the minor version was automatically bumped in the background.

tesseract/deployment/modules/aws/storage/main.tf

Line 28 in b1ce3bf

engine_version = "8.0.mysql_aurora.3.05.2"

tesseract/deployment/modules/aws/storage/main.tf

Line 28 in 54ec802

engine_version = "8.0"

Key findings

• There is no way to disable minor version upgrade via terraform config.
• The AWS Aurora database minor version upgrade will still be applied in cases of critical security issues or when a version reaches its end-of-support date.
• Dependabot does not know how to bump this version in terraform config.
• The performance regression test would not be hermetic if the minor version is not fixed.

Objective

We're looking for a way to keep track of the exact RDS database engine version in Terraform config, and that does not require anyone manually bumping the minor version from time to time. The version change should NOT break OpenTofu/Terraform.