Galera Cluster for MySQL

Features

MySQL/Galera is synchronous multi-master cluster for MySQL/InnoDB database, having features like:

• Synchronous replication
• Active-active multi-master topology
• Read and write to any cluster node
• Automatic membership control, failed nodes drop from the cluster
• Automatic node joining
• True parallel replication, on row level
• Direct client connections, native MySQL look & feel

Benefits

These features yield un-seen benefits for a DBMS clustering solution:

• No slave lag
• No lost transactions
• Both read and write scalability
• Smaller client latencies

Technology

MySQL/Galera cluster uses Galera library for the replication implementation. To interface with Galera replication, we have enhanced MySQL server to support replication API definition in the wsrep API project.

The implementation of the replication API in MySQL server , happens in open source project: MySQL-wsrep.

Founded in 2008, eNovance is a "new generation" hosting and managed services company, pioneer in Open Source Cloud Computing and Multi-Cloud Management.

eNovance is specialized in improving the end-user experience for web and mobile applications (high performance and high availability features), Big Data solutions (elasticity, reactivity, international distribution, performance, resilience), Cloud Computing (automatization, elasticity, "on-demand" services) and Open Source/Open Cloud environments.

"Our objective is to provide our clients with the best end-user experience possible" - Raphaël Ferreira, CEO, eNovance

eNovance is also in the Top 10 contributors of the OpenStack project (Open Source IaaS) and launched in May 2012 the 1st European OpenStack Cloud: eNocloud.

Developed by Monty Program AB, MariaDB is an enhanced, backwards-compatible, drop-in replacement of the MySQL® database server.

MariaDB strives to be the logical choice for database professionals looking for a robust, scalable, and reliable SQL server. To accomplish this, Monty Program works to hire the best and brightest developers in the industry, work closely and cooperatively with the larger community of users and developers in the true spirit of Free and open source software, and release software in a manner that balances predictability with reliability. Much more information is available on the Monty Program website, and we heartily encourage you to spend some time reading before installing or deploying MariaDB.

Here are some important resources to get you started. All links will redirect you to external sites, noted in parentheses.

• About MariaDB (kb.askmonty.org)
• Downloading MariaDB (downloads.askmonty.org)
• MariaDB vs MySQL (kb.askmonty.org)
• MariaDB code hosting (Launchpad)
• How to contribute code (kb.askmonty.org)
• Monty Program's community ethos (montyprogram.com)
• Monty Program's commercial offerings (montyprogram.com)

Schooner provides off-the-shelf MySQL and NoSQL software products for use in the most demanding mission-critical apps. Schooner MySQL Enterprise with Active Cluster is a full distribution of MySQL + InnoDB, with multi-threaded synchronous replication deeply integrated into InnoDB. Active Cluster solves the problems in traditional MySQL replication, delivering high availability with great performance, guaranteed data consistency, no slave lag, immediate automated failover, and dramatically simpler cluster administration. Active Cluster works with databases that use hard drives or flash memory for persistent storage, and is part of the SkySQL Reference Architecture.

Sphinx is an open source full text search server, designed from the ground up with performance, relevance (aka search quality), and integration simplicity in mind. It's written in C++ and works on Linux (RedHat, Ubuntu, etc), Windows, MacOS, Solaris, FreeBSD, and a few other systems.

Sphinx lets you either batch index and search data stored in an SQL database, NoSQL storage, or just files quickly and easily — or index and search data on the fly, working with Sphinx pretty much as with a database server.

A variety of text processing features enable fine-tuning Sphinx for your particular application requirements, and a number of relevance functions ensures you can tweak search quality as well.

Searching via SphinxAPI is as simple as 3 lines of code, and querying via SphinxQL is even simpler, with search queries expressed in good old SQL.

Sphinx clusters scale up to billions of documents and tens of millions search queries per day, powering top websites such as Craigslist, DailyMotion, NetLog, etc.

And last but not least, it's open-sourced under GPLv2, and the community edition is free to use.

Driven by Tokutek’s proprietary Fractal Tree®indexes, a new data structure that performs up to two orders of magnitude faster than traditional B-Tree technology, TokuDB delivers superlative read/write characteristics that intelligently aggregate and rebalance indexed data. With TokuDB v6.5, MySQL users realize the following benefits:

• Delivers High Insertion Speed -- TokuDB Fractal Tree indexes continue to expand database capacity with huge insertion rates and greater scalability. The latest release delivers an order of magnitude improvement in insertion performance over the competition for flash memory. It is ideal for applications that must simultaneously query and update large volumes of rapidly arriving data (e.g., clickstream analytics). 
• Stores 10x More Data --  TokuDB delivers 10x compression without any performance degradation. Users can therefore take advantage of much greater amounts of available space without paying more for additional storage. 
• Allows Hot Schema Changes -- Hot column addition/deletion/rename/resize provides the ability to add/drop/change a column to a database without taking the database offline. Database administrators are free to redefine or add new fields with no downtime.