Thanks Eric and Mark, we were thinking along similar lines. But we already need Cassandra for regular database purpose, so instead of having both Kafka and Cassandra, the possibility of using Cassandra alone was explored.
Another usecase where update notification can be useful is when we want to synchronize two or more instances of same component. Say two threads of component 'A' can share the same database. When a record is updated in database by thread 1, a notification is sent to thread 2. After that thread 2, performs a read. I think this also is an anti-pattern. Regards, Aaditya On Tue, May 24, 2016 at 12:45 PM, Mark Reddy <mark.l.re...@gmail.com> wrote: > +1 to what Eric said, a queue is a classic C* anti-pattern. Something like > Kafka or RabbitMQ might fit your use case better. > > > Mark > > On 24 May 2016 at 18:03, Eric Stevens <migh...@gmail.com> wrote: > >> It sounds like you're trying to build a queue in Cassandra, which is one >> of the classic anti-pattern use cases for Cassandra. >> >> You may be able to do something clever with triggers, but I highly >> recommend you look at purpose-built queuing software such as Kafka to solve >> this instead. >> >> On Tue, May 24, 2016 at 9:49 AM Aaditya Vadnere <sk1...@gmail.com> wrote: >> >>> Hi experts, >>> >>> We are evaluating Cassandra as messaging infrastructure for a project. >>> >>> In our workflow Cassandra database will be synchronized across two >>> nodes, a component will INSERT/UPDATE records on one node and another >>> component (who has registered for the specific table) on second node will >>> get notified of record change. >>> >>> The second component will then try to read the database to find out the >>> specific message. >>> >>> Is it possible for Cassandra to support such workflow? Basically, is >>> there a way for Cassandra to generate a notification anytime schema changes >>> (so we can set processes to listen for schema changes). As I understand, >>> polling the database periodically or database triggers might work but they >>> are costly operations. >>> >>> >>> -- >>> Aaditya Vadnere >>> >> > -- Aaditya Vadnere
