Cassandra - Revision history

Nicolas: /* Manage Roles */

2020-10-12T04:11:51Z

Manage Roles

← Older revision		Revision as of 04:11, 12 October 2020
Line 99:		Line 99:
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	LIST ROLES;		LIST ROLES;
			</syntaxhighlight>

			* List Roles of a user
			<syntaxhighlight lang="sql">
			LIST ROLES OF myUser;
	</syntaxhighlight>		</syntaxhighlight>

Nicolas: /* Intial Security */

2020-10-12T04:05:57Z

Intial Security

← Older revision		Revision as of 04:05, 12 October 2020
Line 41:		Line 41:
	* Create a backup Admin		* Create a backup Admin
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	~~create role~~ myadmin ~~with password~~ = 'myAdminPassword' ~~and login~~ = true ~~and superuser~~ = true;		CREATE ROLE myadmin WITH PASSWORD = 'myAdminPassword' AND LOGIN = true AND SUPERUSER = true;
	</syntaxhighlight>		</syntaxhighlight>

Nicolas: /* Cassandra */

2020-10-12T04:02:17Z

Cassandra

← Older revision		Revision as of 04:02, 12 October 2020
Line 44:		Line 44:
	</syntaxhighlight>		</syntaxhighlight>

	=== Key space ~~managmenet~~ ===		=== Key space management ===
	* List all keyspaces		* List all keyspaces

Line 53:		Line 53:
	* Create a keyspace		* Create a keyspace
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	create KEYSPACE ~~mmyKeyspace~~ WITH replication = {'class': 'NetworkTopologyStrategy', 'datacenter1': 3};		create KEYSPACE myKeyspace WITH replication = {'class': 'NetworkTopologyStrategy', 'datacenter1': 3};
	</syntaxhighlight>		</syntaxhighlight>

			* Remove a keyspace
			<syntaxhighlight lang="sql">
			DROP KEYSPACE myKeyspace;
			</syntaxhighlight>


			=== Manage Roles ===
	* Create a role that has all permissions in all keyspaces:		* Create a role that has all permissions in all keyspaces:
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
Line 82:		Line 89:
	GRANT EXECUTE ON ALL FUNCTIONS IN KEYSPACE cycling to cyclist_analyst;		GRANT EXECUTE ON ALL FUNCTIONS IN KEYSPACE cycling to cyclist_analyst;
	GRANT cyclist_analyst TO wilson;		GRANT cyclist_analyst TO wilson;
			</syntaxhighlight>

			* Remove a role
			<syntaxhighlight lang="sql">
			DROP ROLE myRole;
			</syntaxhighlight>

			* List Roles
			<syntaxhighlight lang="sql">
			LIST ROLES;
			</syntaxhighlight>

			* List Permissions
			<syntaxhighlight lang="sql">
			LIST All PERMISSIONS;
	</syntaxhighlight>		</syntaxhighlight>

Nicolas: /* Intial Seciruty */

2020-10-12T03:51:36Z

Intial Seciruty

← Older revision		Revision as of 03:51, 12 October 2020
Line 10:		Line 10:
	</syntaxhighlight>		</syntaxhighlight>

	=== Intial ~~Seciruty~~ ===		=== Intial Security ===

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

Nicolas: /* Intial Seciruty */

2020-10-11T19:49:10Z

Intial Seciruty

← Older revision		Revision as of 19:49, 11 October 2020
Line 19:		Line 19:
	Change with this new value:		Change with this new value:
	authenticator: PasswordAuthenticator		authenticator: PasswordAuthenticator
			</pre>

			<pre>
			Old value:
			authorizer: AllowAllAuthorizer

			Change with this new value:
			authorizer: CassandraAuthorizer
	</pre>		</pre>

Nicolas: /* Key space managmenet */

2020-10-11T19:45:38Z

Key space managmenet

