首页 > 解决方案 > AWS Cloudformation RDS EnablePerformanceInsights 不起作用

问题描述

我想通过 Clouformation 创建 RDS 实例。下面是 cloudformation 文件的摘录。

  MasterDB:
    Type: AWS::RDS::DBInstance
    Properties:
      DBName: !Ref DBName
      DBInstanceIdentifier: !Ref DBName
      BackupRetentionPeriod: !Ref DBBackupRetentionPeriod
      AllocatedStorage: !Ref DBAllocatedStorage
      DBInstanceClass: "db.t3.medium"
      DBSubnetGroupName: !Ref DBSubnetGroup
      Engine: MySQL
      AvailabilityZone: !Ref DBAvailabilityZone
      EngineVersion: "5.7.30"
      MasterUsername: !Sub "{{resolve:ssm:/DB/USER:1}}"
      MasterUserPassword: !Sub "{{resolve:ssm-secure:/DB/PASSWORD:1}}"
      MultiAZ: !Ref MultiAZ
      EnablePerformanceInsights: 'true'
      DeletionProtection: 'true'
      DBParameterGroupName: !Ref RDSDBParameterGroup

RDS 的创建没有问题,但我注意到新实例上未启用 Performance Insights 和删除保护。

您能否告知为什么这些选项不起作用?

标签: amazon-cloudformationamazon-rds

解决方案


我在我的沙盒帐户中验证了您的模板,并按预期启用us-east-1了见解和删除保护。

我使用的模板如下(大部分只是注释掉了您的问题中未显示的引用):

Resources:
  MasterDB:
    Type: AWS::RDS::DBInstance
    Properties:
      #DBName: !Ref DBName
      #DBInstanceIdentifier: !Ref DBName
      BackupRetentionPeriod: 0
      AllocatedStorage: 20
      DBInstanceClass: "db.t3.medium"
      #DBSubnetGroupName: !Ref DBSubnetGroup
      Engine: MySQL
      #AvailabilityZone: !Ref DBAvailabilityZone
      EngineVersion: "5.7.30"
      MasterUsername: root
      MasterUserPassword: fsdf45454
      MultiAZ: false
      EnablePerformanceInsights: 'true'
      DeletionProtection: 'true'

在此处输入图像描述


推荐阅读