Thu Mar 3 17:24:11 PST 2005
- Previous message: [Slony1-general] Slony and Fsync
- Next message: [Slony1-general] Executing SQL on connection establishment.
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Josh Berkus wrote: >Here's a hypothetical question: > >Say that we have a master and 2 slaves, and the master has Fsync = False. If >there is a power-out in the data center, and there is data loss/corruption on >the master, is there any way in which that data loss could cascade to the >slaves? > > > Yes, there is. sl_log_1 and sl_seqlog are the main tables that the subscribers consult in order to determine what updates should be applied to them. These could presumably be corrupted by fsync-related failures. You only should see inserts and deletes on sl_log_1/sl_seqlog; the sorts of things that would be expected to "break" would be that you might: a) See entries that had never been committed b) Miss entries that were not properly committed It could steer you wrong :-(.
- Previous message: [Slony1-general] Slony and Fsync
- Next message: [Slony1-general] Executing SQL on connection establishment.
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list