Using dbdeployer to Quickly Set Up MySQL Test Environments

dbdeployer is a powerful tool for deploying MySQL test environments with one‑click support for various architectures and versions, including master‑slave replication, GTID, and group replication.

The article explains how to install dbdeployer on macOS (Linux steps are similar), download the latest release, extract the binary, make it executable, and verify the installation.

Configuration is performed by editing the default config file ( $HOME/.dbdeployer/config.json ) or exporting defaults, for example updating the sandbox-binary path to a custom directory.

Basic usage covers downloading MySQL tarballs via dbdeployer downloads list or manually, unpacking them, and deploying single nodes, replication topologies, or group replication with commands such as dbdeployer deploy single 8.0.17 --gtid --my-cnf-options="character_set_server=utf8mb4" and dbdeployer deploy replication 8.0.17 --repl-crash-safe --gtid .

After deployment, the sandbox directory ( $HOME/sandboxes ) contains scripts for starting, stopping, restarting, and accessing all instances, as well as configuration files and log directories.

The guide also lists common management commands, such as dbdeployer admin capabilities , dbdeployer sandboxes --full-info , dbdeployer global status , and how to lock or delete sandbox groups.

Additional resources and official documentation links are provided at the end.