sysbench 1.1.0 rpm with SSL support

Mysql

For a future article, I was again looking into the possibility of using sysbench to generate data and load on a MySQL database. However, I needed an SSL connection which only version 1.1.0 supports (see issue 308).

Alexey didn’t create a branch and/or release for the version 1.1.0. The code is the master branch.

As you know, I like to install software using the Operating System’s packaging and so I created a rpm for sysbench 1.1.0.

If you are also interested to use this version, here are the rpms for some popular OS and architecture (including Arm):

Now you can use sysbench with the –mysql-ssl option (see the MySQL manual for valid values):

$ sysbench /usr/share/sysbench/oltp_insert.lua –db-driver=mysql
–mysql-host=mysql02 –mysql-user=myadmin
–mysql-password=’Passw0rd!’
–table-size=100000 –tables=8
–mysql-ssl=REQUIRED –threads=2 –rate=8
–report-interval=1 –time=0 run

And we can verify this:

SQL > SELECT variable_value AS tls_version, processlist_user AS
user, processlist_host AS host
FROM performance_schema.status_by_thread AS sbt
JOIN performance_schema.threads AS t
ON t.thread_id = sbt.thread_id
WHERE variable_name = ‘Ssl_version’ AND
processlist_user=’myadmin’
ORDER BY tls_version ;
+————-+———+—————-+
| tls_version | user | host |
+————-+———+—————-+
| TLSv1.2 | myadmin | 109.128.188.66 |
| TLSv1.2 | myadmin | 109.128.188.66 |
| TLSv1.2 | myadmin | 109.128.188.66 |
+————-+———+—————-+

Enjoy MySQL and Sysbench with SSL !