使用Terraform恢复实例_云数据库 RDS(RDS)-阿里云帮助中心

本文介绍如何使用Terraform恢复实例。

前提条件

已创建RDS PostgreSQL实例，详情请参见创建RDS PostgreSQL实例。
实例状态为运行中，您可以通过如下两种方式查看：
- 参见查询实例详情查看参数status，如果取值为Runing则表示实例状态为运行中。
- 前往RDS管理控制台，切换到目标地域，找到指定实例后，查看实例状态。

按时间点恢复实例

在terraform.tf文件中增加resource "alicloud_rds_clone_db_instance" "example" {}配置项，具体配置如下：
```
...
resource "alicloud_rds_clone_db_instance" "example" {
  source_db_instance_id    = alicloud_db_instance.instance.id
  db_instance_storage_type = "cloud_essd"
  payment_type             = "PayAsYouGo"
  restore_time             = "2022-09-29T04:32:59Z"
  db_instance_storage      = "50"
}           
```
说明
restore_time参数配置的取值获取方法：
1. 在terraform.tf文件中增加data "alicloud_rds_backups" "querybackups" {}配置项查询备份。
2. 使用terraform apply执行查询。
3. 使用terraform show查询备份信息，获取查询结果中backup_end_time的参数取值。
具体操作，请参见查看备份。

运行terraform apply。

出现如下配置信息后，确认配置信息并输入yes，开始恢复实例。

alicloud_db_instance.instance: Refreshing state... [id=pgm-****]
data.alicloud_rds_backups.querybackups: Reading...
alicloud_rds_backup.instance: Refreshing state... [id=pgm-****]
alicloud_db_backup_policy.instance: Refreshing state... [id=pgm-****]
data.alicloud_rds_backups.querybackups: Read complete after 0s [id=128503****]

Terraform used the selected providers to generate the following execution plan. Resource actions are indicated with the following symbols:
  + create

Terraform will perform the following actions:

  # alicloud_rds_clone_db_instance.example will be created
  + resource "alicloud_rds_clone_db_instance" "example" {
      + acl                        = (known after apply)
      + auto_upgrade_minor_version = (known after apply)
      + ca_type                    = (known after apply)
      + category                   = (known after apply)
      + connection_string          = (known after apply)
      + db_instance_class          = (known after apply)
      + db_instance_storage        = 50
      + db_instance_storage_type   = "cloud_essd"
      + engine                     = (known after apply)
      + engine_version             = (known after apply)
      + ha_mode                    = (known after apply)
      + id                         = (known after apply)
      + instance_network_type      = (known after apply)
      + maintain_time              = (known after apply)
      + payment_type               = "PayAsYouGo"
      + port                       = (known after apply)
      + private_ip_address         = (known after apply)
      + replication_acl            = (known after apply)
      + restore_time               = "2022-09-29T04:32:59Z"
      + security_ips               = (known after apply)
      + server_cert                = (known after apply)
      + server_key                 = (known after apply)
      + source_db_instance_id      = "pgm-bp1668g9bm4bm9p5"
      + ssl_enabled                = (known after apply)
      + sync_mode                  = (known after apply)
      + tcp_connection_type        = (known after apply)
      + vpc_id                     = (known after apply)
      + vswitch_id                 = (known after apply)
      + zone_id                    = (known after apply)

      + parameters {
          + name  = (known after apply)
          + value = (known after apply)
        }
    }

Plan: 1 to add, 0 to change, 0 to destroy.

Do you want to perform these actions?
  Terraform will perform the actions described above.
  Only 'yes' will be accepted to approve.

  Enter a value:

出现类似如下日志时，表示恢复成功。

alicloud_rds_clone_db_instance.example: Creating...
alicloud_rds_clone_db_instance.example: Still creating... [10s elapsed]
...
alicloud_rds_clone_db_instance.example: Still creating... [24m11s elapsed]
alicloud_rds_clone_db_instance.example: Creation complete after 24m34s [id=pgm-****]

Apply complete! Resources: 1 added, 0 changed, 0 destroyed.

查看结果。

运行terraform show查看实例恢复情况。

...
# alicloud_rds_clone_db_instance.example:
resource "alicloud_rds_clone_db_instance" "example" {
    category                 = "HighAvailability"
    connection_string        = "pgm-****.pg.rds.aliyuncs.com"
    db_instance_class        = "pg.n2.2c.2m"
    db_instance_storage      = 50
    db_instance_storage_type = "cloud_essd"
    deletion_protection      = false
    engine                   = "PostgreSQL"
    engine_version           = "13.0"
    ha_mode                  = "RPO"
    id                       = "pgm-****"
    instance_network_type    = "VPC"
    maintain_time            = "18:00Z-22:00Z"
    payment_type             = "PayAsYouGo"
    port                     = "5432"
    private_ip_address       = "192.168.XX.XX"
    restore_time             = "2022-09-29T04:32:59Z"
    security_ips             = [
        "0.0.0.0/0",
    ]
    source_db_instance_id    = "pgm-****"
    sync_mode                = "Async"
    tcp_connection_type      = "LONG"
    vswitch_id               = "vsw-****"
    zone_id                  = "cn-hangzhou-h"
}

