I am using service discovery for containers in AWS ECS, for a private hosted zone staging.example.com.
.
Now, next to containers I would like to map an AWS RDS database to db.staging.example.com
. However, I cannot modify the Route53 hosted zone, as AWS denies me access because the zone is managed by service discovery
AccessDenied: The resource hostedzone/*** can only be managed through servicediscovery.amazonaws.com (***)
Any advice on how I can accomplish my custom subdomain is greatly appreciated. There is also Cloud Map and App Mesh as AWS services with similar goals regarding dns management, but I could not find any documentation regarding my scenario.