6.7.1.2.2. MySQL on Kubernetes with volume on host

This scenario is executed with Sysbench tool. There is one instance of tool per tester node, each running in N threads. The tool is configured to point to MySQL container directly.

6.7.1.2.2.1. YAML for Kubernetes pod

apiVersion: v1
kind: Pod
metadata:
  name: mysql
  labels:
    name: mysql
spec:
  containers:
    - name: mysql
      image: mysql/mysql-server:5.7
      env:
        - name: MYSQL_ROOT_PASSWORD
          value: r00tme
      volumeMounts:
        - name: mysql-data
          mountPath: /var/lib/mysql
  volumes:
    - name: mysql-data
      hostPath:
        path: /var/lib/mysql

6.7.1.2.2.2. Throughput

The following chart shows the number of queries, read/write queries and transactions depending on total thread count.

Throughput
threads queries per sec read/write queries per sec transactions per sec
20 45929.93 41336.65 2296.42
40 65418.03 58875.32 3270.64
60 71185.91 64063.57 3558.65
80 67894.49 61103.56 3393.92
120 70333.68 63299.39 3515.37
160 70310.28 63276.21 3513.48
200 69755.76 62775.64 3485.03