Production

Time Sync

1. CockroachDB requires moderate levels of clock synchronization to preserve data consistency
   1. Deploy CockroachDB On-Premises | CockroachDB Docs

Sizing

1. The size of your cluster corresponds to its total number of vCPUs.
   1. A smaller number of larger nodes emphasizes cluster stability
   2. A larger number of smaller nodes emphasizes resiliency across failure scenarios.

Deploying in a single node

Creating certificate for the node

Creating the certificate and key for the first node:

cockroach cert create-node \
172.16.221.243 \
172.16.221.243 \
keycloak-poc  \
localhost \
127.0.0.1 \
172.16.221.226 \
haproxy-poc  \
--certs-dir=/data/certs \
--ca-key=/data/certs/ca.key

Creating the certificate and key for the Second node:

cockroach cert create-node \
172.16.221.230 \
172.16.221.230 \
keycloak-poc  \
localhost \
127.0.0.1 \
172.16.221.226 \
haproxy-poc  \
--certs-dir=/data/certs \
--ca-key=/data/certs/ca.key

Starting the nodes

1. SSH into node.
2. Start cockroach

cockroach start \
--certs-dir=/data/certs \
--advertise-addr=172.16.221.243 \
--join=172.16.221.230 \
--cache=.25 \
--max-sql-memory=.25 \
--background

cockroach start \
--certs-dir=/data/certs \
--advertise-addr=172.16.221.230 \
--join=172.16.221.243 \
--cache=.25 \
--max-sql-memory=.25 \
--background

Load Balancer (Haproxy) Config

Refer => Load Balancing CockroachDB using Haproxy

Reference

1. Production Checklist | CockroachDB Docs
2. Deploy CockroachDB On-Premises | CockroachDB Docs
   • Generation of CA Certificates
3. Linux Installation
4. Deploy CockroachDB On-Premises | CockroachDB Docs
   • Haproxy configuration
5. How To Deploy CockroachDB on a Three-Node Cluster on Ubuntu 16.04 | DigitalOcean

Logs