8 messages in com.mysql.lists.clusterRe: Cluster Benchmarking/Stresstesting| From | Sent On | Attachments |
|---|---|---|
| Bart Verwilst | 22 Jun 2005 00:17 | |
| Jigal van Hemert | 22 Jun 2005 00:47 | |
| Stewart Smith | 22 Jun 2005 02:25 | |
| Jigal van Hemert | 22 Jun 2005 04:06 | |
| Harrison Fisk | 22 Jun 2005 08:25 | |
| Jigal van Hemert | 22 Jun 2005 11:51 | |
| Harrison Fisk | 22 Jun 2005 13:09 | |
| Jigal van Hemert | 23 Jun 2005 00:56 |
| Subject: | Re: Cluster Benchmarking/Stresstesting |
|---|---|
| From: | Jigal van Hemert (jig...@spill.nl) |
| Date: | 06/22/2005 11:51:35 AM |
| List: | com.mysql.lists.cluster |
From: "Harrison Fisk"
On Jun 22, 2005, at 7:07 AM, Jigal van Hemert wrote:
[...]
Maybe you can modify Jeremy Zawodny's "MyBench" script to randomly connect to one of the sql servers in the cluster? http://jeremy.zawodny.com/mysql/mybench/
[...]
Another nice tool that can be used for benchmarking and stress testing is super smack. It is quite customizable as to numbers of connections, which servers to connect to, queries to run, etc... It can also do things such as random data generation for tables and other such useful things. It should be able to closer simulate your application without as much as hacking as MyBench would require.
Without starting a religious war, both tools have their pros and cons: super smack: + has some built in functions for generating data, multi-server connects, etc. (hear say, because there was no documentation on the site) - runs on a couple of *nix-like OS's (not well put, but you get the idea) - uses persistent connections (see FAQ) (not very much like practical applications, e.g. PHP 5 has dropped persistent connections altogether with the MySQLi interface)
mybench + fairly easy customizable (perl scripts) + runs on almost any OS (as long as perl is available for that OS) - requires knowledge of perl
I think both tools will do the job nicely, just pick the one that is easiest to handle in your case.
And Mr. Fisk, we both know that modifying a perl script hardly qualifies as "hacking", as you put it. It wouldn't be very nice of me to call MySQL a bunch of hacks to make storing data in and collecting data from a file a bit easier, would it?
Regards, Jigal.