• 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

Consolidating with Integrated Multi-Instance

The exceptional performance of SchoonerSQL™ usually lets customers consolidate multiple MySQL master or slave database servers onto a single Schooner-powered x86 server. Multiple masters can be combined to eliminate sharding. Multiple slaves of the same master can be combined to provide parallel slaves. The consolidation ratio is highest (as much as 10x) for MySQL servers using HDDs and still impressive (usually 2x to 4x) for MySQL servers already using flash memory with legacy MySQL 5.1 or 5.5.

When you consolidate multiple master or slave databases onto a single Schooner-powered x86 server, you see the dramatic benefits of:

• Large increase in datacenter productivity due to reduced server capex and opex,
• Drastic reduction or outright elimination of the need for sharding, and
• Greatly simplified administration.

But SchoonerSQL gives you even more flexibility. Each Schooner-powered server can be configured with separate MySQL instances to combine multiple master database servers and/or multiple slave database servers. Yes, that's up to 16 separate MySQL databases simultaneously on a single x86 server running SchoonerSQL.

When you consolidate separate MySQL instances onto a single Schooner-powered server, you have the same flexibility in administration and resource allocation for each instance that you would if each instance was on its own server. For example, each separate MySQL instance on a single server can:

• Be created, started, stopped, re-started, or deleted independently,
• Be tuned independently,
• Have its own backup and recovery settings and schedule,
• Have its own replication properties,
• Have different file system and network security settings, and
• Have separate monitoring and control.

Furthermore, the server resources can be allocated separately to the different instances (e.g., you can statically carve up DRAM into separate buffer pools).

SchoonerSQL makes consolidation easy with single-instance and multi-instance support. Not only does Schooner offer the best performance and highest availability you've ever seen with MySQL — you get easy scaling and great flexibility too. Scale smart, with Schooner.