You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by AJ Chen <aj...@web2express.org> on 2010/04/02 07:18:07 UTC
best practice for migrating data
when adding/changing a column to a column family for existing data in
cassandra, what's a good way to do it?
thanks,
-aj--
AJ Chen, PhD
Chair, Semantic Web SIG, sdforum.org
http://web2express.org
twitter @web2express
Palo Alto, CA, USA
Re: best practice for migrating data
Posted by Gary Dusbabek <gd...@gmail.com>.
Correct. One node at a time, in rolling fashion. As long as the
config files are not drastically different (you isolate your changes
to the Keyspaces), you will not have a problem.
Gary.
On Fri, Apr 2, 2010 at 09:54, yaw <ya...@gmail.com> wrote:
> Hi all,
> this tells us to stop and start Cassandra ...
> I hope we are not asked to stop whole cluster ... Can we proceed node
> after node ?
>
> ( But how cluster could handle different config.xml files ?)
>
RE: best practice for migrating data
Posted by Mark Jones <MJ...@imagehawk.com>.
I got the idea for this from:
http://wiki.apache.org/cassandra/StorageConfiguration
I put my keyspace setup on a webserver, and I pull it into the config like this:
storage-conf.xml starts with:
<!DOCTYPE storage [
<!-- include all these entities from external files-->
<!ENTITY seeds SYSTEM "http://cassandraconfig /seeds.xml">
<!ENTITY autobootstrap SYSTEM "http://cassandraconfig /autobootstrap.xml">
<!ENTITY bumblekeyspace SYSTEM "http://cassandraconfig /bumblekeyspace.xml">
<!ENTITY listenaddress SYSTEM "listenaddress.xml">
<!ENTITY directories SYSTEM "directories.xml">
]>
Then further down:
<Keyspaces>
&bumblekeyspace;
</Keyspaces>
I didn't want to have to edit lots of files....
From: yaw [mailto:yawyway@gmail.com]
Sent: Friday, April 02, 2010 10:55 AM
To: user@cassandra.apache.org
Subject: Re: best practice for migrating data
Hi all,
this tells us to stop and start Cassandra ...
I hope we are not asked to stop whole cluster ... Can we proceed node after node ?
( But how cluster could handle different config.xml files ?)
2010/4/2 Gary Dusbabek <gd...@gmail.com>>
AJ,
The wiki gives an outline of how to do this:
http://wiki.apache.org/cassandra/FAQ#modify_cf_config
Gary
On Thu, Apr 1, 2010 at 23:18, AJ Chen <aj...@web2express.org>> wrote:
> when adding/changing a column to a column family for existing data in
> cassandra, what's a good way to do it?
> thanks,
> -aj--
> AJ Chen, PhD
> Chair, Semantic Web SIG, sdforum.org<http://sdforum.org/>
> http://web2express.org<http://web2express.org/>
> twitter @web2express
> Palo Alto, CA, USA
>
Re: best practice for migrating data
Posted by yaw <ya...@gmail.com>.
Hi all,
this tells us to stop and start Cassandra ...
I hope we are not asked to stop whole cluster ... Can we proceed node
after node ?
( But how cluster could handle different config.xml files ?)
2010/4/2 Gary Dusbabek <gd...@gmail.com>
> AJ,
>
> The wiki gives an outline of how to do this:
> http://wiki.apache.org/cassandra/FAQ#modify_cf_config
>
> Gary
>
> On Thu, Apr 1, 2010 at 23:18, AJ Chen <aj...@web2express.org> wrote:
> > when adding/changing a column to a column family for existing data in
> > cassandra, what's a good way to do it?
> > thanks,
> > -aj--
> > AJ Chen, PhD
> > Chair, Semantic Web SIG, sdforum.org
> > http://web2express.org
> > twitter @web2express
> > Palo Alto, CA, USA
> >
>
Re: best practice for migrating data
Posted by Gary Dusbabek <gd...@gmail.com>.
AJ,
The wiki gives an outline of how to do this:
http://wiki.apache.org/cassandra/FAQ#modify_cf_config
Gary
On Thu, Apr 1, 2010 at 23:18, AJ Chen <aj...@web2express.org> wrote:
> when adding/changing a column to a column family for existing data in
> cassandra, what's a good way to do it?
> thanks,
> -aj--
> AJ Chen, PhD
> Chair, Semantic Web SIG, sdforum.org
> http://web2express.org
> twitter @web2express
> Palo Alto, CA, USA
>