kubernetes/prod/cockroachdb/README.md

#Installation:

#apply the CRD's:

kubectl apply -f https://raw.githubusercontent.com/cockroachdb/cockroach-operator/v2.18.3/install/crds.yaml

#Install the operator

kubectl apply -f https://raw.githubusercontent.com/cockroachdb/cockroach-operator/v2.18.3/install/operator.yaml

#Create cluster

download example.yaml:

curl -O https://raw.githubusercontent.com/cockroachdb/cockroach-operator/v2.18.3/examples/example.yaml

kubectl create ns cockroachdb kubectl apply -f example.yaml

#install sql cli kubectl create -f https://raw.githubusercontent.com/cockroachdb/cockroach-operator/v2.18.3/examples/client-secure-operator.yaml -n cockroachdb

#exec into it: kubectl exec -it cockroachdb-client-secure -- ./cockroach sql --certs-dir=/cockroach/cockroach-certs --host=cockroachdb-public

#inloggen microk8s kubectl exec -it cockroachdb-0 -n cockroachdb -- ./cockroach sql --certs-dir=/cockroach/cockroach-certs

#commando's:

CREATE DATABASE bank; CREATE TABLE bank.accounts (id INT PRIMARY KEY, balance DECIMAL); INSERT INTO bank.accounts VALUES (1, 1000.50); SELECT * FROM bank.accounts;

SET CLUSTER SETTING enterprise.license = 'crl-0-EN26oN0GGAMyEB8H/7NbpEi6tQ2heG8b6M46EKsS8LVEgUoiitX8BqLmVYY'; ALTER USER roach WITH PASSWORD 'yournewpassword'; CREATE USER roach WITH PASSWORD 'yournewpassword'; GRANT admin TO roach;

#install cockroachdb:

kubectl apply -f cockroachdb.yaml

#Initialiseren cluster:

kubectl exec -it cockroachdb-0
-- /cockroach/cockroach init
--certs-dir=/cockroach/cockroach-certs

#Inloggen client:

kubectl exec -it cockroachdb-client-secure
-- ./cockroach sql
--certs-dir=/cockroach-certs
--host=cockroachdb-public

#Gebruiker aanmaken:

CREATE USER roach WITH PASSWORD 'Cockroach01@';