Distributed state is a difficult problem, but with a little work we can make our systems significantly more reliable。
Consistency is a property of the data, not of the nodes. Avoid systems which assume node state consensus implies data consistency.
Even well-known algorithms like two-phase commit have some caveats, like false negatives. SQL transactional consistency comes in several levels. If you use the stronger consistency levels, remember that conflict handling is essential.