I have to design a solution to stress a clon of my manufacturing databases.
In the intervening time, I am utilizing mysql percona xtradb with tree nodes working in google cloud.
I am utilizing haproxy as load database balancer.
All backend microservices in my firm are configured to attach by means of haproxy to the node1 for writes and to the nodes 2 and three for choose.
I wish to make my database 3 times greater.
I’ve cloned my manufacturing database utilizing backups in different google situations now I will populate this database inserting extra information.
I wish to stress my new database x3 greater, utilizing in my load check the highest queries with the poor efficiency that I’ve discovered utilizing my tuning software (Percona monitoring and administration PMM)
I’ve considering in three choices:
- Use mysqlslap
- Use Apache JMeter utilizing jdbc module
- Design my very own stress software utilizing python with flask to show a API with my customized loadTest after which I can use JMeter or soapUi to emphasize with totally different multithread profiles my API and it runs the queries.
I want to have suggestions on the best way to strategy this or to ask if anyone is aware of different instruments to emphasize database in a multithread surroundings.