Tuesday, March 27, 2012

SchoonerSQL at Percona Live Conference 2012 – Booth #201

Come see Schooner at Percona Live Conference (Booth #201) and learn about SchoonerSQL’s approach to both sync and async replication with parallel appliers. Tired of stale or lagging data in MySQL? Learn how you can achieve data consistency and eliminate slave lag with SchoonerSQL while maintaining 100% compatibility with standard MySQL.
Zero changes required for your application if you have already deployed on MySQL. Visit the Schooner booth to learn more.

Experience a live GUI demo at the booth that will illustrate SchoonerSQL features in a real-world, hands-on format:
  • Instance provisioning and cluster management & monitoring via the Schooner Administrator (GUI)
  • Fault detection and automated failover within a LAN and across the WAN
  • Configuration of synchronous and asynchronous replication clusters
  • Online backup and restore
  • Event-driven e-mail alerts

Attend the Live Session “MySQL Replication: Pros and Cons”
Time: Thursday, April 12th @11:00 - 11:50
Location: Ballroom H
Speaker: Darpan Dinker, VP of Engineering

  • The use of synchronous replication in InnoDB to eliminate data loss and to provide cluster-wide data consistency
  • The use of parallelism and granular concurrency control with synchronous replication to fully exploit commodity servers and storage to maximize performance, resulting in huge datacenter consolidation
  • Extending base synchronous clusters with tightly coupled, parallel asynchronous replication to achieve auto-failover and consistency across geographically dispersed data centers


Monday, March 19, 2012

Two Schooner Webinars this week- HA and Membrain 4.0

Best Practices #2: Stop Trading Performance for High Availability
Tuesday, March 20, 2012, 10 a.m. PT / 1 p.m. ET
Webinar Details
Organizations need both high performance and high availability to remain competitive in today's 24x7 online economy. Please join us in this business discussion to learn how new technologies are, for the first time, offering IT decision makers an alternative that delivers both high performance and high availability, at a lower cost than status-quo solutions.
Register here

How to Get Lightning-Fast Performance with Membrain 4.0 and Fusion-io
Thursday, March 22nd, 11 a.m. PT / 2 p.m. ET 
Webinar Details 
Join this discussion on the latest release of Schooner Membrain (version 4.0) and how pairing it with Fusion-io ioMemory results in DRAM-like performance with the persistence of flash, providing a low-latency solution that accelerates database performance, reduces painful sharing and drives business value through increased server utilization.
Register here

Thursday, March 15, 2012

One SchoonerSQL node provides more throughput than nine Clustrix nodes – Part 2

The Schooner performance team completed a report that documents a TPCC-mysql benchmark run at the scale of 5000 warehouses (about 500GB) to observe stability at high levels of throughput. The impetus for this run was a Clustrix (a Flash-memory storage based database appliance) report documenting the solution’s stability and scalability at 3, 6 and 9 cluster nodes using the same benchmark and at the same scale.

SchoonerSQL executed on Red Hat Enterprise Linux Server v6.2 installed on a commodity Dell server fitted with Fusion ioDriveDuo based Flash memory and the same amount of DRAM as 3 nodes of Clustrix (144GB).

The comprehensive report provides the following details (such that the results can be reproduced):
·      Charts that plot throughput and response time over the period of the run
·      Hardware profile output
·      InnoDB configuration for consistency, durability and sizing
·      MySQL show variables output
·      Layout of database related files on hard-drive and Flash memory
·      MySQL configuration (my.cnf) for SchoonerSQL
·      Exact output from the benchmark driver program

In direct comparison with Clustrix results, one SchoonerSQL node executed higher throughput than 9 nodes of Clustrix.

The SchoonerSQL report can be found at

One SchoonerSQL node provides more throughput than nine Clustrix nodes – Part 1

Tuesday, March 13, 2012

Schooner Membrain™ 4.0 is released

Schooner’s rapid enhancements and continuous development has resulted in the release of Membrain 4.0. It is now generally available and can be deployed in production environments.

Membrain 4.0 highlights:
  • Increase from 512 GB to 1 TB (1024 GB) in the amount of flash memory supported on each x86 server
  • Full-featured graphical user interface (GUI) for easier management and monitoring of the Membrain instances 
  • Support for monitoring instances of stock memcached, which are often used in conjunction with flash-optimized Membrain 
  • Upgraded installer 
  • Upgraded remote diagnostics tool 
  • Support for Red Hat Enterprise Linux 6.2 and CentOS 6.2

Read the press release                                                                                

As this is my first blog post on Membrain, let me give you a brief overview on the technology and its benefits.

Brief Overview
Memcache is a distributed memory caching system that is widely used to speed up dynamic web applications by alleviating database load. But there are several limitations-
  • Data is not persistent (cached data is lost if memcache server goes down)
  • No replication or failover mechanism
  • Cached data is limited to the memory available (in most cases 64GB)
  • No effective monitoring, management GUI tool with backup utility

But Schooner Membrain addresses all of the above issues. It is a flash optimized multi-threaded key-vale store providing high performance coupled with synchronous replication and persistent caching.

Membrain is based on the standard memcached protocol and API, which is 100% compatible.
Integrating Schooner Membrain into your Memcached environment is simply a matter of adding the Schooner’s network interfaces to the configuration files of your Memcached clients. No need to alter your application client code unless you require data persistence.

Membrain server can be used as a standard cache or backend storage medium.One can turn off the persistence if they require just a standard cache.

Membrain Benefits

Persistent Data Store
Schooner Membrain provides the ability for users to store the cached data on either fusion IO or any other PCI-e based flash memory or SSD for persistence. Data is safe even if there is a power outage.

High Availability
It provides high availability through synchronous replication and auto failover. Two Membrain servers can be configured as a mirrored pair, in which data to one server are replicated to the other. If one server in the pair goes down, the other transparently assumes its VIPs and serves its clients.

Membrain supports the creation of multiple virtual storage domains called “containers” to provide fine-grained control over cached resources.
Containers provide isolation and policy control, yet efficiently share processor, DRAM, and flash resources. It can support up to 128 dynamic containers.

Protects against Data Corruption or Data Loss
Many applications need to back up the contents of key-value store to recover from user errors or application-driven data corruption. Membrain supports full and incremental backup and restore of persistent containers to hard disk drives.

Robust GUI
Membrain includes an easy-to-use graphical user interface (GUI) that allows all aspects of configuration, monitoring, management and maintenance that can be performed with intuitive screens and menus.

Huge Consolidation
Membrain can consolidate large number of nodes to fewer nodes.
For example, an application may require a total of 1 TB of memory to achieve a targeted hit rate. If a typical Memcached server has 64 GB of DRAM, this application would require 16 nodes to get the required capacity. Spreading the client workload across 16 nodes results in poor processor and network utilization (<10%). With Membrain one can have the entire working set of the application to be hosted on a single node, enabling balanced use of processor and networking resources leading to huge consolidation.

Download Schooner Membrain white paper below to know more details

Tuesday, March 6, 2012

Schooner becomes an Ispirer Systems partner to enable seamless database migration to SchoonerSQL

Organizations have begun to realize the value of moving from expensive database vendors to Schooner, reaping enterprise functionality at a fraction of the cost.
To better enable these migrations, Schooner and Ispirer have partnered to ensure smooth, seamless database migration to SchoonerSQL, an enterprise-grade SQL database delivering 99.999% uptime at a fraction of the cost of competing solutions. SchoonerSQL is 100% compatible with MySQL, for easy adoption.

SQLWays is a popular tool offered by Ispirer to convert stored procedures, functions, triggers, database schema (DDL) and data from Oracle, Sybase, Informix, IBM, Microsoft SQL Server, PostgreSQL and EnterpriseDB to SchoonerSQL.

This partnership will help Schooner reach more enterprise customers and offer them an easy path to migrate from high cost databases to SchoonerSQL.

Press Release

Migration Services