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 slow access to your data and struggles to strike a balance between affordable IT solutions and those with all of the functionality you need, join this webinar series to learn more about high availability database options for 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)

SchoonerSQL 5.1.1 is released

Our continuous investment has culminated in our release of SchoonerSQL 5.1.1, which includes automatic asynchronous replication and failover across WAN or LAN, intra-schema parallel replication appliers for WAN or LAN, customized alerts and fast synchronous 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

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/white_papers

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

Schooner 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.
Details below-

http://www.schoonerinfotech.com/products/schoonersql/schoonersql_5_1

Want to know more? Join this webinar on December 14th 10am PST

https://www3.gotomeeting.com/register/988533686

Achieving 99.999% Availability with SchoonerSQL

Five 9s or 99.999% availability is a popular term describing the level service up-time in a year; 5 9s is the highest practical level of availability for most organizations. It’s very hard to achieve five 9s with legacy MySQL, and doing so has required plenty of manual intervention and hand-holding. But Schooner’s approach and its replication flexibility bring 5 9s to any datacenter than needs it, with no hassle.

We published a white paper called “Achieving Five 9s with SchoonerSQL”.  This paper describes the architecture of SchoonerSQL™, a full HA build of MySQL and its standard InnoDB storage engine. This paper then explains how to use the flexible synchronous and asynchronous replication modes in SchoonerSQL to get five nines availability. The paper then describes the recommended HA hardware setup for using SchoonerSQL.

You can download the white paper from:

http://www.schoonerinfotech.com/resources/white_papers

SchoonerSQL: True MySQL and InnoDB means Zero Vendor Lock-In

SchoonerSQL™ is and will remain 100% MySQL and InnoDB compliant, assuring that customer investments in MySQL are fully preserved. SchoonerSQL is not a rewrite of MySQL and InnoDB; SchoonerSQL is built using the MySQL and InnoDB commercial source code. Schooner rigorously sticks to this standard and does not introduce any incompatibilities that could lock in a customer to Schooner’s products. Schooner has developed an extensive automated QA test suites and a large verification server farm to ensure standard compliance.

SchoonerSQL enhances and optimizes MySQL, going beyond to provide many unique benefits such as:

  1. 99.999% availability with auto fail-over across LAN/MAN/WAN
  2. Guaranteed no data loss and no stale data with “synchronous read masters”
  3. High scalability and performance inside or across data centers
  4. Simplified GUI to monitor and manage the entire server environment

These benefits are not available from any other MySQL distribution, with or without the various add-ons. Our rigorous adherence to MySQL and InnoDB means that database users can anytime switch from community MySQL to SchoonerSQL or back. There’s never any need to change schemas or data.

Porting data from community MySQL and InnoDB to SchoonerSQL, which is an easy step, has several benefits:

  1. No migration problems
  2. Zero data type changes
  3. No running of special scripts or mysql_upgrade command to check in-compatibilities
  4. Very little downtime
  5. No need to hire special database expertise

Consider an example: If a company X is presently using community MySQL, these are the simple steps it needs to follow after deciding to use SchoonerSQL:

  1. Backup data and transaction logs
  2. Backup MySQL configuration file(s)
  3. Uninstall community MySQL
  4. Install SchoonerSQL
  5. Restore saved data and transaction logs
  6. Put the proper settings into the instance configuration (using our GUI or by editing the new /etc/my.cnf file)
  7. Start the instance.

The same process applies to users who want to move back from SchoonerSQL to Community MySQL. No vendor lock-in.

To sum up, Schooner does not lock you in since we are fully standard based and 100% compatible with MySQL and InnoDB. Users can reap the benefits of SchoonerSQL features and never worry about vendor-lock in.