NoHostAvailable:, In elassandra on insert query with Network Topology Strategy

Question

In elassandra on insert query with Network Topology Strategy it show's 'no host available'.

cqlsh>CREATE KEYSPACE IF NOT EXISTS twitter WITH replication={ 'class':'NetworkTopologyStrategy', 'dc1':'1' };

cqlsh>CREATE TABLE twitter.user (
   name text,
   attrs map<text,text>,
   PRIMARY KEY (name)
);

cqlsh>INSERT INTO twitter.user (name,attrs) VALUES ('bob',{'email':'bob@gmail.com','firstname':'bob'});

nodetool status

another keyspace using same dc, show's this

sachin@user-PC:~/elassandraDemo/elassandra-2.4.2/bin$ ./nodetool status twitter Datacenter: DC1 =============== Status=Up/Down |/ State=Normal/Leaving/Joining/Moving -- Address Load Tokens Owns (effective) Host ID Rack UN 127.0.0.1 186.72 KB 8 0.0% 089a9ce4-7676-4b14-9773-58aa5913fa34 r1 — Sachin, Sep 13 '17 at 11:08

Ashraful Islam · Accepted Answer · 2017-09-13T11:38:34.860

3

Change data center name of your keyspace to DC1

ALTER KEYSPACE twitter WITH replication = {'class': 'NetworkTopologyStrategy', 'DC1' : 1};

Data Center name is case sensitive.

Edited

Two replication strategies are available:

SimpleStrategy: Use for a single data center only. If you ever intend more than one data center, use the NetworkTopologyStrategy.
NetworkTopologyStrategy: Highly recommended for most deployments because it is much easier to expand to multiple data centers when required by future expansion.

edited Sep 13 '17 at 11:38

answered Sep 13 '17 at 11:14

Ashraful Islam

12,470
3
32
53

is datacenter or replication is same thing or not? – Sachin Sep 13 '17 at 11:21
No. For each keyspace replication can be configured for each data center – Ashraful Islam Sep 13 '17 at 11:24
is that possible to work elasticsearch on simpleStrategy? – Sachin Sep 13 '17 at 11:28
@SachinArora yes, it is possible. and check the edited answer – Ashraful Islam Sep 13 '17 at 11:38
It's work well with DC1 but when we created another keyspace with the same DC1 then it's not worked. – Sachin Sep 13 '17 at 11:43
pls check the question again, I added another further problem index not found – Sachin Sep 13 '17 at 12:14
@SachinArora the problem you mention is not about cassandra. It's the elasticsearch. elasticsearch index not found. – Ashraful Islam Sep 13 '17 at 12:29

score 0 · Answer 2 · answered Nov 17 '17 at 11:33

0

'dc1' at the time of creating the keyspace should be the Datacenter name when you use nodetool status

answered Nov 17 '17 at 11:33

isaura almar

406
5
11

NoHostAvailable:, In elassandra on insert query with Network Topology Strategy

2 Answers2