Dear Monks,

For some time now, my linux distro installs MariaDB instead of MySQL on a version upgrade (fedora38)! Yep! It zaps MySQL and puts MariaDB there. I had managed before to uninstall it and reinstall MySQL. But this time I came to a wall. Two actually.

One, the mariadb connectors package is required by some other package (vtk) even if I have installed and using MySQL. And so it can not be uninstalled without that package breaking. The mariadb connectors supply mysql_config which is used by DBD::mysql to find the current MySQL version which freaks out when it reports 10.8 (MariaDB version!) instead of 8.0 (MySQL version). This obstacle can be overcome with breaking that package. No big deal, just irritation.

Two, after installing MySQL (and erasing MariaDB), MySQL fails to initialise the database directories. Doing it manually makes things even worse with wrong usernames etc.

So, I quit right there and restored MariaDB. My task now is to change DSNs in my Perl codes and hopefully only minor changes in SQL files.

My question is: shall I bang my head more on that wall and finally manage to install MySQL (and repeat this procedure once a year when the distro makes a version upgrade) or go with the flow of MariaDB? Yeah Maria sounds enticing as long as it is not the Black Maria! Although I have no problem with any other Black or White Maria.

I know there are other DBs there but I started with that.

Edit: I forgot to mention that I have already hit another obstacle despite the widely advertised "MariaDB is a drop-in replacement for MySQL", described at MariaDB : read credentials from file fails (via dsn option mariadb_read_default_file).

Edit2: the die has been cast, the rubicon has been crossed with MariaDB.

Edit3: met with some problems : DBD::MariaDB + DBIx::Class = woes

thank you // bw, bliako

In reply to Is it worth migrating from MySQL to MariaDB? by bliako

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.