[SERVER-34268] The Backup Requirement during Compact Execution-Confirmation Created: 03/Apr/18 Updated: 24/Apr/18 Resolved: 12/Apr/18 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Storage |
| Affects Version/s: | 3.4.0 |
| Fix Version/s: | None |
| Type: | Question | Priority: | Major - P3 |
| Reporter: | Sandeep [X] | Assignee: | Kelsey Schubert |
| Resolution: | Done | Votes: | 1 |
| Labels: | compact, mongodb, windows, wiredtiger | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
Windows |
||
| Participants: |
| Description |
|
Dear Team, Below are the environment details
As per the MongoDB documentation for Compact command, it is recommended to create a backup before performing Compact command. (Ref: https://docs.mongodb.com/manual/reference/command/compact/#dbcmd.compact) However as per the MongoDB documentation, if we terminate the Compact command in between AND if journaling is enabled, it will be restored without any issue and we may have to rebuild the indexes (Ref: https://docs.mongodb.com/manual/reference/command/compact/#operation-termination) To ensure that 'data' backup is not required , we have terminated the compact Operation while it is executing on the database collections with dataSize=68.8GiB, and observed that the both 'data' and 'index' remains valid and usable. Could you please confirm whether backup is really necessary even if Journaling is enabled or not, Thank you. Thanks & Regards |
| Comments |
| Comment by Kelsey Schubert [ 12/Apr/18 ] |
|
Hi Urs, We recommend taking backups as a general good practice, and strongly recommend enabling journalling to ensure writes are not lost in the event of an unclean shutdown and ensure that mongods can quickly make data durable on the primary for requirements like w:majority writes. That said, I'm not aware of any issues with running compact on WiredTiger that would necessitate taking a backup. Kind regards, |
| Comment by Sandeep [X] [ 12/Apr/18 ] |
|
Dear Backlog,Storage-Team, May I request you to please confirm whether backup is really necessary even if Journaling is enabled or not Please? Thanks & Regards |
| Comment by Sandeep [X] [ 05/Apr/18 ] |
|
Dear Team, |