You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Bhupendra Baraiya <Bh...@continuum.net> on 2016/03/22 08:12:27 UTC
Transaction Support in Cassandra
HI ,
We are currently thinking of moving from Sql to Cassandra but our major worry here is we have a system which required concurrent 200 connection at time and they do the updates and insert and delete which requires Transaction support
When I searched o Google about these what I got is Cassandra support Lightweight Transaction And Quorum consistency is there any other way we can achieve the same Transaction support in Cassandra as available in Ms Sql Server
Below is the link where Team had actually build Transaction support in Cassandra same as there is Sql Server is it available to Public (all those who download latest Cassandra)
http://www.planetcassandra.org/blog/interview/acid-transactions-with-apache-cassandra-social-network-ok-ru-moves-from-microsoft-sql-to-handle-200m-users/
Thanks and regards,
Bhupendra Baraiya
Continuum Managed Services, LLC.
p: 902-933-0019
e: bhupendra.baraiya@continuum.net<ma...@continuum.net>
w: continuum.net
[http://cdn2.hubspot.net/hub/281750/file-393087232-png/img/logos/email-continuum-logo-151x26.png]<http://www.continuum.net/>
Re: Transaction Support in Cassandra
Posted by Emīls Šolmanis <em...@gmail.com>.
That said, if you *really* want transactionality other than what's provided
by batches, you should probably look into a more suitable solution. Using
Cassandra exclusively with lightweight transactions at quorum writes will
put serious load on it, and you probably won't achieve decent write
throughput. Closest you can come to that sounds reasonable is batched
mutations at single consistency with quorum reads.
You might also want to read through the docs, e.g.,
http://docs.datastax.com/en/cassandra/2.2/cassandra/architecture/archIntro.html
since it seems you don't understand some fundamental concepts of how
Cassandra operates.
On Tue, 22 Mar 2016 at 10:08 DuyHai Doan <do...@gmail.com> wrote:
> "So what will be the closest Alternative of Transaction in Cassandra"
> --> A batch of mutations with LightweightTransaction for a single
> partition or simple LightweightTransaction
>
> On Tue, Mar 22, 2016 at 11:04 AM, Bhupendra Baraiya <
> Bhupendra.Baraiya@continuum.net> wrote:
>
>> Ok so we will not get what they had developed
>>
>>
>>
>> So what will be the closest Alternative of Transaction in Cassandra
>>
>>
>>
>> Thanks and regards,
>>
>>
>>
>> *Bhupendra Baraiya*
>>
>> Continuum Managed Services, LLC.
>>
>> p: 902-933-0019
>>
>> e: bhupendra.baraiya@continuum.net
>>
>> w: continuum.net
>>
>> <http://www.continuum.net/>
>> [image: image001.png]
>>
>>
>>
>> *From:* DuyHai Doan [mailto:doanduyhai@gmail.com]
>> *Sent:* March 22, 2016 1:20 PM
>> *To:* user@cassandra.apache.org
>> *Subject:* Re: Transaction Support in Cassandra
>>
>>
>>
>> First Ok.ru support for acid transactions is using a complete FORK of
>> Apache Cassandra so people using it need to maintain the fork themselves.
>>
>> Second, as far as I know, they don't intend to publish the source code so
>> it's not really available in the public space either. The reason is that
>> their architecture has been tailored for their own usage and hardware so I
>> 'm not sure it can be adapted for general purpose public usage...
>>
>> Le 22 mars 2016 08:12, "Bhupendra Baraiya" <
>> Bhupendra.Baraiya@continuum.net> a écrit :
>>
>> HI ,
>>
>>
>>
>> We are currently thinking of moving from Sql to Cassandra but our major
>> worry here is we have a system which required concurrent 200 connection at
>> time and they do the updates and insert and delete which requires
>> Transaction support
>>
>>
>>
>> When I searched o Google about these what I got is Cassandra support
>> Lightweight Transaction And Quorum consistency is there any other way we
>> can achieve the same Transaction support in Cassandra as available in Ms
>> Sql Server
>>
>>
>>
>> Below is the link where Team had actually build Transaction support in
>> Cassandra same as there is Sql Server is it available to Public (all those
>> who download latest Cassandra)
>>
>>
>>
>>
>> http://www.planetcassandra.org/blog/interview/acid-transactions-with-apache-cassandra-social-network-ok-ru-moves-from-microsoft-sql-to-handle-200m-users/
>>
>>
>>
>> Thanks and regards,
>>
>>
>>
>> *Bhupendra Baraiya*
>>
>> Continuum Managed Services, LLC.
>>
>> p: 902-933-0019
>>
>> e: bhupendra.baraiya@continuum.net
>>
>> w: continuum.net
>>
>> <http://www.continuum.net/>
>> [image: image001.png]
>>
>>
>>
>>
>
Re: Transaction Support in Cassandra
Posted by DuyHai Doan <do...@gmail.com>.
"So what will be the closest Alternative of Transaction in Cassandra"
--> A batch of mutations with LightweightTransaction for a single partition
or simple LightweightTransaction
On Tue, Mar 22, 2016 at 11:04 AM, Bhupendra Baraiya <
Bhupendra.Baraiya@continuum.net> wrote:
> Ok so we will not get what they had developed
>
>
>
> So what will be the closest Alternative of Transaction in Cassandra
>
>
>
> Thanks and regards,
>
>
>
> *Bhupendra Baraiya*
>
> Continuum Managed Services, LLC.
>
> p: 902-933-0019
>
> e: bhupendra.baraiya@continuum.net
>
> w: continuum.net
>
> [image:
> http://cdn2.hubspot.net/hub/281750/file-393087232-png/img/logos/email-continuum-logo-151x26.png]
> <http://www.continuum.net/>
>
>
>
> *From:* DuyHai Doan [mailto:doanduyhai@gmail.com]
> *Sent:* March 22, 2016 1:20 PM
> *To:* user@cassandra.apache.org
> *Subject:* Re: Transaction Support in Cassandra
>
>
>
> First Ok.ru support for acid transactions is using a complete FORK of
> Apache Cassandra so people using it need to maintain the fork themselves.
>
> Second, as far as I know, they don't intend to publish the source code so
> it's not really available in the public space either. The reason is that
> their architecture has been tailored for their own usage and hardware so I
> 'm not sure it can be adapted for general purpose public usage...
>
> Le 22 mars 2016 08:12, "Bhupendra Baraiya" <
> Bhupendra.Baraiya@continuum.net> a écrit :
>
> HI ,
>
>
>
> We are currently thinking of moving from Sql to Cassandra but our major
> worry here is we have a system which required concurrent 200 connection at
> time and they do the updates and insert and delete which requires
> Transaction support
>
>
>
> When I searched o Google about these what I got is Cassandra support
> Lightweight Transaction And Quorum consistency is there any other way we
> can achieve the same Transaction support in Cassandra as available in Ms
> Sql Server
>
>
>
> Below is the link where Team had actually build Transaction support in
> Cassandra same as there is Sql Server is it available to Public (all those
> who download latest Cassandra)
>
>
>
>
> http://www.planetcassandra.org/blog/interview/acid-transactions-with-apache-cassandra-social-network-ok-ru-moves-from-microsoft-sql-to-handle-200m-users/
>
>
>
> Thanks and regards,
>
>
>
> *Bhupendra Baraiya*
>
> Continuum Managed Services, LLC.
>
> p: 902-933-0019
>
> e: bhupendra.baraiya@continuum.net
>
> w: continuum.net
>
> [image:
> http://cdn2.hubspot.net/hub/281750/file-393087232-png/img/logos/email-continuum-logo-151x26.png]
> <http://www.continuum.net/>
>
>
>
>
RE: Transaction Support in Cassandra
Posted by Bhupendra Baraiya <Bh...@continuum.net>.
Ok so we will not get what they had developed
So what will be the closest Alternative of Transaction in Cassandra
Thanks and regards,
Bhupendra Baraiya
Continuum Managed Services, LLC.
p: 902-933-0019
e: bhupendra.baraiya@continuum.net<ma...@continuum.net>
w: continuum.net
[http://cdn2.hubspot.net/hub/281750/file-393087232-png/img/logos/email-continuum-logo-151x26.png]<http://www.continuum.net/>
From: DuyHai Doan [mailto:doanduyhai@gmail.com]
Sent: March 22, 2016 1:20 PM
To: user@cassandra.apache.org
Subject: Re: Transaction Support in Cassandra
First Ok.ru support for acid transactions is using a complete FORK of Apache Cassandra so people using it need to maintain the fork themselves.
Second, as far as I know, they don't intend to publish the source code so it's not really available in the public space either. The reason is that their architecture has been tailored for their own usage and hardware so I 'm not sure it can be adapted for general purpose public usage...
Le 22 mars 2016 08:12, "Bhupendra Baraiya" <Bh...@continuum.net>> a écrit :
HI ,
We are currently thinking of moving from Sql to Cassandra but our major worry here is we have a system which required concurrent 200 connection at time and they do the updates and insert and delete which requires Transaction support
When I searched o Google about these what I got is Cassandra support Lightweight Transaction And Quorum consistency is there any other way we can achieve the same Transaction support in Cassandra as available in Ms Sql Server
Below is the link where Team had actually build Transaction support in Cassandra same as there is Sql Server is it available to Public (all those who download latest Cassandra)
http://www.planetcassandra.org/blog/interview/acid-transactions-with-apache-cassandra-social-network-ok-ru-moves-from-microsoft-sql-to-handle-200m-users/
Thanks and regards,
Bhupendra Baraiya
Continuum Managed Services, LLC.
p: 902-933-0019<tel:902-933-0019>
e: bhupendra.baraiya@continuum.net<ma...@continuum.net>
w: continuum.net<http://continuum.net>
[http://cdn2.hubspot.net/hub/281750/file-393087232-png/img/logos/email-continuum-logo-151x26.png]<http://www.continuum.net/>
Re: Transaction Support in Cassandra
Posted by DuyHai Doan <do...@gmail.com>.
First Ok.ru support for acid transactions is using a complete FORK of
Apache Cassandra so people using it need to maintain the fork themselves.
Second, as far as I know, they don't intend to publish the source code so
it's not really available in the public space either. The reason is that
their architecture has been tailored for their own usage and hardware so I
'm not sure it can be adapted for general purpose public usage...
Le 22 mars 2016 08:12, "Bhupendra Baraiya" <Bh...@continuum.net>
a écrit :
> HI ,
>
>
>
> We are currently thinking of moving from Sql to Cassandra but our major
> worry here is we have a system which required concurrent 200 connection at
> time and they do the updates and insert and delete which requires
> Transaction support
>
>
>
> When I searched o Google about these what I got is Cassandra support
> Lightweight Transaction And Quorum consistency is there any other way we
> can achieve the same Transaction support in Cassandra as available in Ms
> Sql Server
>
>
>
> Below is the link where Team had actually build Transaction support in
> Cassandra same as there is Sql Server is it available to Public (all those
> who download latest Cassandra)
>
>
>
>
> http://www.planetcassandra.org/blog/interview/acid-transactions-with-apache-cassandra-social-network-ok-ru-moves-from-microsoft-sql-to-handle-200m-users/
>
>
>
> Thanks and regards,
>
>
>
> *Bhupendra Baraiya*
>
> Continuum Managed Services, LLC.
>
> p: 902-933-0019
>
> e: bhupendra.baraiya@continuum.net
>
> w: continuum.net
>
> [image:
> http://cdn2.hubspot.net/hub/281750/file-393087232-png/img/logos/email-continuum-logo-151x26.png]
> <http://www.continuum.net/>
>
>
>