Differences

This shows you the differences between two versions of the page.

--- cassandra_mngm [2018/08/28 07:57] – external edit 127.0.0.1
+++ cassandra_mngm [2019/10/18 20:04] (current) – external edit 127.0.0.1
@@ Line 2: / Line 2: @@
 For a NoSQL, Cassandra seems more as SQL Database (Oracle, DB2, etc) than NoSQL databases (Mongo for example)
 A lot of the commands are the same as SQL datatabase, as you will see below:
+====Connection====
+First and foremost, we have to connect to our cassandra :) Cassandra uses a lot of ports and knowing which ports to use is essential:
+Cassandra
+  *     7199 JMX monitoring port and in earlier Cassandra (0.8) version it was 8080
+  *     9042 CQL Native Transport Port
+  *     9160 Thrift client API
+  *     7000 Inter-node cluster
+  *     7001 TLS Internode communication (used if TLS enabled)
+DataStax OpsCenter
+  *     61620 opscenterd daemon
+  *     61621 Agent
+  *     8888 Website
+So for our connection we will use port: 9042, which is the native CQL client port, as follows:
+<sxh bash>
+$ cqlsh 172.27.1.246 9042  -u jandonov -p XXXXXXXXXXXXXXXXXXXXX
+    ^         ^        ^         ^               ^
+    |         |        |         |               |
+  Client IP Address  Port     Username        Password
+[cqlsh 5.0.1 | Cassandra 3.10 | CQL spec 3.4.4 | Native protocol v4]
+Use HELP for help.
+jandonov@cqlsh> SELECT * FROM system_schema.keyspaces;
+ keyspace_name      | durable_writes | replication
+</sxh>
 ====Schemas/Databases====