2
votes

I have a system that generate 100,000 rows/s and size of each row is 1KB and want to use Cassandra for database. I get data from Apache Kafka and then should insert it into database. What is the best way for load this volume of data into Cassandra ?

1
Split the data into batches. Preferably batches of size 1000 and write the data to cassandra db. - Vineeth Chitteti

1 Answers

1
votes

Kafka Connect is designed for this. On this page you will find a list of connectors including a Cassandra sink connectors https://www.confluent.io/product/connectors/