dolt v0.1.0

Databases

Dolt — a SQL database with Git-style version control: branch, diff, merge, and clone your data and schema, with a MySQL-compatible wire protocol so existing clients and drivers just work. Deployed as a host-networked Nomad service (dolt sql-server) with a persistent data volume.

nomad-pack run dolt --registry nomploy

…or one line (add registry + run)

curl -fsSL https://packs.nomploy.com/install.sh | sh -s -- dolt

Needs nomad-pack on PATH. The script only adds the nomploy registry and runs this pack.

Source ↗ Project ↗ ★ 24.5k ⚑ Report an issue

1 task sql 3306 1 volume image dolthub/dolt-sql-server:latest tracks :latest image bumped today

Variables 9

values.hcl

Save as values.hcl, edit, then run:

nomad-pack run dolt -f values.hcl --registry nomploy

# The name of the Nomad job.
job_name = "dolt"

# The Nomad namespace to deploy into.
namespace = "default"

# The datacenters to deploy to.
datacenters = ["*"]

# The Dolt SQL server image. Pin a tag in production.
image = "dolthub/dolt-sql-server:latest"

# Host port for the MySQL-compatible SQL server.
port = 3306

# Password for the root user (DOLT_ROOT_PASSWORD). CHANGE THIS.
root_password = "change-me-please"

# Named volume for Dolt data (/var/lib/dolt): all databases, branches, and history.
data_volume = "dolt_data"

# Placement constraints. Pin to the node holding the volume. On a nomploy cluster: attribute = "$${meta.nomploy_control_plane}", operator = "=", value = "true".
constraints = []

# Resources for the Dolt task.
resources = {
    cpu    = 500
    memory = 512
  }

Name	Type	Default	Description
job_name	string	"dolt"	The name of the Nomad job.
namespace	string	"default"	The Nomad namespace to deploy into.
datacenters	list	["*"]	The datacenters to deploy to.
image	string	"dolthub/dolt-sql-server:latest"	The Dolt SQL server image. Pin a tag in production.
port	number	3306	Host port for the MySQL-compatible SQL server.
root_password set me	string	"change-me-please"	Password for the root user (DOLT_ROOT_PASSWORD). CHANGE THIS.
data_volume	string	"dolt_data"	Named volume for Dolt data (/var/lib/dolt): all databases, branches, and history.
constraints	list	[]	Placement constraints. Pin to the node holding the volume. On a nomploy cluster: attribute = "$${meta.nomploy_control_plane}", operator = "=", value = "true".
resources	object	{ cpu = 500 memory = 512 }	Resources for the Dolt task.

Back up this pack

This pack stores data in one Docker named volume: dolt_data

restic

# Run on the node hosting this pack. Point restic at your repo first:
#   export RESTIC_REPOSITORY="s3:https://<account>.r2.cloudflarestorage.com/<bucket>"
#   export RESTIC_PASSWORD="<repo-password>"
#   export AWS_ACCESS_KEY_ID=<key>  AWS_SECRET_ACCESS_KEY=<secret>
restic backup \
  /var/lib/docker/volumes/dolt_data/_data

rclone (sync to S3/R2)

rclone sync /var/lib/docker/volumes/dolt_data/_data backup:<bucket>/dolt_data

Paths assume the default Docker volume location (/var/lib/docker/volumes). Restore by stopping the job, restoring files into the same volume, and re-running the pack.

Readme

dolt

Dolt — "Git for data." A SQL database with real version control: branch, diff, merge, and clone your data and schema, with full commit history. It speaks the MySQL wire protocol, so existing clients, drivers, and ORMs connect unchanged.

Single host-networked Nomad service running dolt sql-server with a persistent data volume.

Deploy

nomad-pack registry add nomploy https://github.com/Nomploy/nomad-packs
nomad-pack run dolt --registry=nomploy

Configure

Variable	Default	Description
`port`	`3306`	MySQL-compatible SQL port.
`root_password`	`change-me-please`	Root password (`DOLT_ROOT_PASSWORD`). Change it.
`data_volume`	`dolt_data`	`/var/lib/dolt` — all databases, branches, and history.
`image`	`dolthub/dolt-sql-server:latest`	Container image. Pin a tag in production.
`resources`	`{ cpu = 500, memory = 512 }`	Task resources.

Connect with any MySQL client (mysql -h <node-ip> -P 3306 -u root -p), then use Dolt's version-control SQL — CALL DOLT_COMMIT('-am','message'), DOLT_BRANCH(), DOLT_MERGE(), and the dolt_diff_* / dolt_log system tables. Root connects from localhost (same-node clients use 127.0.0.1); to allow remote root, add DOLT_ROOT_HOST to the task. Serves an unencrypted SQL port — keep it on an internal network or front it with TLS. Pin the job to the node holding the volume with constraints.