Screencast Example Code

Here is the example project that we used in the HiveDB screencast along with a SQL script to create the databases. You can get the project a couple of ways:

  • Update: the screencast example code is no longer available on GitHub. However you can download a tarball here.

    Checkout the screencast branch from GitHub

    
    $ git clone git://github.com/britt/hivedb.git
    $ cd hivedb/
    $ git checkout --track -b screencast-example origin/screencast
    
    

HiveDB Screencast

A partitioned database in just 15 minutes.

We’ve put together a screencast that gives a quick introduction to working with HiveDB and Hibernate Shards. We’ve tried hard to make it as easy and as much like working with regular Hibernate as possible. With this tutorial you should be able to get a partitioned data store running and ready for development in just a few minutes.


Horizontal Data Partitioning with HiveDB & Hibernate Shards from Britt Crawford on Vimeo.

Pick your poison:

Switching from SVN to Git

We are switching our version control repository from Subversion to Git. Initially I read Why Distributed Version Control Matter to You, Today and shrugged my shoulders and said, “Maybe so, but subversion works fine.” However we recently ran into a situation where we needed more robust branching and merging features than Subversion had to offer, combine that with GitHub’s easy setup and awesome interface, and we were sold.

From now on HiveDB and HiveDB-Blobject will be located at:

  • HiveDB (git://github.com/britt/hivedb.git)
  • Blobject (git://github.com/britt/hivedb-blobject.git)

The old subversion repository will stay online but no new code will be added to it.

To get the source code you can run

git clone git://github.com/britt/hivedb.git

or you can download the tarball.

Download source tarball from GitHub

More info on git

P.S. This maybe the first time that we have mentioned the hivedb-blobject project on the blog. There is more information to come, but the short description is that Blobject is a library that plugs into Hibernate and lets you store the bulk of an object as a serialized blob. Why would you want to do this you might ask? Well, an alter statement on 10^9 rows doesn’t complete very quickly. Blobject lets you store the bulk of your objects as serialized blobs. This way you can store multiple versions of the blob schema in the database simultaneously and upgrade them on demand as they are retrieved.

About

HiveDB is an open source framework for building scalable, high-performance, partitioned MySQL systems created and maintained by:


Join us at the HiveDB-Dev Google group.

Comments

  • Ajit: Does hivedb support aggregation of data across shards? For me this is a very interesting use case and if hivedb...
  • Alex Li: It is a wonderful move to stay away from SVN. Unfortunately, Git seems does not handle file rename/move well...
  • britt: @MikeD Hi MikeD, I’m not sure that I understand your question correctly. So, if I’m answering the...
  • britt: @Divya B 1. HiveDB doesn’t handle replication. In general we defer to MySQL native replication. However,...
  • Divya B: Could you also give us some information about the following? 1. Is there any data replication happening in...