Skip to content

README.md

Latest commit

 

History

History
94 lines (63 loc) · 4.79 KB

README.md

File metadata and controls

94 lines (63 loc) · 4.79 KB

Azure MySQL Autoscale IOPS - Overview

IOPS (Input/Output Operations Per Second)

Costa Rica

GitHub Cloud2BR OSS - Learning Hub

Last updated: 2025-07-16

List of References (Click to expand)
Table of Content (Click to expand)

When Autoscale IOPS is enabled for Azure Database for MySQL (Flexible Server), the IOPS (Input/Output Operations Per Second) automatically scale both up and down based on your workload demands.

  • During high demand, the system increases IOPS to maintain performance.
  • During low demand, it scales down to reduce resource usage and cost.

How to provision

  1. Go to the Azure Portal

  2. Search for Azure Database for MySQL Flexible Server in the search bar.

  3. Click Create.

  4. Choose your subscription, resource group, and server name.

  5. Select the region, MySQL version, and workload type (e.g., Development, Production).

    E.g.How.to.provision.MySQL.Flexible.Server.mp4

How to enable IOPS (manual approach)

  1. Go to the Azure Portal

  2. Select the server you want to configure.

  3. In the left-hand menu, go to Settings > Compute + Storage.

  4. In the IOPS section, select the option Autoscale IOPS

  5. Click Save to apply the changes.

    How.to.configure.Autoscale.IOPS.mp4

How to enable IOPS (script)

Automate the activation of Autoscale IOPS using Python and the Azure REST API, ideal for managing multiple servers across resource groups or entire subscriptions. This feature is only supported on General Purpose and Business Critical tiers, and currently not available via Azure CLI or PowerShell.

How to Monitor IOPS Scaling

How I know if the IOPS have scaled up or down when the server's using the autoscale IOPS feature? You can use the metrics available in Azure Monitor.

  1. Use Azure Monitor Metrics:

    • Go to your server in the Azure portal

    • Go to the Monitoring section and select Metrics.

      image

    • Choose the Storage IO metric (both percent and count).

      image

    • Set a custom time range to observe trends over time.

      Storage IO Count Storage IO Percent
      image image

  2. Look for Scaling Patterns:

    • If you see sudden increases or decreases in the IOPS metric that correlate with workload changes, this indicates that autoscale IOPS has adjusted the performance level.
    • You can also monitor IO utilization percentage to see how close your server is to its current IOPS limit.

  3. Enable Alerts (Optional): You can set up alerts in Azure Monitor to notify you when IOPS usage crosses certain thresholds, which can help you track scaling events in real time.

    How.to.configure.Autoscale.IOPS.mp4
Total views

Refresh Date: 2025-07-16