Hi, We're working with the CDC feature to develop an agent to stream changes in Cassandra DB into Kafka. However, the CDC feature doesn't work well for us so far because CommitLog files are rarely flushed into cdc_raw directory, and the frequency can be as low as a few months.
Is there any suggested and feasible way to increase the frequency for Cassandra to flush CommitLog files please? We're thinking about decreasing *commitlog_segment_size_in_mb* from 32 to 16, and decreasing *commitlog_total_space_in_mb* from 8192 to 160. Does this sound like a reasonable approach? Is there any concern or anything we need to be warned about trying this please? Thank you! Bingqin Zhou