I have a mongo database which I perform extensive aggregations that consumes almost all CPU while aggregation runs. So I was thinking that I could replicate the database and then run aggregations on secondary database. The only problem is that I have to save the results of the aggregations in a secondary collection that does not exists on the primary. Will this cause a problem to the replication? If yes, what other options do I have?
Thank you