I am a newbie to Mongo. I am working on making an API which stores data records of individuals. I am using a Virtual Private server for hosting the API and the server. I am looking at possible mechanisms/schema choices I can use to isolate the data of individuals, so that data records of individuals which belong to a group can be accessed by admin users of that group, despite all the data about individuals being stored in one table(‘group’ is a property of each entry).
I have the following queries:
- Is it ok to store all the data in one table with the group being used as a differrentiator – Are there any mechanisms I can use to achieve data isolation.
- Is it easy to move from one running instance of mongo db to a cluster, when the demand on the instance increases.
Any help appreciated,