maria-developers team mailing list archive
Mailing list archive
Re: Any plans about starting to use /var/lib/mariadb for data instead of /var/lib/mysql?
I dont think that the option to have one datadir per major version (eg:
/var/lib/mysql-5.6) is a good idea, it will add confusion and might
break scripts or symlinks on major version upgrade for example while
only one major version should exist at once on the system (at least if
the current way of handling mysql versions is done on Debian).
As for the switching to a different datadir, it would also imply to use
a different config directory as well such as /etc/mariadb as the datadir
is actually set on /etc/mysql/my.cnf.
The whole debate depends on the possibility to install mariadb and mysql
on the same system, if its not the path chosen, i would prefer to keep
the /var/lib/mysql datadir as the default datadir and add checks on
mysql/mariadb-server packages purge not to remove the datadir if any of
the fork packages is still installed and throw a warning message about
the possible incompatibility and upgrade methods on "migration".
Creating a script to simplify the migration for non-drop-in forks (eg:
maria10 and mysql5.6) would also be a possibility, it would check if any
of the tables on the server has a table engine that is not present on
the other (eg: aria on mysql) or specific row/columns formats and would
dump all tables and grants and import it on the new installation.
On 07/24/2014 02:04 PM, Otto Kekäläinen wrote:
Does the MariaDB project have any plans about switching the data dir
to /var/lib/mariadb in some release?
In Debian there has been discussion about separating the
binary-incompatible MySQL forks into separate /var/lib/<fork> to ease
maintenance and secure data so that purging some packages will not
accidentally delete data that another package uses.
The thread is named "Discussion on handling 5.6 related matters" and
available at http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/2014-July/thread.html
I'd appreciate any guidelines here on what the upstream plans are.
The Debian MySQL/MariaDB packaging team willl have an IRC meeting
tomorrow at 16:00 UTC and I need to express my opinion on the mattes
and what kind of changes I'm willing to do to the MariaDB package.
Obviously I'd like to follow upstream as much as possible to keep the
delta between Debian and upstream small and thus the maintenance