rds-quickly-use-rds-sql-server-serverless-instance.yml

ROSTemplateFormatVersion: '2015-09-01'
Description:
  zh-cn: 创建RDS SQL Server Serverless实例，配置超级用户账号，设置安全IP访问，并提供公网访问端点及端口。
  en: Create an RDS SQL Server Serverless instance, configure a superuser account,
    set up secure IP access, and provide a public endpoint and port for external connectivity.
Parameters:
  DBInstanceId:
    Type: String
    Label:
      en: RDS SQL Server Serverless InstanceId
      zh-cn: RDS SQL Server Serverless实例Id
    Description:
      en: The id of RDS SQL Server Serverless instance, make sure the instance has entered
        the running state
      zh-cn: RDS SQL Server Serverless实例Id，请确保实例已经进入运行中的状态。
    AssociationProperty: ALIYUN::RDS::Instance::InstanceId
  AccountName:
    Type: String
    Label:
      en: Database Account
      zh-cn: 数据库账号
    Description:
      en: The account name must be 2 to 32 characters in length and can contain lowercase
        letters, digits, and underscores (_). It must start with a letter and end
        with a letter or digit.
      zh-cn: 由小写字母、数字、下划线（_）组成，以字母开头，以字母或数字结尾，最多32个字符。
    Default: testuser
  Password:
    Type: String
    Label:
      en: Database account password
      zh-cn: 数据库账号密码
    Description:
      en: 'The password must be 8 to 32 characters in length and must contain at least
        three of the following types: uppercase letters, lowercase letter, digits,
        and special characters. Special characters include <span style="background:#E7E9EB;"><b>!@#$%^&*()_+-=</b></span>'
      zh-cn: 必须包含三种及以上类型：大写字母、小写字母、数字、特殊符号。长度为8～32位。特殊字符包括<span style="background:#E7E9EB;"><b>!@#$%^&*()_+-=</b></span>
    AssociationProperty: ALIYUN::RDS::Instance::AccountPassword
    NoEcho: true
Resources:
  Account:
    Type: ALIYUN::RDS::Account
    Properties:
      AccountName:
        Ref: AccountName
      AccountType: Super
      AccountDescription: tutorial account
      AccountPassword:
        Ref: Password
      DBInstanceId:
        Ref: DBInstanceId
  SecurityIps:
    Type: ALIYUN::RDS::DBInstanceSecurityIps
    Properties:
      DBInstanceId:
        Ref: DBInstanceId
      DBInstanceIPArrayAttribute: 0.0.0.0/0
      DBInstanceIPArrayName: mywhitelist
    DependsOn: Account
  Connection:
    Type: ALIYUN::RDS::Connection
    Properties:
      DBInstanceId:
        Ref: DBInstanceId
      Port: 3306
      ConnectionStringPrefix:
        Fn::Sub: ${DBInstanceId}o
    DependsOn: SecurityIps
Outputs:
  PublicEndpoint:
    Description:
      en: Public Endpoint.
      zh-cn: 外网地址。
    Value:
      Fn::GetAtt:
      - Connection
      - ConnectionString
  PublicPort:
    Description:
      en: Public port.
      zh-cn: 外网端口。
    Value:
      Fn::GetAtt:
      - Connection
      - Port
  AccountName:
    Description:
      en: Database username.
      zh-cn: 数据库用户名。
    Value:
      Fn::GetAtt:
      - Account
      - AccountName
Metadata:
  ALIYUN::ROS::Interface:
    ParameterGroups:
    - Parameters:
      - DBInstanceId
      - AccountName
      - Password
    TemplateTags:
    - acs:document:试用教程:快速使用RDS SQL Server Serverless实例