Why Docker Is Not Suitable for Running MySQL: Data Safety, Performance, and Resource Isolation Issues

When asked about environment setup, the author, a senior architect, recommends Docker for personal learning because it allows quick installation and clean removal of services like MySQL, but cautions that production deployments require careful evaluation of whether a service is suitable for containerization.

Data Safety Issues

Storing MySQL data inside a container is risky because containers can be stopped or removed at any time, leading to data loss; although volumes can persist data, they do not guarantee safety, and crashes may corrupt the database.

Performance Issues

MySQL is I/O‑intensive; running multiple instances in Docker on a single physical host can create I/O bottlenecks that dramatically reduce read/write performance. A bank architect is quoted saying that database performance bottlenecks usually appear at the I/O layer, which Docker’s shared‑storage model can exacerbate.

Suggested mitigation strategies include separating the database program from its data, storing data on shared storage, avoiding host‑volume sharing, using lightweight or distributed databases, and deploying MySQL on physical machines or KVM when high I/O performance is required.

State Issues

Docker’s horizontal scaling is designed for stateless services; databases, which maintain state, do not fit this model. Therefore, when MySQL runs in Docker, external storage must be provided to preserve state.

Resource Isolation

Docker’s cgroup‑based resource limits can restrict maximum usage but cannot fully isolate resources from other processes; heavy workloads on the host can degrade MySQL performance inside containers.

Can MySQL Run in Containers?

MySQL can be containerized in specific scenarios: workloads that are not sensitive to data loss, lightweight or distributed databases that can be automatically restarted, and setups that use middleware for auto‑scaling, disaster recovery, and multi‑node operation. Examples include travel and e‑commerce platforms that have successfully containerized their databases.

Finally, the author invites readers to discuss these viewpoints and offers personal contact for further questions.

--- Promotional Section ---

The remainder of the article promotes an AI community called “AI Club & Side‑Business”, offering free ChatGPT accounts, paid membership plans, exclusive resources, and a series of benefits such as tutorials, manuals, and a one‑year after‑sale service.

It also includes multiple calls‑to‑action for joining the community, purchasing discounted memberships, and scanning QR codes for additional resources.

Additional links to open‑source projects, interview question collections, and other technical content are provided at the end.