Cassandra for Oracle DBA’s Part 12 : Client Connections & Timeouts

We also set timeouts for client side, 

TNSNAMES.ora or sqlnet.ora (Client Side)

root@wash-i-16ca26c8-prod ~/.ccm/repository/4.5.2/resources/cassandra/conf $ vi cqlshrc.default

root@wash-i-16ca26c8-prod ~/.ccm/repository/4.5.2/resources/cassandra/conf $

Set the client_timeout as like sqlnet.ora timeout setting

[connection]

hostname = 192.168.1.2

port = 9160

client_timeout=40

###################################

Node Communication Settings * Timeouts

###################################

root@wash-i-16ca26c8-prod ~/.ccm/geek_cluster/node1/resources/cassandra/conf $

root@wash-i-16ca26c8-prod ~/.ccm/geek_cluster/node1/resources/cassandra/conf $ grep listen cassandra.yaml

listen_address: 127.0.0.1

root@wash-i-16ca26c8-prod ~/.ccm/geek_cluster/node1/resources/cassandra/conf $ grep broadcast cassandra.yaml

root@wash-i-16ca26c8-prod ~/.ccm/geek_cluster/node1/resources/cassandra/conf $ grep seed cassandra.yaml

seed_provider:

  - seeds: 127.0.0.1,127.0.0.2,127.0.0.3

root@wash-i-16ca26c8-prod ~/.ccm/geek_cluster/node1/resources/cassandra/conf $ grep storage cassandra.yaml

ssl_storage_port: 7001

storage_port: 7000

root@wash-i-16ca26c8-prod ~/.ccm/geek_cluster/node1/resources/cassandra/conf $ grep token cassandra.yaml

initial_token: -9223372036854775808

num_tokens: 1

root@wash-i-16ca26c8-prod ~/.ccm/geek_cluster/node1/resources/cassandra/conf $

root@wash-i-16ca26c8-prod ~/.ccm/geek_cluster/node1/resources/cassandra/conf $ cat cassandra-topology.properties

default=dc1:r1