Create Azure App Service Plan, MySQL DB and a Web App With Terraform

This Terraform post will show you how to create an Azure Linux App Service Plan, MySQL Database and an App Service Web App with Terraform.

The below configuration will also be using the Terraform random password module to generate a password for the MySQL user. Note: The password will appear in the Terraform state file (.tfstate).

The App Service Plan is configured with an S1 standard Linux plan. The MySQL database is set to version 8, configured with 1 X Gen 5 vCPU and 10GB storage.

The Web App Web Service is configured as a vanilla Linux Web App which means you can load any application to it using Git or FTP.

Configuration

To run the code, save the file and run terraform plan and apply. or you can clone our Terraform repository and run it.

terraform {
  required_providers {
    azurerm = {
      source = "hashicorp/azurerm"
      version = "2.61.0"
    }
  }
}

provider "random" {
  # Configuration options
}



provider "azurerm" {

  features{}
}

resource "azurerm_resource_group" "rg" {
  name     = "deploycontainers"
  location = "westus"
}

resource "azurerm_app_service_plan" "appserviceplan" {
  name                = "deploycontainers"
  location            = azurerm_resource_group.rg.location
  resource_group_name = azurerm_resource_group.rg.name
  kind                = "Linux"
  reserved            = true

  sku {
    tier = "Standard"
    size = "S1"
  }
}

resource "random_password" "password" {
  length = 16
  special = true
  override_special = "_%@"
}

resource "azurerm_mysql_server" "mysql" {
  name                = "ntwmysql"
  location            = azurerm_resource_group.rg.location
  resource_group_name = azurerm_resource_group.rg.name

  administrator_login          = "mysqladmin"
  administrator_login_password = random_password.password.result

  sku_name   = "B_Gen5_1"
  storage_mb = 10240
  version    = "8.0"
  ssl_enforcement_enabled = true

  
}

resource "azurerm_app_service" "webapp" {
  name                = "deploycontainerswordpress"
  location            = azurerm_resource_group.rg.location
  resource_group_name = azurerm_resource_group.rg.name
  app_service_plan_id = azurerm_app_service_plan.appserviceplan.id 

  } 

output "password" {
  description = "The MySQL DB password is:" 
  value = random_password.password.result
  sensitive = true
}

If you like this post, make sure you visit our main category page for Terraform.

Processing…
Success! You're on the list.

Posted

in

by