Hi, The maximum storage size of Azure database for MySQL is 16TB( https://learn.microsoft.com/en-us/azure/mysql/single-server/select-right-deployment-type#comparing-the-mysql-deployment-options-in-azure ), and it is already 14TB of ours. What options do we have? We are currently using a Single server.

Hi, @Testa Thanks for the question and using the MS Q&A platform If I understand correctly your max storage size has reached 14TB and you want to what are the options to reduce it. The first check is if the data available is really required and claim back for a free space Try to understand how this 14TB is distributed that can give more ideas and help to clear Turning on Auto grow is a good choice however this will also fail if it goes beyond the max space available. Please let me know if you are looking for any additional information. Regards Geetha

Azure database for mysql storage limit

Accepted answer

GeethaThatipatri-MSFT 27,717 Reputation points Microsoft Employee

2022-11-02T19:45:16.667+00:00

Hi, @Testa Thanks for the question and using the MS Q&A platform
If I understand correctly your max storage size has reached 14TB and you want to what are the options to reduce it.
The first check is if the data available is really required and claim back for a free space
Try to understand how this 14TB is distributed that can give more ideas and help to clear
Turning on Auto grow is a good choice however this will also fail if it goes beyond the max space available.

Please let me know if you are looking for any additional information.

Regards
Geetha
Please sign in to rate this answer.
Testa 551 Reputation points

2022-11-03T07:20:09.13+00:00

Hi @GeethaThatipatri-MSFT ,

Thank you for your reply.

Azure database for MySQL Single Server will be retired, and the document suggest migrating to a Flexible server.

Whether it is Single or Flexible, the maximum storage size 16TB according to the doc I shared the above. The storage is already reached to 14TB.

Even if managed to reduce a bit now, it is a matter of time to reach to the maximum storage

What options do we have? Should we consider using different services? Or we need to migrate to Flexible server. Then, we should split the database to multiples using, say, HASH Partitioning? Is there any recommendation?

GeethaThatipatri-MSFT 27,717 Reputation points Microsoft Employee

2022-11-03T18:47:19.013+00:00

@Testa We would recommend migrating to Flexible Server Business Critical SKU where we plan to support up to 100TB (currently in private preview). To assist with the migration of your14TB server, I can help to create support and our engineers will work with you closely if you want to go with a single server to flex.

Announcing Azure Database for MySQL - Flexible Server for business-critical workloads - Microsoft Community Hub

Regards
Geetha

GeethaThatipatri-MSFT 27,717 Reputation points Microsoft Employee

2022-11-04T14:34:31.257+00:00

Thank you for visiting the Microsoft QA forums! Have a great day!

Regards
Geetha
Sign in to comment

Azure database for mysql storage limit

0 additional answers