Please enlighten us with a cluster database that enables guaranteed consistency with dynamic node membership. They all have quirks handling membership (unless you're looking at a shared disk setup).
HBase for example is always consistent, but if you lose a node unexpectedly some data is not available for some time.