[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,
We are using the compact command inorder to reduce the storage space of data and index.
We need your Support to confirm that 'data' folder backup creation is really required or not?

Below are the environment details

  1. mongodb Journals are enabled by default
  2. Mongod server version: db version v3.4.0
  3. OS: Windows 7, architecture: "x86", version: "6.1" , platform: "Java/OracleCorporation/1.8.0_162-b12"

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
Sandeep KS



 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,
Kelsey

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
Sandeep KS

Comment by Sandeep [X] [ 05/Apr/18 ]

Dear Team,
Could you please confirm whether backup is really necessary even if Journaling is enabled or not
Thanks & Regards
Sandeep KS

Generated at Thu Feb 08 04:36:05 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.