Suitable MySQL benchmark tool
I'm looking for a benchmark tool that can benchmark MySQL Replication.
- It can connect to multiple replicas and the master. So it does write operations on the master, and reads from slaves.
- It should also be capable for adjusting read (SELECT)/write (UPDATE, DELETE ...) ratio, or change the number of read and number of write.
- The output is expected to be tps or more.
Does anyone can suggest a tool for me? Thanks in advance.
Unfortunately, I don't know of any benchmarks which perform R/W splitting. This is something you may have to build yourself, but it should be fairly straightforward to modify existing benchmarks as mysqlslap or the MySQL Benchmark Suite.
use sysbench.. its good.. http://www.howtoforge.com/how-to-benchmark-your-system-cpu-file-io-mysql-with-sysbench
-Priyesh
精彩评论