GitHub - db-branch/db-branch: Instant MySQL database branches on ZFS clones, clustered across VMs with ProxySQL routing
Instant MySQL database branches on ZFS clones, clustered across VMs with ProxySQL routing - db-branch/db-branch
Instant MySQL database branches on ZFS clones, clustered across VMs with ProxySQL routing - db-branch/db-branch
Instant database branches for MySQL and PostgreSQL, on your own servers.
Test a migration, let an AI agent loose, or give every pull request its own copy of the database. db-branch creates a copy-on-write branch of a large database in seconds, with nothing copied. Break it, reset it, throw it away. Built on ZFS clones, self-hosted, Apache-2.0.
Status: Beta. db-branch is usable today, but APIs and command-line details may still change before 1.0. It is an independent open-source project, built from scratch.
On a Mac or Windows machine, about 2 minutes. db-branch needs Linux and ZFS, so run it in an Ubuntu VM with Multipass. One command makes the VM, installs db-branch, initialises it on a file-backed ZFS pool and loads a small sample base, shop (MySQL 8.4):
multipass launch 24.04 --name db-branch-eval --memory 4G --disk 30G --timeout 900 \ --cloud-init https://raw.githubusercontent.com/db-branch/db-branch/main/scripts/eval-cloud-init.yaml multipass exec db-branch-eval -- cloud-init status --wait # wait for the setup (about two minutes) multipass exec db-branch-eval -- cat /etc/motd # console URL and sign-in (admin / admin), or what failed multipass shell db-branch-eval # then: sudo db-branch branch create try --base shop --ttl 1h --record
On Windows (PowerShell or cmd), put the multipass launch command on one line and drop the \:
multipass launch 24.04 --name db-branch-eval --memory 4G --disk 30G --timeout 900 --cloud-init https://raw.githubusercontent.com/db-branch/db-branch/main/scripts/eval-cloud-init.yaml
--record records a branch so it can be restored to any point.admin; the console asks for a new one at the first sign-in.--timeout 900 keeps launch from giving up on a slow connection./etc/motd says so, and sudo tail -n 30 /var/log/cloud-init-output.log in the VM shows why.multipass delete --purge db-branch-eval.--ttl when it is no longer needed.branch upgrade --check-only to see what it would run into, before touching the base.branch reset returns a branch to its creation state; --ttl deletes it automatically.branch checkpoint saves a running branch's state instantly; branch restore puts it back. Restoring replaces the current state, and every checkpoint you already have stays restorable.branch upgrade moves one branch to a newer MySQL or PostgreSQL version while the base and the other branches stay put. A checkpoint is saved first, and a failed upgrade rolls back by itself.Requirements: Ubuntu 24.04 LTS or 26.04 LTS, and a ZFS pool (the zfsutils-linux package is installed as a dependency).
curl -fsSL https://apt.db-branch.com/db-branch.gpg | sudo tee /usr/share/keyrings/db-branch.gpg >/dev/null echo "deb [signed-by=/usr/share/keyrings/db-branch.gpg] https://apt.db-branch.com stable main" | sudo tee /etc/apt/sources.list.d/db-branch.list sudo apt update && sudo apt install db-branch sudo db-branch init --pool <zpool>
The repository signing key fingerprint is 3F404C4E5D49FA653F8385692C6E89E341D4D7A5. db-branch init prints the initial admin password once.
db-branch runtime install postgres@18.6 # a database engine version db-branch base create prod --runtime postgres@18.6 --dump prod.sql.gz # a base: your data, loaded once db-branch branch create feature-x --base prod --ttl 72h # a branch: instant, copy-on-write db-branch branch dsn feature-x # connection URL (includes the password) db-branch branch checkpoint feature-x --name before-migration # save the state (instant) db-branch branch restore feature-x before-migration # go back to the saved state db-branch branch reset feature-x # discard every change db-branch branch delete feature-x # remove it
MySQL works the same way, for example mysql@8.4.13. List installable versions with db-branch runtime available. To try a version upgrade on one MySQL branch:
db-branch branch upgrade feature-x --runtime mysql@8.4.13 --check-only # what would the upgrade run into? db-branch branch upgrade feature-x --runtime mysql@8.4.13 # move this branch only; a checkpoint is saved first
A base is a ZFS dataset holding a loaded database. A branch is a ZFS clone of a base snapshot, so creating one copies nothing, and each branch runs its own database server on its own port. Optionally, ProxySQL routes client connections to the right branch by user name (or by a /*db_branch='name'*/ query comment). Several nodes form a Raft cluster that shares bases, branches, settings and users.
proxysql, greenmask, greenmask-mysql, anon (routing and data masking).There is no hosted or cloud version of db-branch.
git commit -s).Apache-2.0. See LICENSE and NOTICE.
db-branch は、ZFS クローンで MySQL / PostgreSQL のデータベースブランチを発行・リセット・破棄するツールです。現在は Beta で、1.0 までに API が変わる可能性があります。コアは Apache-2.0 で、有償モジュール(認証/SSO・監査・履歴・差分・FSx ストレージ)は別パッケージ(クローズドソース、セルフホスト、ライセンスキー)です。
Mac / Windows では、Multipass のコマンド1つで試せます: https://db-branch.com/ja/docs/getting-started/#multipass-ですぐ試す。日本語のサイトは https://db-branch.com/ja/、設計ドキュメントは docs/ にあります(日本語)。
Texto de github.com tal como lo publicó, leído de su página y mostrado aquí con el formato de El Autómata. El original, en github.com · Volver a la noticia de El Autómata