e-commerce-business-and-database.yml

ROSTemplateFormatVersion: '2015-09-01'
Description:
  zh-cn: 电商业务及数据库上云。
  en: E-commerce business and database on the cloud.
Metadata:
  ALIYUN::ROS::Interface:
    ParameterGroups:
      - Parameters:
          - InstanceType
          - ECS_ZoneId_1
          - ECS_ZoneId_2
          - Password
        Label:
          default: ECS
      - Parameters:
          - DBInstanceClass
          - RDS_ZoneId_1
          - RDS_ZoneId_2
          - DBPassword
        Label:
          default: RDS
      - Parameters:
          - LoadBalancerSpec
          - SLB_ZoneId_1
        Label:
          default: SLB
    TemplateTags:
      - acs:technical-solution:network:ECS:电商行业业务及数据库上云
Parameters:
  ECS_ZoneId_1:
    Type: String
    AssociationProperty: ALIYUN::ECS::Instance:ZoneId
    Label:
      zh-cn: ECS可用区A
      en: Availability Zone A of ECS
    Description:
      en: An availability zone to create for the ECS instance, <font color='red'><b>ensure that the current region has 
        at least two different availability zones to choose from</b>. If there are no two availability zones, 
        please change other parameters or switch to another region and check again.
      zh-cn: 创建ECS实例的可用区，<font color='red'><b>请确保当前地域有至少两个不同的可用区可供选择</b></font>。若无双可用区，请修改其他参数或切换至其他地域后重新查看。
  ECS_ZoneId_2:
    Type: String
    AssociationProperty: ALIYUN::ECS::Instance:ZoneId
    Label:
      zh-cn: ECS可用区B
      en: Availability Zone B of ECS
    Description:
      en: An availability zone to create for the ECS instance, <font color='red'><b>ensure that the current region has
        at least two different availability zones to choose from</b>. If there are no two availability zones,
        please change other parameters or switch to another region and check again.
      zh-cn: 创建ECS实例的可用区，<font color='red'><b>请确保当前地域有至少两个不同的可用区可供选择</b></font>。若无双可用区，请修改其他参数或切换至其他地域后重新查看。
  RDS_ZoneId_1:
    Type: String
    AssociationProperty: ALIYUN::ECS::Instance:ZoneId
    Label:
      zh-cn: RDS主可用区
      en: Master availability zone
    Description:
      en: The master availability zone to create for the RDS instance, <font color='red'><b>ensure that the current 
        region has at least two different availability zones to choose from</b>. If there are no two availability zones,
        please change other parameters or switch to another region and check again.
      zh-cn: 创建RDS实例的主可用区，<font color='red'><b>请确保当前地域有至少两个不同的可用区可供选择</b></font>。若无双可用区，请修改其他参数或切换至其他地域后重新查看。
  RDS_ZoneId_2:
    Type: String
    AssociationProperty: ALIYUN::ECS::Instance:ZoneId
    Label:
      zh-cn: RDS备可用区
      en: Slave availability zone
    Description:
      en: The slave availability zone to create for the RDS instance, <font color='red'><b>ensure that the current
        region has at least two different availability zones to choose from</b>. If there are no two availability zones,
        please change other parameters or switch to another region and check again.
      zh-cn: 创建RDS实例的备可用区，<font color='red'><b>请确保当前地域有至少两个不同的可用区可供选择</b></font>。若无双可用区，请修改其他参数或切换至其他地域后重新查看。
  InstanceType:
    Type: String
    Label:
      en: ECS Instance Type
      zh-cn: ECS实例规格
    AssociationProperty: ALIYUN::ECS::Instance::InstanceType
    AssociationPropertyMetadata:
      SystemDiskCategory: cloud_essd
      Constraints:
        InstanceTypeFamily: 'ecs.u1'
  Password:
    Type: String
    Label:
      en: ECS instance password
      zh-cn: ECS实例密码
    Description:
      en: 'Length 8-32 characters, can contain size letters, Numbers and special symbols,
        including: !@#$%^&*()_+-='
      zh-cn: 长度8-32个字符,可包含大小字母、数字及特殊符号（包含：!@#$%^&*()_+-=）
    ConstraintDescription:
      en: '8-32 characters, can contain size letters, Numbers and special symbols,
        including: !@#$%^&*()_+-='
      zh-cn: 8-32个字符,可包含大小字母、数字及特殊符号（包含：!@#$%^&*()_+-=）
    MinLength: 8
    MaxLength: 32
    NoEcho: true
  DBInstanceClass:
    Type: String
    Label:
      en: Specifications
      zh-cn: 规格
    Description:
      en: 'Select the instance specification based on the type of database engine
        and the available area support;<br>see detail: <a href=''https://www.alibabacloud.com/help/doc-detail/26312.html''
        target=''_blank''><b><font color=''blue''>Instance specification sheet</font></b></a>'
      zh-cn: 根据数据库引擎的类型和可用的区域支持选择实例规格；<br>请参见详细信息：<a href='https://help.aliyun.com/document_detail/26312.html'
        target='_blank'><b><font color='blue'>实例规格表</font></b></a>
    Default: rds.mysql.s2.large
  DBPassword:
    Type: String
    Label:
      en: Database password
      zh-cn: 数据库密码
    Description:
      en: 'Length 8-32 characters, can contain size letters, Numbers and special symbols,
        including: !@#$%^&*()_+-= <br>It applies to both the password of the self-built database on ECS and
        the password of RDS.'
      zh-cn: 长度8-32个字符,可包含大小字母、数字及特殊符号（包含：!@#$%^&*()_+-=）<br>同时适用于ECS上自建数据库的密码与RDS的密码。
    ConstraintDescription:
      en: '8-32 characters, can contain size letters, Numbers and special symbols,
        including: !@#$%^&*()_+-='
      zh-cn: 8-32个字符,可包含大小字母、数字及特殊符号（包含：!@#$%^&*()_+-=）
    MinLength: 8
    MaxLength: 32
    NoEcho: true
  LoadBalancerSpec:
    Type: String
    Label:
      en: Load balancer instance specification
      zh-cn: 负载均衡实例规格
    Default: slb.s1.small
    AssociationProperty: ALIYUN::SLB::Instance::InstanceType
  SLB_ZoneId_1:
    Type: String
    AssociationProperty: ALIYUN::NLB::Zone::ZoneId
    Label:
      zh-cn: SLB主可用区
      en: Master availability zone
    Description:
      en: The master availability zone to create for the SLB instance, <font color='red'><b>ensure that the current
        region has at least two different availability zones to choose from</b>. If there are no two availability zones,
        please change other parameters or switch to another region and check again.
      zh-cn: 创建SLB实例的主可用区，<font color='red'><b>请确保当前地域有至少两个不同的可用区可供选择</b></font>。若无双可用区，请修改其他参数或切换至其他地域后重新查看。
