I took a look. Its kinda fun running mysql client to drive hbase. It seems to work, basically. I had some hiccups and questions which I sent to contact on antsdb project. Also suggest that a page or two on antsdb would help if you explained architecture, examples (if only to show that it IS just like having mysql installed), and what gets created in hbase (and why) so easier figuring whats going on (I had advantage in that I saw half of a talk you gave at hbaseconasia, etc. -- smile).
I'll report more after playing more. Thanks, S On Tue, May 8, 2018 at 2:22 AM Water Guo <[email protected]> wrote: > Dear HBase Community, > > I’d like to take this opportunity to introduce my open source project > AntsDB. It is a database virtualization software that brings MySQL > compatibility to HBase. It means you can use any MySQL bindings such as > JDBC, ODBC, PHP, Perl to manipulate data in HBase. It supports most MySQL > DDLs and all DMLs, transaction control, table locks, row locks etc. Up to > date applications such as MySQL console, MySQL command lines, BenchmarkSQL, > MediaWiki, SonarQube, DBeaver, SquirrelSQL and many others can run directly > on HBase using AntsDB layer. The project is hosted at > https://github.com/waterguo/antsdb. > > AntsDB is designed to support high concurrency, low latency applications. > It uses local storage as cache so it can further reduce the latency of > HBase. We have benchmarked AntsDB using YCSB. The result is at > http://www.antsdb.com/?p=171. > > People always ask me how it is different from Phoenix. While Phoenix is > building a powerful SQL layer for HBase, we want to focus on backward > compatibility. We want to have applications built for MySQL can be used > directly on HBase. And people who are familiar with traditional relational > database can adopt HBase/Hadoop stack with ease. > > I’d be very glad if you find the project is useful and your feedback is > very welcome. > > Thanks > -water >
