# Premium long-term TPCC, derived from perf_x_tpcc1k.yaml.
idCounter: 1236
workflow_id: 210010
nodes:
- id: __START__
  type: start
  data:
    name: __START__
    inputs:
    - id: '41'
      name: tidbcloud_org_id
      kind: value
      value: '1369847559692509625'
      type: String
      description: ''
      required: true
    outputs:
    - name: tidbcloud_org_id
      type: String
      description: ''
      id: '867'
    spec: {}
  position:
    x: 12
    y: 79
  measured:
    width: 800
    height: 492
  selected: false
- id: '10'
  type: testbed_create
  position:
    x: 1086.62248113445
    y: 17.075503773109972
  data:
    name: tidbcloud_cluster_create
    inputs:
    - id: '7143'
      name: org_id
      kind: reference
      value: ''
      type: String
      description: ''
      required: false
      fromOutput:
        node: __START__
        parameter: tidbcloud_org_id
    outputs:
    - name: testbed
      type: Object
      subType: Testbed
      description: Handler of the testbed
      objectSchema:
        type: Object
        description: Handler of the testbed
        properties:
          testbed_name:
            type: String
            description: Name of the testbed
          testbed_items:
            type: Object
            description: Items of the testbed
          resourcepool_name:
            type: String
            description: Resource pool name
      id: '1199'
    - name: testbed.testbed_name
      type: String
      description: Name of the testbed
      id: '1200'
    - name: testbed.testbed_items
      type: Object
      description: Items of the testbed
      id: '1201'
    - name: testbed.resourcepool_name
      type: String
      description: Resource pool name
      id: '1202'
    - name: tc
      type: Object
      subType: TIDBCLOUD_NEXTGEN_CLUSTER
      description: Handler of the tc
      objectSchema:
        type: Object
        description: Handler of the tc
        properties:
          private_endpoint:
            type: String
            description: Private endpoint
          prometheus_url:
            type: String
            description: Prometheus URL
      id: '1203'
    - name: tc.private_endpoint
      type: String
      description: Private endpoint
      id: '1204'
    - name: tc.prometheus_url
      type: String
      description: Prometheus URL
      id: '1205'
    spec:
      generateName: bench-premium
      resourcePool: eks-amd64-default
      reclaimPolicy:
        lease: 240h
        gcStrategy:
          onFailure:
            reserveEnv:
              durationOnWorkingHour: 1h
          onSuccess:
            reserveEnv:
              durationOnWorkingHour: 0h
      items:
      - id: '1797'
        name: tc
        type: TIDBCLOUD_NEXTGEN_CLUSTER
        spec: |
          clusters:
            - connect: privatelink
              initProvider:
                tidb:
                  nodeQuota:
                    maxNodeCount: 1
                    minNodeCount: 1
                    nodeCount: 1
                    nodeSpec:
                      cpu: 2
                      memoryGi: 8
              requestUnit:
                max: 20000
                min: 20000
              tidbGroup: cluster1
          resourcePoolTemplateClaim:
            arguments:
              - name: owner
                value: liting@pingcap.com
              - name: tikv_tag
                value: cloud-engine-nextgen
              - name: coprocessor_worker_tag
                value: cloud-engine-nextgen
              - name: tikv_worker_tag
                value: cloud-engine-nextgen
              - name: pd_tag
                value: master-nextgen
              - name: pd_scheduling_tag
                value: master-nextgen
              - name: pd_tso_tag
                value: master-nextgen
              - name: tidb_tag
                value: master-nextgen
              - name: tiproxy_tag
                value: main
              - name: tidb_worker_tag
                value: master-nextgen
              - name: tiflash_compute_tag
                value: master-nextgen
              - name: tiflash_write_tag
                value: master-nextgen
              - name: coprocessor_worker_version
                value: v26.3.99
              - name: tikv_version
                value: v26.3.99
              - name: tikv_worker_version
                value: v26.3.99
              - name: pd_version
                value: v26.3.99
              - name: pd_scheduling_version
                value: v26.3.99
              - name: pd_tso_version
                value: v26.3.99
              - name: tidb_version
                value: v26.3.99
              - name: tidb_worker_version
                value: v26.3.99
              - name: tiproxy_version
                value: v26.3.99
              - name: tiflash_compute_version
                value: v26.3.99
              - name: tiflash_write_version
                value: v26.3.99
            exclusive: true
            name: lt-premium-private
            overrides:
              logicalRegionName: aws-staging-us-west-2-mjp
              orgID: "{{.inputs.org_id}}"
            reuseExisting: true
          rootPassword: "12345678"
      testPlanTags:
      - service:benchbot
    fastFail: false
  measured:
    width: 693
    height: 626
  selected: false
  dragging: false
