CockroachDB is a powerful, open-source distributed SQL database designed for cloud applications. Installing a CockroachDB cluster on Ubuntu 24.04 can enhance your application's scalability and resilience. This guide will walk you through the installation process on your VPS server. For reliable hosting solutions, consider using windowsvps for your next VPS server deployment.
Prerequisites
Before you begin, ensure that you have the following:
- A VPS server running Ubuntu 24.04.
- Root or sudo access to the server.
- At least 2 GB of RAM and 2 CPU cores for each node.
Step 1: Update Your System
Start by updating your package list and installed packages:
sudo apt update && sudo apt upgrade -yStep 2: Install CockroachDB
Download the latest stable version of CockroachDB:
wget https://binaries.cockroachdb.com/cockroach-v22.1.6.linux-amd64.tgzExtract the downloaded archive:
tar -xzvf cockroach-v22.1.6.linux-amd64.tgzMove the Cockroach binary to the appropriate location:
sudo cp cockroach-v22.1.6.linux-amd64/cockroach /usr/local/bin/Make the Cockroach binary executable:
sudo chmod +x /usr/local/bin/cockroachStep 3: Start the CockroachDB Cluster
To start a single-node CockroachDB cluster, run:
cockroach start --insecure --listen-addr=localhost:26257 --http-port=8080 --store=store=path/to/storeMake sure to replace path/to/store with a directory where you want to store the data.
Step 4: Initialize the Database
In a new terminal window, initialize the database by running:
cockroach init --insecure --host=localhost:26257Step 5: Access the CockroachDB Admin UI
You can access the CockroachDB Admin UI by navigating to http://localhost:8080 in your web browser.
Step 6: Joining Additional Nodes (Optional)
If you want to add more nodes to your cluster, run the following command on each additional node:
cockroach start --insecure --join=localhost:26257 --listen-addr=:26257 --http-port=8080 --store=path/to/storeReplace <node_ip> with the actual IP address of the node you are adding.
Step 7: Configure CockroachDB as a Service (Optional)
To run CockroachDB as a service, create a systemd service file:
sudo nano /etc/systemd/system/cockroach.serviceAdd the following configuration:
[Unit]
Description=CockroachDB
After=network.target
[Service]
User=root
ExecStart=/usr/local/bin/cockroach s
