GitLab: With the release of version 12.1, we stop supporting MySQL

Now we will tell why, starting with version 12.1, GitLab will no longer support MySQL.

In July 2017, GitLab warned that it would stop supporting MySQL . So, with the release of 12.1, the period of preparation for this will end, and we will no longer support MySQL . The decision is not easy, and we would like to share our arguments.

MySQL was not very suitable for our use case.

There are many successful implementations of MySQL, but in our case it did not quite fit. Compared to PostgreSQL, MySQL has several limitations , which led to problems with PostgreSQL when trying to adapt MySQL. Here is a small list of restrictions:

• MySQL did not manage to effectively support nested groups
• There are also restrictions on the fields that we go around using various tweaks, and as a result, mysql may simply not save data
• MySQL TEXT, length
• MySQL
• ( Geo), MySQL

"" MySQL, , — . , .

CI, , MySQL . , , , MySQL.

(PostgreSQL MySQL), . - , . ( ): LATERAL JOIN PostgreSQL , , MySQL.

PostgreSQL

Usage Ping, , PostgreSQL. , 1200 MySQL 110000 PostgreSQL.

, , MySQL, , PostgreSQL gitlab 12.1 .

, MySQL, , .

?

, MySQL PostgreSQL , , .