How Often Should you Archive Journal Files?

From InterBase
Jump to: navigation, search

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?