Re: selective replication of keyspaces

2012-11-27 Thread Edward Capriolo
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 jer...@simpleartmarketing.comwrote:


 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-u...@incubator.apache.org mailing list archive at
 Nabble.com.



Re: selective replication of keyspaces

2012-11-27 Thread jer...@simpleartmarketing.com
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 edlinuxg...@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 jer...@simpleartmarketing.com
 mailto:jer...@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
  http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/selective-replication-of-keyspaces-tp7584007.html
 Sent from the cassandra-u...@incubator.apache.org
  mailto:cassandra-u...@incubator.apache.org mailing list archive at
  Nabble.com.



Re: selective replication of keyspaces

2012-11-27 Thread Edward Capriolo
My mistake that is older cli syntax, I wad just showing the concept set up
4 datacenter and selectively replicate keyspaces between them.

On Tuesday, November 27, 2012, jer...@simpleartmarketing.com 
jer...@simpleartmarketing.com wrote:
 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 edlinuxg...@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 jer...@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-u...@incubator.apache.org mailing list archive at
Nabble.com.