I have a 3-node cluster running Couchbase Server 5.5.2. Index service runs on all three nodes. On this cluster, I have a bucket with UUIDs served as document ids. I create a number of partitioned indexes like this:
attr1)) PARTITION BY HASH(META().Id);
I see that the load on nodes is distributed very much unequally, even though, partitioning by a uniformly distributed attribute (UUID) is expected to distribute the index more or less uniformly. One of the cluster nodes works hard (mostly CPU and also I/O) and other nodes are quite idle. Note that I just guess that the index distribution across the nodes is not uniform, because I have not found a way to check it. Could you help me to understand what’s going wrong?
Thanks in advance