Re: Barman equivalent for Cassandra?

[Jonathan Lacefield]

There is a community delivered tool named Medusa that may have what you're
looking for as well - https://cassandra.tools/medusa

Jonathan Lacefield
e. jlacefi...@datastax.com
w. www.datastax.com
schedule a meeting on my calendar



On Fri, Mar 12, 2021 at 8:07 AM David Tinker  wrote:

> Hi Guys
>
> I need to backup my 3 node Cassandra cluster to a remote machine. Is there
> a tool like Barman (really nice streaming backup tool for Postgresql) for
> Cassandra? Or does everyone roll their own scripts using snapshots and so
> on?
>
> The data is on all 3 nodes using about 900G of space on each.
>
> It would be difficult for me to recover even a day of lost data. An hour
> might be ok.
>
> Thanks
> David
>
>

Re: Barman equivalent for Cassandra?

[Erick Ramirez]

I'm not familiar with Barman but if you're looking for a backup software
for Cassandra, have a look at Medusa from The Last Pickle --
https://github.com/thelastpickle/cassandra-medusa/wiki.

It's open-source and is also used for https://k8ssandra.io/ -- the platform
for deploying Cassandra on Kubernetes with tools for repairs, backups and
monitoring built-in. Cheers!

Re: Barman equivalent for Cassandra?

[Bowen Song]

You can have a separate DC, so a physical destruction of an entire DC 
(such as a fire 😉) will not result in data loss; you can turn on 
automatic snapshot on truncate & drop table to help prevent some data 
losses caused by bugs and human errors; you can also have a cron job to 
take snapshots (and delete old snapshots), so you can rollback to an 
earlier version. In addition to storing snapshots off-site, you can also 
archive the commitlog files, even CDC files off-site to minimize the 
amount of data loss in case of a total physical destruction of the 
entire Cassandra cluster.


If you are okay with at most an hour of data loss, an hourly snapshot 
stored off-site should be more than enough. Note that SSTable files are 
immutable, and that makes incremental backup very easy - just upload the 
new SSTable files and you are done.



On 12/03/2021 13:06, David Tinker wrote:

Hi Guys

I need to backup my 3 node Cassandra cluster to a remote machine. Is 
there a tool like Barman (really nice streaming backup tool for 
Postgresql) for Cassandra? Or does everyone roll their own scripts 
using snapshots and so on?


The data is on all 3 nodes using about 900G of space on each.

It would be difficult for me to recover even a day of lost data. An 
hour might be ok.


Thanks
David



-
To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org
For additional commands, e-mail: user-h...@cassandra.apache.org

Barman equivalent for Cassandra?

[David Tinker]

Hi Guys

I need to backup my 3 node Cassandra cluster to a remote machine. Is there
a tool like Barman (really nice streaming backup tool for Postgresql) for
Cassandra? Or does everyone roll their own scripts using snapshots and so
on?

The data is on all 3 nodes using about 900G of space on each.

It would be difficult for me to recover even a day of lost data. An hour
might be ok.

Thanks
David