登录RDS控制台查看实例恢复情况。

按备份集恢复实例

在terraform.tf文件中增加resource "alicloud_rds_clone_db_instance" "example" {}配置项，具体配置如下：
```
...
resource "alicloud_rds_clone_db_instance" "example" {
  source_db_instance_id    = alicloud_db_instance.instance.id
  db_instance_storage_type = "cloud_essd"
  payment_type             = "PayAsYouGo"
  backup_id                = "1499356764"
  db_instance_storage      = "50"
}           
```
说明
backup_id参数配置的取值获取方法：
- 在terraform.tf文件中增加data "alicloud_rds_backups" "querybackups" {}配置项查询备份。
- 使用terraform apply执行查询。
- 使用terraform show查询备份信息，获取查询结果中backup_id的参数取值。
具体操作，请参见查看备份。

运行terraform apply。

出现如下配置信息后，确认配置信息并输入yes，开始恢复实例。

alicloud_db_instance.instance: Refreshing state... [id=pgm-****]
data.alicloud_rds_backups.querybackups: Reading...
alicloud_db_readonly_instance.default: Refreshing state... [id=pgr-****]
alicloud_db_backup_policy.instance: Refreshing state... [id=pgm-****]
data.alicloud_rds_backups.querybackups: Read complete after 0s [id=5945****]

Terraform used the selected providers to generate the following execution plan. Resource actions are indicated with the
following symbols:
  + create

Terraform will perform the following actions:

  # alicloud_rds_clone_db_instance.example will be created
  + resource "alicloud_rds_clone_db_instance" "example" {
      + acl                        = (known after apply)
      + auto_upgrade_minor_version = (known after apply)
      + backup_id                  = "1499356764"
      + ca_type                    = (known after apply)
      + category                   = (known after apply)
      + connection_string          = (known after apply)
      + db_instance_class          = (known after apply)
      + db_instance_storage        = 50
      + db_instance_storage_type   = "cloud_essd"
      + engine                     = (known after apply)
      + engine_version             = (known after apply)
      + ha_mode                    = (known after apply)
      + id                         = (known after apply)
      + instance_network_type      = (known after apply)
      + maintain_time              = (known after apply)
      + payment_type               = "PayAsYouGo"
      + port                       = (known after apply)
      + private_ip_address         = (known after apply)
      + replication_acl            = (known after apply)
      + security_ips               = (known after apply)
      + server_cert                = (known after apply)
      + server_key                 = (known after apply)
      + source_db_instance_id      = "pgm-****"
      + ssl_enabled                = (known after apply)
      + sync_mode                  = (known after apply)
      + tcp_connection_type        = (known after apply)
      + vpc_id                     = (known after apply)
      + vswitch_id                 = (known after apply)
      + zone_id                    = (known after apply)

      + parameters {
          + name  = (known after apply)
          + value = (known after apply)
        }
    }

Plan: 1 to add, 0 to change, 0 to destroy.

Do you want to perform these actions?
  Terraform will perform the actions described above.
  Only 'yes' will be accepted to approve.

  Enter a value:

出现类似如下日志时，表示恢复成功。

alicloud_rds_clone_db_instance.example: Creating...
alicloud_rds_clone_db_instance.example: Still creating... [10s elapsed]
...
alicloud_rds_clone_db_instance.example: Still creating... [19m31s elapsed]
alicloud_rds_clone_db_instance.example: Creation complete after 19m39s [id=pgm-bp1sox718o31j940]

Apply complete! Resources: 1 added, 0 changed, 0 destroyed.

查看结果。

运行terraform show查看实例恢复情况。

...
# alicloud_rds_clone_db_instance.example:
resource "alicloud_rds_clone_db_instance" "example" {
    backup_id                = "1499356764"
    category                 = "HighAvailability"
    connection_string        = "pgm-****.pg.rds.aliyuncs.com"
    db_instance_class        = "pg.n2.2c.2m"
    db_instance_storage      = 50
    db_instance_storage_type = "cloud_essd"
    deletion_protection      = false
    engine                   = "PostgreSQL"
    engine_version           = "13.0"
    ha_mode                  = "RPO"
    id                       = "pgm-****"
    instance_network_type    = "VPC"
    maintain_time            = "18:00Z-22:00Z"
    payment_type             = "PayAsYouGo"
    port                     = "5432"
    private_ip_address       = "192.168.XX.XX"
    security_ips             = [
        "0.0.0.0/0",
    ]
    source_db_instance_id    = "pgm-****"
    sync_mode                = "Async"
    tcp_connection_type      = "LONG"
    vswitch_id               = "vsw-****"
    zone_id                  = "cn-hangzhou-h"
}

登录RDS控制台查看实例恢复情况。