How to connect to RDS aurora MYSQL private DB using Boto3?
I tried searching ways to connect to RDS aurora serverless MYSQL private db found a way here, but it is asking secret arn of the DB, unable to find that one out can anyone help me with the way to generate secret ARN or a way to connect to RDS aurora serverless MYSQL private db i am able to fetch all remaining details for the option mentioned in the above link, steps i am following:
- created RDS aurora serverless MYSQL private db
- connected a ec2 instance
- generating python script to connect to rds
if you suggest any alternative, that is also fine, TIA
If you're referring to this documentation https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/data-api.html#data-api.calling.python then it will only work if you have an Aurora Serverless v1 (not v2) and a Data API enabled.
When enabling the Data API, you'll be creating a secret, and its ARN then you'll be putting in the secret_arn variable in that python script
Relevant questions
Move RDS MySQL 5.6.40 database to Aurora Serverless
asked 3 years agoadd new DB inside aurora cluster
Accepted Answerasked 5 months agoUnable to restore Aurora Serverless V1 snapshot to Aurora Provisioned
Accepted Answerasked 3 months agoUnable to export aurora mysql serverless snapshot to S3
asked 2 years agoHow to connect to RDS aurora MYSQL private DB using Boto3?
asked a month agoRDS Aurora parameter group max_timeout custom setting not reflecting on the DB even after a reboot
asked a month agoAWS RDS Aurora MySql Serverless: ft_min_word_len is not being recognized
asked 3 months agomoving rds aurora serverless from Public subnet to private subnet within same VPC
asked a month agoBest practices for migrating MySQL RDS to Aurora Serverless
Accepted Answerasked 3 years agoCannot connect remotely to serverless Aurora MySQL
asked 3 years ago
can you please explain how to connect to serverless V2 using python?