Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Azure Database for MySQL flexible server supports two storage options, so you can match the storage layer to your workload's performance, scale, and cost requirements:
- Premium file share - The default storage option, available across all service tiers and regions.
- Premium SSD v2 (preview) - Managed-disk based storage that you can scale storage capacity, IOPS, and throughput independently.
The storage you provision is the capacity available to your server. It holds database files, temporary files, transaction logs, and MySQL server logs. Pricing is based on the compute tier, compute size, storage option, and storage size you choose.
Note
Premium SSD v2 for Azure Database for MySQL flexible server is currently in preview for supported compute SKUs and regions.
Premium file share
Premium file share is the default storage option for Azure Database for MySQL flexible server. The service uses the same storage technology across the Burstable, General Purpose, and Memory-Optimized service tiers.
Key characteristics:
- Storage size: 20 GiB to 16 TiB for Burstable and General Purpose tiers; up to 32 TiB for the Memory-Optimized tier.
- Scaling granularity: Storage scales in 1-GiB increments and you can increase it at any time after creating the server. Storage scaling is an online operation and doesn't require a restart.
- IOPS: Supports both pre-provisioned IOPS and autoscale IOPS. The minimum IOPS is 360 across all compute sizes, and the maximum IOPS is determined by the selected compute size.
- Storage autogrow: Enabled by default for all new servers.
- Feature support: Supports the full set of flexible server capabilities, including high availability, read replicas, and accelerated logs.
Premium file share is a good fit for most production workloads, including web and mobile apps, line-of-business applications, and workloads that benefit from autoscale IOPS.
Premium SSD v2 (preview)
Premium SSD v2 is built on Azure managed disks. It offers higher performance and, as a general rule, a better price-performance ratio than earlier storage options. Unlike Premium file share, where maximum IOPS is tied to the compute size, Premium SSD v2 lets you tune capacity, IOPS, and throughput independently, so you pay only for the performance you need.
The managed-disk based architecture also introduces support for the latest General Purpose and Memory-Optimized v6 SKU families, so you can run larger and more demanding workloads with better price-performance.
Typical scenarios:
- Transaction-intensive workloads that need a large amount of IOPS for short, high-demand periods (for example, month-end processing or sales events).
- Throughput-heavy workloads such as reporting, bulk loads, or gaming applications that need higher throughput during peak hours only.
- Large databases that need more storage capacity or higher performance ceilings than Premium file share provides.
- Cost-sensitive production workloads where you want to provision exactly the capacity and performance you need, rather than over-provisioning storage to get more IOPS.
Premium SSD v2 performance model
| Setting | Range | Notes |
|---|---|---|
| Disk size | 1 GiB-64 TiBs | Set in 1-GiB increments. |
| IOPS | 3,000-80,000 | Can be adjusted independently of disk size. Effective IOPS is also capped by the compute size. |
| Throughput (MB/s) | 125-2000 | Can be adjusted independently of disk size and IOPS. |
Note
Your compute size also has IOPS and throughput limits. Even though you can configure storage independently of the compute size, you might not be able to consume all provisioned IOPS or throughput on servers with a small number of vCores. For details, see Compute options.
Price
For the most up-to-date pricing information, see Azure Database for MySQL pricing. The Azure portal shows the estimated monthly cost on the Compute + storage page based on the options you select. If you don't have an Azure subscription, use the Azure pricing calculator.