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.

Containers
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

Friday, February 17, 2012

Schooner On-Demand Webinars now Available

Database Best Practices for 2012: A Roadmap to Lower TCO

Intended for IT Directors, C-level executives and their direct reports. If your organization suffers from unavailable, inaccurate or less-than-instantaneous data and struggle to strike a balance between affordable IT solutions and those that really deliver, join this webinar series to learn more about high availability paradigm shifts and business continuity best practices.

 

Tips, Tricks and Tools to Improve DBA Quality of Life: A Schooner Tech Series

Intended for DBAs and Sys Admins responsible for managing, monitoring and maintaining data centers.

More information can be found here:-
http://www.schoonerinfotech.com/resources/index.php (click on Webinars)



Wednesday, February 1, 2012

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

Percona recently evaluated the performance of Clustrix appliances by running tpcc-mysql benchmark at a scale factor of 5000 warehouse.
Based on Percona’s blog, each Clustrix appliance node comprises of the following:
  • 2x Intel 4-core processors (Xeon)
  • 48GB RAM (40GB allocated to InnoDB buffer pool)
  • 7x Intel SSD G2 (160GB each), software RAID0
The following results are taken from the report for Clustrix (tpcc-mysql new-order transactions/ 10 seconds):


For convenience, the above results have been converted to TPM (transactions/minute):


You can download the detailed white paper here:
Clustrix_TPCC_Percona_White Paper

The SchoonerSQL Comparison
We were curious to see what a single instance of SchoonerSQL (a full distribution of MySQL/InnoDB)  on a single node could compare at the same benchmark scale - 5000 warehouses with the same benchmark, tpcc-mysql from Percona.

SchoonerSQL was installed on a system with the following configuration:
  • 2x Intel 6-core processors (Westmere)
  • 92GB DRAM (72GB used for InnoDB buffer pool)
  • 8x OCZ SSDs (200GB each) (can be alternatively replaced with FusionIO or Intel)
  • 2x SAS HDDs with NVRAM in RAID controller (for OS and commit log)
  
Result summary: At 64 connections with exactly the same workload conditions, a single SchoonerSQL node measured more throughput than 9 Clustrix nodes.

Tuesday, January 10, 2012

SchoonerSQL 5.1.1 is released

Our continuous investment and advancement has culminated in releasing SchoonerSQL 5.1.1.
This is built on SchoonerSQL 5.1 that includes all the exciting features e.g. auto async replication failover for WAN or LAN, intra-schema parallel replication appliers for WAN or LAN, customized alerts and fast sync recovery.
Highlights below-
  • Improved async parallel applier performance(more than 4x throughput improvement compared to MySQL 5.5)
  • Online upgrades
  • Improved logging and statistics for diagnostics and trouble-shooting
  • Customer requested enhancements and stability fixes


    Friday, December 16, 2011

    Top 7 reasons why DBAs love the SchoonerSQL Cluster Admin GUI

    We posted a new white paper called “Top 7 reasons why DBAs love the SchoonerSQL Cluster Admin GUI”.
    Highlights below-
    1. Online Database Provisioning with Simplified Replication Management
    2. Single Unified View of the Complete Database Environment
    3. Online Database Migration
    4. Granular Database Monitoring
    5. Online Backup with Restore
    6. Integrated Configuration Management with Email-Based Alerts
    7. Centralized Log Management
    Download the detailed white paper in the link below
    http://www.schoonerinfotech.com/resources/index.php










    Thursday, December 1, 2011

    Best-in-class SchoonerSQL 5.1 is GA Now. Try it and get blown away.


    SchoonerSQL 5.1 is now enterprise-ready: a fully tested GA product that can be deployed for your production environment.
    We have added some exciting features like Auto Async Failover across WAN, to make DBAs go ecstatic, and Intra-Schema Parallel Async Appliers to provide 4x throughput compared to MySQL 5.5 async replication.
    We also added Alerts for MySQL Admin Cluster GUI and a new feature called High Speed Incremental Recovery.


    You want to know more? Join this webinar on December 14th 10am PST
    https://www3.gotomeeting.com/register/988533686