Chief technical Officer, Schooner Information Technology
In a typical scale out deployment for a MySQL service, granular sharding with small masters is required since the throughput and update rate of MySQL has been so limited. Also, each master is configured with many slaves to scale reads using MySQL asynchronous replication. The slaves lag behind the master causing stale and inconsistent data reads, and the slaves perform at a low performance level due to serial application of updates, increasing the number of required slaves. Failover of master or slaves is an error prone, manual, long process. These issues create a lot of pain for administrators, and negatively impact the quality of service (performance and availability) as well as capital and operating expenses.
Schooner MySQL core fully exploits commodity hardware allowing very large masters with extremely high performance and update traffic(effective scale-up), typically 4-20x the throughput of legacy MySQL. Schooner MySQL Active Cluster provides fully consistent data across the master and each of its slaves, very high perfromance with parallel synchronous replication, and instantaneous, transparent failover, In most cases, Schooner master performance is plenty for the natural database partitions, and master subsharding is not required (in contrast to legacy mysql). Read scaling with slaves is linear, with very simple administration to create, migrate, etc. This is coupled with fast automatic fail-over and recovery for masters or slaves. Descriptions of innovations, analysis, and benchmarks are available at www.SchoonerInfotech.com.
The net results of all of this is that building a scale-out MySQL service with excellent quality of service (high thoughput, low response time, high availability) and low TCO is much easier and cost effective with Schooner MySQL.