An Azure managed MySQL database service for app development and deployment.
Hi,
In my experience if call to Location Based Capability Set - Get REST API returns 500 InternalServerError it means the subscription is blocked from deploying to the region. Due to capacity constraints it is common for many subscriptions to be blocked from deploying MySQL Flexible server to the most popular regions (East US and East US 2 are among those that are blocked).
Try deploying to a less popular region, for example, US West 3. You may test using REST api with below link:
Click Try It button, sign in, select your directory, for capabilitySetName enter default , for locationName enter the region code (e.g. westus3, westus2, centralus, eastus, etc. ), scroll down and click Run button. If you get InternalServerError it means subscription is blocked for that region, if you get a list of supported editions, skus, etc., then that means region is permitted.
I first noticed this some months ago when investigating via portal. If portal shows "Subscription '<subscription>' is not allowed to provision in '<region>' you'll see the underlying REST API call returns 500 error. That's how the portal knows to display the error. Using 500 error in this way is generally not "standard" practice, but it seems to be how this api method works.
What you can do is submit a free Service and subscription limits (quotas) request via portal and select Quota type: Azure Database for MySQL Flexible server, on Additional details tab click Enter details, Quota type: Region access, select the region you need, enter vCores requested, etc. Please note your request for region access may be denied.
How to Create an Azure support request
If you have trouble creating the support request please let me know and I'll post detailed, specific to MySQL Flexible instructions including screenshots.
Please click Accept Answer and upvote if the above was helpful.
Thanks.
-TP