Recovery for deleted SSTables files for one column family.

[Mike Yeap <wk...@gmail.com>]

Hi all, I would like to know, is there any way to rebuild a particular
column family when all the SSTables files for this column family are
missing?? Say we do not have any backup of it.

Thank you.

Regards,
Mike Yeap

Re: Recovery for deleted SSTables files for one column family.

[Mike Yeap <wk...@gmail.com>]

Hi Ben, the scenario that I was trying to test was all sstables (deleted)
from one node. So I did what you suggested (rebuild the sstables from other
replicas in the cluster) and it rebuilt the sstables successfully.

I think the reason that I didn't see the sstables rebuilt earlier on was
because I didn't use the -full option of the "nodetool rebuild".

Thanks!

Regards,
Mike Yeap

On Thu, May 19, 2016 at 4:03 PM, Ben Slater <be...@instaclustr.com>
wrote:

> Use nodetool listsnapshots to check if you have a snapshot - in default
> configuration, Cassandra takes snapshots for operations like truncate.
>
> Failing that, is it all sstables from all nodes? In this case, your data
> has gone I’m afraid. If it’s just all sstables from one node then running
> repair will rebuild the sstables from the other replicas in the cluster.
>
> Cheers
> Ben
>
> On Thu, 19 May 2016 at 17:57 Mike Yeap <wk...@gmail.com> wrote:
>
>> Hi all, I would like to know, is there any way to rebuild a particular
>> column family when all the SSTables files for this column family are
>> missing?? Say we do not have any backup of it.
>>
>> Thank you.
>>
>> Regards,
>> Mike Yeap
>>
> --
> ————————
> Ben Slater
> Chief Product Officer, Instaclustr
> +61 437 929 798
>

Re: Recovery for deleted SSTables files for one column family.

[Ben Slater <be...@instaclustr.com>]

Use nodetool listsnapshots to check if you have a snapshot - in default
configuration, Cassandra takes snapshots for operations like truncate.

Failing that, is it all sstables from all nodes? In this case, your data
has gone I’m afraid. If it’s just all sstables from one node then running
repair will rebuild the sstables from the other replicas in the cluster.

Cheers
Ben

On Thu, 19 May 2016 at 17:57 Mike Yeap <wk...@gmail.com> wrote:

> Hi all, I would like to know, is there any way to rebuild a particular
> column family when all the SSTables files for this column family are
> missing?? Say we do not have any backup of it.
>
> Thank you.
>
> Regards,
> Mike Yeap
>
-- 
————————
Ben Slater
Chief Product Officer, Instaclustr
+61 437 929 798