RE: [EXTERNAL] Re: Adding datacenter and data verification

2018-09-18 Thread Durity, Sean R
the table. The data will get written to all the proper, new nodes. Sean Durity From: Pradeep Chhetri Sent: Tuesday, September 18, 2018 1:55 AM To: user@cassandra.apache.org Subject: [EXTERNAL] Re: Adding datacenter and data verification Hi Eunsu, By going through the documentation, I think you

Re: Adding datacenter and data verification

2018-09-17 Thread Pradeep Chhetri
Hi Eunsu, By going through the documentation, I think you are right, you shouldn't use withUsedHostsPerRemoteDc because it will contact nodes in other datacenters. No i don't use withUsedHostsPerRemoteDc, but instead i use withLocalDc option. On Tue, Sep 18, 2018 at 11:02 AM, Eunsu Kim wrote:

Re: Adding datacenter and data verification

2018-09-17 Thread Eunsu Kim
Yes, I altered the system_auth key space before adding the data center. However, I suspect that the new data center did not get the system_auth data and therefore could not authenticate to the client. Because the new data center did not get the replica count by altering keyspace. Do your client

Re: Adding datacenter and data verification

2018-09-17 Thread Pradeep Chhetri
Hello Eunsu, I am also using PasswordAuthenticator in my cassandra cluster. I didn't come across this issue while doing the exercise on preprod. Are you sure that you changed the configuration of system_auth keyspace before adding the new datacenter using this: ALTER KEYSPACE system_auth WITH RE

Re: Adding datacenter and data verification

2018-09-17 Thread Eunsu Kim
In my case, there were authentication issues when adding data centers. I was using a PasswordAuthenticator. As soon as the datacenter was added, the following authentication error log was recorded on the client log file. com.datastax.driver.core.exceptions.AuthenticationException: Authenticati

Re: Adding datacenter and data verification

2018-09-17 Thread Pradeep Chhetri
Hello Alain, Thank you very much for reviewing it. You answer on seed nodes cleared my doubts. I will update it as per your suggestion. I have few followup questions on decommissioning of datacenter: - Do i need to run nodetool repair -full on each of the nodes (old + new dc nodes) before starti

Re: Adding datacenter and data verification

2018-09-17 Thread Alain RODRIGUEZ
Hello Pradeep, It looks good to me and it's a cool runbook for you to follow and for others to reuse. To make sure that cassandra nodes in one datacenter can see the nodes of > the other datacenter, add the seed node of the new datacenter in any of the > old datacenter’s nodes and restart that no

Re: Adding datacenter and data verification

2018-09-17 Thread Pradeep Chhetri
Hello everyone, Can someone please help me in validating the steps i am following to migrate cassandra snitch. Regards, Pradeep On Wed, Sep 12, 2018 at 1:38 PM, Pradeep Chhetri wrote: > Hello > > I am running cassandra 3.11.3 5-node cluster on AWS with SimpleSnitch. I > was testing the process

Adding datacenter and data verification

2018-09-12 Thread Pradeep Chhetri
Hello I am running cassandra 3.11.3 5-node cluster on AWS with SimpleSnitch. I was testing the process to migrate to GPFS using AWS region as the datacenter name and AWS zone as the rack name in my preprod environment and was able to achieve it. But before decommissioning the older datacenter, I