Tuning Cassandra for event sourcing model

2017-05-27 Thread Andrii Biletskyi
Hi all, We use Cassandra as a primary operational database in our data platform. One of the cases - store the latest user profiles information that is sourced from the upstream system. Importantly, we get each time the entire row, not particular columns that were updated. The access pattern is th

High network traffic and cpu after read query

2017-05-20 Thread Andrii Biletskyi
Hi all, Running Cassandra 3.9 on 5 node cluster (c4.2xlarge machines). We have loaded quite huge 350M rows table. Also there are some other read and write operations happening *on other small tables*, but the load is very little, cpu is normally less than 10%, network traffic from and to nodes is