cockroachdb_docker.md

https://www.cockroachlabs.com/docs/stable/start-a-local-cluster-in-docker-linux.html

create cluster

sudo docker network create -d bridge roachnet
sudo docker run -d --name=roach1 --hostname=roach1 --net=roachnet -p 26257:26257 -p 8080:8080  -v "${PWD}/cockroach-data/roach1:/cockroach/cockroach-data" cockroachdb/cockroach:v19.2.2 start --insecure --join=roach1,roach2,roach3
sudo docker run -d --name=roach2 --hostname=roach2 --net=roachnet -v "${PWD}/cockroach-data/roach2:/cockroach/cockroach-data" cockroachdb/cockroach:v19.2.2 start --insecure --join=roach1,roach2,roach3
sudo docker run -d --name=roach3 --hostname=roach3 --net=roachnet -v "${PWD}/cockroach-data/roach3:/cockroach/cockroach-data" cockroachdb/cockroach:v19.2.2 start --insecure --join=roach1,roach2,roach3

start cluster

sudo docker exec -it roach1 ./cockroach init --insecure
grep 'node starting' cockroach-data/roach1/logs/cockroach.log -A 11

shell

sudo docker exec -it roach1 ./cockroach sql --insecure

admin UI

accessed via http://localhost:8080

stop cluster

sudo docker stop roach1 roach2 roach3

delete cluster

sudo docker rm roach1 roach2 roach3
sudo rm -rf cockroach-data