dbdeployer

DBdeployer is a tool that deploys MySQL database servers easily. This is a port of MySQL-Sandbox, originally written in Perl, and re-designed from the ground up in Go. See the features comparison for more detail.

Documentation updated for version 1.66.0 (26-Jul-2022 10:30 UTC)

Installation
- Manual installation
- Installation via script
Prerequisites
Initializing the environment
Updating dbdeployer
Main operations
- Overview
- Unpack
- Deploy single
- Deploy multiple
- Deploy replication
- Re-deploy a sandbox
Database users
Database server flavors
Getting remote tarballs
- Looking at the available tarballs
- Getting a tarball
- Customizing the tarball list
- Changing the tarball list permanently
- From remote tarball to ready to use in one step
- Guessing the latest MySQL version
Practical examples
Standard and non-standard basedir names
Using short version numbers
Multiple sandboxes, same version and type
Using the direct path to the expanded tarball
Ports management
Concurrent deployment and deletion
Replication topologies
Skip server start
MySQL Document store, mysqlsh, and defaults.
Installing MySQL shell
Database logs management.
dbdeployer operations logging
Sandbox customization
Sandbox management
Sandbox macro operations
- dbdeployer global exec
- dbdeployer global use
Sandbox deletion
Default sandbox
Using the latest sandbox
Sandbox upgrade
Dedicated admin address
Loading sample data into sandboxes
Running sysbench
Obtaining sandbox metadata
Replication between sandboxes
- a. NDB to NDB
- b. Group replication to group replication
- c. Master/slave to master/slave.
- d. Hybrid replication
- e. Cloning
Using dbdeployer in scripts
Importing databases into sandboxes
Cloning databases
Compiling dbdeployer
Generating additional documentation
Command line completion
Using dbdeployer source for other projects
Exporting dbdeployer structure
Semantic versioning
Do not edit