Re: Changing schema on multiple nodes while they are isolated

2015-10-05 Thread Clint Martin
that tables with same names >>> but different ids were present in the keyspace. I don’t know if there is a >>> way to fix that with nodetool but I don’t think that it is a good practice. >>> >>> >>> >>> To solve this, we have a “schema creat

Re: Changing schema on multiple nodes while they are isolated

2015-10-05 Thread Stephen Baynes
is a good practice. >> >> >> >> To solve this, we have a “schema creator” application node that is >> responsible to change the schema. If this node is down, schema updates are >> not possible. We can make any node ‘creator’, but only one can be enabled >> at an

RE: Changing schema on multiple nodes while they are isolated

2015-10-05 Thread Jacques-Henri Berthemet
conflicts it will be resolved on the basis of the row timestamp. -- Jacques-Henri Berthemet From: Stephen Baynes [mailto:stephen.bay...@smoothwall.net] Sent: lundi 5 octobre 2015 11:00 To: user@cassandra.apache.org Subject: Re: Changing schema on multiple nodes while they are isolated > Why do

Re: Changing schema on multiple nodes while they are isolated

2015-10-05 Thread Stephen Baynes
a automatically. > > > > *--* > > *Jacques-Henri Berthemet* > > > > *From:* Stephen Baynes [mailto:stephen.bay...@smoothwall.net] > *Sent:* vendredi 2 octobre 2015 18:08 > *To:* user@cassandra.apache.org > *Subject:* Re: Changing schema on multiple nodes while they are i

Re: Changing schema on multiple nodes while they are isolated

2015-10-02 Thread Clint Martin
ode that is > responsible to change the schema. If this node is down, schema updates are > not possible. We can make any node ‘creator’, but only one can be enabled > at any given time. > > *--* > > *Jacques-Henri Berthemet* > > > > *From:* Stephen Baynes [mailto:step

Re: Changing schema on multiple nodes while they are isolated

2015-10-02 Thread Robert Coli
On Fri, Oct 2, 2015 at 9:08 AM, Stephen Baynes < stephen.bay...@smoothwall.net> wrote: > Will need to do some thinking about this. I wonder about shiping a backup > of a good system keyspace and restore it on each node before it starts for > the first time - but will that end up with each node hav

RE: Changing schema on multiple nodes while they are isolated

2015-10-02 Thread Jacques-Henri Berthemet
ailto:stephen.bay...@smoothwall.net<mailto:stephen.bay...@smoothwall.net>] Sent: vendredi 2 octobre 2015 16:46 To: user@cassandra.apache.org<mailto:user@cassandra.apache.org> Subject: Changing schema on multiple nodes while they are isolated Is it safe to make schema changes ( e.g. create keysp

Re: Changing schema on multiple nodes while they are isolated

2015-10-02 Thread Stephen Baynes
ynes [mailto:stephen.bay...@smoothwall.net] > *Sent:* vendredi 2 octobre 2015 16:46 > *To:* user@cassandra.apache.org > *Subject:* Changing schema on multiple nodes while they are isolated > > > > Is it safe to make schema changes ( e.g. create keyspace and tables ) on > mult

RE: Changing schema on multiple nodes while they are isolated

2015-10-02 Thread Jacques-Henri Berthemet
enabled at any given time. -- Jacques-Henri Berthemet From: Stephen Baynes [mailto:stephen.bay...@smoothwall.net] Sent: vendredi 2 octobre 2015 16:46 To: user@cassandra.apache.org Subject: Changing schema on multiple nodes while they are isolated Is it safe to make schema changes ( e.g. create keyspace

Changing schema on multiple nodes while they are isolated

2015-10-02 Thread Stephen Baynes
Is it safe to make schema changes ( e.g. create keyspace and tables ) on multiple separate nodes of a cluster while they are out of communication with other nodes in the cluster? For example create on node A while node B is down, create on node B while A is down, then bring both up together. We ar