apiVersion: api/v1
kind: Plan
name: endless-oltp-stability-sysbench-bulk-insert
#type: ONE_SHOT
schedule: '0 0 * * 1,3,5'
tags: []
variables:
- name: CaseCmdParms
  default: |
    workloadType:
      type : [ 'sysbench_bulk_insert' ]
    tpccParms:
      storage : s3://benchmark/tpcc-1000-4.0
      db : tpcc
      warehouse : 1000
      threads : 512
      ignoreErrors : 2013,1213,1105,8028,9007,8027,9005,9001,1205,8022,8028,9004,9007,1062
    sysbenchParms:
      storage : s3://benchmark/sysbench-32-10000000
      db : test
      tableNum : 32
      tableSize : 10000000
      threads : 512
      ignoreErrors : 2013,1213,1105,8028,9007,8027,9005,9001,1205,8022,8028,9004,9007,1062
      workloadCheckIgnoreErrors: 2013,1213,1105,1205,8022,8027,8028,9004,9007,9001,9005
    runTime:
      totalRunTime: 10h 
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:
        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
  items:
  - name: tc
    type: TIDB_CLUSTER
    spec:
      pd:
        replicas: 1
        maxReplicas: 1
        storageClassName: "fast-disks"
        requests:
          cpu: 4000m
          memory: 8Gi
        limits:
          cpu: 4000m
          memory: 8Gi
        baseImage: '{{meta.parameters.pd_base_image}}'
      tikv:
        replicas: 4
        maxReplicas: 4
        storageClassName: "fast-disks"      
        requests:
          cpu: 8000m
          memory: 32Gi
          storage: 1000Gi
        limits:
          cpu: 8000m
          memory: 32Gi
          storage: 1000Gi
        baseImage: '{{meta.parameters.tikv_base_image}}'
      tidb:
        replicas: 2
        maxReplicas: 2
        requests:
          cpu: 8000m
          memory: 48Gi
        limits:
          cpu: 8000m
          memory: 48Gi
        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_bulk_image}}'
        command:
        - tail
        - "-f"
        - "/dev/null"
        resources:
          requests:
            cpu: 8000m
            memory: 16Gi
steps:
- name: oltp-fun-001
  caseName: oltp_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