search

awsdocs / amazon-aurora-user-guide

The open source version of the Amazon Aurora User Guide. You can provide feedback by submitting issues in this repo, or propose changes by submitting a pull request.
Other
53 stars 102 forks source link

unable to add IAM role to aurora #18

Closed venkateshkb closed 4 years ago

venkateshkb commented 4 years ago

when calling the AddRoleToDBCluster operation: You currently can't add a role to Aurora Serverless DB Cluster --- Im getting this error

randyurbano commented 4 years ago

Thanks for your feedback, and sorry about the delay in responding.

See the limitations for Aurora Serverless in this topic:

Limitations of Aurora Serverless https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.html#aurora-serverless.limitations

Aurora Serverless doesn't support the features that require adding a role, such as S3 integration. So, adding an IAM role doesn't apply to Aurora Serverless DB clusters.

adnan-iqbal-ch commented 2 years ago

is there a way to support aws_s3.query_export_to_s3 on Aurora Serverless, its not possible because of above limitation. Is there any alternative approach available for Aurora Serverless to move data to s3 or change capture via trigger to downstream?

hebbsThakral commented 2 years ago

Did you find a solution? I can only think about having a trigger on multiple tables to populate a changes table (maybe with an ID and json field). The triggers insert the changes to this table. Then (sadly) poll the changes changes table with a "select ... for update" (so you can do this in parallel if you want to) and delete any change after successfully invoking the S3 or lambda function from your application server.

adnan-iqbal-ch commented 2 years ago

I have done by logging a message in logs and triggering a lambda from cloudwatch logs with pattern and pulling data from aurora on log event.

hebbsThakral commented 2 years ago

Great idea - how did you manage to log a message into the Aurora logs?