I'm planning to implement this schema in Mongodb, I have been doing some readings about schema design, and the notion was whenever you structure your data like a relational database you must be doing something wrong.
what should I do when collection size gets larger than 16MB limit? app_log in server_log collections gets might in some cases grow larger than 16MB depending how busy the server is.
I'm aware of the cap feature that I could use, but the requirement is store all logs for 90 days.
Do you see any potential issues with my design?
- Is it a good practice to have the application check for collection size and create new collection by day / hour ..etc to accommodate log size growth?