With thanks to Patrick Galbraith and his DBD::drizzle 0.200 I am now able to test client benchmarks side by side with MySQL and Drizzle.
For simple benchmarking with clients, generally when I have little time, I use a simple Perl framework mybench. I was able to change just the connection string and run tests.
The diff of my two scripts where:
---
> my $user = $opt{u} || "appuser";
> my $pass = $opt{p} || "password";
> my $port = $opt{P} || 3306;
> my $dsn = "DBI:mysql:$db:$host;port=$port";
---
< my $user = $opt{u} || "root";
< my $pass = $opt{p} || "";
< my $port = $opt{P} || 4427;
< my $dsn = "DBI:drizzle:$db:$host;port=$port";
---
It’s too early to tell what improvement Drizzle will make. Just running my …
[Read more]