Hi All -
I’m testing out cockroach DB to use for our production datastore for some of our applications. These applications are really not in the line of queries and is used for offline processing, so we would really prefer consistency and resiliency over performance. There might be tweaking needed with my setup but it’s essentially this:
Replication Factor of 3 (default)
Replication Factory of 3 (default)
When I start up US-West cluster and bootstrap, etc everything works perfectly. I Even ran a similar haproxy and ycsb load test similar to Auto Cloud Migration documentation. When I start up US-East, I see everything work according to the documentation and the replica’s per node even out across the two DC’s. Even the performance numbers seemed acceptable to me as well.
However, my problem was this: when I shutoff US-East (to sort of simulate a network and/or DC failure), the US-East cluster became unresponsive. The CockroachDB UI also became pretty unresponsive, and I wasn’t able to access any of the data that should have been in US-West.
Is there something wrong with my setup? Thanks for taking a look at this inquiry - I’m hoping its just something simple I’ve overlooked and appreciate someone with more experience just giving my setup a once over.