All of that needs tooling.
I have a teeny, tiny cluster using MySQL+galera as a multi-master cluster, but it took a while to iterate to monitoring that tells me when one node is unhealthy and getting the correct repair and restart procedures.
FWIW, I built all the functionality into rqlite from the very start, for exactly those reasons. In the real world a database must be operated.
https://github.com/rqlite/rqlite/blob/master/DOC/DIAGNOSTICS...
https://github.com/rqlite/rqlite/blob/master/DOC/CLUSTER_MGM...
I like to use projects which lots of other projects depend on directly. That way if the main project goes unsupported, all the other projects using it will band together to support a fork. I believe open source that is not created for a company will last much longer. (I like that they rewrote it in C, though; it would probably survive well as a fork if enough people/projects use it)