- id: '35'
  type: ti_workload_call
  position:
    x: 2105
    y: 112.5
  data:
    name: tpcc_1k_prepare
    inputs:
    - id: '36'
      name: tidb_cluster
      kind: reference
      value: ''
      type: Object
      subType: TIDBCLOUD_NEXTGEN_CLUSTER
      description: Handler to the tidb cluster
      required: true
      fromOutput:
        node: tidbcloud_cluster_create
        parameter: tc
    - id: '1131'
      name: tidb_group
      kind: value
      value: cluster1
      type: String
      description: TiDB group name
      required: true
      deletable: true
    outputs:
    - name: exec_id
      type: String
      description: TiWorkload Execution ID
      id: '1209'
    - name: exec_status
      type: String
      description: TiWorkload Execution Status
      id: '1210'
    - name: exec_tasks
      type: Object
      description: Tasks of the TiWorkload Execution
      id: '1211'
    spec:
      tiworkload_host: https://tiworkload.pingcap.net
      workload_name: tpcc
      prepare: |-
        params:
          thread: 100
          warehouses: 1000
          storage_url: |-
            s3://qa-workload-datasets/benchmark/tpcc-1k-with-clustered-index
          s3_endpoint: |-
            https://qa-workload-datasets.s3.us-west-2.amazonaws.com
          # db_name: Set name to restore TARGET DB / Empty to restore FULL CLUSTER .
          db_name: "tpcc"
          # br_options: You can set extra options like '--checksum-concurrency 128 --ddl-batch-size=32 --kespace=kespace-a --pitr-concurrency=128'
          br_options: '--check-requirements=false --concurrency=12 --tikv-max-restore-concurrency=16'
          # br_version: BR Version is recommended to be the same as the TiDB cluster version
          br_version: "master-next-gen"
          # br_base_image: BR Base Image is the image name used by Testbed to deploy BR. Leave empty to use the default image.
          br_base_image: 'gcr.io/pingcap-public/dbaas/br'
          # prepare_method: br_restore/sql_generate/import
          prepare_method: "br_restore"
          # supported_methods: br_restore,sql_generate,import
      db_port: 4000
      pd_port: 2379
      user_id: 240023
      cluster_type: tidbcloud_nextgen_cluster
      db_host: tc-tidb
      pd_host: tc-pd
    fastFail: true
  measured:
    width: 701
    height: 464
  selected: false
  dragging: false
- id: '87'
  type: ti_workload_call
  position:
    x: 1696.6457832349533
    y: 747.7114603194193
  data:
    name: tpcc_1k_100th_2hrs
    inputs:
    - id: '614'
      name: tidb_cluster
      kind: reference
      value: ''
      type: Object
      subType: TIDBCLOUD_NEXTGEN_CLUSTER
      description: Handler to the tidb cluster
      required: true
      fromOutput:
        node: tidbcloud_cluster_create
        parameter: tc
    - id: '1131'
      name: tidb_group
      kind: value
      value: cluster1
      type: String
      description: TiDB group name
      required: true
      deletable: true
    outputs:
    - name: exec_id
      type: String
      description: TiWorkload Execution ID
      id: '1215'
    - name: exec_status
      type: String
      description: TiWorkload Execution Status
      id: '1216'
    - name: exec_tasks
      type: Object
      description: Tasks of the TiWorkload Execution
      id: '1217'
    spec:
      tiworkload_host: https://tiworkload.pingcap.net
      workload_name: tpcc
      db_port: 4000
      pd_port: 2379
      user_id: 240023
      cluster_type: tidbcloud_nextgen_cluster
      db_host: tc-tidb
      pd_host: tc-pd
      workload: |-
        params:
          client_cnt: 1
          client_resource: '{ "cpu": "15", "memory": "26Gi" }'
          db_name: tpcc
          thread: 200
          duration: 1440
          tpc_options: "--ignore-error"
          warehouses: 1000
    fastFail: true
  measured:
    width: 701
    height: 425
  selected: false
  dragging: false
- id: '862'
  type: sleep
  position:
    x: -127.09590347106632
    y: 1189.6661829329087
  data:
    name: sleep_after_prepare
    inputs: []
    outputs: []
    spec:
      duration: 20m
    fastFail: false
  measured:
    width: 600
    height: 108
  selected: false
  dragging: false
edges:
- source: __START__
  sourceHandle: a
  target: '10'
  targetHandle: w1
  id: __START__-10-w1
  type: custom
  data:
    name: w1
    type: OnCondition
    onConditions:
    - OnSuccess
  selected: false
- id: 10-35-w1
  source: '10'
  sourceHandle: source
  target: '35'
  type: custom
  targetHandle: w1
  data:
    type: OnCondition
    onConditions:
    - OnSuccess
    name: w1
- source: '35'
  sourceHandle: source
  target: '862'
  targetHandle: w1
  id: 35-862-w1
  type: custom
  data:
    name: w1
    type: OnCondition
    onConditions:
    - OnSuccess
- source: '862'
  sourceHandle: source
  target: '87'
  targetHandle: w1
  id: 862-87-w1
  type: custom
  data:
    name: w1
    type: OnCondition
    onConditions:
    - OnSuccess
startNodeParams:
- id: '41'
  name: tidbcloud_org_id
  type: String
  description: ''
  required: true
  value: '1369847559692509625'