terraform.azure.best-practice.azure-mysql-geo-backup-enabled.azure-mysql-geo-backup-enabled

profile photo of semgrepsemgrep
Author
unknown
Download Count*
LGPL Commons Clause
License

Ensure that MySQL server enables geo-redundant backups

Run Locally

Run in CI

Semgrep CI docs

Defintion

Edit RuleView Source
Open in Playground 
rules:
  - id: azure-mysql-geo-backup-enabled
    message: Ensure that MySQL server enables geo-redundant backups
    patterns:
      - pattern: resource
      - pattern-inside: |
          resource "azurerm_mysql_server" "..." {
          ...
          }
      - pattern-not-inside: |
          resource "azurerm_mysql_server" "..." {
          ...
          geo_redundant_backup_enabled = true
          ...
          }
    metadata:
      category: best-practice
      technology:
        - terraform
        - azure
      license: Commons Clause License Condition v1.0[LGPL-2.1-only]
    languages:
      - hcl
    severity: WARNING

Examples

azure-mysql-geo-backup-enabled.tf

# fail
# ruleid: azure-mysql-geo-backup-enabled
resource "azurerm_mysql_server" "example" {
  name                = var.mysqlserver_name
  location            = var.resource_group.location
  resource_group_name = var.resource_group.name

  administrator_login          = var.admin_name
  administrator_login_password = var.password
  sku_name = var.sku_name
  storage_mb = var.storage_mb
  version    = var.server_version

  auto_grow_enabled            = true
  backup_retention_days        = 7
  geo_redundant_backup_enabled = false
  infrastructure_encryption_enabled = false
    public_network_access_enabled = true
}

# fail
# ruleid: azure-mysql-geo-backup-enabled
resource "azurerm_mysql_server" "example" {
  name                = var.mysqlserver_name
  location            = var.resource_group.location
  resource_group_name = var.resource_group.name

  administrator_login          = var.admin_name
  administrator_login_password = var.password
  sku_name = var.sku_name
  storage_mb = var.storage_mb
  version    = var.server_version

  auto_grow_enabled            = true
  backup_retention_days        = 7
  infrastructure_encryption_enabled = false
}

# pass
resource "azurerm_mysql_server" "example" {
  name                = var.mysqlserver_name
  location            = var.resource_group.location
  resource_group_name = var.resource_group.name

  administrator_login          = var.admin_name
  administrator_login_password = var.password
  sku_name = var.sku_name
  storage_mb = var.storage_mb
  version    = var.server_version

  auto_grow_enabled            = true
  backup_retention_days        = 7
  geo_redundant_backup_enabled = true
  infrastructure_encryption_enabled = false
  public_network_access_enabled = false
}