• Overview
  • Schooner MySQL with Active Cluster
    • High Availability with High Performance
    • Optimizing InnoDB for Top Performance
    • Solving MySQL Replication Problems
    • Reducing Sharding and Consolidating Slaves
    • Consolidating with Integrated Multi-Instance
    • Simplified Cluster Administration
  • Schooner Membrain
  • Supported Platforms
  • Pricing and Licensing
  • The Schooner Advantage

High Availability with High Performance

Schooner MySQL® with Active Cluster™ is a full high-performance high-availability distribution of MySQL + innoDB. Schooner MySQL has high-speed fully-synchronous replication deeply integrated into InnoDB, to deliver high availability with great performance, instant and automated failover, no data loss, and radically simpler cluster administration.

Schooner MySQL Active Cluster replication completely eliminates slave lag. The performance of nodes running Active Cluster replication is superior to standard MySQL asychronous or semi-synchronous replication. And it pretty close to the performance of Schooner MySQL nodes without synchronous replication enabled. The administration of a synchronous cluster is also radically simpler: for example, just click to create a new slave node. Recovery from a failed master or slave node is completely transparent and instantaneous.

Schooner MySQL delivers great performance with replication whether the MySQL database is on hard drives, a SAN, or flash memory (or using Flashcache). Moreover, Schooner MySQL has unique optimizations that fully exploit flash memory for higher performance coupled with lower power consumption, making it easy for datacenters that want to adopt flash.

Schooner MySQL provides these additional benefits:

• Full support for MySQL legacy replication: Schooner MySQL supports MySQL asynchronous replication. Schooner MySQL synchronous replication operates at high speed over a LAN or MAN (metro-area network). Beyond that, the communication time makes synchronous replication too slow for some applications. Asynchronous MySQL replication is still our recommended solution for backup across wide-area networks.
• Flash-based database durability through log and data synchronization on commits and checkpoints: The MySQL with InnoDB transactional model guarantees ACID (atomicity, concurrency, isolation, and durability) compliance. Some MySQL + InnoDB distributions do not preserving ACID semantics when flash drives are used. For example, PCIe-based flash drives often buffer data written by InnoDB in the host's DRAM before writing to the flash drive. SATA flash drives often buffer many writes from InnoDB in internal SSD memory before writing to the flash chips. In such cases, MySQL assumes that writes have been performed, and, if the system crashes or the power fails, these writes are lost. As a result the durability semantic is violated, leading to database corruption. You can move to flash when you want with full confidence: Schooner MySQL guarantees full ACID compliance, ensuring durability through synchronous posting to non-volatile memory of logs and data on commits and checkpoints.
• RAID and Hot Swap: For flash memory users, Schooner MySQL can provide RAID across SAS and SATA flash memory drives so that a failure in a hard drive or SSD will not cause a node failure. Flash drives in the SAS and SATA form factors are hot-swappable, so online repair is a snap.

You can get MySQL and InnoDB free since there are open-source versions available. But the servers to run them aren't free. Neither are the power, pipe, and people needed to run and manage them. Downtime is quite expensive too. Schooner MySQL gives you high availability with high performance with whatever persistent storage you want. And when you use flash, Schooner MySQL turns your standard x86 servers into super-servers that let you handle way bigger loads with way fewer nodes.

Scale smart, with Schooner.