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
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.
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.
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 project. Will be nice to have line in your bugtracer
I've the same error. Fresh install with Debian + nginx + php facts + mariadb. any one know how to solved it?
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.
Hi Till! Of course. I follow this tutorial https://www.howtoforge.com/perfect-server-debian-wheezy-nginx-bind-dovecot-ispconfig-3-p2 but instead of install mysql-server I've installed mariadb-server. All go fine, but I see this error in /Var/log/nginx/error.log and I don't know why?. I will try that you say me in other post and try to install php5-mysqlnd and I'll tell you the result. Thanks.
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.
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!
