Question about nodetool status ... output
Hi, I have one node in my 5-node cluster that effectively owns 100% and it looks like my cluster is rather imbalanced. Is it common to have it this imbalanced for 4-5 nodes? My current output for a keyspace is: $ nodetool status myks Datacenter: Cassandra = Status=Up/Down |/ State=Normal/Leaving/Joining/Moving -- Address Load Tokens Owns (effective) Host ID Rack UN X.X.X.33 203.92 GB 256 41.3% 871968c9-1d6b-4f06-ba90-8b3a8d92dcf0 RAC1 UN X.X.X.32 200.44 GB 256 34.2% d7cacd89-8613-4de5-8a5e-a2c53c41ea45 RAC1 UN X.X.X.51 197.17 GB 256 100.0% 344b0adf-2b5d-47c8-8881-9a3f56be6f3b RAC1 UN X.X.X.52 113.63 GB 1 46.3% 55daa807-af49-44c5-9742-fe456df621a1 RAC1 UN X.X.X.31 204.49 GB 256 78.3% 48cb0782-6c9a-4805-9330-38e192b6b680 RAC1 My keyspace has RF=3 and originally I added X.X.X.52 (num_tokens=1 was a mistake) and then X.X.X.51. I haven't executed `nodetool cleanup` on any nodes yet. For the curious, the full ring can be found here: https://gist.github.com/JensRantil/57ee515e647e2f154779 Cheers, Jens -- Jens Rantil Backend engineer Tink AB Email: jens.ran...@tink.se Phone: +46 708 84 18 32 Web: www.tink.se Facebook https://www.facebook.com/#!/tink.se Linkedin http://www.linkedin.com/company/2735919?trk=vsrp_companies_res_phototrkInfo=VSRPsearchId%3A1057023381369207406670%2CVSRPtargetId%3A2735919%2CVSRPcmpt%3Aprimary Twitter https://twitter.com/tink
Re: Question about nodetool status ... output
Your data model also contributes to the balance (or lack of) of the cluster. If you have a really bad data partitioning Cassandra will not do any magic. Regarding that cluster, I would decommission the x.52 node and add it again with the correct configuration. After the bootstrap, run a cleanup. If is still that off-balance, you need to look into your data model. Regards, Carlos Juzarte Rolo Cassandra Consultant Pythian - Love your data rolo@pythian | Twitter: cjrolo | Linkedin: *linkedin.com/in/carlosjuzarterolo http://linkedin.com/in/carlosjuzarterolo* Mobile: +31 6 159 61 814 | Tel: +1 613 565 8696 x1649 www.pythian.com On Fri, Jun 12, 2015 at 11:58 AM, Jens Rantil jens.ran...@tink.se wrote: Hi, I have one node in my 5-node cluster that effectively owns 100% and it looks like my cluster is rather imbalanced. Is it common to have it this imbalanced for 4-5 nodes? My current output for a keyspace is: $ nodetool status myks Datacenter: Cassandra = Status=Up/Down |/ State=Normal/Leaving/Joining/Moving -- Address Load Tokens Owns (effective) Host ID Rack UN X.X.X.33 203.92 GB 256 41.3% 871968c9-1d6b-4f06-ba90-8b3a8d92dcf0 RAC1 UN X.X.X.32 200.44 GB 256 34.2% d7cacd89-8613-4de5-8a5e-a2c53c41ea45 RAC1 UN X.X.X.51 197.17 GB 256 100.0% 344b0adf-2b5d-47c8-8881-9a3f56be6f3b RAC1 UN X.X.X.52 113.63 GB 1 46.3% 55daa807-af49-44c5-9742-fe456df621a1 RAC1 UN X.X.X.31 204.49 GB 256 78.3% 48cb0782-6c9a-4805-9330-38e192b6b680 RAC1 My keyspace has RF=3 and originally I added X.X.X.52 (num_tokens=1 was a mistake) and then X.X.X.51. I haven't executed `nodetool cleanup` on any nodes yet. For the curious, the full ring can be found here: https://gist.github.com/JensRantil/57ee515e647e2f154779 Cheers, Jens -- Jens Rantil Backend engineer Tink AB Email: jens.ran...@tink.se Phone: +46 708 84 18 32 Web: www.tink.se Facebook https://www.facebook.com/#!/tink.se Linkedin http://www.linkedin.com/company/2735919?trk=vsrp_companies_res_phototrkInfo=VSRPsearchId%3A1057023381369207406670%2CVSRPtargetId%3A2735919%2CVSRPcmpt%3Aprimary Twitter https://twitter.com/tink -- --
Re: Question about nodetool status ... output
Hi Carlos, Yes, I should have been more specific about that; basically all my primary ID:s are random UUIDs so I find that very hard to believe that my data model should be the problem here. I will run a full repair of the cluster, execute a cleanup and recommission the node, then. Thanks, Jens On Fri, Jun 12, 2015 at 2:38 PM, Carlos Rolo r...@pythian.com wrote: Your data model also contributes to the balance (or lack of) of the cluster. If you have a really bad data partitioning Cassandra will not do any magic. Regarding that cluster, I would decommission the x.52 node and add it again with the correct configuration. After the bootstrap, run a cleanup. If is still that off-balance, you need to look into your data model. Regards, Carlos Juzarte Rolo Cassandra Consultant Pythian - Love your data rolo@pythian | Twitter: cjrolo | Linkedin: *linkedin.com/in/carlosjuzarterolo http://linkedin.com/in/carlosjuzarterolo* Mobile: +31 6 159 61 814 | Tel: +1 613 565 8696 x1649 www.pythian.com On Fri, Jun 12, 2015 at 11:58 AM, Jens Rantil jens.ran...@tink.se wrote: Hi, I have one node in my 5-node cluster that effectively owns 100% and it looks like my cluster is rather imbalanced. Is it common to have it this imbalanced for 4-5 nodes? My current output for a keyspace is: $ nodetool status myks Datacenter: Cassandra = Status=Up/Down |/ State=Normal/Leaving/Joining/Moving -- Address Load Tokens Owns (effective) Host ID Rack UN X.X.X.33 203.92 GB 256 41.3% 871968c9-1d6b-4f06-ba90-8b3a8d92dcf0 RAC1 UN X.X.X.32 200.44 GB 256 34.2% d7cacd89-8613-4de5-8a5e-a2c53c41ea45 RAC1 UN X.X.X.51 197.17 GB 256 100.0% 344b0adf-2b5d-47c8-8881-9a3f56be6f3b RAC1 UN X.X.X.52 113.63 GB 1 46.3% 55daa807-af49-44c5-9742-fe456df621a1 RAC1 UN X.X.X.31 204.49 GB 256 78.3% 48cb0782-6c9a-4805-9330-38e192b6b680 RAC1 My keyspace has RF=3 and originally I added X.X.X.52 (num_tokens=1 was a mistake) and then X.X.X.51. I haven't executed `nodetool cleanup` on any nodes yet. For the curious, the full ring can be found here: https://gist.github.com/JensRantil/57ee515e647e2f154779 Cheers, Jens -- Jens Rantil Backend engineer Tink AB Email: jens.ran...@tink.se Phone: +46 708 84 18 32 Web: www.tink.se Facebook https://www.facebook.com/#!/tink.se Linkedin http://www.linkedin.com/company/2735919?trk=vsrp_companies_res_phototrkInfo=VSRPsearchId%3A1057023381369207406670%2CVSRPtargetId%3A2735919%2CVSRPcmpt%3Aprimary Twitter https://twitter.com/tink -- -- Jens Rantil Backend engineer Tink AB Email: jens.ran...@tink.se Phone: +46 708 84 18 32 Web: www.tink.se Facebook https://www.facebook.com/#!/tink.se Linkedin http://www.linkedin.com/company/2735919?trk=vsrp_companies_res_phototrkInfo=VSRPsearchId%3A1057023381369207406670%2CVSRPtargetId%3A2735919%2CVSRPcmpt%3Aprimary Twitter https://twitter.com/tink