Load/Stress testing a Galera Cluster
Does anyone know a good way to load/stress test a Galera cluster?
Are there any tools people use?
I'm using MysqlSlap but not sure it's showing me relevant results.
Here's a command I'm using:
mysqlslap --user=root --host=localhost --concurrency=5 --iterations=1000 --number-of-queries=100 --query="REPLACE INTO mytest (ts, id, f1, f2, f3, f4) VALUES (now(), 100*rand(), 'field text', 1000*rand(), 'more text', 1)" --create-schema=mysqlslap --pre-query="CREATE TABLE mysqlslap.mytest(ts TIMESTAMP, id INT NOT NULL PRIMARY KEY, f1 VARCHAR(255), f2 INT, f3 CHAR(20), f4 INT) ENGINE=INNODB" --post-query="DROP TABLE mysqlslap.mytest"
I use a slightly altered version of this command and execute it on three databases, each server updating a single database (mysqlslap, mysqlslap2, mysqlslap3).
The command writes/deletes to the 'mytest' table continuously. I'm not sure why, but this method of testing seems to use up all the memory on each server until the server starts to use swap. The servers have a minimum of 8Gb memory.
I'm running around 10 Wordpress websites on the servers. Would be great to see any suggestions for stress testing tools.
Please sign in to leave a comment.