Hello,

I have two servers with battery backed power supply (USV). So it is unlikely, 
that both will crash at the same time.

Will synchronous replication work with fsync=off? 
That means we will commit to system cache, but not to disk. Data will not 
survive a system crash but the second system should still be consistent.

Or: will it work with 
master: fsync=off 
and 
slave(s): fsync=on? 
In this case master is free for read-queries and slave has time to do all the 
heavy writing. Data on master will not survive a crash but can be restored from 
slave.

Thanks,

Joerg



Reply via email to