← Older revision		Revision as of 19:45, 11 October 2020
Line 43:		Line 43:
	</syntaxhighlight>		</syntaxhighlight>

			* Create a keyspace
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	create KEYSPACE mmyKeyspace WITH replication = {'class': 'NetworkTopologyStrategy', 'datacenter1': 3};		create KEYSPACE mmyKeyspace WITH replication = {'class': 'NetworkTopologyStrategy', 'datacenter1': 3};
	</syntaxhighlight>		</syntaxhighlight>

			* Create a role that has all permissions in all keyspaces:
			<syntaxhighlight lang="sql">
			CREATE ROLE keyspace_admin;
			GRANT ALL PERMISSIONS ON ALL KEYSPACES TO keyspace_admin;
			GRANT keyspace_admin to martin;
			</syntaxhighlight>

			* Create an administrator role for a single keyspace:
			<syntaxhighlight lang="sql">
			CREATE ROLE cycling_admin;
			GRANT ALL PERMISSIONS ON KEYSPACE cycling to cycling_admin;
			GRANT cycling_admin TO sandy;
			</syntaxhighlight>

	<syntaxhighlight lang="~~bash~~">		* Create a role that can only make data changes, INSERT, UPDATE, DELETE, and TRUNCATE for any table in the keyspace cycling:
			<syntaxhighlight lang="sql">
			GRANT MODIFY ON KEYSPACE cycling TO team_manager;
			GRANT team_manager to sandy;
			</syntaxhighlight>

	CREATE KEYSPACE ~~IF NOT EXISTS myWorkspace~~		* Create a role that can only select data and use functions in the cycling keyspace:
			<syntaxhighlight lang="sql">
			CREATE ROLE cyclist_analyst;
			GRANT SELECT ON KEYSPACE cycling TO cyclist_analyst;
			GRANT EXECUTE ON ALL FUNCTIONS IN KEYSPACE cycling to cyclist_analyst;
			GRANT cyclist_analyst TO wilson;
	</syntaxhighlight>		</syntaxhighlight>

Nicolas: /* Key space managmenet */

2020-10-11T19:39:21Z

Key space managmenet

← Older revision		Revision as of 19:39, 11 October 2020
Line 37:		Line 37:

	=== Key space managmenet ===		=== Key space managmenet ===
	<syntaxhighlight lang="~~bash~~">		* List all keyspaces

			<syntaxhighlight lang="sql">
			SELECT * FROM system_schema.keyspaces;
			</syntaxhighlight>

			<syntaxhighlight lang="sql">
	create KEYSPACE mmyKeyspace WITH replication = {'class': 'NetworkTopologyStrategy', 'datacenter1': 3};		create KEYSPACE mmyKeyspace WITH replication = {'class': 'NetworkTopologyStrategy', 'datacenter1': 3};
	</syntaxhighlight>		</syntaxhighlight>

Nicolas: /* Cassandra */

2020-10-11T19:31:20Z

Cassandra

← Older revision		Revision as of 19:31, 11 October 2020
Line 9:		Line 9:
	SELECT cluster_name, listen_address FROM system.local;		SELECT cluster_name, listen_address FROM system.local;
	</syntaxhighlight>		</syntaxhighlight>

			=== Intial Seciruty ===

	* Update /etc/cassandra/yaml to add password authentification		* Update /etc/cassandra/yaml to add password authentification
Line 29:		Line 31:
	</syntaxhighlight>		</syntaxhighlight>

			* Create a backup Admin
			<syntaxhighlight lang="bash">
			create role myadmin with password = 'myAdminPassword' and login = true and superuser = true;
			</syntaxhighlight>

			=== Key space managmenet ===
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	create KEYSPACE mmyKeyspace WITH replication = {'class': 'NetworkTopologyStrategy', 'datacenter1': 3};		create KEYSPACE mmyKeyspace WITH replication = {'class': 'NetworkTopologyStrategy', 'datacenter1': 3};

Nicolas: /* Cassandra */

2020-10-11T19:27:19Z

Cassandra

@@ Line 4: / Line 4: @@
 nodetool status
 </syntaxhighlight>
 <syntaxhighlight lang="bash">

Nicolas: Created page with "== Cassandra == nodetool status CREATE KEYSPACE IF NOT EXISTS myWorkspace "

2020-10-11T19:03:31Z

Created page with "== Cassandra == <syntaxhighlight lang="bash"> nodetool status </syntaxhighlight> <syntaxhighlight lang="bash"> CREATE KEYSPACE IF NOT EXISTS myWorkspace </syntaxhighlight>"

New page

== Cassandra ==

<syntaxhighlight lang="bash">
nodetool status
</syntaxhighlight>

<syntaxhighlight lang="bash">

CREATE KEYSPACE IF NOT EXISTS myWorkspace
</syntaxhighlight>