Cassandra: backup entire keyspace
backup, cassandra
Solution
The best way is by doing snapshots (`nodetool snapshot`). You can learn a lot about how that works and how best to use it in this Datastax documentation (disclaimer: I work for Datastax).
You'll want to make sure you have JNA enabled (some relevant instructions can be found on this page). If you do, snapshots are extremely fast; they're just hard links to existing sstables. No copying needs to be done. You can combine snapshots with other backup tools (or just rsync, cp, etc) if you want to keep track of your backups in a particular way.
Problem
I was just wondering what would be the best way to backup an entire keyspace in Cassandra... what do you think? Previously i just copied the data folder into my backup hard drive, but then i had problems to restore the database after updating.