CDC on system tables

ScyllaDB
1

Looking to enable CDC on system.large_partitions to keep a tab on the large partitions.

However, got the following error when enabling it on the system.large_partitions:
Unauthorized: Error from server: code=2100 [Unauthorized] message="system keyspace is not user-modifiable."

Is it possible in Scylla to enable CDC on system keyspace tables? What are the alternatives to get CDC on system.large_partitions table?

Thanks.

2

Hi,

sorry, there is no way to enable CDC on system tables.

A simple way for keeping a tab on large partitions - if you just want to know whether there’s a large partition that you should be worried about - would be to have a simple app which queries system.large_partitions periodically, e.g. once a day, and setup some alerts if the results pass certain thresholds.