OLAP-analysis-based-on-Hologres.yml

ROSTemplateFormatVersion: '2015-09-01'
Description:
  zh-cn: 创建VPC、VSwitch与Hologres实例，配置Intranet、VPC隧道及Internet访问，支持轻量级高性能OLAP分析。
  en: Create VPC, VSwitch, and Hologres instances, configure Intranet, VPC tunneling,
    and Internet access, supporting lightweight high-performance OLAP analytics.
Parameters:
  ZoneId:
    Type: String
    Label:
      en: Availability Zone
      zh-cn: 可用区
    AssociationProperty: ALIYUN::ECS::ZoneId
    AssociationPropertyMetadata:
      AutoSelectFirst: true
  CommonName:
    Type: String
    Default: olap-analysis
Resources:
  Vpc:
    Type: 'ALIYUN::ECS::VPC'
    Properties:
      CidrBlock: 192.168.0.0/16
      VpcName:
        Fn::Sub: ${CommonName}-vpc
  VSwitch:
    Type: 'ALIYUN::ECS::VSwitch'
    Properties:
      VpcId:
        Ref: Vpc
      CidrBlock: 192.168.0.0/24
      ZoneId:
        Ref: ZoneId
      VSwitchName:
        Fn::Sub: ${CommonName}-vsw
  Hologram:
    Type: 'ALIYUN::Hologram::Instance'
    Properties:
      ProductCode: hologram_postpay_public_cn
      InstanceType: Standard
      ZoneId:
        Ref: ZoneId
      PaymentType: PostPaid
      PricingCycle: Hour
      Endpoints:
        - Type: Intranet
        - VSwitchId:
            Ref: VSwitch
          VpcId:
            Ref: Vpc
          Type: VPCSingleTunnel
        - Type: Internet
      InstanceName:
        Fn::Sub: ${CommonName}-hologram
      Cpu: 32
Outputs:
  JDBCAddress:
    Description:
      en: JDBC address.
      zh-cn: JDBC连接地址。
    Value: 'rm-bp1z69dodhh85z9qa.mysql.rds.aliyuncs.com:3306'
  DataBaseName:
    Description:
      en: Database name.
      zh-cn: 数据库名称。
    Value: 'github_events_share'
  DataBaseUserName:
    Description:
      en: Database user name.
      zh-cn: 数据库用户名。
    Value: 'workshop'
  DataBasePassword:
    Description:
      en: Database password.
      zh-cn: 数据库密码。
    Value: 'workshop#2017'
Metadata:
  ALIYUN::ROS::Interface:
    ParameterGroups:
      - Parameters:
        - ZoneId
    TemplateTags:
    - acs:technical-solution:data-analysis:基于Hologres轻量高性能OLAP分析-tech_solu_146
    Hidden:
    - CommonName
  ALIYUN::ROS::Composer:
    '06035496':
      Rect:
        - 496
        - 419
        - 40
        - 100
        - 1
        - 0
      ResT: Composer::ROSParameter::AlibabaCloud
    9d49fde9:
      Parent: '06035496'
      Rect:
        - 452
        - 346
        - 60
        - 150
        - 2
        - 0
      ResT: Composer::ROSParameter::Region
    4462bc0b:
      Res:
        - Vpc
      Parent: 9d49fde9
      Rect:
        - 393
        - 275
        - 80
        - 200
        - 3
        - 0
    c569ddcc:
      Res:
        - VSwitch
      Parent: 4462bc0b
      Rect:
        - 330
        - 198
        - 100
        - 250
        - 4
        - 0
    18e93d78:
      Res:
        - Hologram
      Parent: c569ddcc
      Rect:
        - 40
        - 40
        - 245
        - 329
        - 5
        - 0