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 driftx@gmail.com designates
 209.85.212.178 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAN3fqkwJSf6_EPBhQu2uKm_5RCAiqXqLSOsGnNP1+K0ugGAoaw@mail.gmail.com>
References: 
 <CAN3fqkzqW4xUek3hg-JJc1nLauL3mLdm1qbA+KtG3jRr-KW+5g@mail.gmail.com>
 <CAAafH9QjXtF1xSg7MW=wyv+UJ-09fOHcdeFZ-o3b6HHPkrUkdg@mail.gmail.com>
 <CAN3fqkwJSf6_EPBhQu2uKm_5RCAiqXqLSOsGnNP1+K0ugGAoaw@mail.gmail.com>
From: Brandon Williams <driftx@gmail.com>
Date: Thu, 24 May 2012 14:28:41 -0500
Message-ID: 
 <CAAafH9TGiF-mbzKYnrZ0Jnd_KTOpOfdY7VJREk_EAkWFoCRhNg@mail.gmail.com>
Subject: Re: Migrating from a windows cluster to a linux cluster.
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Thu, May 24, 2012 at 1:50 PM, Henrik Schr=F6der <skrolle@gmail.com> wrot=
e:
> Ok. It's important for us to not have any downtime, so how about this
> solution:
>
> We startup the Linux cluster independently.
> We configure our application to send all Cassandra writes to both cluster=
s,
> but only read from the Windows cluster.
> We run sstableloader on each windows server (Is it possible to do in
> parallell?), sending whatever it has to the Linux cluster.
> When it's done on all Windows servers, we configure our application to on=
ly
> talk to the Linux cluster.

That sounds fine, with the caveat that you can't run sstableloader
from a machine running Cassandra before 1.1, so copying the sstables
manually (assuming both clusters are the same size and have the same
tokens) might be better.

> The only issue with this is the timestamps of the data and tombstones in
> each sstable, will they be preserved by sstableloader? What about deletes=
 of
> non-existing keys? Will they be stored in the Linux cluster so that when
> sstableloader inserts the key later, it's resolved as being deleted?

None of that should be a problem.

-Brandon