Beyond apt install: Building Safe MySQL Test Environments

Many database professionals know only one way to install MySQL: using a system package manager. While this approach works for production environments, it limits experimentation and makes it difficult to safely test configuration changes, compare MySQL versions, or reproduce production issues.

Testing directly on production systems is risky. Yet without isolated environments, meaningful learning and troubleshooting practice become difficult.

This hands-on workshop introduces practical, safe, and repeatable methods for running MySQL servers for testing. Participants will learn multiple approaches, from manual initialization to modern sandbox tools, and understand when to use each.

By the end of the session, attendees will be able to confidently create and manage isolated MySQL environments for experimentation, troubleshooting, and learning.

Workshop Structure.

1. Why You Need a Sandbox. We will discuss risks of testing on production, common beginner mistakes, safe experimentation workflows, and how to reproduce production issues responsibly.

2. Starting MySQL Manually. We will learn how to initialize MySQL data directory manually, start mysqld from the command line, create a custom configuration, and understand what happens behind the scenes. This section builds a foundational understanding of how MySQL actually starts and operates.

3. Modern Sandbox Tools: hands-on exploration. We will learn how to create custom MySQL instances, replication, and cluster setups on Docker, DBdeployer (we will use an actively maintained fork of this project), and on Anydbver.

4. Working with Real Data Safely. We will install a test database, learn how to safely copy production data for testing, and scale the production configuration so it fits your laptop.

5. Bonus for advanced users: starting MySQL sandboxes with MTR (MySQL Test Framework). We will discuss what MTR is and why it helps to test effectively. You will learn how to start MySQL from MTR and how to test your production issues with it.

Learning Objectives.

By the end of this workshop, participants will be able to:

• Explain why sandbox environments are essential for safe MySQL experimentation.
• Manually start a MySQL server from the command line.
• Create and manage MySQL sandbox environments using Docker, DBdeployer, and Anydbver.
• Install a replication environment and clusters in just a few seconds.
• Run multiple MySQL versions side-by-side for comparison.
• Safely replicate production configurations and datasets for troubleshooting purposes.
• Confidently experiment without risking production systems.

This tutorial is designed for Junior DBAs, Developers working with MySQL, DevOps engineers, new MySQL support engineers, and anyone who wants to safely test MySQL configurations and versions

Prerequisites.

Participants should:

• Have basic familiarity with MySQL (connecting, running simple queries)
• Be comfortable using the command line in Linux or macOS
• Bring a laptop with: Docker installed (recommended), ability to install local software, at least 8GB RAM recommended for running multiple test instances
• Alternatively, have a mobile device with an installed SSH client.

No prior experience with sandbox tools is required.