Cassandra sync command

Solved64 views
0
0 Comments

Hi Dojo,

after restoring a failover pair the database wasn't restored. Now the cluster is working together but the new node hasn't all the data. Is there a command to activate the copy over?

Stefan Schedletzky [DevOps Enabler] Selected answer as best 8th November 2024

1 Answer

3
2.03K 0 Comments

Hi Stefan

I would propose to perform a repair action on 1 of the nodes

    Nodetool repair -j 2 -full SLDMADB

Note that there should be scheduled tasks on the servers to make sure the nodes remain healthy. So if you don't perform the above command, then the nodes should get in sync either way.

=> both servers should have a scheduled task for the compaction action (i.e. cleanup actions)
=> 1 of the servers should have a scheduled task for the repair action (i.e. making sure the nodes remain in sync)

Stefan Schedletzky [DevOps Enabler] Selected answer as best 8th November 2024