CockroachDB

Download, Install and Running

Create folder /apps/crdb

Download cockroach bundle from https://binaries.cockroachdb.com/cockroach-v22.1.13.linux-amd64.tgz

cd /apps
wget https://binaries.cockroachdb.com/cockroach-v22.1.13.linux-amd64.tgz

mkdir -p /apps/crdb
mkdir -p /apps/amf/logs

tar -xvf /apps/cockroach-v22.1.13.linux-amd64.tgz -C /apps/crdb --strip-components=1 

We can start cockroach database with single node as follows

nohup /apps/crdb/cockroach start-single-node  --insecure --store=data --http-addr=localhost:59091 --background >>/apps/amf/logs/startcrdb.log 2>&1 &

Create Database and import DB Schema

• Connect to Cockroachdb

  • cd /apps/crdb

  • ./cockroach sql --insecure

  • create database amf;

  • \q

• Download and extract dependencies bundle

• ./cockroach sql --database=amf --insecure < /apps/schema.sql