Install CockroachDB on Linux

On this page Carat arrow pointing down
Tip:

To deploy a free CockroachDB Cloud cluster instead of running CockroachDB yourself, see the Quickstart.

See Release Notes for what's new in the latest release, v23.2.9. To upgrade to this release from an older version, see Cluster Upgrade.

Use one of the options below to install CockroachDB.

To install a FIPS-compliant CockroachDB binary, refer to Install a FIPS-compliant build of CockroachDB.

CockroachDB on ARM is Generally Available in v23.2.0 and above. For limitations specific to ARM, refer to Limitations.

Download the binary

The CockroachDB binary for Linux requires glibc, libncurses, and tzdata, which are found by default on nearly all Linux distributions, with Alpine as the notable exception.

  1. Visit Releases to download the CockroachDB archive for the architecture of your Linux host. The archive contains the cockroach binary and the supporting libraries that are used to provide spatial features. Extract the archive and optionally copy the cockroach binary into your PATH so you can execute cockroach commands from any shell. If you get a permission error, use sudo.

  2. Note:

    If you plan to use CockroachDB's spatial features, you must complete the following steps. Otherwise, your installation is now complete.

  3. CockroachDB uses custom-built versions of the GEOS libraries. Copy these libraries to one of the locations where CockroachDB expects to find them.

    By default, CockroachDB looks for external libraries in /usr/local/lib/cockroach or a lib subdirectory of the CockroachDB binary's current directory. If you place these libraries in another location, you must pass the location in the --spatial-libs flag to cockroach start. The instructions below assume the /usr/local/lib/cockroach location.

    1. Create the directory where the external libraries will be stored:

      icon/buttons/copy
      mkdir -p /usr/local/lib/cockroach
    2. Copy the library files to the directory. In the following commands, replace {ARCHITECTURE} with linux-amd64 for Intel, or with linux-arm64 for ARM.

      icon/buttons/copy
      cp -i cockroach-v23.2.9.linux-{ARCHITECTURE}/lib/libgeos.so /usr/local/lib/cockroach/
      icon/buttons/copy
      cp -i cockroach-v23.2.9.linux-{ARCHITECTURE}/lib/libgeos_c.so /usr/local/lib/cockroach/

      If you get a permissions error, prefix the command with sudo.

  4. Verify that CockroachDB can execute spatial queries.

    1. Make sure the cockroach binary you just installed is the one that runs when you type cockroach in your shell:

      icon/buttons/copy
      which cockroach
      /usr/local/bin/cockroach
    2. Start a temporary, in-memory cluster using cockroach demo:

      icon/buttons/copy
      cockroach demo
    3. In the demo cluster's interactive SQL shell, run the following command to test that the spatial libraries have loaded properly:

      icon/buttons/copy
      > SELECT ST_IsValid(ST_MakePoint(1,2));

      You should see the following output:

        st_isvalid
      --------------
      true
      (1 row)

      If your cockroach binary is not properly accessing the dynamically linked C libraries in /usr/local/lib/cockroach, it will output an error message like the one below.

      ERROR: st_isvalid(): geos: error during GEOS init: geos: cannot load GEOS from dir "/usr/local/lib/cockroach": failed to execute dlopen
                Failed running "sql"
  5. Keep up-to-date with CockroachDB releases and best practices:

Use Kubernetes

To orchestrate CockroachDB using Kubernetes, either with configuration files or the Helm package manager, use the following tutorials:

Use Docker

Warning:
Running a stateful application like CockroachDB in Docker is more complex and error-prone than most uses of Docker. Unless you are very experienced with Docker, we recommend starting with a different installation and deployment method.

For CockroachDB v22.2.beta-5 and above, Docker images are multi-platform images that contain binaries for both Intel and ARM. Multi-platform images do not take up additional space on your Docker host.

Docker images for previous releases contain Intel binaries only. Intel binaries can run on ARM systems, but with a significant reduction in performance.

CockroachDB on ARM is in Limited Access in v22.2.13, and is experimental in all other versions. Experimental images are not qualified for production use and not eligible for support or uptime SLA commitments.

  1. Install Docker for Linux. Please carefully check that you meet all prerequisites.

  2. Confirm that the Docker daemon is running in the background:

    icon/buttons/copy
    $ docker version

    If you do not see the server listed, start the Docker daemon.

    Note:
    On Linux, Docker needs sudo privileges.
  3. Pull the image for the v23.2.9 release of CockroachDB from Docker Hub:

    icon/buttons/copy
    $ sudo docker pull cockroachdb/cockroach:v23.2.9
  4. Keep up-to-date with CockroachDB releases and best practices:

Build from Source

See the public wiki for guidance. When building on the ARM architecture, refer to Limitations.

Limitations

CockroachDB runtimes built for the ARM architecture have the following limitations:

Validate workloads that rely on floating point operations or FMA instrincs before migrating those workloads to ARM in production.

When building from source on ARM, it is not currently possible to disable FMA intrinsics in Go. To track the status of this feature request, refer to GoLang issue #36971.

  • In production, Cockroach Labs recommends that all cluster nodes have identical CockroachDB versions, CPU architecture, hardware, and software.
  • A mix of Intel and ARM nodes is supported as a temporary transitional state during the migration only. Cockroach Labs recommends that you test and validate your workload ahead of the migration to ensure that the workload and your application work as expected in a cluster with both Intel and ARM nodes, especially with respect to floating-point arithmetic.

What's next?

Note:
By default, each node of a CockroachDB cluster periodically shares anonymous usage details with Cockroach Labs. For an explanation of the details that get shared and how to opt-out of reporting, see Diagnostics Reporting.

Yes No
On this page

Yes No