Are Cassandra Triggers Thread Safe? ("Tough questions perhaps!")

Hi, 1. Are Cassandra Triggers Thread Safe? what happens if two writes invoke the trigger where the trigger is trying to modify same row in a partition? 2. Had anyone used it successfully on production? If so, any issues? (I am using the latest version of C* 3.10) 3. I have partitions that are

Re: Help with cassandra triggers

Trigger only gets executed on the coordinator. There's no remote DC trigger. What you need is Change Data Capture (CDC). https://issues.apache.org/jira/browse/CASSANDRA-8844 On Tue, Jan 17, 2017 at 9:40 AM suraj pasuparthy wrote: > Hello > We have a usecase where we need to support triggers wi

Help with cassandra triggers

Hello We have a usecase where we need to support triggers with multiple datacenters. The use case is we need is 1) Data is written into DC1. 2) The Sync configured will sync the data to DC2 3) when the data is written into DC2, we need a trigger to fire on DC2. I have tested the triggers for a loc

Re: Cassandra Triggers

https://issues.apache.org/jira/browse/CASSANDRA-8844 On Wed, Nov 9, 2016 at 8:34 PM, sat wrote: > Hi, > > We are doing POC on Cassandra for our business needs. We also need some > kind of notification when a column/attribute is modified > (insert/update/delete) of a table. > > Thanks for sharing

Re: Cassandra Triggers

Hi, We are doing POC on Cassandra for our business needs. We also need some kind of notification when a column/attribute is modified (insert/update/delete) of a table. Thanks for sharing information about CDC. Could you please point us to some example of how to implement this in Cassandra 3.9.

Re: Cassandra Triggers

They are production ready in the sens that they are fully functional. But using them require a *deep* knowledge of Cassandra Internal Write path and is dangerous because the write path is critical. Alternatively if you need a notification system of new mutation, there is a CDC feature, available s

Cassandra Triggers

Hi, Are Triggers in Cassandra production ready ? Version: Cassandra 3.3.0 Thanks Manoj

Re: Cassandra Triggers - Cassandra internally creating trigger.jar files in /tmp/lib/ directory

Thanks Vladimir!! I did that and it's working good now. It is taking new location when I reloadtriggers. Really appreciate your support! Regards Sudheer On Thursday, October 13, 2016, Vladimir Yudovin wrote: > Yes, pass this argument to bin/cassandra script: > *bin/cassandra -Djava.io.tmpdir=/p

Re: Cassandra Triggers - Cassandra internally creating trigger.jar files in /tmp/lib/ directory

Yes, pass this argument to bin/cassandra script: bin/cassandra -Djava.io.tmpdir=/path/to/tmpdir Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes. On Thu, 13 Oct 2016 00:36:35 -0400sudheer k

Re: Cassandra Triggers - Cassandra internally creating trigger.jar files in /tmp/lib/ directory

Sorry for the confusion. I didn't see that command line arguments you told in the mail. So, this arguments needs to be passed when I start Cassandra? Regards Sudheer On Thursday, October 13, 2016, sudheer k wrote: > Appreciate your reply Vladimir! Is this the configuration I need to > include i

Re: Cassandra Triggers - Cassandra internally creating trigger.jar files in /tmp/lib/ directory

Appreciate your reply Vladimir! Is this the configuration I need to include in Cassandra-env.sh file? Regards Sudheer On Thursday, October 13, 2016, Vladimir Yudovin wrote: > Hi, > > where can I change that default location /tmp/lib it is using for creating > the jar files? > Cassandra uses Jav

Re: Cassandra Triggers - Cassandra internally creating trigger.jar files in /tmp/lib/ directory

Hi, where can I change that default location /tmp/lib it is using for creating the jar files? Cassandra uses Java property java.io.tmpdir as temporary folder. By default it's /tmp but can be changed with command line arguments: cassandra -Djava.io.tmpdir=/path/to/tmpdir Best regards, Vla

Cassandra Triggers - Cassandra internally creating trigger.jar files in /tmp/lib/ directory

Hi All, I faced issue with triggers today. Below is the clear description of the issue: 1) When we planned to use triggers, we placed the triggers.jar file in /conf/triggers folder in Cassandra, restarted the Cassandra service and created a trigger in CQLSH. Everything was working good as expecte

Re: cassandra triggers

On Sun, Mar 22, 2015 at 10:31 PM, Rahul Bhardwaj < rahul.bhard...@indiamart.com> wrote: > I want to use triggers in cassandra. Is there any tutorial on creating > triggers in cassandra . > For the record, it is my understanding that you almost certainly should not use the cu

Re: cassandra triggers

okay, if you leave a comment in the blog on what is breaking and what cassandra, I can take a look at the code when I get the time. :-) jason On Mon, Mar 23, 2015 at 8:15 PM, Asit KAUSHIK wrote: > attached is the code . You follow the process for compiling and using the > code. > > If anything

Re: cassandra triggers

attached is the code . You follow the process for compiling and using the code. If anything more is required please let me know. The Jar file has to be put into /usr/share/cassandra/conf/triggers. Hope this helps Regards asit On Mon, Mar 23, 2015 at 3:20 PM, Rahul Bhardwaj < rahul.bhard...@ind

Re: cassandra triggers

Yes Asit you can share it with me, let c if we can implement with our requirement. Regards: Rahul Bhardwaj On Mon, Mar 23, 2015 at 1:43 PM, Asit KAUSHIK wrote: > Hi Rahul, > > i have created a trigger which inserts a default value into the table. But > everyone are against using it. As its an

Re: cassandra triggers

Hi Rahul, i have created a trigger which inserts a default value into the table. But everyone are against using it. As its an external code which may be uncompatible in future releases. Its was a chnallenge as all the examples are of old 2.0.X veresion where RowMutable package is used which is dis

cassandra triggers

Hi All, I want to use triggers in cassandra. Is there any tutorial on creating triggers in cassandra . Also I am not good in java. Pl help !! Regards: Rahul Bhardwaj -- Follow IndiaMART.com for latest updates on this and more:

Is it possible to synchronous run Cassandra Triggers?

Hi, All I am interested in using the new Cassandra feature Trigger to implement a synchronous (or asynchronous but with deadline) index on Cassandra. The Trigger API allows one to define a mutation job to do (in the future) but is there any way to control when the (asynchronously executed) job is

Cassandra Triggers Capability published out to GitHub

FYI -- http://brianoneill.blogspot.com/2012/03/cassandra-triggers-for-indexing-and.html https://github.com/hmsonline/cassandra-triggers Feedback welcome. Contribution and involvement is even better. ;) -brian -- Brian ONeill Lead Architect, Health Market Science (http

Virgil Moved (and Cassandra-Triggers coming soon)

andra-triggers. It is an AOP-based trigger solution that provides a simple trigger/event-log that can be used for data replication and indexing reacting to column family mutations. https://github.com/hmsonline/cassandra-triggers -brian -- Brian ONeill Lead Architect, Health Market Science