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