Results 1 to 7 of 7

Thread: MariaDB, what do you think ?

  1. #1
    Join Date
    Feb 2012
    Beans
    23

    MariaDB, what do you think ?

    Everything is in the title. Did you try MariaDB ? what do you think of it ?

  2. #2
    Join Date
    Feb 2007
    Location
    Nagoya, Japan
    Beans
    343
    Distro
    Xubuntu 11.10 Oneiric Ocelot

    Re: MariaDB, what do you think ?

    I have been using MariaDB (in production servers as well) for the last year or so... so far so good. It has some extra features that I like but I don't use them all.

    If you use PHP, be aware that you can't update PHP (from the repository) as mariadb's "mysql-common" version is slighly older than the one of MySQL (required by php-mysql module). But soon or later its updated and then you can update PHP (probably not to the last version). For me, it hasn't be a big issue. I just have to be sure to put php-mysql in "hold".

    If you don't need the MariaDB extra features, then I would say there won't be so much difference of using MySQL.

    Cheers.
    Servers: Hardy(x4), Lucid(x6);
    Workstations: Quantal(x2), Lucid(x1);
    WM Flavors: Xubuntu(x3)
    Save Energy

  3. #3
    Join Date
    Feb 2012
    Beans
    Hidden!

    Re: MariaDB, what do you think ?

    MariaDB is fine. The main question is trusting or not Oracle regarding MySQL, technical point of view currently being "the same".

  4. #4
    Join Date
    Feb 2012
    Beans
    23

    Re: MariaDB, what do you think ?

    Quote Originally Posted by LepeKaname View Post
    I have been using MariaDB (in production servers as well) for the last year or so... so far so good. It has some extra features that I like but I don't use them all.

    If you use PHP, be aware that you can't update PHP (from the repository) as mariadb's "mysql-common" version is slighly older than the one of MySQL (required by php-mysql module). But soon or later its updated and then you can update PHP (probably not to the last version). For me, it hasn't be a big issue. I just have to be sure to put php-mysql in "hold".

    If you don't need the MariaDB extra features, then I would say there won't be so much difference of using MySQL.

    Cheers.
    Very interesting what are the extra features ? and are you using it for big databases ?

  5. #5
    Join Date
    Feb 2007
    Location
    Nagoya, Japan
    Beans
    343
    Distro
    Xubuntu 11.10 Oneiric Ocelot

    Re: MariaDB, what do you think ?

    This is the Official list of features: http://kb.askmonty.org/en/mariadb-versus-mysql-features

    In my case, I moved to MariaDB because of these reasons: The "virtual-columns" support, row lock, increased performance and restore/replay from logs.

    I'm not sure what do you mean by "BIG", but one of our largest databases that is running in MariaDB is around 5GB compressed (largest table size is arond 1 million records).... so far, so good.

    The best part is that MariaDB is practically an exact replacement of MySQL, so you don't need to modify your codes or your queries from MySQL -> MariaDB. You can perform some benchmarks with your actual data and see if you gain performance. If for some reason you don't feel like staying with MariaDB, then you can easily go back (unless you are using some MariaDB-only features).
    Servers: Hardy(x4), Lucid(x6);
    Workstations: Quantal(x2), Lucid(x1);
    WM Flavors: Xubuntu(x3)
    Save Energy

  6. #6
    Join Date
    Feb 2012
    Beans
    23

    Re: MariaDB, what do you think ?

    Thank you I'm looking at it.

  7. #7
    Join Date
    Sep 2007
    Location
    UK
    Beans
    19
    Distro
    Lubuntu 13.04 Raring Ringtail

    Re: MariaDB, what do you think ?

    I'm considering replacing MySQL with MariaDB for my PHP-based forums. I probably won't need the absolutely latest PHP version, so if it's a bit behind on that I guess it won't be a problem.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •