• Overview
  • SchoonerSQL
    • Optimizing InnoDB for Top Performance
    • Reducing Sharding and Consolidating Slaves
    • Consolidating with Integrated Multi-Instance
    • Simplified Cluster Administration
  • Membrain
  • Supported Platforms
  • Pricing and Licensing

Radically Simplified Cluster Administration

Visually Appealing Web-Based GUI

SchoonerSQL includes a web-based cluster administration GUI that makes life a lot easier for DBAs and developers. No more writing scripts or pulling hairs when the database goes down or when a database migration is required. Just relax or sip a cup of coffee while SchoonerSQL efficiently handles these things.

Read more below about the visibility and control that SchoonerSQL provides.

Understanding Your Database Environment

Our cluster administration GUI carefully monitors your entire database platform and provides useful optimization statistics with extensive displays of resource utilization. These include:

• Physical (cores, storage, network) and logical (buffers, locks) resources
• CPU, disk, RAM usage
• I/O read and write (kb/s)
• Bytes in and out (kb/s)

Online Provisioning of Your Servers

SchoonerSQL removes the hassles and headaches of manual failover or restarting the failed instance. Our GUI will

• On the fly Create/Start/Stop/Remove MySQL instances
• Assign VIPs to Masters, Read Masters, and Asynchronous Masters and Slaves
• Create Synchronous and Asynchronous groups or clusters
• Assign Master role
• Choose priorities for auto failover
• Automatic failover and failback

One-Click Database Migration

We provide an easy way of migrating an instance from one node to another node within a synchronous cluster group through our one-click "migrate" button. You have the option of selecting the source node and the target node for migration. One-click database migration saves plenty of time and effort for the users.

Integrated Online Full and Incremental Hot Backup

SchoonerSQL gives users the flexibility to do both logical backup through "mysqldump" or "hot backup" through our online backup tool. With hot backup you get the option of "Full Backup" or "Incremental Backup" at regular intervals (scheduled backup).

The tool also supports full database restore and automatic synchronization of the Read Master / Slave with its Master.

Email-Based Alerts

SchoonerSQL sends email-based alerts that are very useful in monitoring the overall database cluster. The alert contains name, date and time, severity, description, and configurable thresholds. The following alerts are supported:

• Instance created/deleted
• Instance up/down
• Instance attached/detached
• Group created/removed
• Recovery started with several phases
• Async failover
• VIP configuration