Why MySQL Remains Popular: Simplicity, Open Source, Replication, Engine Flexibility, and Community Support

Zhou Yanwei, the Database Director at Qunar.com and chair of the China MySQL User Group (ACMUG), leads and organizes MySQL community activities in China.

At Qunar, he is responsible for the management and maintenance of the database platform, covering MySQL, Redis, and HBase, including architecture design, performance tuning, daily operations, and automated operation platform design. He has led the creation of the Qunar MySQL Development Specification, MySQL backup platform, Redis high‑availability architecture, PXC high‑availability architecture, database client middleware, QMHA architecture, Inception design and platform implementation, and has helped open‑source the Inception audit service.

Since the late 1990s, the Internet boom has provided a vast space for MySQL’s growth, especially with the rise of interactive social platforms, e‑commerce, and fintech, which demand high concurrency, high performance, high availability, lightweight resources, easy maintenance, and scalability.

MySQL’s popularity can be attributed to several factors: it is simple—anyone with a basic IT background can install, run, and use MySQL by following the documentation, and it supports most of ANSI SQL‑92; it is open source—its code is publicly available for security audits and free use, enabling massive deployments without commercial licensing costs.

Replication support has existed since version 3.23.15, allowing master‑slave architectures that synchronize data in near real‑time, facilitating online backups, read/write separation, and load balancing across many slaves (e.g., deployments with up to 12 slaves).

MySQL’s plugin storage‑engine architecture distinguishes it from many other databases, offering a variety of engines such as MyISAM, InnoDB, NDB, TokuDB, etc. InnoDB, the most widely used engine, benefits from this modular design, keeping MySQL vibrant and competitive.

Early support from MySQL’s founder Monty (Michael Widenius), who wrote thousands of emails to help users, set a precedent for community assistance; the author also maintains the open‑source InceptionSQL audit project, addressing numerous user questions.

MySQL’s early collaboration with other communities—such as PHP and Perl—helped popularize the LAMP stack (Linux, Apache, MySQL, PHP), leading to widespread pre‑installation on Linux distributions.

The community’s contribution is vital: professional teams like Percona, Google, and Facebook continuously add features and tools; domestically, ACMUG gathers top MySQL talent and receives support from companies like Tencent and Alibaba, as well as recognition from Oracle, the MariaDB Foundation, and Monty himself.