I want to emulate some shared-hosting activity in testing environment. Is particularly interested I/O performance. Need to emulate: many sql queries, http queries, and some additional activity, extracting large archive for example.
Comes to mind only creating full copy of shared-hosting server, all sites, with all bases and write some daemon for parsing access.log and perform requests from it. But even in this case there are difficulties: need to copy a thousand sites, many queries in log at any second, must be provided POST queries, not only GET, need to be authorized on dozens of sites (some heavy queries produced by operation in administrative section of sites.)
Maybe there is a ready solution for this test?
Operating system of test platform: FreeBSD
UPD: purpose of the test - compare the performance of the system with different mysql solution and different configuration of RAID (usual mirror and hybrid mirror ).