Score:0

Necessity to backup Cassandra system keyspaces

in flag

I was wondering about the necessity to backup (in order to restore of course) the system keyspaces of Cassandra.

My backup/restore procedure is the following:

  • backup: snapshots (nodetool) + dump of keyspaces (cqlsh DESC keyspace) on all cluster nodes
  • restore:
    • create keyspaces (cqlsh)
    • restore schema.cql of all tables of all snapshots (cqlsh)
    • import tables of all snapshots (sstableloader)

With this procedure, I was wondering:

  1. I read that among system keyspaces, only system_schema could be usefull to be backuped/restored, are there others ?
  2. Since I recreate keyspaces, and reimport tables schema (cql included in snapshots for each table), is the backup/restore of the keyspace system_schema necessary ?

Thank you

I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.