Hi I had checked the process suggested by aws guidelines videoand url link related to this issue, but unable to move RDS aurora serverless mysql database from public to private, can anyone please help me with this or at least tell me the viability of this process. I am unable to proceed with the step in the above url : Remove the public subnets and add private subnets on your DB instance as it is saying both public subnets are in use, i thought to proceed, but later on I don't have the option to reboot the rds aurora mysql db
The links that you have shared are for RDS provisioned instances, to which RDS Aurora Serverless does not belong to.
The answer depends on the version of RDS Aurora Serverless (v1 or v2), which you have not given in your question:
RDS Aurora Serverless v1: While the cluster always lives inside a VPC, it is only reachable from within the same VPC, see the RDS Aurora documentation:
You can't give an Aurora Serverless v1 DB cluster a public IP address. You can access an Aurora Serverless v1 DB cluster only from within a VPC.
The cluster can never be public. Therefore, you cannot move it to a private subnet since it already is private.
For RDS Aurora Serverless v2, however, you can choose to have a public IP, but this is not the default option during creation. If yours doesn't have a public IP, then you don't need to move it into a private subnet.