We have lots of mysql servers, master-slave and sharded databases. A
recurring task when a new feature/application comes in to test the
database with real workload. This needs test data and test query
generation. Until now I did this with ad-hoc scripts, I looked for tools
to do this, so far I found nothing.
The closest thing to this was benerator, but it doesn't generate test
queries. I need to measure write performance too (or concurrent
read/write performance), so it would be good if I can tell the tool to
generate bulk inserts with n records or generate a csv file or generate
single insert... statements, so I can simulate the application's
workload (of course I can do this with the application itself, but in
development stage it is important to see how the database itself performs).
Does such a tool exists? No problem if it is mysql only. If not, I think
I will write one.