apiVersion: api/v1
kind: Plan
name: endless-oltp-4core-quota-limiter-fun-001
#type: ONE_SHOT
schedule: '0 0 * * 6'
tags: []
variables:
- name: CaseCmdParms
  default: |
    workloadType:
      type : [ 'randomWorkload' ]
      randomWorkloadScope: [ 'tpcc',
       'sysbench_oltp_read_write' ]
    tpccParms:
      storage : s3://benchmark/tpcc10000
      db : tpcc10000
      warehouse : 10000
      threads : 512
      ignoreErrors : '{{meta.parameters.oltp_rel_ignoreErrors}}'
    sysbenchParms:
      storage : s3://benchmark/sysbench_64_7000w
      db : sysbench_64_7000w
      tableNum : 64
      tableSize : 70000000
      threads : 64
      ignoreErrors : '{{meta.parameters.oltp_rel_ignoreErrors}}'
    clusterSpecParms:
      tikvCPU : 4  
testbed:
  generateName: endless-oltp-
  reclaimPolicy:
    gcStrategy:
      onFailure:
        artifact:
          monitor: true
          log: true
        reserveEnv:
          durationOnWorkingHour: '{{meta.parameters.onFailureNoReserve}}'
        notification:
          feishu: https://open.feishu.cn/open-apis/bot/v2/hook/259e813d-7676-4876-8de2-962df96f4d8e
      onSuccess:
        notification:
          feishu: https://open.feishu.cn/open-apis/bot/v2/hook/259e813d-7676-4876-8de2-962df96f4d8e
  items:
  - name: tc
    type: TIDB_CLUSTER
    spec:
      pd:
        replicas: 3
        maxReplicas: 4
        storageClassName: "fast-disks"
        requests:
          cpu: 4000m
          memory: 8Gi
        limits:
          cpu: 4000m
          memory: 8Gi
        baseImage: '{{meta.parameters.pd_base_image}}'
      tikv:
        replicas: 4
        maxReplicas: 5
        storageClassName: "fast-disks"
        config: |
          [quota]
          foreground-cpu-time = 500
          foreground-write-bandwidth = "1MB"
          foreground-read-bandwidth = "1MB"
        requests:
          cpu: 4000m
          memory: 16Gi
          storage: 1500Gi
        limits:
          cpu: 4000m
          memory: 16Gi
          storage: 1500Gi
        baseImage: '{{meta.parameters.tikv_base_image}}'
      tidb:
        replicas: 2
        maxReplicas: 3
        requests:
          cpu: 4000m
          memory: 16Gi
        limits:
          cpu: 4000m
          memory: 16Gi
        baseImage: '{{meta.parameters.tidb_base_image}}'
      version: '{{meta.parameters.base_image_version}}'
  - name: br
    type: BR_NODE
    spec:
      image: '{{meta.parameters.br_image}}'
      artifact:
        artifactPaths:
        - /tmp/br.log*
  - name: benchtoolset
    type: WORKLOAD_NODE
    spec:
      container:
        name: benchtoolset
        image: '{{meta.parameters.bench_toolset_image}}'
        command:
        - tail
        - "-f"
        - "/dev/null"
        resources:
          requests:
            cpu: 8000m
            memory: 16Gi
steps:
- name: oltp-workload-fun-001
  caseName: oltp_workload_fun_001
  arguments:
  - name: tc
    value: "{{testbed.tc}}"
  - name: benchtoolset
    value: '{{testbed.benchtoolset}}'
  - name: br
    value: '{{testbed.br}}'
  - name: casecmdparms
    value: '{{variables.CaseCmdParms}}'
- name: oltp-add-index-and-column-fun-001
  caseName: oltp_add_index_and_column_fun_001
  arguments:
  - name: tc
    value: "{{testbed.tc}}"
  - name: benchtoolset
    value: '{{testbed.benchtoolset}}'
  - name: br
    value: '{{testbed.br}}'
  - name: casecmdparms
    value: '{{variables.CaseCmdParms}}'
# - name: oltp-full-scan-fun-001
#   caseName: oltp_full_scan_fun_001
#   arguments:
#   - name: tc
#     value: "{{testbed.tc}}"
#   - name: benchtoolset
#     value: '{{testbed.benchtoolset}}'
#   - name: br
#     value: '{{testbed.br}}'
#   - name: casecmdparms
#     value: '{{variables.CaseCmdParms}}'
# - name: oltp-analyze-table-fun-001
#   caseName: oltp_analyze_table_fun_001
#   arguments:
#   - name: tc
#     value: "{{testbed.tc}}"
#   - name: benchtoolset
#     value: '{{testbed.benchtoolset}}'
#   - name: br
#     value: '{{testbed.br}}'
#   - name: casecmdparms
#     value: '{{variables.CaseCmdParms}}'
- name: oltp-split-merge-fun-001
  caseName: oltp_split_merge_fun_001
  arguments:
  - name: tc
    value: "{{testbed.tc}}"
  - name: benchtoolset
    value: '{{testbed.benchtoolset}}'
  - name: br
    value: '{{testbed.br}}'
  - name: casecmdparms
    value: '{{variables.CaseCmdParms}}'
- name: oltp-scale-out-fun-001
  caseName: oltp_scale_out_fun_001
  arguments:
  - name: tc
    value: "{{testbed.tc}}"
  - name: benchtoolset
    value: '{{testbed.benchtoolset}}'
  - name: br
    value: '{{testbed.br}}'
  - name: casecmdparms
    value: '{{variables.CaseCmdParms}}'
- name: oltp-scale-in-fun-001
  caseName: oltp_scale_in_fun_001
  arguments:
  - name: tc
    value: "{{testbed.tc}}"
  - name: benchtoolset
    value: '{{testbed.benchtoolset}}'
  - name: br
    value: '{{testbed.br}}'
  - name: casecmdparms
    value: '{{variables.CaseCmdParms}}'
- name: oltp-drop-table-fun-001
  caseName: oltp_drop_table_fun_001
  arguments:
  - name: tc
    value: "{{testbed.tc}}"
  - name: benchtoolset
    value: '{{testbed.benchtoolset}}'
  - name: br
    value: '{{testbed.br}}'
  - name: casecmdparms
    value: '{{variables.CaseCmdParms}}'
failFast: false