what is your keyspace configuration. Do you have all the keyspaces configured for both DCs?
can you run below query from cqlsh and see if the keyspace is configured to use both DCs select * from system.schema_keyspaces; # if your cluster is on 2.1 or less select * from system_schema.keyspaces # for 3.0 clusters - Anil On Mon, Jun 18, 2018 at 11:06 AM, learner dba < cassandra...@yahoo.com.invalid> wrote: > Hi, > > Data volume varies a lot in our two DC cluster: > > Load Tokens Owns > > 20.01 GiB 256 ? > > 65.32 GiB 256 ? > > 60.09 GiB 256 ? > > 46.95 GiB 256 ? > > 50.73 GiB 256 ? > > kaiprodv2 > > ========= > > /Leaving/Joining/Moving > > Load Tokens Owns > > 25.19 GiB 256 ? > > 30.26 GiB 256 ? > > 9.82 GiB 256 ? > > 20.54 GiB 256 ? > > 9.7 GiB 256 ? > > I ran clearsnapshot, garbagecollect and cleanup, but it increased the size > on heavier nodes instead of decreasing. Based on nodetool cfstats, I can > see partition keys on each node varies a lot: > > Number of partitions (estimate): 3142552 > > Number of partitions (estimate): 15625442 > > Number of partitions (estimate): 15244021 > > Number of partitions (estimate): 9592992 > Number of partitions (estimate): 15839280 > > How can I diagnose this imbalance further? > >
