SchoonerSQL™

Benefits

• Delivers up to 5 9s availability
• Guarantees no lost, stale, or corrupt data
• Eliminates slave lag across a LAN
• Provides immediate automated failover across LAN or WAN
• Makes administration easy through a GUI written for DBAs
• Drives dramatic server consolidation thanks to superior throughput with or without replication
• Maintains 100% compatibility with widely-used MySQL and InnoDB

You'll see substantial savings on servers and on the power, pipe, and people to run them, compared to any other SQL database on the market. Not to mention the real money you save by slashing downtime 95% compared to traditional MySQL. Your DBAs will know a new tranquility from less hassle, and will be free to tackle your backlog.

Learn More

You can get a lot more detail from these Schooner whitepapers:

• The Short Guide to MySQL High Availability Options: 8 pages, discussing the available approaches to HA with MySQL;
• Mission-Critical MySQL and InnoDB: 11 pages, discussing what it takes to achieve HA with MySQL and why SchoonerSQL delivers;
• The Top 10 Reasons Why MySQL Experts Switch to SchoonerSQL: 16 pages, on the key operational advantages that lead customers to buy SchoonerSQL.

See for Yourself

In fact, we think that SchoonerSQL is the most cost-effective OLTP database, bar none, for demanding mission-critical apps. Do a free 21-day trial of SchoonerSQL.

Scale smart, with Schooner.

Capabilities

SchoonerSQL is based on MySQL and InnoDB for extreme ease of adoption. But SchoonerSQL solves the replication problems of traditional MySQL (5.1, 5.5, and the future 5.6) without sacrificing performance. The main capabilities of SchoonerSQL include:

• High-speed (multi-threaded) fully synchronous replication across a LAN or MAN;
• High-speed asynchronous replication across a WAN, which limits the update lag of the remote site to the duration of the network latency;
• Automated immediate failover and recovery across LAN or WAN;
• Radically simplified One-Click Cluster Administration using the SchoonerSQL GUI, which was written to make life easier for DBAs;
• Unlimited read scaling through a combination of synchronous replication over a LAN to "read masters" and asynchronous slaves across LAN or WAN;
• Unlimited write scaling through a deep integration with dbShards from Code Futures, which offers easy and extensible sharding;
• Extensive optimizations to the standard InnoDB storage engine to fully exploit the power of modern multi-core x86 processors [add link the new Tech Note on InnoDB optimizations];
• Unique optimizations to fully exploit flash memory (SSDs) for extreme vertical scaling, by using the full IOPS (I/O operations per second) available from modern flash drives. You can start with data on hard drives or a SAN and migrate to flash to take full advantage of its performance and power consumption benefits;
• Flexible multi-instance support. SchoonerSQL can be configured with separate MySQL instances to combine multiple master database servers and/or multiple slave database servers. You can run up to 16 separate MySQL databases simultaneously on a single x86 server running SchoonerSQL, and set different administration properties for each.

All of this is from our out-of-the-box software product, written for your standard x86 Dell, HP, and IBM servers. You don't need to roll your own. You don't need to buy custom hardware. You don't need to put up with the high total cost of ownership of the traditional enterprise databases.

Benchmarks

Get the Biggest Bang from Your Servers

SchoonerSQL incorporates unique Schooner innovations for maximum multi-threading to provide the best performance and highest throughput on your standard x86 servers, whether your database is on hard drives or flash memory. SchoonerSQL is the top performer both on single nodes and with replication across LAN or WAN.

SchoonerSQL versus Clustrix: Check out this detailed analysis and benchmark of SchoonerSQL on one standard x86 server, with Fusion-io flash drives, outperforming nine Clustrix custom hardware servers.

• One SchoonerSQL node provides more throughput than nine Clustrix nodes
• SchoonerSQL Percona TPCC MySQL details

SchoonerSQL beats Clustrix on Throughput Performance by a Mile

At 64 connections with exactly the same workload conditions, a single SchoonerSQL node measured more throughput than 9 Clustrix nodes.

Supported Platforms

SchoonerSQL™ is the 100%-compatible full build of MySQL and InnoDB that offers 99.999% high availability with high performance, guarantees no lost or stale data, does immediate automated failover over LAN and WAN, provides easy unlimited scaling, and simplifies cluster administration. SchoonerSQL delivers all of this on your standard x86 servers and blades.

Get the Most out of Your Servers

SchoonerSQL's innovative software architecture fully exploits the capabilities of modern x86-based servers, storage technology, and network bandwidth. Here are the main hardware considerations needed to get the full benefit of SchoonerSQL:

