We have 3 shard cluster, The cluster shard1 and shard2 have the highest hardware specification. but the shard3 has lower hardware specification. we have collection called users and has field cookies.
Is there any possibility to config to shard based on whether or not the field for cookie exists ?
if it exists, the document should be on shard1 and shard2, and if it does not exist, the document should be on shard3.
The goal is for cost optimization our cluster.