We have a development Cassandra cluster of 8 nodes. It's being used by more than 20 developers and every day we create many keyspaces and more than 10 tables in each keyspace.
Currently, the cluster has more than 300 Keyspaces. The performance of the cluster is really bad and I do not find anything in Cassandra logs that show what's wrong in the cluster. Sometimes we got failures when creating new keyspaces.
Do you think this is something because of having too many keyspaces? and why?
Thanks in advance.