allard
64 lines
1.7 KiB
Markdown
64 lines
1.7 KiB
Markdown
#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@';
|