MariaDB & distributions update, Dec 2013

A few things to note recently, amongst MariaDB in distributions. 

  1. Ubuntu keeps MySQL 5.5 despite MariaDB’s success. There’s a lot of reasons for this, but remember the key takeaway here is MySQL 5.5 & the fact that MariaDB wasn’t even in Debian yet when the decision was made.
  2. MariaDB is now inside of Debian/sid – check out the packages.
  3. RHEL 7 comes with MariaDB 5.5 as a default; this is a good thing.

Now, from a distribution standpoint, we’re looking at starting to ship 10.0 as well. Distro maintainers don’t want one-way streets (i.e. an upgrade to MariaDB prevents you from going back to MySQL). This is something we have to deal with as more start looking at MySQL 5.6 & MariaDB 10 (think temporal literals as an example).

  • Federico Razzoli

    But i thought that MariaDB 10 supports the temporal syntax… am I missing something?

    MariaDB [test]> SELECT version();
    +——————–+
    | version() |
    +——————–+
    | 10.0.6-MariaDB-log |
    +——————–+
    1 row in set (0.00 sec)

    MariaDB [test]> CREATE TABLE temporal SELECT ’1994-01-01′ AS `str`, DATE ’1994-01-01′ AS `date`;
    Query OK, 1 row affected (0.57 sec)
    Records: 1 Duplicates: 0 Warnings: 0

    MariaDB [test]> DESC temporal;
    +——-+————-+——+—–+————+——-+
    | Field | Type | Null | Key | Default | Extra |
    +——-+————-+——+—–+————+——-+
    | str | varchar(10) | NO | | | |
    | date | date | NO | | 0000-00-00 | |
    +——-+————-+——+—–+————+——-+
    2 rows in set (0.00 sec)

    • http://bytebot.net/blog colincharles

      Its there, its with regards to on-disk compatibility. See:http://lists.alioth.debian.org/…/2013-December/006202.html


i