Not able to create MySQL flexible Server Replica in paired region

Maulin Shah (Crest Data Systems Private Lim) 40 Microsoft Vendor

When we are trying to create read replica for MySQL flexible Server through AZ CLI/terraform, it's throwing internal server error. although if we are trying from the Azure portal then it's working fine.

Please find the below details of error:
performing Create: unexpected status 500 with error: InternalServerError: An unexpected error occured while processing the request. __Tracking ID: '5de43f1b-e0d7-4df9-966a-6afe057d2ff8'

It would be great if someone can provide a more logs from above mentioned Tracking ID__

Rahul Randive 8,826 Reputation points Microsoft Employee

2024-02-15T13:52:25.8566667+00:00

Hi Maulin Shah (Crest Data Systems Private Lim), Since you mentioned that you are able to create servers through the portal without any issues, it seems that there is no problem with the backend service. I observed that server creation was successful for your subscription on Feb 4th and 8th. However, if you are encountering difficulties creating a server through the script, there might be an issue with the Terraform script. Have you encountered this problem with the script before? It appears that you are attempting to create the server in the West US2 region. You could try using a different region, but I suspect that the issue lies within the script itself. Thank you!
Maulin Shah (Crest Data Systems Private Lim) 40 Reputation points Microsoft Vendor

2024-02-15T16:46:50.45+00:00

it's also failing with the AZ cli, ARM template, and bicep files. I also tried the same ARM template which I downloaded from Azure portal while creating read replica in paired region.

I am able to create the server through all options, also able to create read replica in same region through all options but when I am trying to create read replica in paired region using AZ cli, ARM template, terraform, and bicep files, it throw an error.
Rahul Randive 8,826 Reputation points Microsoft Employee

2024-02-15T17:38:52.97+00:00

Hi Maulin Shah (Crest Data Systems Private Lim) From the list please check the paired region is available for region you are creating a server 2nd can you please share the cli command which you are using to create server. (you can remove server and other details from the command) Thank you!

Maulin Shah (Crest Data Systems Private Lim) 40 Microsoft Vendor

Yes, paired region is available for region I am creating a server.

REST API

Body="{'location':'westus','properties':{'createMode':'Replica','sourceServerResourceId':'/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testgr/providers/Microsoft.DBforMySQL/flexibleServers/source-server'}}"

az rest --method PUT --uri "https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testgr/providers/Microsoft.DBforMySQL/flexibleServers/replica-server?api-version=2023-06-30" --headers "Content-Type=application/json" --body $Body

AZ CLI

az mysql flexible-server replica create --replica-name replica-server --source-server source-server --subscription ffffffff-ffff-ffff-ffff-ffffffffffff --location westus  --resource-group testgr

Bicep

resource sourceServerName 'Microsoft.DBforMySQL/flexibleServers@2022-09-30-preview' existing = {
    name: 'source-server'
}

resource replicaServer 'Microsoft.DBforMySQL/flexibleServers@2022-09-30-preview' = {
  name: 'replica-server'
  location: 'westus'
  properties: {
    createMode: 'Replica'
    sourceServerResourceId: 
  }
}

I have tried with all of the above way to provision read replica in paired region but it's throwing internal server error only.

Rahul Randive 8,826 Reputation points Microsoft Employee

2024-02-15T18:54:12.9133333+00:00

Hi Maulin Shah (Crest Data Systems Private Lim) •

Could you please try with below command mentioned in the [document]

(https://learn.microsoft.com/en-us/azure/mysql/single-server/how-to-read-replicas-cli) A read replica server can be created using the following command: az mysql server replica create --name mydemoreplicaserver --source-server mydemoserver --resource-group myresourcegroup

To create a cross region read replica, use the --location parameter. The CLI example below creates the replica in West US. az mysql server replica create --name mydemoreplicaserver --source-server mydemoserver --resource-group myresourcegroup --location westus

Thank you!
Maulin Shah (Crest Data Systems Private Lim) 40 Reputation points Microsoft Vendor

2024-02-16T03:24:57.7866667+00:00

I have tried with the same command but getting the internal server error only.

it would be great if I can get more details of error on the base of Tracking ID.
ShaktiSingh-MSFT 13,836 Reputation points Microsoft Employee

2024-02-19T03:53:46.1266667+00:00

Hi Maulin Shah (Crest Data Systems Private Lim) •

I would recommend you to please file a support ticket for deeper investigation and in case if you don't have a support plan, do let us know here so that we can check on other options to unblock you.

Thanks

1 answer

Rahul Randive 8,826 Reputation points Microsoft Employee

2024-02-15T19:14:27.1533333+00:00

Hi Maulin Shah (Crest Data Systems Private Lim) As per the document, How to create and manage read replicas in Azure Database for MySQL using the Azure CLI and REST API I have used below command to create replica in westus and it worked for me. az mysql server replica create --name mydemoreplicaserver --source-server mydemoserver --resource-group myresourcegroup --location westus
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Share via

Not able to create MySQL flexible Server Replica in paired region

1 answer