Azure DB for MySQL – Storage v1 vs v2

When it comes to MySQL and storage you will normally have to decide on 3 options: basic, general purpose v1 or v2.

Basic does support up to 1TB and is low-cost option but has no IOPs guarantee, not really recommended for production systems. General purpose v2 should be the one used because it uses latest storage infrastructure which can support up to 16-TB and 20000 IOPs a shown below.

Some key points on v2:

How can you check what you have? If you go to the pricing / scaling storage section of MySQL within Azure Portal you need to see what your maximum scale is. Below shows 4TB meaning my storage is version 1.

This is because I created my database in a region where v2 is not available at the time of writing (Norway East)

So always check the location of where you want to build your database server to get the best storage options and performance.

1 thought on “Azure DB for MySQL – Storage v1 vs v2

  1. Pingback: Dew Drop – February 8, 2022 (#3616) – Morning Dew by Alvin Ashcraft

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s