apiVersion: api/v1
kind: Plan
name: endless-oltp-sysbench-oltp-read-only-fun
#type: ONE_SHOT
schedule: '0 0 * * 1,2,3,4,5'
tags: []
variables:
- name: CaseCmdParms
  default: |
    workloadType:
      type : [ 'sysbench_oltp_read_only' ]
    tpccParms:
      storage : s3://benchmark/tpcc-1000-4.0
      db : tpcc
      warehouse : 1000
      threads : 512
      ignoreErrors : 2013,1213,1105,8028,9007
    sysbenchParms:
      storage : s3://benchmark/sysbench-32-10000000
      db : test
      tableNum : 32
      tableSize : 10000000
      threads : 512
      ignoreErrors : 2013,1213,1105,8028,9007
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
          storage: 1500Gi
        limits:
          cpu: 4000m
          memory: 8Gi
          storage: 1500Gi
        baseImage: '{{meta.parameters.pd_base_image}}'
        version: '{{meta.parameters.pd_component_version}}'
      tikv:
        replicas: 4
        maxReplicas: 5
        storageClassName: "fast-disks"
        requests:
          cpu: 8000m
          memory: 16Gi
        limits:
          cpu: 8000m
          memory: 16Gi
        baseImage: '{{meta.parameters.tikv_base_image}}'
        version: '{{meta.parameters.tikv_component_version}}'
      tidb:
        replicas: 2
        maxReplicas: 3
        requests:
          cpu: 8000m
          memory: 16Gi
        limits:
          cpu: 8000m
          memory: 16Gi
        baseImage: '{{meta.parameters.tidb_base_image}}'
        version: '{{meta.parameters.tidb_component_version}}'
      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-pause-resume-scheduler-fun-001
  caseName: oltp_pause_resume_scheduler_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-tso-scalibility-fun-001
  caseName: oltp_tso_scalibility_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