Cassandra

Cassandra

nodetool status

bin/cqlsh localhost
SELECT cluster_name, listen_address FROM system.local;

Intial Seciruty

• Update /etc/cassandra/yaml to add password authentification

Old value:
authenticator: AllowAllAuthenticator

Change with this new value:
authenticator: PasswordAuthenticator

• Test new configuration

cqlsh -u cassandra -p cassandra

• Change default cassandra password

ALTER USER cassandra WITH PASSWORD 'newPassword';

• Create a backup Admin

create role myadmin with password = 'myAdminPassword' and login = true and superuser = true;

Key space managmenet

• List all keyspaces

SELECT * FROM system_schema.keyspaces;

create KEYSPACE mmyKeyspace WITH replication = {'class': 'NetworkTopologyStrategy', 'datacenter1': 3};

CREATE KEYSPACE IF NOT EXISTS myWorkspace