• Overview
  • SchoonerSQL
    • Optimizing InnoDB for Top Performance
    • Reducing Sharding and Consolidating Slaves
    • Consolidating with Integrated Multi-Instance
    • Simplified Cluster Administration
  • Membrain
  • Supported Platforms
  • Pricing and Licensing

Reducing Sharding and Consolidating Slaves

MySQL DBAs often spend a lot of time fighting to keep most of the data in main memory to meet end-user performance expectations. The DBA often repeats these steps: when the database grows, trim it; if you cannot trim, shard it. Sharding requires client-side changes, adding to the programming burden. Schooner's high-availability MySQL distribution — SchoonerSQL™ enables significant master and slave consolidation. Customers often achieve consolidation ratios of 8-to-1 or 10-to-1, which greatly reduces complexity for DBAs and programmers. Available on a vast range of standard x86 servers (learn more about supported platforms), SchoonerSQL lets datacenters do way more with way less hardware and hassle.

Reduce Sharding by Consolidation of Multiple Masters

SchoonerSQL is tuned for extreme multi-threading so it exploits the parallelism of multi-core processors to deliver top performance. We give you high availability with high performance, whether your database is stored on hard drives, a SAN, flash drives or Flashcache. When you want to get the full benefit of flash memory, SchoonerSQL is the fast and low risk path to flash. Flash enables huge masters. Because of our software you get DRAM-like speeds from the full complement of flash memory. The high throughput of SchoonerSQL brings dramatic consolidation from multiple traditional MySQL + InnoDB masters to one Schooner-powered x86 server, as shown below. It also provides headroom, reducing the need for sharding.

Consolidation of Multiple Slaves

The high performance of SchoonerSQL and its ability to support and efficiently use huge amounts of flash memory enables consolidation of many traditional MySQL with InnoDB slaves from separate x86 servers into one Schooner-powered x86 server. Going from MySQL running against hard drives, the consolidation is often 8-to-1 or more, as shown below. Going from MySQL running against the same SSDs that you'd use with SchoonerSQL products but use today with legacy MySQL, you usually get a 2- or even 3-to-1 consolidation.

SchoonerSQL provides server consolidation that dramatically reduces your overall cost and complexity of server deployment, the number of network connections required to connect database clients to slaves, and the power needed to run and cool the servers.

Scale smart, with Schooner. See for yourself with a download and free trial.