[prev in list] [next in list] [prev in thread] [next in thread] 

List:       cassandra-user
Subject:    Re: backing up data from cassandra
From:       Jonathan Ellis <jbellis () gmail ! com>
Date:       2009-10-29 12:33:54
Message-ID: e06563880910290533rf0dba30v938f9b36806525ce () mail ! gmail ! com
[Download RAW message or body]

programatically, yes, but nodeprobe doesn't expose that yet.  Feel
free to create a ticket.

On Thu, Oct 29, 2009 at 4:20 AM, Chris Were <chris.were@gmail.com> wrote:
> Is it possible to only backup selected column families?
> On Wed, Oct 7, 2009 at 8:15 AM, Jonathan Ellis <jbellis@gmail.com> wrote:
>>
>> I don't really see "nodeprobe snapshot" and "mv snapshotdir/* livedir"
>> as all that much harder, but maybe that's just me.
>>
>> for a cluster, just add dsh.
>>
>> -Jonathan
>>
>> On Tue, Oct 6, 2009 at 3:42 PM, Joe Van Dyk <joevandyk@gmail.com> wrote:
>> > Sure not as easy as a "pg_dump db > dump.sql" and "psql db < dump.sql"
>> > though.  Oh well.
>> >
>> >
>> >
>> > On Tue, Oct 6, 2009 at 11:28 AM, Edmond Lau <edmond@ooyala.com> wrote:
>> >> Thanks for the replies guys.  It sounds like restoration via snapshots
>> >> + some application-side logic to sanity check/repair any data around
>> >> the snapshot time is the way to go.
>> >>
>> >> Edmond
>> >>
>> >> On Mon, Oct 5, 2009 at 10:15 AM, Jonathan Ellis <jbellis@gmail.com>
>> >> wrote:
>> >>> On Mon, Oct 5, 2009 at 11:23 AM, Thorsten von Eicken
>> >>> <tve@rightscale.com> wrote:
>> >>>> Isn't the question about how you back up a cassandra cluster, not a
>> >>>> single node?
>> >>>
>> >>> Sure, but the generalization is straightforward. :)
>> >>>
>> >>>> Can you snapshot the various nodes at different times or do
>> >>>> they need to be synchronized?
>> >>>
>> >>> The closer the synchronization, the more consistent they will be.
>> >>> (Since Cassandra is designed around eventual consistency, there's some
>> >>> flexibility here.  Conversely, there's no way to tell the system
>> >>> "don't accept any more writes until the snapshot is done.")
>> >>>
>> >>>> Is there a minimal set of nodes that are
>> >>>> sufficient to back up?
>> >>>
>> >>> Assuming your replication is 100% up to date, backing up every N nodes
>> >>> where N is the replication factor could be adequate in theory, but I
>> >>> wouldn't recommend trying to be clever like that, since if you
>> >>> "restored" from backup like that your system would be in a degraded
>> >>> state and vulnerable to any of the restored nodes failing.
>> >>>
>> >>> -Jonathan
>> >>>
>> >>
>> >
>> >
>> >
>> > --
>> > Joe Van Dyk
>> > http://fixieconsulting.com
>> >
>
>

[prev in list] [next in list] [prev in thread] [next in thread]