Self-host CockroachDB on a VPS
A distributed SQL database that speaks the Postgres wire protocol, run as one insecure node for development and small workloads. The SQL port is private, the admin console is the web page. Source available license.
levelrail-cli templates deploy cockroachdb --name my-cockroachdbSpecification
- Status
- Listed
- Category
- Database Tools
- Services
- cockroachdb
- Ports
- 8080, 26257
- Volumes
- 1
- Memory
- about 1 GiB
- arm64
- unknown
- amd64
- unknown
- Settings to fill in
- none
- Listing
- Community template
About CockroachDB
A distributed SQL database that speaks the Postgres wire protocol, run as one insecure node for development and small workloads. The SQL port is private, the admin console is the web page. Source available license.
What it deploys
CockroachDB runs as one service in a single Compose app, listening on ports 8080, 26257, with 1 named volume mount.
| Service | Image | Tag | Ports | Volumes |
|---|---|---|---|---|
| cockroachdb | cockroachdb/cockroach | v24.3.1 | 8080, 26257 | cockroach_data -> /cockroach/cockroach-data |
Before you install
- CPU architecture. arm64 unknown. The scan could not read a manifest or the tag is chosen at install time. This is not a claim either way.
- Listed. It is in the catalog. Back up the data volume before changing an image tag.
Settings and environment
The catalog lists no environment variables for this template.
First run
- Open the admin console, and connect clients from this project to cockroachdb:26257 as root with no password.
Install CockroachDB on a VPS
-
Install Levelrail on a fresh VPS
Run this as root on a Linux server (amd64 or arm64) with ports 80 and 443 reachable. The installer prints a setup link.
curl -fsSL https://levelrail.com/install.sh | sudo sh -
Sign in
Open the setup link, choose a password, then log the CLI in. The CLI install command is
curl -fsSL https://levelrail.com/install-cli.sh | shif the machine does not have it. See Getting started.levelrail-cli login --device -
Read the template
Shows the entry, including its full compose.yaml.
levelrail-cli templates get cockroachdb -
Deploy it
This deploys the template compose file as an app. The app name defaults to the template id; --name sets another.
levelrail-cli templates deploy cockroachdb --name my-cockroachdb
Without a domain the app gets an sslip.io address. You can also deploy it from the dashboard: Apps, New app, Browse templates, then CockroachDB.
Docs and upstream
More in Database Tools
- CloudBeaverA web-based database manager for browsing and querying Postgres, MySQL, SQLite and more.
- ClickHouseA columnar database built for fast analytical queries over large datasets.
- ChromaA developer-friendly embedding database for AI applications, served over a simple HTTP API. Open to anyone who can reach it, so reach it from other services in this project at chroma:8000, or attach a domain only behind Basic Auth. Not published on the host.
- CouchDBA document database with an HTTP API, built-in replication and the Fauxton admin console.
- DbGateA web database client for SQL and NoSQL databases with a generated login and a data volume. Sign in as admin with the generated password, then add connections to other services here.
- BytebaseA database schema change and migration tool with review workflows built in.