Describe the bug
Trying to Setup MySQL8 Aurora via CDK
this.importBucket = new s3.Bucket(this, this.stackConfig.PaymentsS3ImportBucket);
this.exportBucket = new s3.Bucket(this, this.stackConfig.PaymentsS3ExportBucket);
const paymentsAuroraCluster = new rds.DatabaseCluster(this, this.stackConfig.PaymentsDatabaseId, {
engine: rds.DatabaseClusterEngine.auroraMysql({version: rds.AuroraMysqlEngineVersion.VER_3_01_0}),
credentials: rds.Credentials.fromGeneratedSecret('someadmin'),
iamAuthentication: true,
instanceProps: {
instanceType: ec2.InstanceType.of(ec2.InstanceClass.R5, ec2.InstanceSize.LARGE),
vpcSubnets: {
subnetType: ec2.SubnetType.PRIVATE_ISOLATED,
},
vpc: somevpc
},
defaultDatabaseName: this.stackConfig.DefaultDatabase,
s3ImportBuckets: [this.importBucket],
s3ExportBuckets: [this.exportBucket]
});CDK synth template has this
"Type": "AWS::RDS::DBClusterParameterGroup",
"Properties": {
"Description": "Cluster parameter group for aurora-mysql8.0",
"Family": "aurora-mysql8.0",
"Parameters": {
"aws_default_s3_role": {
"Fn::GetAtt": [
"foomysql8S3ImportRoleA2225BF9",
"Arn"
]
},
"aurora_select_into_s3_role": {
"Fn::GetAtt": [
"foomysql8S3ExportRoleE8D8EE1E",
"Arn"
]
}
}
aurora_select_into_s3_role is not a valid parameter for MySQL8 and deploy fails
10:44:22 AM | UPDATE_FAILED | AWS::RDS::DBClusterParameterGroup | fooauroramysq...meterGroup73951D0D
Invalid / Unsupported DB Parameter: aurora_select_into_s3_role
See a similar issue reported here #19126, but probably this only resolved import and needs a similar fix for export
Or is there a workaround?
Expected Behavior
aws_default_s3_role for MySQL8 supports export as well and should be the parameter when s3BucketExport is requested.
Current Behavior
10:44:22 AM | UPDATE_FAILED | AWS::RDS::DBClusterParameterGroup | fooauroramysq...meterGroup73951D0D
Invalid / Unsupported DB Parameter: aurora_select_into_s3_role
Reproduction Steps
Included in description
Possible Solution
No response
Additional Information/Context
No response
CDK CLI Version
2.19.0 (build e0d3e62)
Framework Version
No response
Node.js Version
v17.7.2
OS
Mac
Language
Typescript
Language Version
4.6.2
Other information
No response
Describe the bug
Trying to Setup MySQL8 Aurora via CDK
CDK synth template has this
aurora_select_into_s3_roleis not a valid parameter for MySQL8 and deploy failsSee a similar issue reported here #19126, but probably this only resolved
importand needs a similar fix forexportOr is there a workaround?
Expected Behavior
aws_default_s3_rolefor MySQL8 supports export as well and should be the parameter whens3BucketExportis requested.Current Behavior
Reproduction Steps
Included in description
Possible Solution
No response
Additional Information/Context
No response
CDK CLI Version
2.19.0 (build e0d3e62)
Framework Version
No response
Node.js Version
v17.7.2
OS
Mac
Language
Typescript
Language Version
4.6.2
Other information
No response