On a DMS with Cassandra cluster, I want to keep my database lean & healthy.
When downgrading to a connector version without logger tables, how can I check if the keyspace for these logger tables (sldmadb_elementdata_<dmaid>_<eid>_<tableid>) in Cassandra still exist?
Next, how can I drop that data and these keyspaces?
Hi Jan-Klaas,
I did a quick test.
Three elements were created with a version that includes the logger table (Cisco Manager v5.1.7.25). Key spaces were created.
After that, the versions were reverted to the version without the logger table. The key spaces were not deleted.
Because of that, they were manually removed using the 'DROP KEYSPACE' cqlsh command.
It seems that the logger table key spaces were not dropped even when the elements were deleted, until recently RN40523...
In case there are a large number of logger table key spaces that need to be deleted, manually doing it is not ideal. I have written a bash script that can automate this process.