Re:Dqlite – High-Availability SQLite
by maurodelazeri on Friday August 30, 2019 @10:17AM
(#20838810)
how is the performance running 3 nodes? how many inserts/reads can be done in average ?
[ Parent
| on HN ]
Re:Dqlite – High-Availability SQLite
by free-ekanayaka on Friday August 30, 2019 @11:13AM
(#20839383)
Depends on how fast is your disk, what file system and kernel you use, and how low is your network latency. Difficult to predict. But it's basically as fast as it can get given 1) hardware constraints 2) raft consensus.
If you want light-speed insert/delete, you could probably don't use the disk at all: as long as a majority of your nodes don't die, you won't lose any data. You can also go somewhere in between and save to disk only at specific intervals.
Do all nodes participate as full RAFT nodes? Or can you have read-only nodes?
Aren't non-leader RAFT nodes already read-only?
I guess I meant observer nodes, with read-only DB access.
I just mean that RAFT nodes are already read-only for most of their lives — it’s not clear to me why you’d want nodes to be dedicated as read-only; it would only reduce consistency guarantees (and I believe you wouldn’t be avoiding the heartbeat and data consistency network chatter).. I think the leadership functionality comes cheap