cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jens Rantil" <>
Subject Re: Cassandra backup via snapshots in production
Date Fri, 21 Nov 2014 16:40:43 GMT
> The main purpose is to protect us from human errors (eg. unexpected manipulations: delete,
drop tables, …).

If that is the main purpose, having "auto_snapshot: true” in cassandra.yaml will be enough
to protect you.

Regarding backup, I have a small script that creates a named snapshot and for each sstable;
encrypts, uploads to S3 and deletes the snapshotted sstable. It took me an hour to write and
roll out to all our nodes. The whole process is currently logged, but eventually I will also
send an e-mail if backup fails.

Jens Rantil
Backend engineer
Tink AB

Phone: +46 708 84 18 32

Facebook Linkedin Twitter

On Tue, Nov 18, 2014 at 3:52 PM, Ngoc Minh VO <>

> Hello all,
> We are looking for a solution to backup data in our C* cluster (v2.0.x, 16 nodes, 4 x
500GB SSD, RF = 6 over 2 datacenters).
> The main purpose is to protect us from human errors (eg. unexpected manipulations: delete,
drop tables, …).
> We are thinking of:
> -          Backup: add a 2TB HDD on each node for C* daily/weekly snapshots.
> -          Restore: load the most recent snapshots or latest “non-corrupted” ones
and replay missing data imports from other data source.
> We would like to know if somebody are using Cassandra’s backup feature in production
and could share your experience with us.
> Your help would be greatly appreciated.
> Best regards,
> Minh
> This message and any attachments (the "message") is
> intended solely for the intended addressees and is confidential. 
> If you receive this message in error,or are not the intended recipient(s), 
> please delete it and any copies from your systems and immediately notify
> the sender. Any unauthorized view, use that does not comply with its purpose, 
> dissemination or disclosure, either whole or partial, is prohibited. Since the internet

> cannot guarantee the integrity of this message which may not be reliable, BNP PARIBAS

> (and its subsidiaries) shall not be liable for the message if modified, changed or falsified.

> Do not print this message unless it is necessary,consider the environment.
> ----------------------------------------------------------------------------------------------------------------------------------
> Ce message et toutes les pieces jointes (ci-apres le "message") 
> sont etablis a l'intention exclusive de ses destinataires et sont confidentiels.
> Si vous recevez ce message par erreur ou s'il ne vous est pas destine,
> merci de le detruire ainsi que toute copie de votre systeme et d'en avertir
> immediatement l'expediteur. Toute lecture non autorisee, toute utilisation de 
> ce message qui n'est pas conforme a sa destination, toute diffusion ou toute 
> publication, totale ou partielle, est interdite. L'Internet ne permettant pas d'assurer
> l'integrite de ce message electronique susceptible d'alteration, BNP Paribas 
> (et ses filiales) decline(nt) toute responsabilite au titre de ce message dans l'hypothese
> ou il aurait ete modifie, deforme ou falsifie. 
> N'imprimez ce message que si necessaire, pensez a l'environnement.
View raw message