quiver

A parallel, consistent logical copier for MySQL and MariaDB: dump, load, copy server to server, across the network, masking personal data as it is read.

Install

curl -fsSL https://raw.githubusercontent.com/jongleb/quiver/main/install.sh | sh
brew install jongleb/tap/quiver

Commands

quiver dump

Dump MySQL or MariaDB into SQL or CSV files

quiver load

Load a quiver dump into MySQL or MariaDB

quiver copy

Copy MySQL or MariaDB into another server, with no

quiver agent

Dump MySQL or MariaDB to a collector over quiver's own

quiver collect

Receive one dump from quiver agent and write it into

quiver relay

Pass one dump from quiver agent on to the next hop

quiver mask

Try an expression of the masking language on values,

Masking

Columns are masked as rows are read, by rules on the command line, in the quiverfile, or in a policy written in a small language of S-expressions: selectors by name and type, kept and strict columns, keyed fake values that still join, dates, word lists. See the masking language.

(strict "shop.users")
(keep "shop.users.id")
(mask "shop.users.phone" (concat "+7 (" (str (keyed-int value 900 999)) ") " (digits value 3) "-" (right value 5)))
(mask (where (table "shop.*") (column "*email*") (type text)) (email value))

This is the documentation of quiver 1.4.0.