Skip site navigation (1)Skip section navigation (2)
Date:      Sun, 02 Jun 2024 21:44:47 +0000
From:      bugzilla-noreply@freebsd.org
To:        ports-bugs@FreeBSD.org
Subject:   [Bug 277922] Mk/bsd.default-versions.mk: Change default version of MySQL to MariaDB 10.11 (mysql=10.11m)
Message-ID:  <bug-277922-7788-lhOq1wmXP2@https.bugs.freebsd.org/bugzilla/>
In-Reply-To: <bug-277922-7788@https.bugs.freebsd.org/bugzilla/>
References:  <bug-277922-7788@https.bugs.freebsd.org/bugzilla/>

next in thread | previous in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D277922

--- 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 que=
ry
performance and behavior.

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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-277922-7788-lhOq1wmXP2>