cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alain RODRIGUEZ <arodr...@gmail.com>
Subject Re: Auto backup script
Date Mon, 09 Jul 2012 10:37:37 GMT
Hi,

I use parallel-ssh within this script :

#!/bin/bash
parallel-ssh -h hosts.txt -t 3600 "nodetool -h localhost snapshot
mykeyspace -t \`date +%Y%m%d\`";
parallel-ssh -h hosts.txt -t 14400 "find
/raid0/cassandra/data/mykeyspace/snapshots/\`date +%Y%m%d\` -type f \(
-name \*\Data.db -o -name \*\Index.db \) -print0 | xargs -0 tar -czvf
/raid0/cassandra/data/mykeyspace/snapshots/mykeyspace_\`date
+%Y%m%d\`_\`cat /etc/hostname\`.tar.gz";
parallel-ssh -h hosts.txt -t 14400 "scp
/raid0/cassandra/data/mykeyspace/snapshots/mykeyspace_\`date
+%Y%m%d\`_\`cat /etc/hostname\`.tar.gz
user@backupserver:/home/myuser/";
parallel-ssh -h hosts.txt -t 14400 "nodetool -h localhost clearsnapshot";

host.txt contains the ip of all my nodes.

This can certainly be optimized but works for me.

Alain

2012/7/9 Adeel Akbar <adeel.akbar@panasiangroup.com>:
> Hi,
>
> I have planned to backup of my cassandra 3 node ring database for security.
> Please let me know that what method i used for backup and if anyone have
> script, please share with me.
> --
>
>
> Thanks & Regards
>
> Adeel Akbar

Mime
View raw message