本文介绍如何使用Terraform临时关闭高可用RDS PostgreSQL实例的主备自动切换。
前提条件
已创建RDS PostgreSQL实例,详情请参见创建RDS PostgreSQL实例。
实例状态为运行中,您可以通过如下两种方式查看:
参见查询实例详情查看参数status,如果取值为Runing则表示实例状态为运行中。
前往RDS管理控制台,切换到目标地域,找到指定实例后,查看实例状态。
操作步骤
高可用实例默认开启主备自动切换,支持通过Terraform临时关闭主备自动切换,则参考如下配置:
在terraform.tf文件的
resource "alicloud_db_instance" "instance" {}
中增加ha_config
和manual_ha_time
配置项,具体配置如下:... resource "alicloud_db_instance" "instance" { ... ha_config = "Manual" manual_ha_time = "2022-09-30T09:00:00Z" }
说明控制台显示时间为北京时间,通过terraform设置时需要配置为UTC时间,UTC时间
09:00
对应北京时间为17:00
。运行
terraform apply
。出现如下配置信息后,确认配置信息并输入yes,开始修改RDS PostgreSQL实例配置。
alicloud_db_instance.instance: Refreshing state... [id=pgm-****] Terraform used the selected providers to generate the following execution plan. Resource actions are indicated with the following symbols: ~ update in-place Terraform will perform the following actions: # alicloud_db_instance.instance will be updated in-place ~ resource "alicloud_db_instance" "instance" { ~ ha_config = "Auto" -> "Manual" id = "pgm-****" + manual_ha_time = "2022-09-30T09:00:00Z" # (33 unchanged attributes hidden) # (1 unchanged block hidden) } Plan: 0 to add, 1 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_db_instance.instance: Modifying... [id=pgm-****] alicloud_db_instance.instance: Still modifying... [id=pgm-****, 10s elapsed] ... alicloud_db_instance.instance: Still modifying... [id=pgm-****, 3m0s elapsed] alicloud_db_instance.instance: Modifications complete after 3m4s [id=pgm-****] Apply complete! Resources: 0 added, 1 changed, 0 destroyed.
查看结果。
运行
terraform show
查看RDS PostgreSQL实例的主备自动切换状态。# alicloud_db_instance.instance: resource "alicloud_db_instance" "instance" { client_ca_enabled = 0 client_crl_enabled = 0 connection_string = "pgm-****.pg.rds.aliyuncs.com" connection_string_prefix = "pgm-****" db_instance_storage_type = "cloud_essd" db_time_zone = "Asia/Shanghai" deletion_protection = false engine = "PostgreSQL" engine_version = "13.0" force_restart = false ha_config = "Manual" id = "pgm-****" instance_charge_type = "Postpaid" instance_name = "terraformtest" instance_storage = 50 instance_type = "pg.n2.2c.2m" maintain_time = "05:00Z-06:00Z" manual_ha_time = "2022-09-30T09:00:00Z" monitoring_period = 300 period = 0 port = "5432" private_ip_address = "192.168.XX.XX" resource_group_id = "rg-****" security_group_ids = [] security_ip_mode = "normal" security_ips = [ "127.0.0.1", ] sql_collector_config_value = 30 sql_collector_status = "Disabled" storage_auto_scale = "Enable" storage_threshold = 30 storage_upper_bound = 100 target_minor_version = "rds_postgres_1300_20220830" tcp_connection_type = "SHORT" vpc_id = "vpc-****" vswitch_id = "vsw-****" zone_id = "cn-hangzhou-j" pg_hba_conf { address = "127.0.0.1" database = "all" method = "md5" priority_id = 1 type = "host" user = "all" } }
登录RDS控制台查看RDS PostgreSQL实例的主备自动切换状态。
文档内容是否对您有帮助?