Question 1

How to install dbdeployer on Ubuntu?

Accepted Answer

Download the pre-compiled binary from GitHub or use the installation script from the wiki. Since it's a Go binary, just place it in your PATH and run 'dbdeployer init' to set up the environment.

Question 2

dbdeployer vs Docker for MySQL testing?

Accepted Answer

dbdeployer is faster for local, bare-metal MySQL sandboxes with minimal overhead, while Docker offers better isolation and portability across environments. Use dbdeployer for quick iteration; Docker for consistent containerized setups.

Question 3

How to set up replication with dbdeployer?

Accepted Answer

Use the 'deploy replication' command with topology flags like '--topology=master-slave'. dbdeployer automates the configuration, setting up ports, users, and replication channels based on the MySQL version.

Question 4

Can dbdeployer be used with MariaDB?

Accepted Answer

Yes, dbdeployer supports MySQL flavors including MariaDB, as mentioned in the database server flavors wiki. You need to provide the MariaDB tarball, and it will deploy it similarly to MySQL.

Question 5

Is dbdeployer still maintained?

Accepted Answer

The original repository is archived, with development moved to ProxySQL's fork. This means updates may be sporadic, and users should check the ProxySQL repository for newer versions or alternatives.

Question 6

How to deploy multiple MySQL versions with dbdeployer?

Accepted Answer

Use the 'deploy multiple' command with different tarballs or version numbers. dbdeployer manages separate data directories and ports for each instance, allowing concurrent testing across versions.

DBdeployer

What is DBdeployer?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions