Show HN: AntsDB – a database virtualization software for HBase

AntsDB is a database virtualization software/middleware that provides a low latency high concurrency virtual MySQL layer on top of Hadoop HBase. It is wire compatible with MySQL and supports core features such as all DMLs, most DDLs, transaction control, index, full text search, MVCC, row and table locks etc. It is designed to make HBase, or any data warehouse, an OLTP database.

Up to date, it can work with many MySQL applications such as MySQL console, MySQL command line utilities, MediaWiki, SonarQube, DBeaver, phpMyAdmin, Squirrel SQL etc. I've benchmarked it with YCSB. It is significantly faster than mainstream relational databases. Results can be found at http://www.antsdb.com/?p=171.

I started this project a few years ago with a couple of questions in my mind: (1) why do you need a front-end database if all it does can be done by a middleware (2) I like the scalability of Hadoop but I hate missing the nice features from the traditional relational database. Why can't I have both? (3) How far can you go with Java?

Now I believe I have limited success with my experiment and I'd like to share it with the community. The project is open source. GitHub url is https://github.com/waterguo/antsdb.

You are welcome to try it out or use the code in your own projects. I will be very grateful if you can give me some feedback.