[Bug 277922] Mk/bsd.default-versions.mk: Change default version of MySQL to MariaDB 10.11 (mysql=10.11m)

From: <bugzilla-noreply_at_freebsd.org>
Date: Sun, 02 Jun 2024 21:44:47 UTC
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=277922

--- Comment #29 from Christos Chatzaras <chris@cretaforce.gr> ---
Migrating from MySQL 8.0 to MariaDB 10.11 involves more than simply
uninstalling MySQL and installing MariaDB using the same /var/db/mysql data
directory. There are numerous incompatibilities between the two systems. For
instance, MySQL 8.0 supports collations like utf8mb4_0900_ai_ci, which are not
available in MariaDB. As a result, exporting databases in .sql format and
importing them into MariaDB is impractical on a large scale. Additionally,
there are differences in storage engines, authentication plugins, and
optimizers, as well as query planners, all of which can lead to varying query
performance and behavior.

-- 
You are receiving this mail because:
You are on the CC list for the bug.