We have two multi-node datacenters currently running mysql, we would like to transition to cockroachdb. Only certain tables within the database are replicated between datacenters, the other tables have independent data. The plan is to have 3 nodes in each datacenter running cockroachdb.
The question is if we lose one of the two datacenters, will the remaining datacenter keep running since we only have 3 out of 6 nodes running, which would not provide a quorum? If not is there some alternate design that can accomplish this?
These are private datacenters and it is not possible to move to a hosted solution.