• Base Server: Use any HP, Dell, or IBM multi-core x86 server (Intel, not AMD) or blade running Red Hat Linux 5.4 / 5.5 / 6.2 or CentOS 5.4 / 5.5 / 6.2.
• Multiple cores: SchoonerSQL is extensively multi-threaded to fully exploit multiple processor cores. Use a server with at least two 4-, 6-, or 8-core processors; performance scales linearly with number of cores.
• Data storage: Your database can be stored on hard drives, SSDs (solid-state drives or flash drives), or SAN. Adding high-performance high-capacity SSDs is the best way to achieve extreme vertical scaling on each server. SSDs dramatically improve performance compared to HDDs, and there's no hard limit to the amount of flash memory that SchoonerSQL can exploit.
• DRAM: We recommend 64 GB of DRAM, especially when using SSDs for persistent storage since SchoonerSQL caches between DRAM and flash to give you DRAM-type speeds from flash. More DRAM never hurts, but you usually won't need it since SchoonerSQL fully exploits the flash IOPS to deliver performance like what you'd get from using more DRAM.
• Ethernet: You can use 1 GB Ethernet among servers. You can boost the performance of replication in SchoonerSQL by using 10 GB Ethernet.

Use Flash Memory for Extreme Vertical Scaling

SchoonerSQL does not require flash memory; some users deploy with their data on HDDs and others deploy with their data on SSDs. But most users are interested in someday moving to SSDs for its performance and energy-saving benefits. Moving a database from hard drives to flash drives is a great way to maximize application performance while reducing power consumption, and to achieve extreme vertical scaling. SchoonerSQL has unique patent-pending software optimizations that exploit the high I/O rates of multiple flash drives in parallel to get the most from SSDs.

We can help you weigh the tradeoffs in moving from HDDs or SAN to SSDs, and selecting the flash drives that give you the best economics.

See What SchoonerSQL Can Do For You

Download SchoonerSQL for a free 21-day trial.

We're experts in helping you choose the hardware to maximize performance and operational savings. Check out the Tuning Guide that comes with SchoonerSQL. Or contact Schooner sales, which is happy to help.

Learn More

You can get a lot more detail from these Schooner whitepapers:

• The Short Guide to MySQL High Availability Options: 8 pages, discussing the available approaches to HA with MySQL;
• Mission-Critical MySQL and InnoDB: 11 pages, discussing what it takes to achieve HA with MySQL and why SchoonerSQL delivers;
• The Top 10 Reasons Why MySQL Experts Switch to SchoonerSQL: 16 pages, on the key operational advantages that lead customers to buy SchoonerSQL.

See for Yourself

In fact, we think that SchoonerSQL is the most cost-effective OLTP database, bar none, for demanding mission-critical apps. Do a free 21-day trial of SchoonerSQL.

Scale smart, with Schooner.

Pricing and Licensing

Affordable Datacenter Transformation

SchoonerSQL™ is 100% compatible with MySQL and its standard InnoDB storage engine. But SchoonerSQL's breakthrough approach to exploiting commodity hardware gives you higher availability, better performance, and a much lower total cost of ownership than any other enterprise-grade database. SchoonerSQL greatly improves datacenter productivity, enabling you to get a lot more useful work from your standard x86 servers.

Annual Subscriptions

SchoonerSQL is licensed on an Annual Subscription basis on a wide range of x86 servers, with the database on hard drives, SSDs (flash memory), or SAN. The quantity-one fee for an Annual Subscription is US $9,500 on any server of up to two sockets, regardless of the number of processor cores. SchoonerSQL licenses for servers with three or more processor sockets cost more because your annual TCO savings are larger. Please contact Schooner sales for a quote on your specific configuration.

The Annual Subscription fee is paid up front, with a discount for pre-payment for multiple years. Substantial volume discounts apply as well as discounts for large project-, site-, and enterprise-wide licenses. Run the numbers and see how SchoonerSQL saves you money and hassle compared to all other SQL and NoSQL databases.

What You Get with an Annual Subscription

Each SchoonerSQL license includes Schooner Customer Support Service during the subscription term, providing:

• All upgrades (including new functionality)
• All patches and bug fixes
• Unlimited web and telephone support on SchoonerSQL functionality

Optional 24/7 deep MySQL support is available for an additional fee from Schooner partner SkySQL AB.

During your license term you may freely transfer Schooner licenses among supported server families (e.g., move from HP to Dell).

Try Before You Buy

See how Schooner software can deliver high availability with high performance, and transform the economics of your datacenter. Start your free trial of SchoonerSQL today.

Learn More

You can get a lot more detail from these Schooner whitepapers:

• The Short Guide to MySQL High Availability Options: 8 pages, discussing the available approaches to HA with MySQL;
• Mission-Critical MySQL and InnoDB: 11 pages, discussing what it takes to achieve HA with MySQL and why SchoonerSQL delivers;
• The Top 10 Reasons Why MySQL Experts Switch to SchoonerSQL: 16 pages, on the key operational advantages that lead customers to buy SchoonerSQL.

See for Yourself

In fact, we think that SchoonerSQL is the most cost-effective OLTP database, bar none, for demanding mission-critical apps. Do a free 21-day trial of SchoonerSQL.

Scale smart, with Schooner.