| title | description | author | ms.author | ms.service | ms.topic | ms.date | ms.custom |
|---|---|---|---|---|---|---|---|
Auto grow storage - Azure CLI - Azure Database for MariaDB |
This article describes how you can enable auto grow storage using the Azure CLI in Azure Database for MariaDB. |
savjani |
pariks |
mariadb |
how-to |
3/18/2020 |
devx-track-azurecli |
This article describes how you can configure an Azure Database for MariaDB server storage to grow without impacting the workload.
The server reaching the storage limit, is set to read-only. If storage auto grow is enabled then for servers with less than 100 GB provisioned storage, the provisioned storage size is increased by 5 GB as soon as the free storage is below the greater of 1 GB or 10% of the provisioned storage. For servers with more than 100 GB of provisioned storage, the provisioned storage size is increased by 5% when the free storage space is below 10GB of the provisioned storage size. Maximum storage limits as specified here apply.
To complete this guide:
- You need an Azure Database for MariaDB server.
[!INCLUDE azure-cli-prepare-your-environment-no-header.md]
- This article requires version 2.0 or later of the Azure CLI. If using Azure Cloud Shell, the latest version is already installed.
Enable server auto-grow storage on an existing server with the following command:
az mariadb server update --name mydemoserver --resource-group myresourcegroup --auto-grow Enabled
Enable server auto-grow storage while creating a new server with the following command:
az mariadb server create --resource-group myresourcegroup --name mydemoserver --auto-grow Enabled --location westus --admin-user myadmin --admin-password <server_admin_password> --sku-name GP_Gen5_2 --version 10.3
Learn about how to create alerts on metrics.