How Often Should you Archive Journal Files?
Use the following statements and questions to help determine how often to archive journal files:
- How much data can you afford to lose if the IB server is destroyed?
- What is the journal rollover frequency? There is no reason to archive journal files more often that the journal rollover interval.
- Frequent journal rollover + frequent journal archiving means minimum data loss. However, too frequent journal rollover + too frequent journal archiving means poor performance. What is the best balance for your system?