Mission-critical MySQL and NoSQL/memcached are usually deployed using replication; the redundancy provides service continuity in the case of unplanned or planned hardware or software outages. But the traditional MySQL and NoSQL replication and failover mechanisms are not very efficient. They often introduce operational problems such as:
- lost, inconsistent, or stale data,
- slave lag,
- a large performance hit compared to single-node usage,
- clumsy ways of setting up and managing a cluster, and
- time-consuming, error-prone manual processes of recovery.
You can learn more about the MySQL side of this in our white paper "The Short Guide to MySQL HA Options."
Schooner replication guarantees no lost or stale data, and no slave lag. Our off-the-shelf, high-availability, high-performance MySQL and NoSQL software products are for the most demanding mission-critical applications:
- SchoonerSQL™: This is our full OLTP database that offers 99.999% high availability with high performance for the most demanding mission-critical applications. SchoonerSQL guarantees no lost or stale data, cuts both planned and unplanned downtime with instant automated failover over LAN and WAN, and provides unlimited read scaling, unlimited write scaling, and easy cluster administration. And it's 100% compatible with MySQL and its standard storage engine, InnoDB.
- Membrain™: This is the smart memcached, optimized to fully exploit the capacity, performance, and power-consumption benefits of flash memory. Membrain offers high-speed synchronous pair-wise replication between nodes, which guarantees no data loss, and supports immediate and automatic failover and recovery.
Scale smart with Schooner to slash your downtime, get great performance, and handle way bigger loads with way fewer nodes. See for yourself, with a download and free trial of SchoonerSQL or Schooner Membrain.