Is O_DIRECT_NO_FSYNC safe on FreeBSD with ZFS for MySQL data?

[CyberCr33p]

I would like to ask whether O_DIRECT_NO_FSYNC is safe for data on a FreeBSD server using ZFS. For the past few years I have been running with O_DIRECT.

 

[atax1a]

per our understanding, O_DIRECT on freebsd doesn't suffer from the problems that it does on linux. Disabling fsync, however, is likely to be unsafe.

 

[CyberCr33p]

I do not mind losing few seconds of data if the server loses power, but I do care about avoiding data corruption.

 

[atax1a]

i think zfs has you covered here, then.

 

[mer]

Aren't there some ZFS "special" vdevs that are designed for synch writes on a zpool? basically synch writes get to a log first then to zpool so that if the transaction does not complete to the zpool it can be replayed from the special? ZIL and SLOG come to mind as acronyms.