Hello MongoDB Folk,
I am looking for some inputs and thoughts on reading only from Secondary through dedicated mongos.
Is there any way to route all queries particularly from mongos that will read data only from secondary nodes of sharded cluster and no write will be entertained.
To achieve this below are the tools I am aware of and that too comes with a lot of constraints like no support on index sync and requires a lot of manual interventions in order to manage and replicate a whole new cluster.
This is the improvement request I have submitted in MongoDB
If the above improvement seems useful then please up-vote and any other tools or utility recommendations are most welcome.