July 28, 2010

dbShards — a lot like an MPP OLTP DBMS based on MySQL or PostgreSQL

I talked yesterday w/ Cory Isaacson, who runs CodeFutures, makers of dbShards. dbShards is a software layer that turns an ordinary DBMS (currently MySQL or PostgreSQL) into an MPP shared-nothing ACID-compliant OLTP DBMS. Technical highlights included: 

Business highlights for CodeFutures and dbShards include:


3 Responses to “dbShards — a lot like an MPP OLTP DBMS based on MySQL or PostgreSQL”

  1. Joe Harris on July 29th, 2010 7:57 am

    Smaller companies who have similar needs (scale out OLTP using MySQL), and are comfortable working without commercial support, should also look into the Spider storage engine for MySQL. http://spiderformysql.com/ Spider provides a simpler version of much of the same functionality.

  2. Fred Holahan on July 30th, 2010 10:47 am

    dbShards is an interesting looking product. If I’m not mistaken, the failover strategy actually uses semi-synchronous replication, which is almost as fast as asynchronous while providing consistency rivaling synchronous approaches. That’s pretty cool.

    I would be interested in knowing:

    1. How dbShards handles partition rebalancing. Does a partition need to be taken offline and rebalanced manually? How are in-flight transactions handled during a rebalancing process? Is there a management console that gives the DBA/sysadmin partition usage info?

    2. What level of integration exists between dbShards and memcached, if any. Vanilla memcached is visible to the application tier and requires things like cache invalidation to be explicitly managed. Does dbShards provide any transparency or other added value for memcached infrastructures?

    3. Why would MySQL users choose dbShards over MySQL Cluster?

  3. I’m collecting data points on NoSQL and HVSP adoption | DBMS2 -- DataBase Management System Services on August 18th, 2010 9:09 am

    […] dbShards has around 6 customers, including Facebook. (Facebook may outpace even Twitter and Zynga in using the most products mentioned in this post.) […]

Leave a Reply

Feed: DBMS (database management system), DW (data warehousing), BI (business intelligence), and analytics technology Subscribe to the Monash Research feed via RSS or email:


Search our blogs and white papers

Monash Research blogs

User consulting

Building a short list? Refining your strategic plan? We can help.

Vendor advisory

We tell vendors what's happening -- and, more important, what they should do about it.

Monash Research highlights

Learn about white papers, webcasts, and blog highlights, by RSS or email.