Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id DA296D11E for ; Wed, 28 Nov 2012 00:29:20 +0000 (UTC) Received: (qmail 71422 invoked by uid 500); 28 Nov 2012 00:29:18 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 71396 invoked by uid 500); 28 Nov 2012 00:29:18 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 71388 invoked by uid 99); 28 Nov 2012 00:29:18 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 Nov 2012 00:29:18 +0000 X-ASF-Spam-Status: No, hits=4.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_HELO_PASS,SPF_NEUTRAL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [74.208.4.194] (HELO mout.perfora.net) (74.208.4.194) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 Nov 2012 00:29:12 +0000 Received: from oxusltgw05.schlund.de (oxusltgw05.lxa.perfora.net [172.19.206.7]) by mrelay.perfora.net (node=mrus1) with ESMTP (Nemesis) id 0MFvOI-1TPmHk0HnK-00EufR; Tue, 27 Nov 2012 19:28:50 -0500 Date: Tue, 27 Nov 2012 19:28:50 -0500 (EST) From: "jeremy@simpleartmarketing.com" Reply-To: "jeremy@simpleartmarketing.com" To: user@cassandra.apache.org Message-ID: <963839061.221030.1354062530090.JavaMail.open-xchange@email.1and1.com> In-Reply-To: References: <1354053777360-7584007.post@n2.nabble.com> Subject: Re: selective replication of keyspaces MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_221029_433148336.1354062530048" X-Priority: 3 Importance: Medium X-Mailer: Open-Xchange Mailer v6.20.7-Rev4 X-Provags-ID: V02:K0:x/+nHGSYtmsrdZQ2oPr7jzOA8jCKYmP+9HEZQOm0YMF zh3wFPZg5sroswzNPVbljfNKPSsya1AE+iyAHmCC+adKW4TgBK JUPMxn1NxioiqmLT+udCOA4xCV8xK/PWYFuv+VDGQvDpSXOAKW sqaTFJbJ3mfEiWyuggEzHmFLwzrP383hYcae241fq/VibyLlY1 XrNJnu4BWm2K7AaGE1c6BHKYYb0GVslCcR9/y61Lpql03fnA/2 s0zHo9ApzUfgBbm8Ze5RqXtV7MnmcLUqSV/8a7+zR4m82xe/fv iOM0Nc9Zx5zr4Cy6gj6kZEM8nnQGHhszYo4N+tu7xvrofuFbUB 3czX10Gm3mYFmlnMspEVYpBYlqBJO8OHsI5y8xF4xbn3t33LwW j6txys8tO3WbNIaukWk0hxMtQqim9bFjSfWjGybh0wsPKGd+re WtWhz X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_221029_433148336.1354062530048 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Thank you. This is a good start I was beginning to think it couldn't be done. When I run the command I get the error syntax error at position 21: missing EOF at 'placement_strategy' that is probably because I still need to set the correct properties in the conf files On November 27, 2012 at 5:41 PM Edward Capriolo wrote: > You can do something like this: > > Divide your nodes up into 4 datacenters art1,art2,art3,core > > [default@unknown] create keyspace art1 placement_strategy = > 'org.apache.cassandra.locator.NetworkTopologyStrategy' and > strategy_options=[{art1:2,core:2}]; > > [default@unknown] create keyspace art2 placement_strategy = > 'org.apache.cassandra.locator.NetworkTopologyStrategy' and > strategy_options=[{art2:2,core:2}]; > > [default@unknown] create keyspace art3 placement_strategy = > 'org.apache.cassandra.locator.NetworkTopologyStrategy' and > strategy_options=[{art3:2,core:2}]; > > [default@unknown] create keyspace core placement_strategy = > 'org.apache.cassandra.locator.NetworkTopologyStrategy' and > strategy_options=[{core:2}]; > > > > On Tue, Nov 27, 2012 at 5:02 PM, Artist > wrote: > > > I have 3 art-servers each has a cassandra cluster. > > Each of the art-servers has config/state information stored in a > > Keyspaces > > respectively called > > art-server-1-current-state, art-server-2-current-state, > > art-server-3-current-state > > > > in my core server I have a separate Cassandra cluster. I would like to > > use > > Cassandra to replicate the current-state of each art-server on the core > > cassandra server without sharing that information with any of the > > art-servers. > > > > Is there is a way to replicate the keyspaces to a single Cassandra > > cluster > > my core without having any peer sharing between the 3 art-servers. > > > > - > > Artist > > > > > > > > -- > > View this message in context: > > http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/selective-replication-of-keyspaces-tp7584007.html > > > > Sent from the cassandra-user@incubator.apache.org > > mailing list archive at > > Nabble.com. > > > ------=_Part_221029_433148336.1354062530048 MIME-Version: 1.0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
Thank you.  This is a good  start I was beginning to think it couldn't be done.
 
When I run the command I get the error 
 
syntax error at position 21: missing EOF at 'placement_strategy'
 
that is probably because I still need to set the correct properties in the conf files
 
 

On November 27, 2012 at 5:41 PM Edward Capriolo <edlinuxguru@gmail.com> wrote:
You can do something like this:
 
Divide your nodes up into 4 datacenters art1,art2,art3,core
 
[default@unknown] create keyspace art1 placement_strategy = 'org.apache.cassandra.locator.NetworkTopologyStrategy' and strategy_options=[{art1:2,core:2}];
 
[default@unknown] create keyspace art2 placement_strategy = 'org.apache.cassandra.locator.NetworkTopologyStrategy' and strategy_options=[{art2:2,core:2}];
 
[default@unknown] create keyspace art3 placement_strategy = 'org.apache.cassandra.locator.NetworkTopologyStrategy' and strategy_options=[{art3:2,core:2}];
 
[default@unknown] create keyspace core placement_strategy = 'org.apache.cassandra.locator.NetworkTopologyStrategy' and strategy_options=[{core:2}];
 
 

On Tue, Nov 27, 2012 at 5:02 PM, Artist <jeremy@simpleartmarketing.com> wrote:

I have 3 art-servers each has a cassandra cluster.
Each of the art-servers has config/state information stored in a Keyspaces
respectively called
art-server-1-current-state, art-server-2-current-state,
art-server-3-current-state

in my core server I have a separate Cassandra cluster.  I would like to use
Cassandra to replicate the current-state of each art-server on the core
cassandra server without sharing that information with any of the
art-servers.

Is there is a way to replicate the keyspaces to a single Cassandra cluster
my core without having any peer sharing between the 3 art-servers.

-
Artist



--
View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/selective-replication-of-keyspaces-tp7584007.html
Sent from the cassandra-user@incubator.apache.org mailing list archive at Nabble.com.

 
------=_Part_221029_433148336.1354062530048--