Schooner On-Demand Webinars now Available

Database Best Practices for 2012: A Roadmap to Lower TCO

Intended for IT Directors, C-level executives and their direct reports. If your organization suffers from unavailable, inaccurate or less-than-instantaneous data and struggle to strike a balance between affordable IT solutions and those that really deliver, join this webinar series to learn more about high availability paradigm shifts and business continuity best practices.

• Best Practice #1: Spend Less for High Availability.
  Watch it at your convenience. It is available now. (32 minutes)

 

Tips, Tricks and Tools to Improve DBA Quality of Life: A Schooner Tech Series

Intended for DBAs and Sys Admins responsible for managing, monitoring and maintaining data centers.

• Radically Simpler Database Admin: A Tour of the SchoonerSQL GUI
  Watch it at your convenience. It is available now. (29 minutes)

More information can be found here:-
http://www.schoonerinfotech.com/resources/index.php (click on Webinars)

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

Percona recently evaluated the performance of Clustrix appliances by running tpcc-mysql benchmark at a scale factor of 5000 warehouse.

Based on Percona’s blog, each Clustrix appliance node comprises of the following:

• 2x Intel 4-core processors (Xeon)
• 48GB RAM (40GB allocated to InnoDB buffer pool)
• 7x Intel SSD G2 (160GB each), software RAID0

The following results are taken from the report for Clustrix (tpcc-mysql new-order transactions/ 10 seconds):

For convenience, the above results have been converted to TPM (transactions/minute):

You can download the detailed white paper here:

Clustrix_TPCC_Percona_White Paper

The SchoonerSQL Comparison

We were curious to see what a single instance of SchoonerSQL (a full distribution of MySQL/InnoDB)  on a single node could compare at the same benchmark scale - 5000 warehouses with the same benchmark, tpcc-mysql from Percona.

SchoonerSQL was installed on a system with the following configuration:

• 2x Intel 6-core processors (Westmere)
• 92GB DRAM (72GB used for InnoDB buffer pool)
• 8x OCZ SSDs (200GB each) (can be alternatively replaced with FusionIO or Intel)
• 2x SAS HDDs with NVRAM in RAID controller (for OS and commit log)

  

Result summary: At 64 connections with exactly the same workload conditions, a single SchoonerSQL node measured more throughput than 9 Clustrix nodes.