Advertisement
Guest User

CASSANDRA-6852 input

a guest
Mar 13th, 2014
21
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.95 KB | None | 0 0
  1. Here are my ring
  2. ----------------
  3.  
  4. Datacenter: dc2
  5. ===============
  6. Status=Up/Down
  7. |/ State=Normal/Leaving/Joining/Moving
  8. -- Address Load Tokens Owns Host ID Rack
  9. UN 10.0.1.199 41.71 MB 256 10.0% 66f73790-26e4-4012-a506-54edac89323b r01
  10. UN 10.0.1.34 45.79 MB 256 10.6% 468bf889-caf2-4fe3-b79c-53543e7ee5f4 r01
  11. UN 10.0.1.167 43.48 MB 256 10.1% e0864764-f877-4636-a8ea-69f47a6c7ee3 r01
  12. UN 10.0.1.119 42.06 MB 256 10.5% f7f49f53-6dc4-408a-9ea0-6fe27ce13777 r01
  13. Datacenter: dc1
  14. ===============
  15. Status=Up/Down
  16. |/ State=Normal/Leaving/Joining/Moving
  17. -- Address Load Tokens Owns Host ID Rack
  18. UN 10.0.1.209 43.51 MB 256 10.2% cd9f5919-9895-4a72-9822-194c0950d950 r01
  19. UN 10.0.1.193 43.96 MB 256 9.7% 499441ca-08f6-4dc4-a727-580b4c5f5593 r01
  20. UN 10.0.1.192 41.57 MB 256 9.6% 6f7fd50d-d0a3-4a30-84be-8b8d123f6e12 r01
  21. UN 10.0.1.244 44.01 MB 256 9.8% 718325b1-e225-40d2-95bb-7c012f191644 r01
  22. Datacenter: dc3
  23. ===============
  24. Status=Up/Down
  25. |/ State=Normal/Leaving/Joining/Moving
  26. -- Address Load Tokens Owns Host ID Rack
  27. UN 10.0.1.128 121.95 KB 256 10.1% 41690239-75c5-474f-8b07-524937abe879 r01
  28. UN 10.0.1.69 126.73 KB 256 9.4% 5a4ed0a1-7979-4dbb-ac16-117df685dbb1 r01
  29.  
  30. I have this data :
  31. ------------------
  32.  
  33. CREATE KEYSPACE ks1 WITH replication = {
  34. 'class': 'NetworkTopologyStrategy',
  35. 'dc1': '2',
  36. 'dc2': '2'
  37. };
  38.  
  39. use ks1;
  40.  
  41. CREATE TABLE t1 (
  42. str text,
  43. val int,
  44. PRIMARY KEY (str)
  45. ) WITH compression={'sstable_compression': 'SnappyCompressor'};
  46.  
  47. You can see those tokens (I have sorted trying to find ranges) :
  48. --------------------------
  49.  
  50. 10.0.1.167 r01 Up Normal 37.54 MB 10.15% 92599675876152029
  51. 10.0.1.128 r01 Up Normal 62.5 KB 10.08% 936104068755107049 <—
  52. 10.0.1.128 r01 Up Normal 62.5 KB 10.08% 943395402795400988 <—
  53. 10.0.1.119 r01 Up Normal 37.62 MB 10.46% 947638296150677630
  54. 10.0.1.128 r01 Up Normal 62.5 KB 10.08% 948472585151216644
  55. 10.0.1.199 r01 Up Normal 37.56 MB 10.04% 961678697172837907
  56.  
  57. I try to check what stores ranges on 10.0.1.128:
  58. ------------------------------------------------
  59.  
  60. cqlsh:ks1> select * from t1 where token(str)>=936104068755107049 AND token(str)<943395402795400988 limit 10;
  61.  
  62. str | val
  63. ------------+---------
  64. str46947 | 46947
  65. str420293 | 420293
  66. str1248609 | 1248609
  67. str294735 | 294735
  68. str508320 | 508320
  69. str1369802 | 1369802
  70. str872818 | 872818
  71. str1722208 | 1722208
  72. str638028 | 638028
  73. str25757 | 25757
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement