If you do try Linux:
- buy hardware that’s supported. For some things (storage) virtually everything works. For others, (video cards, latest-gen wifi) you need to make sure it’s supported out-of-the-box. It’s not worth the headache of trying to get it to work unless you just like geeking out.
- if some piece if software or hardware doesn’t work, it doesn’t work. If you spend more than a half hour (or whatever your limit is) trying to get it to work, just say to yourself ‘not available on Linux right now’ and move on. Linix has way more access to beta and alpha-level stuff, and that can make it tempting to try to fix whatever problem. Just don’t bother.
That said, most of the systems I use Linux on, it just works.
A lot of those issues of ‘multiple primaries’ can be resolved with intelligent data types and actions. That is, if we have a notion of how the data is organized, a lot of decisions can be made a priori. Ones that can’t can be read-only during a split.
Comment groups are mergeable sets. Any unique comment is a valid comment.
For any individual comment, any tombstone causes a comment to be unseeable (and ideally be deleted). Any edits are latest-wins.
A lot can be sorted out that way - enough to be usable. Some databases even support that on a db level.