A few points here...
I don't know why you feel you need to separate your data into 2 clusters.
Cassandra will deal just fine with all your data in a single cluster. You
can use TTLs to keep trade data for as long as you need to and it will get
purged out automatically.
Having 1 node won't give y
thanks, we are going to have 500 000 msgs per day, historical database will
be growing every day, but we also want one cluster with one day of data.
most of the time we will be pushing data into database, but we also want to
execute client's queries and allow them to fetch historical trades and
ord
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 p
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 wrot
have the today_data keyspace only replicate to the host with the trading
application then have the historical_data only replicate to the two node
cluster.
From: Vero Kato
Reply-To:
Date: Friday, March 25, 2016 at 2:09 PM
To:
Subject: apache cassandra for trading system
hi, we are building
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
