Christopher Browne cbbrowne
Thu Mar 3 17:24:11 PST 2005
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 :-(.


More information about the Slony1-general mailing list