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
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
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
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
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
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