1

I would like to know how to change or modify the cluster name for the existing Cassandra cluster. I followed to update the cluster name using the below query but it failed while trying to alter the system table.

[cqlsh 6.8.0 | DSE 6.8.25 | CQL spec 3.4.5 | DSE protocol v2]

cqlsh> UPDATE system.local SET cluster_name = 'DummyCluster' where key='local';
InvalidRequest: Error from server: code=2200 [Invalid query] message="Modification is not supported by table system_views.local_node"

2 Answers 2

1

Changing the name of an existing cluster is NOT a supported operation in Cassandra. This is the reason the procedure is not provided in any official documentation.

Cassandra experts are aware that there is a hack available to be able to rename an existing cluster but being experts, they are aware of the consequences of doing so.

For everyone else coming across this post in the future, do NOT try any instructions or procedures you find on the internet that allegedly allows you to rename your cluster. We don't recommend it so it's not supported. Cheers!

1

@CassandraNovice, there is no official tools to get this done today. This is a risky operation. Instead, I would recommend you build the destination/target cluster and move data from source to this new cluster via tools such as DSBulk Loader, Zero Downtime Migrations, etc.,

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.