Azure Database for MySQL - Single Server

Question

Azure Database for MySQL - Single Server

Brijesh Muliya 46

Soon support for Azure Database for MySQL - Single Server will end.

Is it ok if I move Azure Database for MySQL - Single Server to SQL Elastic Pool?
If I move Azure Database for MySQL - Single Server to SQL Elastic Pool the application working with the current database will be disconnected?
Any other solution to upgrade Azure Database for MySQL - Single Server without affecting current workload or making any changes in infrastructure?

Answer accepted by question author

0 additional answers

Your answer

Answer 1

GeethaThatipatri-MSFT 29,597 Microsoft Employee Moderator

Hi, @Brijesh Muliya Welcome to the Microsoft Q&A platform, thanks for posting the question and for using Azure Services.
As I understand you want to migrate to SQL Elastic pool from Azure Database for MySQL - Single Server as the support for MySQL is ending soon.
I would understand why you want to move to the Azure Elastic pool?
Single Server users are recommended to move to Flexible Server. When you migrate to Flexible Server, your RI reservations can be exchanged with Flexible Server so you see continued discounted prices as you move from Single to Flexible Server. Please read this document for more information

For Migrating to the flexible server, there are both offline and online migration scenarios to help you select the right tools
https://learn.microsoft.com/en-us/azure/mysql/migrate/how-to-decide-on-right-migration-tools

Regards
Geetha

Brijesh Muliya 46 Reputation points

2023-01-03T17:18:37.557+00:00

Hi @GeethaThatipatri-MSFT ,. Thanks for your reply.

My concern is that with this sql db single server if i migrate to flexible it would effect connection strings and maybe required lots of infrastructure changes so that is why I thought of elastic pool.

I read the document but even in FAQ i didn't see confirmation regarding my query so that it why i posted the question here.
GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator

2023-01-04T00:42:09.717+00:00

@Brijesh Muliya Can you please share what is the workload type and size number of servers, SKU, storage size, and any special features enabled – CMK/AAD/Private Link etc)?

Regards
Geetha
Brijesh Muliya 46 Reputation points

2023-01-04T11:46:20.94+00:00

Hi @GeethaThatipatri-MSFT ,

Azure Database for MySQL Single Server General Purpose - Compute Gen5
Azure Database for MySQL Single Server General Purpose - Compute Gen5

Azure Database for MySQL Single Server General Purpose - Storage
Azure Database for MySQL Single Server General Purpose - Storage

can not share extra details bcs of policy but the workload has 3 environment like dev testing and prod so its critical.
GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator

2023-01-04T14:40:12.643+00:00

@Brijesh Muliya Did you get a chance to check the private message?
Brijesh Muliya 46 Reputation points

2023-01-04T14:42:37.137+00:00

Sorry didn't get you There, where to check ?
GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator

2023-01-04T14:47:40.69+00:00

@Brijesh Muliya you should be getting the notification

Share via

Azure Database for MySQL - Single Server

0 additional answers

Your answer