{"id":2803,"date":"2022-08-29T11:33:29","date_gmt":"2022-08-29T11:33:29","guid":{"rendered":"https:\/\/www.checkmateq.com\/blog\/?p=2803"},"modified":"2023-08-04T16:18:41","modified_gmt":"2023-08-04T16:18:41","slug":"install-cockroach-db-cluster","status":"publish","type":"post","link":"https:\/\/www.checkmateq.com\/blog\/install-cockroach-db-cluster","title":{"rendered":"How to Install Cockroach DB Cluster?"},"content":{"rendered":"

Cockroach DB<\/b> is an elastic SQL\u00a0<\/a> \u00a0database described as\u00a0 “almost impossible” to take down and used for modern applications, It is developed by Cockroach Labs and it’s designed to store copies of data in multiple locations\/stores\u00a0 in order to enable\u00a0 speedy access for the users\u00a0 ,you can easily add or remove a node to Cockroach DB cluster and it’s easy to\u00a0 scale a Cockroach DB cluster from a single node on your laptop to thousands of server nodes, In this blog\u00a0 let’s install Cockroach DB on three nodes and create\u00a0 a\u00a0 cluster.<\/p>\n

Install Cockroach DB on all the Nodes<\/h3>\n
sudo yum install curl tar -y<\/pre>\n
Execute below given command to download the Cockroach DB archive for Linux and its supporting libraries, and then copy the binary into\u00a0 \/usr\/local\/bin\/ so you can execute cockroach commands from any shell.<\/p>\n
sudo curl https:\/\/binaries.cockroachdb.com\/cockroach-v22.1.6.linux-amd64.tgz | tar -xz && sudo cp -i cockroach-v22.1.6.linux-amd64\/cockroach \/usr\/local\/bin\/<\/pre>\n
\"\"<\/p>\n
 <\/p>\n
CockroachDB uses custom-built versions of the\u00a0GEOS<\/strong> libraries, it is an open-source geometry library used by CockroachDB, by default, CockroachDB looks for external libraries in \/usr\/local\/lib\/cockroach<\/strong> , so create a folder named cockroach at\u00a0 \/usr\/local\/lib and copy libgeos.so,\u00a0 libgeos_c.so to it, use below given commands to do this.<\/p>\n
sudo mkdir -p \/usr\/local\/lib\/cockroach\r\nsudo cp -i cockroach-v22.1.6.linux-amd64\/lib\/libgeos.so \/usr\/local\/lib\/cockroach\/\r\nsudo cp -i cockroach-v22.1.6.linux-amd64\/lib\/libgeos_c.so \/usr\/local\/lib\/cockroach\/\r\n<\/pre>\n
Now use below given command on your terminal to check the installation.<\/p>\n
cockroach demo<\/pre>\n
 <\/p>\n
\"\"<\/p>\n
use command\u00a0exit<\/strong> to come out of the shell, once you are done with the installation on all the nodes follow the next steps for creating a cluster.<\/p>\n
Configuring Name Resolution for Cluster Nodes<\/strong><\/h3>\n
Configuring Name resolution is very important while setting up a cluster, because, if a node is unable to resolve the hostname of the other nodes it will give an error while initializing a cluster, I am configuring the local DNS resolver for hostname resolution of the cluster nodes.<\/p>\n
Edit \/etc\/hosts<\/strong> file on all nodes and give your node IP addresses and hostnames as shown in below given snapshot, do it on all the nodes.<\/p>\n
\"\"<\/p>\n
Setup Cockroach DB Cluster<\/h2>\n
Generate Certificates for secure connections\u00a0<\/strong><\/p>\n
Configuration of Cockroach DB cluster in Insecure mode is very simple but it does not perform any encryption of inter-cluster communication, but secure mode uses certificates to enforce encryption of inter-cluster communication and authorization, first create a Certificate Authority-(CA-key), this will be used to digitally sign certificates that you will generate for configuring your Cockroach DB secure cluster<\/p>\n
Create two directories “certs” and “my-safe-directory” on all the nodes<\/b>,use certs to store CA certificate and all node and client certificates and keys, use my-safe-directory to keep your CA key and then reference the key when generating node and client certificates.<\/p>\n
mkdir {certs,my-safe-directory}<\/pre>\n
Configure First Node<\/h3>\n
Now use the following cockroach<\/strong> command to create a certificate authority certificate and a key on the first node<\/strong>.<\/p>\n
cockroach cert create-ca \\ --certs-dir=certs \\ --ca-key=my-safe-directory\/ca.key<\/pre>\n
Generate a certificate for 2nd<\/strong> CockroachDB node<\/strong> using the following command on node one , use your node’s IP address, hostname here<\/p>\n
cockroach cert create-node \\\r\n  172.31.2.22  \\\r\n  ip-172-31-2-22.us-west-2.compute.internal  \\\r\n  127.0.0.1 \\\r\n  localhost \\\r\n  --certs-dir=certs \\\r\n  --ca-key=my-safe-directory\/ca.key\r\n<\/pre>\n
\"\"<\/p>\n
Here\u00a0 172.31.2.22\u00a0 is my 2nd node IP and ip-172-31-2-22.us-west-2.compute.internal is its hostname ,please replace them with your node details, once the certificates are generated, copy the certs folder on to the 2nd node certs folder (CA certificate, node certificate and key) from node cert folder, and after copying use below given command on the first node to remove them and create certificates for first node.<\/p>\n
rm certs\/node.crt certs\/node.key<\/pre>\n
as the certificate and keys are copied to the second node and you have to generate it for the first node, use the same command on the first with 3rd node<\/strong> node IP and hostname and copy them on to node 3 then use\u00a0 “rm certs\/node.crt certs\/node.key” to delete them on node one, and finally use the cockroach create command on node one to generate the certifiacte.<\/p>\n
Now move the certs directory to the cockroach directory (“\/var\/lib\/cockroach”)on each CockroachDB node and change the ownership of Cockroach directory to the user cockroach<\/p>\n
sudo mkdir \/var\/lib\/cockroach\r\nsudo cp -rv certs \/var\/lib\/cpckroach\r\nsudo useradd cockroach\r\nsudo chown -R cockroach.cockroach \/var\/lib\/cockroach\/\r\n<\/pre>\n
Configure Systemd Service for Cockroach DB<\/h3>\n
To enable auto-start of CockroachDB server during Linux startup, you are required to create a systemd service unit, do the following on all the CockroachDB nodes.<\/p>\n
Create a systemd service unit file.<\/p>\n
vi \/etc\/systemd\/system\/cockroachdb.service<\/pre>\n
vi is a editor here<\/p>\n
[Unit]\r\nDescription=Cockroach Database cluster node\r\nRequires=network.target\r\n[Service]\r\nType=notify\r\nWorkingDirectory=\/var\/lib\/cockroach\r\nExecStart=\/usr\/local\/bin\/cockroach start --certs-dir=certs --advertise-addr=ip-172-31-11-237.us-west-2.compute.internal --join=ip-172-31-2-22.us-west-2.compute.internal,ip-172-31-11-229.us-west-2.compute.internal, --cache=.25 --max-sql-memory=.25\r\nTimeoutStopSec=60\r\nRestart=always\r\nRestartSec=10\r\nStandardOutput=syslog\r\nStandardError=syslog\r\nSyslogIdentifier=cockroach\r\nUser=cockroach\r\n[Install]\r\nWantedBy=default.target\r\n<\/pre>\n
Repeat creating the systemd file on each node and you need to replace the –advertise-addr with the hostname of the CockroachDB node on which you are creating this systemd service and then start CockroachDB service using below given command.<\/p>\n
sudo systemctl start cockroachdb<\/pre>\n
Then check the status of the service on each Node.<\/p>\n
sudo systemctl status cockroachdb<\/pre>\n
\"\"<\/p>\n
Before initializing the cluster open the required ports, 26257\/tcp is CockroachDB default service port for SQL interface, execute the below given commands on each node.<\/p>\n
sudo yum install firewalld -y\r\nsudo systemctl enable --now firewalld \r\nsudo firewall-cmd --permanent --add-port={8080,26257}\/tcp\r\nsudo firewall-cmd --reload\r\n<\/pre>\n
\"\"<\/p>\n
Initialize CockroachDB Cluster\u00a0<\/strong><\/p>\n
As all the required configuration is done intialize\u00a0 cockroachDB cluster using below given command.<\/p>\n
cockroach init --certs-dir=certs --host=<address of any node><\/strong>\r\ncockroach init --certs-dir=certs --host=localhost:26257<\/pre>\n
Replace host value with address of any Node, and if the cluster is initialized successfully, you will get a success message as given below.<\/p>\n
\"\"<\/p>\n
 <\/p>\n
Please Contact our technical team for any offshore infrastructure management services website<\/a>, LinkedIn<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Cockroach DB is an elastic SQL\u00a0 \u00a0database described as\u00a0 “almost impossible” to take down and used for modern applications, It is developed by Cockroach Labs and it’s designed to store copies of data in multiple locations\/stores\u00a0 in order to enable\u00a0 speedy access for the users\u00a0 ,you can easily add or remove a node to Cockroach … Continue reading “How to Install Cockroach DB Cluster?”<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":2845,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[79,2,71,70,69,68,59,11,78,63,23,16,24,80,8],"_links":{"self":[{"href":"https:\/\/www.checkmateq.com\/blog\/wp-json\/wp\/v2\/posts\/2803"}],"collection":[{"href":"https:\/\/www.checkmateq.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.checkmateq.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.checkmateq.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.checkmateq.com\/blog\/wp-json\/wp\/v2\/comments?post=2803"}],"version-history":[{"count":21,"href":"https:\/\/www.checkmateq.com\/blog\/wp-json\/wp\/v2\/posts\/2803\/revisions"}],"predecessor-version":[{"id":4174,"href":"https:\/\/www.checkmateq.com\/blog\/wp-json\/wp\/v2\/posts\/2803\/revisions\/4174"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.checkmateq.com\/blog\/wp-json\/wp\/v2\/media\/2845"}],"wp:attachment":[{"href":"https:\/\/www.checkmateq.com\/blog\/wp-json\/wp\/v2\/media?parent=2803"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.checkmateq.com\/blog\/wp-json\/wp\/v2\/categories?post=2803"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.checkmateq.com\/blog\/wp-json\/wp\/v2\/tags?post=2803"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}