Consolidate with Integrated Multi-Instance
The exceptional performance of the Schooner Appliance for MySQL Enterprise with InnoDB allows customers to consolidate up to 8 MySQL database servers onto a single Schooner Appliance. Schooner provides great power and flexibility in consolidating multiple MySQL master database servers or multiple MySQL slave database servers, based on either single instance or multiple instance configurations.
When you consolidate multiple databases into a single instance on a Schooner MySQL Appliance, you see the dramatic benefits of:
- Impressive TCO savings,
- Drastic reduction or outright elimination of the need for sharding, and
- Greatly simplified administration.
Multiple masters can be combined under a Schooner Appliance configured as a single MySQL instance to eliminate sharding, and multiple slaves of the same master can be combined under a single instance to provide parallel slaves.
But the Schooner MySQL Appliance gives you even greater flexibility. Each Schooner Appliance can be configured with separate MySQL instances to combine multiple master database servers and/or multiple slave database servers. Yes, that's all on a single Schooner Appliance.
The key motivations for consolidation though multiple MySQL instances on a Schooner Appliance are separating administration and controlling resource allocation. The separate MySQL instances of the Schooner Appliance can:
- Be tuned independently,
- Have different file system and network security, and
- Have separate monitoring and control.
Furthermore, the Schooner Appliance resources can be allocated separately to the different instances (e.g. statically carve up DRAM into separate buffer pools).
The Schooner MySQL Appliance makes consolidation easy, with flexible single instance and multi-instance support. Not only does Schooner offer the best performance you've ever seen with MySQL along with amazing availability — but you get supreme flexibility as well.