• Overview
  • Why an Appliance
  • MySQL Appliance
  • Memcached/NoSQL Appliance
  • Slashing Your TCO
  • IBM x3650 M2 Platform
  • The Schooner Advantage

MySQL Appliance

Schooner MySQL with InnoDB is optimized and tuned to fully exploit the power and efficiency of flash memory and multi-core processors. We deliver our software innovations on a turkney x86 Linux server from IBM, and call it the Schooner Appliance for MySQL Enterprise with InnoDB. We deliver that way for maximum performance, reliability, and ease of use.

Take a typical commodity server running MySQL with InnoDB or any of its variants, and compare its performance against the Schooner MySQL Appliance. If you're running on HDDs, the Schooner MySQL Appliance delivers an order-of-magnitude performance gain. If you're running on the best alternative flash-based solutions, the Schooner MySQL Appliance is 2x - 3x faster.

In either case Schooner also offers less downtime, easier management, and a 60% lower three-year total cost of ownership (TCO) due to lower capex and opex. Our tight integration of our optimized software with multi-core processors, flash memory, DRAM, and high-speed interconnects delivers compelling business value.

The Schooner MySQL Appliance offers additional benefits to complement its industry-leading performance and server consolidation. The Schooner MySQL Appliance:

• Is fully certified as 100% compatible by Oracle/MySQL, making it easy to integrate into existing environments;
• Looks just like any other x86 Linux-based server on your network, because it is one;
• Greatly simplifies the scaling needed to meet rapidly growing data sets by reducing the need for sharding across multiple masters, and allowing the consolidation of slaves;
• Supports multi-tenancy, in which completely different MySQL databases can share the same Schooner Appliance;
• Delivers comprehensive data and service availability through its rich set of high-availability / disaster-recovery (HA/DR) features, including replication, backup & restore, and RAID;
• Guarantees database durability and consistency;
• Enables new revenue-producing business opportunities based on rapid access to 512 GB or 1.2 TB of fast flash memory.

Schooner customers highly value the consolidation and TCO savings delivered by the Schooner Appliance. For example, a social networking company saw an immediate 9x throughput improvement using Schooner. Another achieved a 10:1 reduction in the number of slaves by using the Schooner Appliance rather than traditional MySQL servers, realizing significant reductions in TCO, power, space consumption, and application complexity.

Schooner customers also love the ability to effectively run large master databases with very high throughput and excellent response time, reducing sharding. For example, by using the Schooner Appliance rather than traditional MySQL servers, a Web 2.0 financial services company is achieving a 5x performance improvement in query response time and throughput for business analytics applications that require heavy dynamic updates and inserts against their 1TB MySQL database.

If your demanding applications rely on MySQL and InnoDB, you can rely on Schooner to deliver better performance, smoother scalability, higher availability, and a much lower TCO than any HDD or flash-based alternative.