Skip to content

README.md

Latest commit

 

History

History
40 lines (33 loc) · 1.31 KB

README.md

File metadata and controls

40 lines (33 loc) · 1.31 KB

Basic CockroachDB Cluster with HAProxy

Simple 3 node CockroachDB cluster with HAProxy acting as load balancer

Services

  • crdb-0 - CockroachDB node
  • crdb-1 - CockroachDB node
  • crdb-2 - CockroachDB node
  • workload-client - CockroachDB node serving as the workload client
  • lb - HAProxy acting as load balancer

Getting started

  1. run ./up.sh
  2. visit the CockroachDB UI @ http://localhost:8080
  3. visit the HAProxy UI @ http://localhost:8081
  4. have fun!

Helpful Commands

Run the TPC-C Workload

While .up.sh will automatically initialize and run the tpcc workload, you can use the following command to restart the tpcc sample workload for 10 minutes. For more details see this.

docker compose exec workload-client /cockroach/cockroach workload run tpcc --tolerate-errors --warehouses=3 --duration=10m "postgresql://root@lb:26257?sslmode=disable"

Open Interactive Shells

docker compose exec crdb-0 /bin/bash
docker compose exec crdb-1 /bin/bash
docker compose exec crdb-2 /bin/bash
docker compose exec workload-client /bin/bash
docker compose exec lb /bin/sh

Stop Individual nodes

docker compose stop crdb-0
docker compose stop crdb-1
docker compose stop crdb-2