[debian-mysql] Bug#841345: Bug#841345: mysql-server-5.7: Unable to switch from mariadb to mysql, "downgrade" is aborted

Robie Basak robie.basak at ubuntu.com
Wed Oct 19 18:47:30 UTC 2016

On Wed, Oct 19, 2016 at 01:49:54PM -0300, Felipe Sateler wrote:
> Mariadb and mysql are supposed to be drop-in replacements, so switching
> between them should be supported.

This is incorrect. They aren't drop-in replacements. MariaDB changes the
internal database format in ways that MySQL doesn't understand. There is
no automated way to switch back.

I'll leave this bug open because I think the UX could be better, but
they need pretty extensive refactoring of how MySQL and MariaDB packages
interact. I'd like for it to be possible for the user to end up with the
option of having a blank database when switch back to MySQL with the
MariaDB database retained, for example. However, I don't think it'll
ever be possible to switch back automatically, as this is simply not
supported by the upstreams.

This is also tracked downstream in Ubuntu at
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20161019/19e31a23/attachment.sig>

More information about the pkg-mysql-maint mailing list