Add new DC to cluster

[Prem Yadav <ip...@gmail.com>]

Hi,
We have an existing cluster consisting of 3 DCs. Authentication is enabled.
I am trying to add a new DC. I followed the steps mentioned at:

http://docs.datastax.com/en/cassandra/2.0/cassandra/operations/ops_add_dc_to_cluster_t.html

Bit, I still can't login to any of the nodes in the new DC using the
superuser. The cassandra superuser was always disabled.

I ran the repair. How long should the repair take for system_auth? Anything
else I am missing?

I restarted the nodes a couple of times. Shouldn't the nodes pull the data?

Any help is appreciated.

Re: Add new DC to cluster

[Prem Yadav <ip...@gmail.com>]

Thanks Anuj.
In our setup it's already NetworkTopology for system_auth. Not sure if it
was default or whether we altered it at some point.
Repair seems to take forever. A few things that worked for me:

I used cqlsh to connect to one of the nodes in existing DCs and set
consistency to ALL. After that I changed the password of the user I wanted
to connect to. Voila :) the consistency worked and I can now connect to the
new DCs using the user.

I guess if I do it for all users, it will work. This is enough for me.
However, I would think 'nodetool rebuild' and a restart should take care of
this. Not sure why it doesn't.






On Sun, Jun 7, 2015 at 5:10 PM, Anuj Wadehra <an...@yahoo.co.in> wrote:

> Hi Prem,
>
> I think system_auth keyspace uses SimpleStrategy by default and thus not
> applicable across dc.Please alter the keyspace to use NetworkTopology and
> set appropriate replication factor for both Dc. After that you can run full
> repair across dc on this keyspace.
>
> I dnt see any drawbacks of doing this. Any suggestions against
> this..please feel free to discuss...
>
> Thanks
> Anuj Wadehra
>
> Sent from Yahoo Mail on Android
> <https://overview.mail.yahoo.com/mobile/?.src=Android>
> ------------------------------
>   *From*:"Prem Yadav" <ip...@gmail.com>
> *Date*:Sun, 7 Jun, 2015 at 8:19 pm
> *Subject*:Add new DC to cluster
>
> Hi,
> We have an existing cluster consisting of 3 DCs. Authentication is enabled.
> I am trying to add a new DC. I followed the steps mentioned at:
>
>
> http://docs.datastax.com/en/cassandra/2.0/cassandra/operations/ops_add_dc_to_cluster_t.html
>
> Bit, I still can't login to any of the nodes in the new DC using the
> superuser. The cassandra superuser was always disabled.
>
> I ran the repair. How long should the repair take for system_auth?
> Anything else I am missing?
>
> I restarted the nodes a couple of times. Shouldn't the nodes pull the data?
>
> Any help is appreciated.
>

Re: Add new DC to cluster

[Anuj Wadehra <an...@yahoo.co.in>]

Hi Prem,


I think system_auth keyspace uses SimpleStrategy by default and thus not applicable across dc.Please alter the keyspace to use NetworkTopology and set appropriate replication factor for both Dc. After that you can run full repair across dc on this keyspace.


I dnt see any drawbacks of doing this. Any suggestions against this..please feel free to discuss...


Thanks

Anuj Wadehra


Sent from Yahoo Mail on Android

From:"Prem Yadav" <ip...@gmail.com>
Date:Sun, 7 Jun, 2015 at 8:19 pm
Subject:Add new DC to cluster

Hi,

We have an existing cluster consisting of 3 DCs. Authentication is enabled.

I am trying to add a new DC. I followed the steps mentioned at:


http://docs.datastax.com/en/cassandra/2.0/cassandra/operations/ops_add_dc_to_cluster_t.html


Bit, I still can't login to any of the nodes in the new DC using the superuser. The cassandra superuser was always disabled.


I ran the repair. How long should the repair take for system_auth? Anything else I am missing?


I restarted the nodes a couple of times. Shouldn't the nodes pull the data?


Any help is appreciated.