Switch to MariaDB

  • Since Oracle more or less given up MySQL i think a switch to MariaDB (which is maintained by Monty, creator of MySQL) is the correct way to go.


    I just wan't to create an open discussion about this and see what the devs think.
    MariaDB is fully compatible with MySQL so the switch shouldn't be so hard.



    OT:
    Wikipedia is throwing out MySQL for MariaDB and the performance they measured is 8% faster ;)


    http://translate.google.com/tr…a-kastar-ut-mysql&act=url

  • Fanating of OpenSource is not so good as for standartisation components? Where did you see a CMS under MariaDB?
    PostgreSQL - maybe, but not exotic databases.

    Edited once, last by DragonZX ().

  • I-mscp is based mainly on debian and ubuntu, when the moment comes to make the switch both distributions will do the changes, and there are no plans to go faster in mariadb adoption than the distributions.


    If you are willing to use this, you can use mariadb repositories and replace you copy of mysql for mariadb ->
    https://downloads.mariadb.org/mariadb/repositories/

  • Hello ;


    I can add it as alternative if you want. It's easy.

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

  • That would be great.


    Now Fedora throws out MySQL for the benefit of MariaDB


    Source: http://www.phoronix.com/scan.php?page=news_item&px=MTI4MDY


    Hello ;


    Don't' worry ;) Support for maria DB will be part of next release. I've added support for external repositories.


    [code=php]
    <packages>
    <httpd>
    <alternative>
    <apache_fcgi>
    <package>apache2</package>
    <package>apache2-mpm-worker</package>
    <package>apache2-suexec</package>
    <package>libapache2-mod-fcgid</package>
    <package>libapache2-mod-fastcgi</package>
    </apache_fcgi>
    <apache_itk>
    <package>apache2</package>
    <package>apache2-mpm-itk</package>
    <package>libapache2-mod-php5</package>
    </apache_itk>
    <apache_php_fpm
    repository="http://php53.dotdeb.org squeeze all"
    repository_key_uri="http://www.dotdeb.org/dotdeb.gpg"
    >
    <package>apache2</package>
    <package>apache2-mpm-worker</package>
    <package>libapache2-mod-fastcgi</package>
    <package>php5-fpm</package>
    </apache_php_fpm>
    </alternative>
    </httpd>
    <po>
    <alternative>
    <courier>
    <package>courier-imap</package>
    <package>courier-imap-ssl</package>
    <package>courier-maildrop</package>
    <package>courier-pop</package>
    <package>courier-pop-ssl</package>
    <package>libgamin0</package>
    </courier>
    <dovecot>
    <package>dovecot-imapd</package>
    <package>dovecot-pop3d</package>
    </dovecot>
    </alternative>
    </po>
    <mta>
    <alternative>
    <postfix>
    <package>postfix</package>
    </postfix>
    </alternative>
    </mta>
    <ftpd>
    <alternative>
    <proftpd>
    <package>proftpd-basic</package>
    <package>proftpd-mod-mysql</package>
    </proftpd>
    </alternative>
    </ftpd>
    <named>
    <alternative>
    <bind9>
    <package>bind9</package>
    </bind9>
    </alternative>
    </named>
    <sql>
    <alternative>
    <MySQL>
    <package>mysql-server</package>
    <package>mysql-client</package>
    </MySQL>
    <MariaDB_5.3
    repository="http://ftp.igh.cnrs.fr/pub/mariadb/repo/5.3/debian squeeze main"
    repository_key_srv="keyserver.ubuntu.com"
    repository_key_id="0xcbcb082a1bb943db"
    comment="Compatible with MySQL 5.1"
    >
    <package>mariadb-client</package>
    <package>mariadb-servers</package>
    </MariaDB_5.3>
    <MariaDB_5.5
    repository="http://ftp.igh.cnrs.fr/pub/mariadb/repo/5.5/debian squeeze main"
    repository_key_srv="keyserver.ubuntu.com"
    repository_key_id="0xcbcb082a1bb943db"
    comment="Compatible with MySQL 5.5"
    >
    <package>mariadb-client</package>
    <package>mariadb-server</package>
    </MariaDB_5.5>
    </alternative>
    </sql>
    <php>
    <package>php5</package>
    <package>php5-cgi</package>
    <package>php5-cli</package>
    <package>php-pear</package>
    <package>php5-adodb</package>
    <package>php5-gd</package>
    <package>php-gettext</package>
    <package>php5-intl</package>
    <package>php5-mcrypt</package>
    <package>php5-mysql</package>
    <package>php5-suhosin</package>
    </php>
    <perl>
    <package>perl</package>
    <package>perl-base</package>
    <package>libperl5.10</package>
    <package>libberkeleydb-perl</package>
    <package>libcrypt-blowfish-perl</package>
    <package>libcrypt-cbc-perl</package>
    <package>libcrypt-passwdmd5-perl</package>
    <package>libdata-validate-domain-perl</package>
    <package>libdata-validate-ip-perl</package>
    <package>libdate-calc-perl</package>
    <package>libdate-manip-perl</package>
    <package>libdatetime-perl</package>
    <package>libdbd-mysql-perl</package>
    <package>libdbi-perl</package>
    <package>libdigest-md5-perl</package>
    <package>libemail-valid-perl</package>
    <package>libfile-copy-recursive-perl</package>
    <package>libfile-mimeinfo-perl</package>
    <package>libio-socket-inet6-perl</package>
    <package>libio-stringy-perl</package>
    <package>libmail-sendmail-perl</package>
    <package>libmailtools-perl</package>
    <package>libmime-perl</package>
    <package>libnet-dns-perl</package>
    <package>libnet-libidn-perl</package>
    <package>libnet-netmask-perl</package>
    <package>libnet-smtp-server-perl</package>
    <package>libsnmp-session-perl</package>
    <package>libterm-readkey-perl</package>
    <package>libterm-readpassword-perl</package>
    <package>libhtml-parser-perl</package>
    <package>libtimedate-perl</package>
    <package>libxml-parser-perl</package>
    <package>libxml-simple-perl</package>
    <package>libemail-simple-perl</package>
    <package>libjson-perl</package>
    </perl>
    <other>
    <package>bash</package>
    <package>pbzip2</package>
    <package>bzip2</package>
    <package>awstats</package>
    <package>chkrootkit</package>
    <package>dialog</package>
    <package>diff</package>
    <package>dnsutils</package>
    <package>gcc</package>
    <package>gzip</package>
    <package>iptables</package>
    <package>ispell</package>
    <package>libc6-dev</package>
    <package>libexpat1</package>
    <package>libexpat1-dev</package>
    <package>libsasl2-modules</package>
    <package>libmcrypt4</package>
    <package>locales</package>
    <package>lynx</package>
    <package>lzma</package>
    <package>make</package>
    <package>openssl</package>
    <package>original-awk</package>
    <package>patch</package>
    <package>policyd-weight</package>
    <package>postgrey</package>
    <package>procmail</package>
    <package>rkhunter</package>
    <package>sasl2-bin</package>
    <package>ssh</package>
    <package>tar</package>
    <package>wget</package>
    <package>curl</package>
    <package>git</package>
    </other>
    </packages>
    [/php]


    Thanks you for using i-MSCP.

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

    Edited once, last by Nuxwin ().

  • Agree with you, but tn that case it must be also PostgreSQL support in that case.


    You cannot compare MariaDB with PostgreSQL. MariaDB is a drop in replacement for MySQL and is fully compatible. It's not the case of PostgreSQL ;)

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206


  • You cannot compare MariaDB with PostgreSQL. MariaDB is a drop in replacement for MySQL and is fully compatible. It's not the case of PostgreSQL ;)


    Oups, I garbled MariaDB... My fault...

  • MariaDB is now supported in master.

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206