Why Docker May Not Be Suitable for Running MySQL: N Reasons Explained

When asked whether to set up a learning environment locally or online, the author recommends using Docker for quick, clean installations such as MySQL, but warns that this advice only applies to personal learning, not production deployments.

Data Security Issues

Storing data inside a container is risky because containers can be stopped or removed, causing data loss; using Docker volumes helps but does not guarantee durability, and sudden crashes may corrupt the database.

Performance Issues

MySQL is I/O‑intensive; running multiple instances on a single host can create I/O bottlenecks that degrade read/write performance, as highlighted by a bank architect who noted that Docker’s shared storage can exacerbate these limits.

Possible mitigations include separating the database program from its data, using shared storage for data, and deploying lightweight or distributed databases that can be automatically restarted.

State Issues

Docker’s horizontal scaling is designed for stateless services, making it unsuitable for stateful databases; persistent storage must be provided separately, and many cloud providers run their flagship databases on bare metal rather than Docker.

Resource Isolation

Docker relies on cgroups for resource limits, which can only cap usage but not fully isolate resources; heavy workloads on the host can still affect MySQL performance inside containers.

Can MySQL Run in Containers?

MySQL can be containerized in certain scenarios: non‑critical workloads that tolerate data loss, lightweight or distributed databases that benefit from automatic restarts, and setups using middleware for auto‑scaling and disaster recovery. Notable examples include containerized deployments at Tongcheng Travel, JD.com, and Alibaba.

Overall, while Docker offers convenience for development and some production use‑cases, careful consideration of data safety, I/O performance, state management, and resource isolation is essential before containerizing MySQL.