4 ms·
There are two separate problems: - clustering to increase performance - clustering for HA Most people want at least the later one. The former one is a bigger
by takeda 11y ago
There are two separate problems:
- clustering to increase performance
- clustering for HA
Most people want at least the later one. The former one is a bigger challenge in case of relational databases so I'll ignore it here.
Regarding consistency vs availability typically is not all black and white, and people are willing to make tradeoff. For example losing few transactions as opposed to being completely down. This is not too bad as long as developers are aware of that special case and write code that can handle that.
Having said that, I'm wondering how a failover system based on BookKeeper[1] would work (a relational database is effectively a state machine, so seems like this could fit). The tradeoff here would be most likely reduced performance though.
[1] http://bookkeeper.apache.org/ http://bookkeeper.apache.org/