4 ms·
You exchange network access against filesystem access, but what if your filesystem is a network device?
by tutfbhuf 6y ago
You exchange network access against filesystem access, but what if your filesystem is a network device?
- config_yml 6y agoSQLite recommends not using network storage: > You are advised to avoid using SQLite on a network filesystem in the first place, since performance will be slow https://sqlite.org/atomiccommit.html#_broken_locking_implementations https://sqlite.org/atomiccommit.html#_broken_locking_impleme...
- tutfbhuf 6y agoThat's a serious limitation since many VMs in datacenters have block devices attached over network.
- striking 6y agoI think this is true for any RDBMS, though. If your block device has high latency, you will see bad perf when the DB tries to fsync.
- tutfbhuf 6y agoBut the block device latency is usually a order of magnitude lower (microseconds) than the network latency between the database and its clients (milliseconds), except when all clients are located in the same datacenters.
- stefanfisk 6y ago”Network filesystems” means stuff like NFS. Networked block devices should generellt be fine AFAIK.
- madpata 6y agoYou exchange network+filesystem access against only filesystem acess. The server needs to store your DB somehow too.