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

[Robie Basak]

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
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1490071.
-------------- 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>