One SchoonerSQL node provides more throughput than nine Clustrix nodes – Part 2

The Schooner performance team completed a report that documents a TPCC-mysql benchmark run at the scale of 5000 warehouses (about 500GB) to observe stability at high levels of throughput. The impetus for this run was a Clustrix (a Flash-memory storage based database appliance) report documenting the solution’s stability and scalability at 3, 6 and 9 cluster nodes using the same benchmark and at the same scale.

SchoonerSQL executed on Red Hat Enterprise Linux Server v6.2 installed on a commodity Dell server fitted with Fusion ioDriveDuo based Flash memory and the same amount of DRAM as 3 nodes of Clustrix (144GB).

The comprehensive report provides the following details (such that the results can be reproduced):

 

·      Charts that plot throughput and response time over the period of the run

·      Hardware profile output

·      InnoDB configuration for consistency, durability and sizing

·      MySQL show variables output

·      Layout of database related files on hard-drive and Flash memory

·      MySQL configuration (my.cnf) for SchoonerSQL

·      Exact output from the benchmark driver program

In direct comparison with Clustrix results, one SchoonerSQL node executed higher throughput than 9 nodes of Clustrix.

The SchoonerSQL report can be found at

http://www.schoonerinfotech.com/products/schoonersql/index.php#Benchmarks

One SchoonerSQL node provides more throughput than nine Clustrix nodes – Part 1

http://schoonerha.blogspot.com/2012/02/one-schoonersql-node-more-throughput-than-9-clustrix-nodes.html