Resources:
  Vpc:
    Type: ALIYUN::ECS::VPC
    Properties:
      VpcName: E_Commerce_Vpc
      CidrBlock: 192.168.0.0/16
  ECS_Vsw_1:
    Type: ALIYUN::ECS::VSwitch
    Properties:
      VpcId:
        Ref: Vpc
      ZoneId:
        Ref: ECS_ZoneId_1
      CidrBlock: 192.168.0.0/24
  ECS_Vsw_2:
    Type: ALIYUN::ECS::VSwitch
    Properties:
      VpcId:
        Ref: Vpc
      ZoneId:
        Ref: ECS_ZoneId_2
      CidrBlock: 192.168.1.0/24
  SLB_Vsw_1:
    Type: ALIYUN::ECS::VSwitch
    Properties:
      VpcId:
        Ref: Vpc
      ZoneId:
        Ref: SLB_ZoneId_1
      CidrBlock: 192.168.2.0/24
  RDS_Vsw_1:
    Type: ALIYUN::ECS::VSwitch
    Properties:
      VpcId:
        Ref: Vpc
      ZoneId:
        Ref: RDS_ZoneId_1
      CidrBlock: 192.168.3.0/24
  RDS_Vsw_2:
    Type: ALIYUN::ECS::VSwitch
    Properties:
      VpcId:
        Ref: Vpc
      ZoneId:
        Ref: RDS_ZoneId_2
      CidrBlock: 192.168.4.0/24
  ECommerceSg:
    Type: ALIYUN::ECS::SecurityGroup
    Properties:
      VpcId:
        Ref: Vpc
      SecurityGroupIngress:
        - PortRange: 22/22
          Priority: 1
          SourceCidrIp: 0.0.0.0/0
          IpProtocol: tcp
          NicType: intranet
        - PortRange: 80/80
          Priority: 1
          SourceCidrIp: 0.0.0.0/0
          IpProtocol: tcp
          NicType: intranet
        - PortRange: 443/443
          Priority: 1
          SourceCidrIp: 0.0.0.0/0
          IpProtocol: tcp
          NicType: intranet
        - PortRange: 3389/3389
          Priority: 1
          SourceCidrIp: 0.0.0.0/0
          IpProtocol: tcp
          NicType: intranet
        - PortRange: -1/-1
          Priority: 1
          SourceCidrIp: 0.0.0.0/0
          IpProtocol: icmp
          NicType: intranet
  LocalWebSiteSg:
    Type: ALIYUN::ECS::SecurityGroup
    Properties:
      VpcId:
        Ref: Vpc
      SecurityGroupIngress:
        - PortRange: 22/22
          Priority: 1
          SourceCidrIp: 0.0.0.0/0
          IpProtocol: tcp
          NicType: intranet
        - PortRange: 80/80
          Priority: 1
          SourceCidrIp: 0.0.0.0/0
          IpProtocol: tcp
          NicType: intranet
        - PortRange: 443/443
          Priority: 1
          SourceCidrIp: 0.0.0.0/0
          IpProtocol: tcp
          NicType: intranet
        - PortRange: 3306/3306
          Priority: 1
          SourceCidrIp: 0.0.0.0/0
          IpProtocol: tcp
          NicType: intranet
        - PortRange: -1/-1
          Priority: 1
          SourceCidrIp: 0.0.0.0/0
          IpProtocol: icmp
          NicType: intranet
  CloudWebSite_1:
    Type: ALIYUN::ECS::Instance
    Properties:
      VpcId:
        Ref: Vpc
      SecurityGroupId:
        Ref: ECommerceSg
      VSwitchId:
        Ref: ECS_Vsw_1
      InstanceName: cloud-web-site-1
      HostName: cloud-web-site-1
      ZoneId:
        Ref: ECS_ZoneId_1
      InstanceChargeType: PostPaid
      InstanceType:
        Ref: InstanceType
      ImageId: centos_7_9_x64_20G_alibase
      SystemDiskCategory: cloud_essd
      SystemDiskSize: 40
      AllocatePublicIP: false
      Password:
        Ref: Password
  CloudWebSite_2:
    Type: ALIYUN::ECS::Instance
    Properties:
      VpcId:
        Ref: Vpc
      SecurityGroupId:
        Ref: ECommerceSg
      VSwitchId:
        Ref: ECS_Vsw_2
      InstanceName: cloud-web-site-2
      HostName: cloud-web-site-1
      ZoneId:
        Ref: ECS_ZoneId_2
      InstanceChargeType: PostPaid
      InstanceType:
        Ref: InstanceType
      ImageId: centos_7_9_x64_20G_alibase
      SystemDiskCategory: cloud_essd
      SystemDiskSize: 40
      AllocatePublicIP: false
      Password:
        Ref: Password
  Slb:
    Type: ALIYUN::SLB::LoadBalancer
    Properties:
      LoadBalancerSpec:
        Ref: LoadBalancerSpec
      VpcId:
        Ref: Vpc
      VSwitchId:
        Ref: SLB_Vsw_1
      LoadBalancerName: slb-ds-demo
      MasterZoneId:
        Ref: SLB_ZoneId_1
  SlbListener:
    Type: ALIYUN::SLB::Listener
    Properties:
      Persistence:
        CookieTimeout: 60
        StickySession: 'on'
        PersistenceTimeout: 180
        XForwardedFor: 'off'
        StickySessionType: insert
      ListenerPort: 80
      Bandwidth: -1
      HealthCheck:
        HttpCode: http_2xx,http_3xx,http_4xx,http_5xx
        HealthCheckType: tcp
        UnhealthyThreshold: 3
        Timeout: 5
        HealthyThreshold: 3
        Port: 80
        URI: /
        Interval: 2
      LoadBalancerId:
        Ref: Slb
      BackendServerPort: 80
      Protocol: tcp
  SlbBackendServerAttachment:
    Type: ALIYUN::SLB::BackendServerAttachment
    Properties:
      BackendServerList:
        - Ref: CloudWebSite_1
        - Ref: CloudWebSite_2
      BackendServerWeightList:
        - 100
        - 100
      LoadBalancerId:
        Ref: Slb
  LocalWebSite:
    Type: ALIYUN::ECS::Instance
    Properties:
      VpcId:
        Ref: Vpc
      SecurityGroupId:
        Ref: LocalWebSiteSg
      VSwitchId:
        Ref: ECS_Vsw_2
      InstanceName: local-web-site
      HostName: local-web-site
      ZoneId:
        Ref: ECS_ZoneId_2
      InstanceChargeType: PostPaid
      InstanceType:
        Ref: InstanceType
      ImageId: centos_7_9_x64_20G_alibase
      SystemDiskCategory: cloud_essd
      SystemDiskSize: 40
      AllocatePublicIP: false
      Password:
        Ref: Password
  Eip_0:
    Type: ALIYUN::VPC::EIP
    Properties:
      Bandwidth: 100
      InstanceChargeType: Postpaid
      InternetChargeType: PayByTraffic
  Eip_1:
    Type: ALIYUN::VPC::EIP
    Properties:
      Bandwidth: 100
      InstanceChargeType: Postpaid
      InternetChargeType: PayByTraffic
  VpcEipAssociation_0:
    Type: ALIYUN::VPC::EIPAssociation
    Properties:
      InstanceId:
        Ref: Slb
      AllocationId:
        Ref: Eip_0
  VpcEipAssociation_1:
    Type: ALIYUN::VPC::EIPAssociation
    Properties:
      InstanceId:
        Ref: LocalWebSite
      AllocationId:
        Ref: Eip_1
  PrepareLocalData:
    Type: ALIYUN::ECS::RunCommand
    DependsOn:
      - VpcEipAssociation_1
      - InstallWebsite
    Properties:
      Sync: true
      Type: RunShellScript
      Timeout: 3600
      InstanceIds:
        - Ref: LocalWebSite
      CommandContent:
        Fn::Sub: |-
          #!/bin/bash
          
          cat > mysql-community.repo << \EOF
          [mysql57-community]
          name=MySQL 5.7 Community Server
          baseurl=https://opentuna.cn/mysql/yum/mysql-5.7-community-el7-$basearch/
          enabled=1
          gpgcheck=0
          gpgkey=https://repo.mysql.com/RPM-GPG-KEY-mysql
          
          [mysql-connectors-community]
          name=MySQL Connectors Community
          baseurl=https://opentuna.cn/mysql/yum/mysql-connectors-community-el7-$basearch/
          enabled=1
          gpgcheck=0
          gpgkey=https://repo.mysql.com/RPM-GPG-KEY-mysql
          
          [mysql-tools-community]
          name=MySQL Tools Community
          baseurl=https://opentuna.cn/mysql/yum/mysql-tools-community-el7-$basearch/
          enabled=1
          gpgcheck=1
          gpgkey=https://repo.mysql.com/RPM-GPG-KEY-mysql
          EOF
        
          mv mysql-community.repo /etc/yum.repos.d/
          yum -y install mysql-community-server
          echo log_bin=ON >> /etc/my.cnf
          echo server-id=1 >> /etc/my.cnf
          systemctl start mysqld
          systemctl enable mysqld
          TmpPassword=`grep 'A temporary password is generated' /var/log/mysqld.log | awk '{print $NF}'`
          mysql -u root -p$TmpPassword --connect-expired-password -e "ALTER USER 'root'@'localhost' IDENTIFIED BY '${DBPassword}'; FLUSH PRIVILEGES;"
          
          cat > setup_mysql.sql << \EOF
          CREATE DATABASE `e_commerce_website`;
          CREATE USER `e_commerce_user` IDENTIFIED BY "${DBPassword}";
          GRANT ALL ON *.* TO "e_commerce_user"@"%";
          FLUSH PRIVILEGES;
          USE `e_commerce_website`;
          CREATE TABLE `products` (
            `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
            `name` varchar(36) NOT NULL,
            `price` varchar(36) NOT NULL,
            PRIMARY KEY (`id`)
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
          INSERT INTO  products (`name`, `price`) values 
          ("ProductName1","100"),
          ("ProductName2","150"),
          ("ProductName3","200"); 
          EOF
          
          chmod +x setup_mysql.sql
          mysql -uroot -p${DBPassword} < setup_mysql.sql
          sed -i 's/${RdsDBInstance.InnerConnectionString}/127.0.0.1/g' /var/www/html/mysql_demo.php
  RdsDBInstance:
    Type: ALIYUN::RDS::DBInstance
    Properties:
      Category: HighAvailability
      DBInstanceStorageType: local_ssd
      ZoneId:
        Ref: RDS_ZoneId_1
      SlaveZoneIds:
        - Ref: RDS_ZoneId_2
      VpcId:
        Ref: Vpc
      VSwitchId:
        Fn::Join:
          - ','
          - - Ref: RDS_Vsw_1
            - Ref: RDS_Vsw_2
      DBInstanceClass:
        Ref: DBInstanceClass
      DBInstanceStorage: 100
      DBMappings:
        - CharacterSetName: utf8
          DBName: e_commerce_website
      Engine: MySQL
      EngineVersion: '5.6'
      MasterUserPassword:
        Ref: DBPassword
      MasterUserType: Super
      MasterUsername: e_commerce_user
      SecurityIPList: 192.168.0.0/16
      SecurityGroupId:
        Ref: ECommerceSg
  DtsInstance:
    Type: ALIYUN::DTS::Instance
    DependsOn: PrepareLocalData
    Properties:
      JobId:
        Fn::GetAtt:
          - MigrationJob
          - DtsJobId
      InstanceClass: small
      PayType: PostPaid
      Type: MIGRATION
      SourceRegion:
        Ref: ALIYUN::Region
      DestinationRegion:
        Ref: ALIYUN::Region
      SourceEndpointEngineName: MySQL
      DestinationEndpointEngineName: MySQL
  MigrationJob:
    Type: ALIYUN::DTS::MigrationJob2
    Properties:
      DtsJobName: e-commerce-migration
      SourceEndpoint:
        InstanceType: ECS
        InstanceID:
          Ref: LocalWebSite
        EngineName: MYSQL
        Port: '3306'
        Region:
          Ref: ALIYUN::Region
        UserName: e_commerce_user
        Password:
          Ref: DBPassword
      DestinationEndpoint:
        InstanceType: RDS
        InstanceID:
          Ref: RdsDBInstance
        EngineName: MYSQL
        Region:
          Ref: ALIYUN::Region
        UserName: e_commerce_user
        Password:
          Ref: DBPassword
      StructureInitialization: true
      DataInitialization: true
      DataSynchronization: true
      DbList:
        e_commerce_website:
          name: e_commerce_website
          all: true
    DependsOn:
      - RdsDBInstance
      - InstallWebsite
      - PrepareLocalData
  InstallWebsite:
    Type: ALIYUN::ECS::RunCommand
    Properties:
      Sync: true
      Type: RunShellScript
      Timeout: 3600
      InstanceIds:
        - Ref: CloudWebSite_1
        - Ref: CloudWebSite_2
        - Ref: LocalWebSite
      CommandContent:
        Fn::Sub: |-
          #!/bin/bash
          set -e
          yum -y install nginx php php-mysql php-fpm
          cat > /etc/nginx/conf.d/e-commerce-website.conf << \EOF
          server {
              listen       80;
              listen       [::]:80;
              server_name  _;
              root         /var/www/html;
      
              # Load configuration files for the default server block.
              include /etc/nginx/default.d/*.conf;
      
              error_page 404 /404.html;
              location = /404.html {
              }
      
              error_page 500 502 503 504 /50x.html;
              location = /50x.html {
              }
      
              location ~ \.php$ {
              root /var/www/html; 
              fastcgi_pass 127.0.0.1:9000;
              fastcgi_index index.php;
              fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
              include fastcgi_params;
              }
          }
          EOF
          
          cd /var/www/html
          cat > index.html << \EOF
          <!DOCTYPE html>
          <html>
          <head>
              <title>电商网站首页</title>
              <meta http-equiv="Conten-Type" content="text/html"; charset="utf-8">
              <style>
                  /* 顶部导航栏 */
                  header {
                      display: flex;
                      justify-content: space-between;
                      align-items: center;
                      padding: 10px;
                      background-color: #ff4400;
                      color: #fff;
                  }
          
                  .logo h1 {
                      margin: 0;
                      font-size: 24px;
                  }
          
                  .logo p {
                      margin: 0;
                      font-size: 14px;
                  }
          
                  nav ul {
                      list-style: none;
                      display: flex;
                  }
          
                  nav ul li {
                      margin-right: 20px;
                  }
          
                  nav ul li a {
                      color: #fff;
                      text-decoration: none;
                      font-size: 16px;
                  }
          
                  /* 主要内容 */
                  main {
                      padding: 20px;
                  }
          
                  .search-bar {
                      display: flex;
                      justify-content: center;
                      align-items: center;
                      padding: 10px;
                      background-color: #fff;
                      margin-bottom: 20px;
                  }
          
                  .search-bar input[type="text"] {
                      padding: 5px;
                      width: 400px;
                      border: none;
                      border-radius: 20px;
                      box-shadow: 0 0 5px rgba(0, 0, 0, 0.3);
                  }
          
                  .search-bar button {
                      padding: 8px 15px;
                      background-color: #ff4400;
                      border: none;
                      color: #fff;
                      border-radius: 20px;
                      cursor: pointer;
                  }
          
                  /* 其他内容样式补充... */
                  .iframe-wrapper {
                      display: flex;
                      justify-content: center;
                      align-items: center;
                      overflow: hidden;
                  }
          
                  .iframe-wrapper iframe {
                      border: none;
                      width: 100%;
                      height: 100%;
                  }
          
                  /* 底部 */
                  footer {
                      background-color: #333333;
                      color: #fff;
                      padding: 20px;
                  }
          
                  footer ul {
                      list-style: none;
                      display: flex;
                      justify-content: center;
                      margin: 0;
                      padding: 0;
                  }
          
                  footer ul li {
                      margin-right: 20px;
                  }
          
                  footer ul li a {
                      color: #fff;
                      text-decoration: none;
                      font-size: 14px;
                  }
              </style>
          </head>
          <body>
              <!-- 顶部导航栏 -->
              <header>
                  <div class="logo">
                      <h1>网站Logo</h1>
                      <p>公司口号</p>
                  </div>
                  <nav>
                      <ul>
                          <li><a href="#">首页</a></li>
                          <li><a href="#">产品分类</a></li>
                          <li><a href="#">特惠促销</a></li>
                          <li><a href="#">关于我们</a></li>
                          <li><a href="#">联系我们</a></li>
                      </ul>
                  </nav>
              </header>
          
              <!-- 主要内容 -->
              <main>
                  <div class="featured-products">
                      <h2>特别推荐</h2>
                      <div class="iframe-wrapper">
                          <iframe src="mysql_demo.php"></iframe>
                      </div>
                  </div>
              </main>
          
              <!-- 底部 -->
              <footer>
                  <ul>
                      <li><a href="#">关于我们</a></li>
                      <li><a href="#">联系我们</a></li>
                      <li><a href="#">帮助中心</a></li>
                      <li><a href="#">隐私政策</a></li>
                  </ul>
              </footer>
          </body>
          </html>
          
          EOF
          
          cat > mysql_demo.php << \EOF
          <?php
          // 连接数据库
          $host = "${RdsDBInstance.InnerConnectionString}";
          $username = "e_commerce_user";
          $password = "${DBPassword}";
          $database = "e_commerce_website";
          $conn = new mysqli($host, $username, $password, $database);
          if ($conn->connect_error) {
              die("数据库连接失败：" . $conn->connect_error);
          }

          // 查询商品数据
          $query = "SELECT * FROM products";
          $result = $conn->query($query);

          // 构建商品信息的HTML
          $productHTML = "";
          if ($result->num_rows > 0) {
              while ($row = $result->fetch_assoc()) {
                  $productHTML .= '
                      <div>
                          <h3>商品名称：' . $row["name"] . '</h3>
                          <p>商品价格：' . $row["price"] . '元</p>
                      </div>
                  ';
              }
          } else {
              $productHTML = "没有找到任何商品。";
          }

          // 关闭数据库连接
          $conn->close();
          ?>

          <!DOCTYPE html>
          <html>
          <head>
              <title>商品列表</title>
              <style>
                  /* 商品列表样式 */
                  .product-list {
                      display: grid;
                      grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
                      grid-gap: 20px;
                      overflow: hidden;
                  }

                  .product {
                      border: 1px solid #ccc;
                      padding: 10px;
                      text-align: center;
                  }
              </style>
          </head>
          <body>
              <div class="product-list">
                  <?php echo $productHTML; ?>
              </div>
          </body>
          </html>

          EOF
          
          systemctl start php-fpm
          systemctl enable php-fpm
          systemctl start nginx
          systemctl enable nginx
Outputs:
  LocalAddress:
    Description:
      zh-cn: 本地网站访问地址。
      en: Local website access address.
    Value:
      Fn::Sub: http://${Eip_1.EipAddress}
  CloudWebsiteAddress:
    Description:
      zh-cn: 云网站访问地址。
      en: Cloud website access address.
    Value:
      Fn::Sub: http://${Eip_0.EipAddress}
  DBInstanceId:
    Description:
      zh-cn: RDS实例ID。
      en: RDS instance id.
    Value:
      Fn::GetAtt:
        - RdsDBInstance
        - DBInstanceId
  DtsJobId:
    Description:
      zh-cn: DTS任务名称。
      en: DTS job name.
    Value:
      Fn::Sub: '<a href="https://dtsnew.console.aliyun.com/migrate/${ALIYUN::Region}" target="_blank">e-commerce-migration</a>'