Set automated backup retention for an instance

This sample specifies the number of automated backups to retain for an instance.

Explore further

For detailed documentation that includes this code sample, see the following:

• Create and manage on-demand and automatic backups

Code sample

Terraform

To learn how to apply or remove a Terraform configuration, see Basic Terraform commands. For more information, see the Terraform provider reference documentation.

resource "google_sql_database_instance" "default" {
  name             = "mysql-instance-backup-retention"
  region           = "asia-northeast1"
  database_version = "MYSQL_8_0"
  settings {
    tier = "db-f1-micro"
    backup_configuration {
      enabled = true
      backup_retention_settings {
        retained_backups = 365
        retention_unit   = "COUNT"
      }
    }
  }
}

What's next

To search and filter code samples for other Google Cloud products, see the Google Cloud sample browser.