Skip to content

chore(rds): deprecate aurora mysql version 1 for mysql 5.6#31551

Merged
mergify[bot] merged 4 commits intoaws:mainfrom
go-to-k:aurora-mysql-v1-deprecate
Oct 25, 2024
Merged

chore(rds): deprecate aurora mysql version 1 for mysql 5.6#31551
mergify[bot] merged 4 commits intoaws:mainfrom
go-to-k:aurora-mysql-v1-deprecate

Conversation

@go-to-k
Copy link
Copy Markdown
Contributor

@go-to-k go-to-k commented Sep 25, 2024

Reason for this change

Aurora MySQL version 1 for MySQL 5.6 is deprecated now.

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraMySQLReleaseNotes/AuroraMySQL.Updates.11Updates.html

Description of changes

Deprecated the version and no longer use the version in integ tests.

Description of how you validated changes

Checklist


By submitting this pull request, I confirm that my contribution is made under the terms of the Apache-2.0 license

@github-actions github-actions bot added p2 distinguished-contributor [Pilot] contributed 50+ PRs to the CDK labels Sep 25, 2024
@aws-cdk-automation aws-cdk-automation requested a review from a team September 25, 2024 08:11
isFromLegacyInstanceProps: true,
};
new rds.DatabaseCluster(stack, 'DualstackCluster', {
engine: rds.DatabaseClusterEngine.auroraMysql({ version: rds.AuroraMysqlEngineVersion.VER_3_02_0 }),
Copy link
Copy Markdown
Contributor Author

@go-to-k go-to-k Sep 25, 2024

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

VER_3_02_0 is deprecated.

Only running the integ test before the snapshot update failed, so I deleted the snapshot directory and ran the test.

Cannot find version 8.0.mysql_aurora.3.02.0 for aurora-mysql


new rds.DatabaseCluster(stack, 'Database', {
engine: rds.DatabaseClusterEngine.auroraMysql({
version: rds.AuroraMysqlEngineVersion.VER_3_01_0,
Copy link
Copy Markdown
Contributor Author

@go-to-k go-to-k Sep 25, 2024

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

VER_3_01_0 is deprecated.

Only running the integ test before the snapshot update failed, so I deleted the snapshot directory and ran the test.

Cannot find version 8.0.mysql_aurora.3.01.0 for aurora-mysql

}),
instances: 3,
instanceProps: {
instanceType: ec2.InstanceType.of(ec2.InstanceClass.BURSTABLE3, ec2.InstanceSize.SMALL),
Copy link
Copy Markdown
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

SMALL cannot be used for Aurora V3, CFn fails with the message:

RDS does not support creating a DB instance with the following combination: DBInstanceClass=db.t3.small, Engine=aurora-mysql, EngineVersion=8.0.mysql_aurora.3.07.1, LicenseModel=general-public-license. For supported combinations of instance class and database engine version, see the documentation.

username: 'clusteradmin',
});
serverlessCluster = new ServerlessCluster(stack, 'AuroraCluster', {
engine: DatabaseClusterEngine.auroraMysql({ version: AuroraMysqlEngineVersion.VER_2_07_1 }),
Copy link
Copy Markdown
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

VER_2_07_1 is deprecated.

});

new rds.DatabaseCluster(this, 'DatabaseCluster', {
engine: rds.DatabaseClusterEngine.AURORA,
Copy link
Copy Markdown
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Only running the integ test before the snapshot update failed, so I deleted the snapshot directory and ran the test.

Engine version not found: oscar/null

Comment on lines -79 to -86
version: AuroraPostgresEngineVersion.VER_11_6,
version: AuroraPostgresEngineVersion.VER_16_3,
});

// WHEN
const family = engine.parameterGroupFamily;

// THEN
expect(family).toEqual('aurora-postgresql11');
Copy link
Copy Markdown
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

While I'm at it: VER_11_6 for PostgreSQL is deprecated.

const mysqlLogTypes = ['error', 'general', 'slowquery', 'audit'];
expect(DatabaseClusterEngine.aurora({ version: AuroraEngineVersion.VER_1_22_2 }).supportedLogTypes).toEqual(mysqlLogTypes);
expect(DatabaseClusterEngine.auroraMysql({ version: AuroraMysqlEngineVersion.VER_2_08_1 }).supportedLogTypes).toEqual(mysqlLogTypes);
expect(DatabaseClusterEngine.auroraPostgres({ version: AuroraPostgresEngineVersion.VER_9_6_9 }).supportedLogTypes).toEqual(['postgresql']);
Copy link
Copy Markdown
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

While I'm at it: VER_9_6_9 for PostgreSQL is deprecated.

Comment on lines 893 to 896
new ServerlessCluster(stack, 'Database', {
engine: DatabaseClusterEngine.AURORA,
engine: DatabaseClusterEngine.AURORA_POSTGRESQL,
parameterGroup: ParameterGroup.fromParameterGroupName(stack, 'ParameterGroup', 'default.aurora-postgresql11'),
});
Copy link
Copy Markdown
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Used AURORA_POSTGRESQL because the 'default.aurora-postgresql11' is specified at parameterGroup.

@aws-cdk-automation aws-cdk-automation added the pr/needs-community-review This PR needs a review from a Trusted Community Member or Core Team Member. label Sep 25, 2024
GavinZZ
GavinZZ previously approved these changes Oct 24, 2024
Copy link
Copy Markdown
Member

@GavinZZ GavinZZ left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Nice, thanks for updating!

@mergify
Copy link
Copy Markdown
Contributor

mergify bot commented Oct 24, 2024

Thank you for contributing! Your pull request will be updated from main and then merged automatically (do not update manually, and be sure to allow changes to be pushed to your fork).

@aws-cdk-automation aws-cdk-automation removed the pr/needs-community-review This PR needs a review from a Trusted Community Member or Core Team Member. label Oct 24, 2024
@mergify
Copy link
Copy Markdown
Contributor

mergify bot commented Oct 24, 2024

Thank you for contributing! Your pull request will be updated from main and then merged automatically (do not update manually, and be sure to allow changes to be pushed to your fork).

@mergify mergify bot dismissed GavinZZ’s stale review October 24, 2024 23:17

Pull request has been modified.

@mergify
Copy link
Copy Markdown
Contributor

mergify bot commented Oct 24, 2024

Thank you for contributing! Your pull request will be updated from main and then merged automatically (do not update manually, and be sure to allow changes to be pushed to your fork).

@aws-cdk-automation
Copy link
Copy Markdown
Collaborator

AWS CodeBuild CI Report

  • CodeBuild project: AutoBuildv2Project1C6BFA3F-wQm2hXv2jqQv
  • Commit ID: ad6124c
  • Result: SUCCEEDED
  • Build Logs (available for 30 days)

Powered by github-codebuild-logs, available on the AWS Serverless Application Repository

@mergify mergify bot merged commit 84d71a4 into aws:main Oct 25, 2024
@mergify
Copy link
Copy Markdown
Contributor

mergify bot commented Oct 25, 2024

Thank you for contributing! Your pull request will be updated from main and then merged automatically (do not update manually, and be sure to allow changes to be pushed to your fork).

@github-actions
Copy link
Copy Markdown
Contributor

Comments on closed issues and PRs are hard for our team to see.
If you need help, please open a new issue that references this one.

@github-actions github-actions bot locked as resolved and limited conversation to collaborators Oct 25, 2024
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.

Labels

distinguished-contributor [Pilot] contributed 50+ PRs to the CDK p2

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants