Re: Cassandra 4.0 and changing DC setting

2021-02-22 Thread Kane Wilson
Great thanks for testing this Paul. You're likely the first one to actually try it on 4.0. Albeit I still think we should have a flag to ALTER to do this for you... not ideal to have users messing with system tables. raft.so - Cassandra consulting, support, and managed services On Mon, Feb 22, 2

Re: Cassandra 4.0 and changing DC setting

2021-02-22 Thread Paul Chandler
Yes, I am only running this on test clusters, I don’t run anything like this without lots of tests first. Anyway this worked well, so thanks for the info. For anyone else who needs this, the cql statement to do this was: insert into system_schema.keyspaces ( keyspace_name , durable_writes, rep

Re: Cassandra 4.0 and changing DC setting

2021-02-21 Thread Kane Wilson
Make sure you test it on a practice cluster. Messing with the system tables is risky business! raft.so - Cassandra consulting, support, and managed services On Sun, Feb 21, 2021 at 11:12 PM Paul Chandler wrote: > Hi Kane, > > That sounds a good idea, I will give it a try on Monday. > > Thanks

Re: Cassandra 4.0 and changing DC setting

2021-02-21 Thread Paul Chandler
Hi Kane, That sounds a good idea, I will give it a try on Monday. Thanks Paul > On 21 Feb 2021, at 11:33, Kane Wilson wrote: > > There has been proposals to add a force/unsafe flag to alter DC but it hasn't > been actioned and at this rate seems unlikely to make it into 4.0. There is > how

Re: Cassandra 4.0 and changing DC setting

2021-02-21 Thread Kane Wilson
There has been proposals to add a force/unsafe flag to alter DC but it hasn't been actioned and at this rate seems unlikely to make it into 4.0. There is however a workaround, albeit not very user friendly. You should be able to modify the system_schema tables directly to do your DC updates. I am y

Cassandra 4.0 and changing DC setting

2021-02-19 Thread Paul Chandler
All, We have a use case where we need to change the datacenter name for a cassandra cluster, we have a script to do this that involves a short downtime. This does the following 1) Change replication factor for the system key spaces to be { ‘OLD_DC’ : ‘3’, ’NEW_DC”: ‘3’ } 2) Change the dc va