Dolphin Express accelerates MySQL applications

Up to 10 times faster MySQL

New reports show that Dolphin Express accelerates single node MySQL 10 times. Read more about the exteme speedup.

Dolphin Express enables users of MySQL and MySQL Cluster to transparently achieve superior database performance on multicore servers or clusters from two to hundreds of nodes. MySQL and Dolphin Express together create a powerful platform ideal for running large databases on multicore or cluster architectures. The key to achieving overall superior performance is maximizing the efficiency of the underlying server architecture. Dolphin has perfected the Dolphin Express technology with Dolphin SuperSockets Software to deliver the fastest memory-to memory data transfers that are critical to database performance. More details about SuperSockets.

Individual database records and queries are relatively small entities of data and for multicore servers and clusters to be efficient and scalable, these data items need to be moved between processors with the lowest possible latency and overhead. This is why performance and scalability of MySQL Cluster improve significantly with Dolphin Express.

 

Success stories

Dolphin has improved MySQL performance for many years, initially using the specialized MySQL Cluster SCI Transporter, and since 2006 using the innovative SuperSockets plug and play solution. Please take a look at some of the public success stories.

 

MySQL Single node Accelerated - Accelerated Loopback

Dolphin Express SuperSocket library includes transparent local socket acceleration through the standard loopback device. Applications running on SMP systems will experience up to 10 times better latency and 6 times better throughput. More details about SMP loopback device acceleration.

 

Improved MySQL performance

Researchers at MySQL have been working with Dolphin Express technology to document the performance and scalability improvements for MySQL Cluster. A series of tests to compare the performance of Dolphin Express  SuperSockets  to Gigabit Ethernet, concluded that overall for most benchmarks Dophin Express SuperSockets improves MySQL Cluster performance  2 - 4 times.

 

Significantly reduced MySQL response time

In a DBT2 test we have seen up to 292% improvement in response time and in a recent LAMP benchmark, Dolphin Express provided response time improvements of up to 712% compared to Gigabit Ethernet. MySQL recommends Dolphin Express on their web site as the solution for efficient scaling of MySQL Cluster.

 

Plug and play Easy integration with mysql

The use of Dolphin SuperSockets only requires installation of the Dolphin Express hardware, device driver and the Dolphin SuperSockets Library leaving applications and MySQL software totally untouched. The Dolphin SuperSockets library ensures full transparency for all applications using socket communication, meaning that all versions of MySQL and MySQL Cluster can be used with Dolphin SuperSockets.

 

Storage replication using DRBD

DRDB based storage replication running over SuperSockets provides a high speed, low latency storage platform for MySQL Databases. Read more about using DRBD with MySQL.

 

High Availability

Redundant Dolphin Express networks are supported for High Availability applications demanding immediate failover capabilities. The SuperSockets software will do channel bonding for increased performance while both redundant networks are available. SuperSockets will transparently switch to Ethernet if all available Dolphin Express networks becomes unavailable. More information about SCI and High Availabilty.

 

Highly scalable

The solution is scalable from two to several hundred computers, all connected using a low-cost Dolphin Express ring (SCI), the two dimensional Dolphin Express Torus topology (SCI) or a Dolphin Express DXS-switch (currently supporting up to 10 ports).

 

Installation

The software comes with an installer that in most cases will be able to automatically install and configure your cluster after answering a few questions. Manual installation is also possible. Please visit the installation pages for more information. The software supports live installations and rolling upgrades ensuring continued applications operations.

 

Availability

Dolphin SuperSockets has been used in MySQL Cluster production systems since 2006. Dolphin Express SuperSockets are currently available for most Linux distributions running AMD or Intel x86 or x86_64. The software has been ported to Solaris and Windows and is currently being beta tested. Please contact Dolphin if you would like to participate in the windows and Solaris beta testing.