Re: Using HBase for real time transaction

2011-09-21 Thread Jean-Daniel Cryans
On Wed, Sep 21, 2011 at 8:36 AM, Jignesh Patel wrote: >  I am not looking for relational database. But looking creating multi tenant > database, now at this time I am not sure whether it needs transactions or not > and even that kind of architecture can support transactions. Currently in HBase

Re: Using HBase for real time transaction

2011-09-21 Thread Jignesh Patel
On Sep 20, 2011, at 10:06 PM, Jean-Daniel Cryans wrote: >> I think there has to be some clarification. >> >> The OP was asking about a mySQL replacement. >> HBase will never be a RDBMS replacement. No Transactions means no way of >> doing OLTP. >> Its the wrong tool for that type of work. > >

Re: Using HBase for real time transaction

2011-09-20 Thread Jean-Daniel Cryans
> I think there has to be some clarification. > > The OP was asking about a mySQL replacement. > HBase will never be a RDBMS replacement.  No Transactions means no way of > doing OLTP. > Its the wrong tool for that type of work. Agreed, if you are looking to handle relational data in a relational

RE: Using HBase for real time transaction

2011-09-20 Thread Michael Segel
> Date: Tue, 20 Sep 2011 15:05:31 -0700 > Subject: Re: Using HBase for real time transaction > From: jdcry...@apache.org > To: common-user@hadoop.apache.org > > While HBase isn't ACID-compliant, it does have have some guarantees: > > http://hbase.apache.org/acid-

Re: Using HBase for real time transaction

2011-09-20 Thread Jean-Daniel Cryans
transactional because it doesn't support > transactions. > Nor is HBase ACID compliant. > > Having said that, yes you can use HBase to serve data in real time. > > HTH > > -Mike > > >> Subject: Re: Using HBase for real time transaction >> From: ji

RE: Using HBase for real time transaction

2011-09-20 Thread Michael Segel
Since Tom isn't technical... ;-) The short answer is No. HBase is not capable of being a transactional because it doesn't support transactions. Nor is HBase ACID compliant. Having said that, yes you can use HBase to serve data in real time. HTH -Mike > Subject: Re: Using H

RE: Using HBase for real time transaction

2011-09-20 Thread GOEKE, MATTHEW (AG/1000)
for real time transaction Tom, Let me reword: can HBase be used as a transactional database(i.e. in replacement of mysql)? The requirement is to have real time read and write operations. I mean as soon as data is written the user should see the data(Here data should be written in Hbase

Re: Using HBase for real time transaction

2011-09-20 Thread Jignesh Patel
Tom, Let me reword: can HBase be used as a transactional database(i.e. in replacement of mysql)? The requirement is to have real time read and write operations. I mean as soon as data is written the user should see the data(Here data should be written in Hbase). -Jignesh On Sep 20, 2011, at

Re: Using HBase for real time transaction

2011-09-20 Thread Tom Deutsch
Real-time means different things to different people. Can you share your latency requirements from the time the data is generated to when it needs to be consumed, or how you are thinking of using Hbase in the overall flow? Tom Deutsch Program Dir