SOLVED

MSATA - mongodb database cleanup

%3CLINGO-SUB%20id%3D%22lingo-sub-886130%22%20slang%3D%22en-US%22%3EMSATA%20-%20mongodb%20database%20cleanup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-886130%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20rebuild%20MSATA%20server%20every%20month%20and%20restoration%20of%20mongodb%20database%20is%20taking%20lot%20of%20time.%20Size%20of%20database%20is%20around%2025%20GB.%20Is%20there%20any%20way%20to%20clean%20up%20the%20database%20of%20unwanted%20data%20to%20make%20the%20backup%20and%20the%20restoration%20faster%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-886130%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Emsata%20mongodb%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-887307%22%20slang%3D%22en-US%22%3ERe%3A%20MSATA%20-%20mongodb%20database%20cleanup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-887307%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F418102%22%20target%3D%22_blank%22%3E%40anishkk79%3C%2FA%3E%26nbsp%3B%2C%20That%20depends%20if%20it%20currently%20holds%20more%20data%20than%20it%20has%20too%20(1%20month%20back).%3C%2FP%3E%0A%3CP%3Ewhat%20is%20the%20disk%20size%2C%20and%20how%20much%20free%20space%20do%20you%20have%20%3F%20what%20was%20the%20recommended%20size%26nbsp%3B%20by%20the%20sizing%20tool%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOn%20another%20note%2C%20I%20am%20interested%20to%20learn%2C%20why%20would%20you%20rebuild%20the%20server%20monthly%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1037959%22%20slang%3D%22en-US%22%3ERe%3A%20MSATA%20-%20mongodb%20database%20cleanup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1037959%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F106935%22%20target%3D%22_blank%22%3E%40Eli%20Ofek%3C%2FA%3E%3C%2FP%3E%3CP%3EWe%20rebuild%20MSATA%20every%20month%20to%20meet%20the%20AMI%20compliance.%20After%20MSATA%20rebuild%20the%20database%20size%20autmatically%20came%20down.%20So%20that%20is%20not%20a%20problem%20now.%3C%2FP%3E%3CP%3EWe%20have%20another%20issue%20related%20to%20mongodb.%20We%20run%20nexpose%20scan%20on%20all%20the%20servers%20to%20check%20the%20vulnerabilities.%20This%20month%20we%20are%20getting%20the%20below%20vulnerabilities%20for%20mongodb%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EMongoDB%3A%20Permissions%2C%20Privileges%2C%20and%20Access%20Controls%20(CVE-2019-2390)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EMongoDB%3A%20Improper%20Input%20Validation%20(CVE-2019-2389)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EMongoDB%3A%20Improper%20Authorization%20(CVE-2019-2386)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EWe%20use%20MSATA%201.9.2%20which%20comes%20with%20mongodb%20version%203.6.10.%20Recommended%20version%20to%20fix%20these%20vulnerabilities%20is%203.6.14.%20Any%20idea%20how%20to%20get%20it%20upgraded%20or%20should%20we%20wait%20till%20Microsoft%20releases%20the%20next%20version%20of%20MSATA%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1038056%22%20slang%3D%22en-US%22%3ERe%3A%20MSATA%20-%20mongodb%20database%20cleanup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1038056%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EWhile%20those%20issues%20do%20not%20effect%20ATA%20as%20we%20are%20blocked%20to%20localhost%20connections%20only%2C%20the%20soon%20to%20be%20released%20update%203%20is%20expected%20to%20upgrade%20mongo%20to%203.6.15.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

We rebuild MSATA server every month and restoration of mongodb database is taking lot of time. Size of database is around 25 GB. Is there any way to clean up the database of unwanted data to make the backup and the restoration faster?

3 Replies
Highlighted

@anishkk79 , That depends if it currently holds more data than it has too (1 month back).

what is the disk size, and how much free space do you have ? what was the recommended size  by the sizing tool?

 

On another note, I am interested to learn, why would you rebuild the server monthly?

Highlighted

@Eli Ofek

We rebuild MSATA every month to meet the AMI compliance. After MSATA rebuild the database size autmatically came down. So that is not a problem now.

We have another issue related to mongodb. We run nexpose scan on all the servers to check the vulnerabilities. This month we are getting the below vulnerabilities for mongodb

 

MongoDB: Permissions, Privileges, and Access Controls (CVE-2019-2390)
MongoDB: Improper Input Validation (CVE-2019-2389)
MongoDB: Improper Authorization (CVE-2019-2386)

 

We use MSATA 1.9.2 which comes with mongodb version 3.6.10. Recommended version to fix these vulnerabilities is 3.6.14. Any idea how to get it upgraded or should we wait till Microsoft releases the next version of MSATA

 

Highlighted
Best Response confirmed by anishkk79 (New Contributor)
Solution
Hi,
While those issues do not effect ATA as we are blocked to localhost connections only, the soon to be released update 3 is expected to upgrade mongo to 3.6.15.