MySQL -> MariaDB

Discussion in 'Feature Requests' started by trojan, May 11, 2013.

  1. trojan

    trojan New Member

    Would it be possible to change (dump) mysql in favor of mariadb in future versions and tutorials?
     
  2. MaddinXx

    MaddinXx Member HowtoForge Supporter

    I don't think the tutorials will suggest Maria/Percona over MySQL - but you can easily switch yourself...

    Personally I use Percona and hadn't have problems
     
  3. dclardy

    dclardy New Member

    I use mariadb, and it was a pretty seamless switch. If you are using Debian and DotDeb repos, you just have to play around with package pinning some.
     
  4. iszabi

    iszabi New Member

    Hi,

    I repleaced mySQL to MariaDB on my vps on last month by this
    Article: http://www.sagetree.com/sage-advice/christoph-weber/replace-mysql-mariadb-ubuntu-1204-lts

    -------
    Apache/2.2.22 (Ubuntu)
    Database client version: libmysql - 10.0.2-MariaDB
    PHP extension: mysqli
    ----------------

    I found erros in ispConfig 3.0.5.2 cron
    "PHP Warning: mysqli::mysqli(): Headers and client library minor version mismatch. Headers:50529 Library:100002 in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 62"


    Used API and headers in PHP
    ----------------------
    php -i |grep API
    Server API => Command Line Interface
    PHP API => 20090626
    Zend Extension Build => API220090626,NTS
    PHP Extension Build => API20090626,NTS
    DOM/XML API Version => 20031129
    MHASH API Version => Emulated Support
    Client API version => 10.0.2-MariaDB
    Client API library version => 10.0.2-MariaDB
    Client API header version => 5.5.29
    Client API version => 10.0.2-MariaDB
    Phar API version => 1.1.1
    ---------------------

    ispConfig and DB are working well, but /var/log/ispconfig/cron.log file is growing... How can I resolve it.

    Thanks.
     
    Last edited: Jun 4, 2013
  5. madmucho

    madmucho ISPConfig Developer ISPConfig Developer

    It is over timet when we all switch

    I im for support mariadb too, hope that will be over time that ispconfig will swich, why ? because of oracle. Please add this as future request to projet.
    Will be nice to have line in your bugtracer
     
  6. trompeteandos

    trompeteandos New Member

    I've the same error. Fresh install with Debian + nginx + php facts + mariadb. any one know how to solved it?
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    This thread is quote outdated as mariadb is supported for a long time already. There are no problems with mariadb, all current setups (e.g. the latest ones for ubuntu, opensuse and centos) use all mariadb. Just ensure that you use the mariadb settings in my.cnf as described in the tutorials.
     
  8. trompeteandos

    trompeteandos New Member

  9. till

    till Super Moderator Staff Member ISPConfig Developer

    The tutorial that you followed install mysql and not mariadb, if you replace a package, then ypu will get errors off course. Mariadb is not 100% mysql compatible, thats why it requires some config settings in my.cnf file. St the line:

    sql_mode=NO_ENGINE_SUBSTITUTION

    in mysqld section of my.cnf file and restart mariadb.

    Btw. the errr in your other post is not related to ispconfig at all, it just occurs because the php that you installed is not 100% compatible with the mysql replacement that you installed.
     
  10. trompeteandos

    trompeteandos New Member

    till, i've installed php5-mysqlnd as you say me in other post and the error is gone. Do you recommend to do the change in my.cnf or if error is not present...it's better not change my.cnf?

    Thank you!
     
  11. till

    till Super Moderator Staff Member ISPConfig Developer

    You have to change my.cnf or some functions will not work properly.
     
  12. trompeteandos

    trompeteandos New Member

    Thanks Till. All OK.
     

Share This Page