RDS MySQL Load Testing with Sysbench

Sometimes you need to do a load test on MySQL Database to test Auto-Scaling for example. I found a very useful tool called

Run MySQL Load Testing

Let’s load test a fresh created database with only 1 instance (Aurora Auto-Scaling is configured on the test-load-database cluster) :

Create a bash script load_test_mysql.sh and paste inside :

#!/bin/bash



for ((n=0;n<100;n++))

do

 echo $(date)

 sysbench /usr/share/sysbench/oltp_read_only.lua --db-driver=mysql --mysql-db=test --mysql-user=YOUR_MYSQL_USER --mysql-password=YOUR_MYSQL_PASSWORD  --mysql-host=YOUR_MYSQL_HOST --threads=80 run

 echo $n

done

And run the test :

chmod +x load_test_mysql.sh

./load_test_mysql.sh

Here come the magic :

Finally I see that my autoscaling works well as I have two new instances :

😁

If you liked this post, you can find more on my blog https://adrien-mornet.tech/ 🚀