Hi All
Can anybody tell me which data store, if any, is the primary?
Alfresco uses both the file system and a database to store repository data and we have had 2 instances of mismatched data due to configuration changes and a data corruption in the last couple of weeks.
Here are the scenarios we are trying to make sure we address:
1. If the database becomes corrupted and we restore a version that is a few days old, can this be re-synced with the file systems alf_data directory so that they can still work together even if that means loosing some data from the alf_data directory?
2. If the alf_data directory becomes corrupted can we re-create this from the current database? i.e. are the current documents also stored in the database along with historical versions?
We always backup both the alf_data directory and the database at the same time, however, there is always a slight time difference between the 2. Our solution is 24/7 and it does not seem possible to avoid the possibility that no data has been modified during the backup process thus a restore will produce a mismatch.
Does anybody have a bullet proof backup & restore policy for these two data stores?
Regards
Steve
