question

igor.rmarinho_185445 avatar image
igor.rmarinho_185445 asked Erick Ramirez edited

How do I deal with big history data from another DB?

Hi guys,

I'd like to have an opinion in situation.

I'm doing a migration from another DB to Cassandra and it has a history table that have 200GB that's 50% of the actual size of my Cassandra DB (400GB), we have to keep the data for legal proposals and everything that's inserted, deleted, updated is written in this table. What would be the best way to deal with a this table in Cassandra, increase resources or create another DC and leave it there? I'm concerned about the amount of additional access will degraded the overall performance.

Thank you.

cassandra
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered Erick Ramirez edited

I don't see that this table will present any problems In my experience, a transaction log table is mostly a write-once and maybe read-never or hardly ever.

200GB isn't really a lot of data so unless you have specific concerns about your cluster, it should be fine. Cheers!

Share
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.