Azure MySQL single server got auto migrated to flexible server

Rakesh Dakornarayan Chandra 15

I have an Azure MySQL single server which got auto migrated to flexible server and currently in stopped state because of which I can't change any settings or can't access it from any client application, when opening in azure portal its showing message "Migration and cutover to Azure Database for MySQL Flexible Server 'mysql-server-name' completed successfully. While the migrated Flexible Server is online and connected to your clients/applications, you will be able to access the server via Azure Portal or CLI only after 12 hours (ARM cache refresh rate) post the migration. Your Single Server instance has been put to stopped state and will be deleted after the number of days set as Backup Retention Period for your Single Server instance.}"

When I checked in MySQL flexible server in portal to see if its available there or not, it was not there also.

Please help me on this.

Rakesh Dakornarayan Chandra 15 Reputation points

2023-09-05T08:51:10.7766667+00:00

Hi @ShaktiSingh-MSFT , thanks for quick response, could you please refer below screenshots and help me to access this server,

my server is still listed under MySQL single server option, but as per message showing up in portal its saying migration is completed and single server instance will be deleted after BackupRetentionPeriod, but I want to use new flexible server now and want to connect using client application but the problem is its not available now.
VMPGroup Company 0 Reputation points

2023-09-05T18:58:40.4266667+00:00

I have this exact same issue. The commands stated above result in no results being found. When filling out a support ticket, I'm prompted to pay for a support subscription
ShaktiSingh-MSFT 15,766 Reputation points

2023-09-06T04:26:23.7066667+00:00

Hi Rakesh Dakornarayan Chandra •, VMPGroup Company •,

To look into this issue quickly, could you please send an email to AzCommunity@Microsoft.com with your Subscription ID and thread link to this post, and I will enable a one-time free support request for your subscription.

Please reference this forum thread in the email subject:

ATTN: SHAKTI - Azure MySQL single server got auto migrated to flexible server.

Regards,

@ShaktiSingh-MSFT
ShaktiSingh-MSFT 15,766 Reputation points

2023-09-07T03:34:01.2766667+00:00

Hi Rakesh Dakornarayan Chandra •,

Just checking if you got a chance to look at the previous comment or the issue is solved.

Thanks
Reeve 0 Reputation points

2024-07-16T07:06:06.29+00:00

Hi ShaktiSingh-MSFT,

i have faced the issue as above , pls help me to resolve it.
ShaktiSingh-MSFT 15,766 Reputation points

2024-10-15T05:09:12.77+00:00

Hi Reeve, John Bevan •

If your server has private endpoint, and you need to authenticate and save migration schedule to initiate migration, if migration was not authenticated, it will keep rescheduling.

Please go to single server --> migration blade --> edit migration --> click authenticate --> follow screens --> then click “I confirm ..” -->save.

If this does not help, we recommend you to raise support case for deeper investigation.

Thanks

1 answer

ShaktiSingh-MSFT 15,766 Reputation points

2023-09-05T08:09:24.0666667+00:00
Hi
Rakesh Dakornarayan Chandra •,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand, you are not able to find Azure MySQL Flexible Server in Azure Portal after migration.

We are sorry about the inconvenience you are facing.

Please try to execute Azure CLI command to check status of the server like below:

az mysql flexible-server db list --resource-group az mysql flexible-server db show [--database-name] [--ids] [--resource-group] [--server-name] [--subscription]

Let us know if the server details show up. If not, please raise support case for immediate attention and investigation.

Thanks
Please sign in to rate this answer.

1 person found this answer helpful.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

John Bevan 6 Reputation points

2024-10-11T13:21:15.19+00:00

We just faced the same issue - looking at the migrations tab we can see the window was midnight to 6am this morning. The error says that the DB may not be visible in CLI or portal until 12 hours after the migration - so maybe it'll show up at 6pm tonight... but in the meantime the systems which connect to it are failing / the new resource isn't visible anywhere.

We weren't notified about this change ahead of time - not sure if there's some announcement channel we need to subscribe to? Our admin accounts don't have emails associated (our security team don't like elevated access accounts being associated with email) and we use PIM for access (so we're only admins for small windows when we need the access, not all the time), so if those are used for comms, that may help explain why we didn't see anything... Is there another option for us to subscribe our support mailbox to so we get informed in future - or were comms just not sent for this?

I've found documentation here: https://learn.microsoft.com/en-us/azure/mysql/migrate/whats-happening-to-mysql-single-server / https://learn.microsoft.com/en-us/azure/mysql/migrate/migrate-single-flexible-in-place-auto-migration - hope that's useful to help give others some context on what just happened to them if they find themselves in a similar situation.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure MySQL single server got auto migrated to flexible server

1 answer

Your answer