Short checkpoint durations
Posted in 2006
Topics: High Availability & Replication, Logging & Checkpoints
One of customers wants to use SAN replication between remote sites for DR purposes. As recently discussed, and explained at length and in detail by Martin Fuerderer, this will have the effect of allowing the DR database to its state at the last checkpoint. Actually the customer wants minimal data use, but doesn't want to use HDR for this. To do this we could set very short checkpoints - say every 60 seconds, or even less. I wondered what experiences others have with checpoint intervals as low as this?
Sorry about the earlier typos, which obscured the meaning: One of customers wants to use SAN replication between remote sites for DR purposes. As recently discussed, and explained at length and in detail by Martin Fuerderer, this will have the effect of allowing the DR database to recover its state at the last checkpoint. Actually the customer wants minimal data loss, but doesn't want to use HDR for this. To do this we could set very short checkpoints - say every 60 seconds, or even less. I wondered what experiences others have with checpoint intervals as low as this?