cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris Were <chris.w...@gmail.com>
Subject Re: backing up data from cassandra
Date Thu, 29 Oct 2009 10:20:10 GMT
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
> >
>

Mime
View raw message