With Topic Subject, U might see there are similar topic already exists but all those existing topics didn’t have the topic related information at all. Hence I’m creating new topic.
Question : In the Replica set of 3 nodes (1 primary, 1 secondary and 1 Arbiter), Is it good Idea to have different set of indexes for Primary and Secondary node. ?
In my replica set, its more like Primary will always remain as primary and so as the secondary. So I was thinking to create all write related indexes on primary node and same write related indexes + additional read related indexes on secondary node (as My reporting related queries always run on secondary).
Is this good approach ? Will this have any impact on the performance on entire replica set that will eventually introduce to latency on the primary node
Thanks in advance