cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jack Krupansky <jack.krupan...@gmail.com>
Subject Re: apache cassandra for trading system
Date Fri, 25 Mar 2016 19:33:03 GMT
How much data do you expect to have - amount added per day, number of days
kept, amount of data per trade, number of tradable securities (or whatever
you are trading?

What kind of access patterns do you expect? Like append, any updates, what
queries, any analytics.

Generally, queries and access patterns will drive the data modeling, and
also impact how much data you can realistically place on each node.

What are your HA (High Availability) requirements?


-- Jack Krupansky

On Fri, Mar 25, 2016 at 2:40 PM, Jonathan Haddad <jon@jonhaddad.com> wrote:

> You can use keyspaces with multiple data centers to get what you want.
>
> That said, if you're going to use only 1 node, I don't think Cassandra is
> the right fit for you.
>
>
> http://rustyrazorblade.com/2013/09/cassandra-faq-can-i-start-with-a-single-node/
>
> On Fri, Mar 25, 2016 at 11:09 AM Vero Kato <vero.katos@gmail.com> wrote:
>
>> hi, we are building trading system and we want to use cassandra as our
>> database.
>> we want this set-up:
>> one node which stored one day set of data which will be running on the
>> same host as trading application
>> two nodes which store all data (for the current date and historical)
>> which will be running on other boxes.
>>
>> can you please suggest how easily it will be to have this set-up? i.e. we
>> have three nodes, but one of them (on the same box where our app located)
>> will be discarding all historical data which are older than one day?
>>
>>
>> thanks
>>
>

Mime
View raw message