Multiple Keyspaces

[Alexander McIvor]

Hi all,

Was hoping to get some confirmation of my thinking?

In kairosdb.properties :
kairosdb.datastore.cassandra.keyspace=kairosdb can be specified. I assume it is possible to have 2 kairosdb instances on different machines - each with different keyspaces eg. kairosdb and kairosdb1 - but pointing to the same Scylla/Cassandra cluster/set of databases? Essentially one exists already - kairosdb. And I would like to add a 2nd kairos instance on a different machine (keyspace kairosdb1). If I set the keyspace to kairosdb1 before first bootup it should also auto-create this keyspace at startup? And without impacting the exisiting kairosdb keyspace. Thanks Alex

[Brian Hawkins]

Yes that is exactly what it is for.  I also have unit tests that run on a different keyspace so as to not mess with live data I may have in C*.  Just be advised that each keyspace in C* has a lot of resources tied to it.  So say you want to use the keyspace to represent a customers data and you have 100 customers - it likely won't work well and C* will give you trouble.  On the other hand say you have a couple of departments that want their metrics separated and you only have 4 or 5 keyspaces that should be fine.

Brian

[alexm...@gmail.com]

Great - thanks for that Brian