title: how to connect to cassandra cluster using cqlsh or command prompt?
body: <p>In other dbs, we connect to db cluster with load balance IP. How do we connect to cassandra cluster using command line? What socket is used? Is this always a single node and IP?
  What if i connect o node1, and node1 goes down. Will this automatically connect to node2 or node3?</p>