Hello,
Yes, MariaDB is supposed to be MySQL compatible, but it is not really.
The first time that I installed MariaDB over MySQL (with lots of
problems -- best to remove MySQL and the DB first), I ran the Bacula
regression tests and MariaDB failed with a false detection of a lock
deadlock, which I reported. It took awhile, but the project did fix the
problem so it *might* now run Bacula with no problems. That is to be seen.
The docker idea is very good.
Best regards,
Kern
On 12/27/18 8:32 AM, Adam Nielsen wrote:
I once tried MariaDB and found that it cannot be installed on the same
machine with MySQL unless you do a lot of tweaking at a very low level.
Currently I have both Postgres and MySQL installed on the same machines,
so supporting an additional DB is painful.
MariaDB is a fork of MySQL, maintained by the original MySQL
developers. Oracle continues to maintain MySQL, but MariaDB is the
"spiritual" successor of MySQL. "MySQL" was named after the creator's
first daughter, "My", and so since Oracle now owns this name the fork
has been named after his second daughter instead, "Maria".
The reason it is so hard to install MariaDB alongside MySQL is the same
as why it would be difficult to install Bacula 9.4 and 9.2 at the same
time - they are both different versions of the same project.
I expect that if MariaDB replaces all the MySQLs, eventually if no
community patches come for MariaDB I will be forced to add support for
it myself ...
MariaDB has already replaced MySQL in most Linux distributions, at
least those aimed at the desktop. There have been very few
compatibility problems. I am currently running Bacula with MariaDB on
the Arch Linux distribution and haven't encountered any issues so far,
but then my backups are only home-user sized. As long as Bacula sticks
to the common feature set and doesn't use any of the new
Oracle-MySQL-specific features then it will probably continue to work
just fine with both MySQL and MariaDB for some time yet, with no special
maintenance effort.
If you did want to test against MySQL and MariaDB separately, this is
something you could easily do with Docker containers, as you can
install whichever versions of whichever packages you like inside the
containers, without affecting anything on your host machine.
Cheers,
Adam.
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
