I am in the process of evaluating the best design for our Cassandra installation.
There is not so much information out there on the Internet about using the first two levels of access that Cassandra provides—keyspaces and column families.
I am wondering if and what the penalties will be if you choose to create an extensive amount of keyspaces or column families (>10.000).
An old blog post somewhere suggested that Cassandra reserves memory for each column family. The article was about the 0.6 version and the current version is 1.0. Is this still the case and a real problem?
What are the penalties of using many thousands of column families or keyspaces in Cassandra?