Re: Replication issue with Multi DC setup in cassandra

Cqlsh looks at the cluster, not node “All men dream, but not equally. Those who dream by night in the dusty recesses of their minds wake up in the day to find it was vanity, but the dreamers of the day are dangerous men, for they may act their dreams with open eyes, to make it possible.” — T.E.

Re: Replication issue with Multi DC setup in cassandra

Run *nodetool cleanup* on the *4.4.4.5* DC node(s). Changing network topology does not *remove* data - it's a manual task. But it should prevent it from replicating over to the undesired DC. Also make sure your LoadBalancingStrategy is set to DCAwareRoundRobinPolicy, with *4.4.4.4* DC set as the

Re: Replication issue with Multi DC setup in cassandra

May I inquire if your configuration is actually data center aware? Do you understand the difference between LQ and replication? *Daemeon C.M. ReiydelleUSA (+1) 415.501.0198London (+44) (0) 20 8144 9872* *“All men dream, but not equally. Those who dream by night in the dusty recesses of

Re: Replication issue with Multi DC setup in cassandra

Did you run `nodetool repair` after changing the keyspace? (not sure if it makes sense though) 2017-05-16 19:52 GMT-03:00 Nitan Kainth : > Strange. Anybody else might share something more important. > > Sent from my iPhone > > On May 16, 2017, at 5:23 PM, suraj pasuparthy

Re: Replication issue with Multi DC setup in cassandra

Yes is see them in the datacenter's data directories.. infact i see then even after i bring down the interface between the 2 DC's which further confirms that a local copy is maintained in the DC that was not configured in the strategy .. its quite important that we block the info for this keyspace

Re: Replication issue with Multi DC setup in cassandra

check for datafiles on filesystem in both DCs. > On May 16, 2017, at 4:42 PM, suraj pasuparthy > wrote: > > So i though the same, > I see the data via the CQLSH in both the datacenters. consistency is set to LQ > > thanks > -Suraj > > On Tue, May 16, 2017 at 2:19

Re: Replication issue with Multi DC setup in cassandra

So i though the same, I see the data via the CQLSH in both the datacenters. consistency is set to LQ thanks -Suraj On Tue, May 16, 2017 at 2:19 PM, Nitan Kainth wrote: > Do you see data on other DC or just directory structure? Directory > structure would populate because it

Re: Replication issue with Multi DC setup in cassandra

Do you see data on other DC or just directory structure? Directory structure would populate because it is DDL but inserts shouldn’t populate, ideally. > On May 16, 2017, at 3:19 PM, suraj pasuparthy > wrote: > > elp me fig

Replication issue with Multi DC setup in cassandra

Hello, I am tying to find a way to PREVENT just one of my keyspaces to not sync to the other datacenter. I have 2 datacenters setup this way : Datacenter: DC:4.4.4.4 == Status=Up/Down |/ State=Normal/Leaving/Joining/Moving -- Address Load Tokens Owns