Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of jbellis@gmail.com designates
 74.125.82.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type:content-transfer-encoding;
        b=AyRujE+r4ha2+yZ5li+NbwQVSveDZ50lAiXRuqJZDi33NZUpygRbZODyRILf97SmbU
         IH8+wJpOjkO06P1mMwQMlIxZBp0u5VkZBBhfSjqmhNSK8eNogdD45KLyC8EJPGdJSTxs
         ZeVQkT12BJ+mKNeizXrDLzAFh86WOXVPfpG+8=
MIME-Version: 1.0
In-Reply-To: <AANLkTilABdwnC3gJuVhJejBBq40ZCWxr9JARz2iDQKpN@mail.gmail.com>
References: <AANLkTilABdwnC3gJuVhJejBBq40ZCWxr9JARz2iDQKpN@mail.gmail.com>
From: Jonathan Ellis <jbellis@gmail.com>
Date: Thu, 10 Jun 2010 14:29:33 -0700
Message-ID: <AANLkTilTpR2FXHNT2r1-sXsxTIdMH5tEcGU2QFxa5lE9@mail.gmail.com>
Subject: Re: Granularity SSTables.
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Only if your clusters have the same number of nodes, with the same tokens.

Trying to get too clever is not usually advisable.

On Thu, Jun 10, 2010 at 3:54 AM, xavier manach <xav@tekio.org> wrote:
> Hi.
>
> =A0I try to understand tricks that I can use with the SSTables, for
> faster manipulation of datas in clusters.
>
> I learn I how copy a keyspaces from data directories to a new node and
> change replicationfactor (thx Jonathan).
>
> If I understood, Each SSTable have 3 files :
> =A0ColumnFamily-ID-Datas.db
> =A0ColumnFamily-ID-Index.db
> =A0ColumnFamily-ID-Filter.db
>
> =A0If I want merge datas from 2 clusters, with differents keys (each
> key is only in one cluster) but with the same ColumnFamily.
> Can I copy all the files from SSTables with the same methode ?
>> 1. nodetool drain & stop original node
>> 2. copy everything =A0***files sstables*** in data/ directories (but not=
 system keyspace!) to new node
>> 3. restart and autobootstrap=3Dfalse [the default]
>
> Thx.
>
>
>
> On Tue, Jun 8, 2010 at 7:12 AM, xavier manach <xav@tekio.org> wrote:
>> Hi.
>>
>> =A0 I have a cluster with only 1 node with a lot of datas (500 Go) .
>> =A0 I want add a new node with the same datas (with a ReplicationFactor
>> 2)
>>
>> The method normal is :
>> stop node.
>> add a node.
>> change replication factor to 2.
>> start nodes
>> use nodetool repair
>>
>> =A0 But , I didn't know if this other method is valid, and if it's can
>> be faster :
>> stop nodes.
>> copy all SSTables
>> change replication factor.
>> start nodes
>> and
>> use nodetool repair
>>
>> =A0 Have you an idea for the faster valid method ?
>>
>> Thx.
>>
>


--=20
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of Riptano, the source for professional Cassandra support
http://riptano.com