[prev in list] [next in list] [prev in thread] [next in thread] 

List:       cassandra-user
Subject:    Triggers and their use in data indexing
From:       Bèrto ëd Sèra <berto.d.sera () gmail ! com>
Date:       2014-07-03 11:41:47
Message-ID: CAKwGa___vKpu7o+FeiBz7SyLYNT49PEEDubym-bbxw0we_wsUQ () mail ! gmail ! com
[Download RAW message or body]

Hi all,

we are planning a set of 3 data-centres (each located in a different
continent). There is a possibility that the connection among them will
occasionally fail for an unforeseeable length of time. The quorum would be
limited to the local data-centre, as each user access his local
data-centre, with the set of 3 "eventually consistent" as a picture of the
entire business.

The delicate bit is that we also have a search-engine. To insulate it from
network issues among data-centres we would like to have one for each DC.
Data would be indexed per-DC, as soon as it gets locally available.

Now the question: is there any way to use triggers so that they will
locally index data from remote DCs when it comes in?

We are in a very early stage of planning, and I am just trying to make sure
that what we plan makes basic sense, as I never used C* triggers and I am
not sure I get all the implications. The search engine is likely to be
ElasticSearch, though this is not cast in stone ATM.

Cheers
Bèrto

-- 
==============================
If Pac-Man had affected us as kids, we'd all be running around in a
darkened room munching pills and listening to repetitive music.

[Attachment #3 (text/html)]

<div dir="ltr">Hi all,<div><br></div><div>we are planning a set of 3 data-centres \
(each located in a different continent). There is a possibility that the connection \
among them will occasionally fail for an unforeseeable length of time. The quorum \
would be limited to the local data-centre, as each user access his local data-centre, \
with the set of 3 &quot;eventually consistent&quot; as a picture of the entire \
business.  </div> <div><br>The delicate bit is that we also have a search-engine. To \
insulate it from network issues among data-centres we would like to have one for each \
DC. Data would be indexed per-DC, as soon as it gets locally available.  <br> \
<br></div><div>Now the question: is there any way to use triggers so that they will \
locally index data from remote DCs when it comes in?  </div><div><br>We are in a very \
early stage of planning, and I am just trying to make sure that what we plan makes \
basic sense, as I never used C* triggers and I am not sure I get all the \
implications. The search engine is likely to be ElasticSearch, though this is not \
cast in stone ATM.</div> <div><br></div><div>Cheers</div><div>Bèrto<br \
clear="all"><div><br></div>-- <br>==============================<br><span \
style="font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;line-height:17px">If \
Pac-Man had affected us as kids, we&#39;d all be running around in a darkened room \
munching pills and listening to repetitive music.</span> </div></div>



[prev in list] [next in list] [prev in thread] [next in thread]