[Bug 277922] Mk/bsd.default-versions.mk: Change default version of MySQL to MariaDB 10.11 (mysql=10.11m)
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.