文档

参数管理

更新时间:

本文介绍如何使用Terraform修改参数以及查询参数修改日志。

前提条件

  • 已创建RDS PostgreSQL实例,详情请参见创建RDS PostgreSQL实例

  • 实例状态为运行中,您可以通过如下两种方式查看:

    • 参见查询实例详情查看参数status,如果取值为Runing则表示实例状态为运行中。

    • 前往RDS管理控制台,切换到目标地域,找到指定实例后,查看实例状态。

修改参数

说明

部分参数修改后会立即重启实例,详情请参见控制台上可修改参数页面中的是否重启列。重启实例会造成连接中断,重启前请做好业务安排,谨慎操作。

本文以修改参数authentication_timeout的取值为120为例。

  1. 在terraform.tf文件的resource "alicloud_db_instance" "instance" {}中增加parameters配置项,具体配置如下:

    ...
    
    resource "alicloud_db_instance" "instance" {
    ...
    parameters {
        name  = "authentication_timeout"
        value = "120"  
       }       
    }     
  2. 运行terraform apply

    出现如下配置信息后,确认配置信息并输入yes,开始修改参数配置。

    alicloud_db_instance.instance: Refreshing state... [id=pgm-****]
    alicloud_db_backup_policy.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" {
            id                         = "pgm-****"
            # (43 unchanged attributes hidden)
    
          + parameters {
              + name  = "authentication_timeout"
              + value = "120"
            }
    
            # (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-****, 3m10s elapsed]
    alicloud_db_instance.instance: Modifications complete after 3m10s [id=pgm-****]
    
    Apply complete! Resources: 0 added, 1 changed, 0 destroyed.
  3. 查看结果。

    • 运行terraform show查看参数修改情况。

      # alicloud_db_instance.instance:
      resource "alicloud_db_instance" "instance" {
          acl                        = "prefer"
          ca_type                    = "aliyun"
          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"
          replication_acl            = "prefer"
          resource_group_id          = "rg-****"
          security_group_id          = "sg-****"
          security_group_ids         = [
              "sg-bp1h9iqx6mxan5tcouwc",
          ]
          security_ip_mode           = "normal"
          security_ips               = [
              "0.0.0.0/0",
          ]
          server_cert                = <<-EOT
              -----BEGIN CERTIFICATE-----
              MIIE7jCCA****xuq/yfM4ALgBJ2
              N9xwKlPQ65q/kux0yErtwhAD
              -----END CERTIFICATE-----
          EOT
          server_key                 = <<-EOT
              -----BEGIN RSA PRIVATE KEY-----
              MIIJKQIB****4Y1K34yE+e+VAdGp
              -----END RSA PRIVATE KEY-----
          EOT
          sql_collector_config_value = 30
          sql_collector_status       = "Disabled"
          ssl_action                 = "Open"
          ssl_status                 = "0"
          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"
      
          parameters {
              name  = "authentication_timeout"
              value = "120"
          }
      
          pg_hba_conf {
              address     = "127.0.0.1"
              database    = "all"
              method      = "md5"
              priority_id = 1
              type        = "host"
              user        = "all"
          }
      }
    • 登录RDS控制台查看参数修改情况。修改参数

查询参数修改日志

  1. 在terraform.tf文件中增加data "alicloud_rds_modify_parameter_logs" "querylogs"配置项,具体配置如下:

    ...
    data "alicloud_rds_modify_parameter_logs" "querylogs" {
      db_instance_id    = alicloud_db_instance.instance.id
      start_time = "2022-09-29T00:00Z"
      end_time = "2022-09-29T23:59Z"
    }         
  2. 运行terraform apply查询实例参数修改日志。

    出现类似如下日志时,表示查询成功。

    alicloud_db_instance.instance: Refreshing state... [id=pgm-****]
    data.alicloud_rds_modify_parameter_logs.querylogs: Reading...
    alicloud_db_backup_policy.instance: Refreshing state... [id=pgm-****]
    data.alicloud_rds_modify_parameter_logs.querylogs: Read complete after 0s [id=6335****]
    
    No changes. Your infrastructure matches the configuration.
    
    Terraform has compared your real infrastructure against your configuration and found no differences, so no changes are needed.
    
    Apply complete! Resources: 0 added, 0 changed, 0 destroyed.
  3. 运行terraform show查看参数修改日志。

    # data.alicloud_rds_modify_parameter_logs.querylogs:
    data "alicloud_rds_modify_parameter_logs" "querylogs" {
        db_instance_id = "pgm-****"
        end_time       = "2022-09-29T23:59Z"
        id             = "63353bb6"
        logs           = [
            {
                modify_time         = "1664423171000"
                new_parameter_value = "all"
                old_parameter_value = "ddl"
                parameter_name      = "log_statement"
                status              = "Applied"
            },
            {
                modify_time         = "1664424162000"
                new_parameter_value = "ddl"
                old_parameter_value = "all"
                parameter_name      = "log_statement"
                status              = "Applied"
            },
            {
                modify_time         = "1664432729000"
                new_parameter_value = "120"
                old_parameter_value = "60"
                parameter_name      = "authentication_timeout"
                status              = "Applied"
            },
        ]
        start_time     = "2022-09-29T00:00Z"
    }
  • 本页导读 (1)