如何利用亚马逊云科技的原生服务提升SAP HANA集群监控中的可观测性

---
AWSTemplateFormatVersion: "2010-09-09"

Resources:
  SSMDocumentRole:
    Type: AWS::IAM::Role
    Properties:
      AssumeRolePolicyDocument:
        Version: '2012-10-17'
        Statement:
        - Effect: Allow
          Principal:
            Service:
            - events.amazonaws.com
          Action:
            - sts:AssumeRole
      Path: /     
      Policies:                
        - PolicyName: ssmroot
          PolicyDocument:
            Version: '2012-10-17'
            Statement:
              - Effect: Allow
                Action:
                  - 'ssm:SendCommand'
                Resource: "*"
      RoleName: SSM-DOCUMENT-ROLE

  EventRole:
    Type: AWS::IAM::Role
    Properties:
      AssumeRolePolicyDocument:
        Version: '2012-10-17'
        Statement:
          - Effect: Allow
            Principal:
              Service:
              - events.amazonaws.com
            Action:
              - sts:AssumeRole
      Path: /    
      Policies:
        - PolicyName: eventroot
          PolicyDocument:
            Version: '2012-10-17'
            Statement:
              - Sid: AllowCloudwatchAccess
                Effect: Allow
                Action: 
                  - 'cloudwatch:*'
                Resource: "*"
              - Sid: IAMPass
                Effect: Allow
                Action: 
                  - 'iam:PassRole'
                Resource: "*"
      RoleName: EVENT-RULE-ROLE


$ aws cloudformation create-stack --stack-name <stackname> --template-body file://iamroles.yaml--capabilities CAPABILITY_NAMED_IAM 

Parameters:
  HANAPRIMARYHOST:
    Description: "SAP HANA Primary Node InstanceID"
    Type: String
  HANASECONDARYHOST:
    Description: "SAP HANA Secondary Node InstanceID"
    Type: String

Resources:
  SSMRunCommandDocument:
    Type: AWS::SSM::Document
    Properties:
      DocumentType: 'Command'
      Content:
        schemaVersion: '2.2'
        description: "ssm document"
        mainSteps:
          - action: "aws:runShellScript"
            name: runShellScript
            inputs:
              runCommand:
                - INSTANCE_ID=$(curl -s http://169.254.169.254/latest/meta-data/instance-id)
                - DBSID=$(grep -o ''pf=[^[:space:]]*'' /usr/sap/sapservices | grep _HDB|awk -F "/" '{print $4}')
                - SIDLOWER=$(echo ${DBSID,,})
                - echo $SIDLOWER
                - SIDADM=${SIDLOWER}adm
                - echo $SIDADM
                - NN=$(grep -o ''pf=[^[:space:]]*'' /usr/sap/sapservices | grep _$HOST|awk -F "/" '{print $7}'|awk -F "_" '{print $2}'|sed 's@^[^0-9]*\([0-9]\+\).*@\1@') 
                - NAMESER=$(runuser -l $SIDADM -c "sapcontrol -nr $NN -function GetProcessList" | grep hdbnameserver | grep Running | wc -l)
                - aws cloudwatch put-metric-data --metric-name HANA-hdbnameserver --dimensions Instance=$INSTANCE_ID --namespace "Custom" --value $NAMESER


$ aws cloudformation create-stack --stack-name <stackname> --template-body file://hanaclustermon.yaml --parameters ParameterKey=HANAPRIMARYHOST,ParameterValue=<hanainstance1id> ParameterKey=HANASECONDARYHOST,ParameterValue==<hanainstance2id>

---
AWSTemplateFormatVersion: "2010-09-09"

Parameters:
  HANAPRIMARYHOST:
    Description: "SAP HANA Primary Node InstanceID"
    Type: String
  HANASECONDARYHOST:
    Description: "SAP HANA Secondary Node InstanceID"
    Type: String

Resources:
  MyDashboard:
    Type: AWS::CloudWatch::Dashboard
    Properties:
      DashboardName: HANA-dashboard
      DashboardBody: !Sub |
          {
              "widgets": [
                {
                      "type": "metric",
                      "x": 0,
                      "y": 0,
                      "width": 6,
                      "height": 6,
                      "properties": {
                        "metrics": [
                            [ "Custom", "HANA-hdbnameserver", "Instance", "${HANAPRIMARYHOST}" ],
                            [ "Custom", "HANA-hdbnameserver", "Instance", "${HANASECONDARYHOST}" ],
                        ],
                          "region": "cn-northwest-1",
                          "stat": "Average",
                          "period": 300,
                          "view": "timeSeries",
                          "title": "HANA Service Status",
                          "stacked": false
                      }
                }
              ]
          }



aws cloudformation create-stack --stack-name <stackname> --template-body file:// hanacluster_cloudwatch.yaml --parameters ParameterKey=HANAPRIMARYHOST,ParameterValue=<hanainstance1id> ParameterKey=HANASECONDARYHOST,ParameterValue=<hanainstance2id>