github.com/percona/percona-xtradb-cluster-operator@v1.14.0/e2e-tests/conf/sysbench-tpcc.yaml (about)

     1  apiVersion: apps/v1
     2  kind: ReplicaSet
     3  metadata:
     4    name: sysbench
     5  spec:
     6    replicas: 1
     7    minReadySeconds: 20
     8    selector:
     9      matchLabels:
    10        app: sysbench
    11    template:
    12      metadata:
    13        name: sysbench
    14        labels:
    15          app: sysbench
    16      spec:
    17        containers:
    18          - name: sysbench
    19            image: perconalab/sysbench
    20            env:
    21              - name: MYSQL_USER
    22                value: root
    23              - name: MYSQL_PASSWORD
    24                value: root_password
    25              - name: MYSQL_HOSTNAME
    26                value: 10.16.5.6
    27            command: ["bash"]
    28            args:
    29              - "-c"
    30              - |
    31                set -ex
    32                mysql \
    33                  --host="${MYSQL_HOSTNAME}" \
    34                  --port=3306 \
    35                  --user="${MYSQL_USER}" \
    36                  --password="${MYSQL_PASSWORD}" \
    37                  -e 'CREATE DATABASE IF NOT EXISTS sbtest;'
    38  
    39                cd ./sysbench-tpcc
    40                sed -i 's/con:query("SET SESSION sql_log_bin = 0")/con:query("SET SESSION sql_log_bin = 1")/' ./tpcc_common.lua
    41                ./tpcc.lua \
    42                    --mysql-host="${MYSQL_HOSTNAME}" \
    43                    --mysql-user="${MYSQL_USER}" \
    44                    --mysql-password="${MYSQL_PASSWORD}" \
    45                    --mysql-db=sbtest \
    46                    --threads=6 \
    47                    --tables=10 \
    48                    --time=300 \
    49                    --force_pk=1 \
    50                    --db-driver=mysql \
    51                    --scale=20 prepare
    52                ./tpcc.lua \
    53                    --mysql-host="${mysql_hostname}" \
    54                    --mysql-user="${mysql_user}" \
    55                    --mysql-password="${mysql_password}" \
    56                    --mysql-db=sbtest \
    57                    --time=300 \
    58                    --threads=6 \
    59                    --report-interval=1 \
    60                    --tables=10 \
    61                    --scale=20 \
    62                    --force_pk=1 \
    63                    --db-driver=mysql run