MariaDB Option

[inetbiz]

Please add mariadb stable as an option to install for databases?

[Skamasle]

Will be nice, but this change is very easy after vesta was installed

Always you can run centos 7, this comes with mariadb by default.

[ghost]

Always you can run centos 7, this comes with mariadb by default.

CentOS 7 comes with PHP 5.6, while Ubuntu comes with PHP7.

I'd rather have PHP7 with MySQL than PHP5.6 with MariaDB.

That being said, I would love the option to select either MariaDB or MySQL as an install option since MariaDB is faster for bigger queries/databases.

[huloza]

You can install mariadb modifying the installer before executing, remove the mysql lines and add the mariadb ones.

Vesta installs the OS stack.

[plutocrat]

Its actually quite a hard job to replace mysql with mariadb after initial installation, on Ubuntu 16 at least. This is because mysql version is 5.7 whereas mariadb version is 10.1, which is based on mysql 5.6. There were many big changes between 5.6 and 5.7, including the renaming of the password field!
So yes, as someone who spent a long time converting between the two, I'd like to see an option in the installer script too.
If anyone is considering doing this, install Maria db as early as possible, either by editing the script, or by installing manually and then removing mysql install from the script.

[anton-reutov]

@inetbiz for all OS by default ?

[ghost]

Yes @anton-reutov #1204 (comment)

[inetbiz]

@anton-reutov not by default. Just as option.

[tgd1973]

How can I install in Ubuntu 16.04 the MariaDB with installer vst-install-ubuntu.sh instead of MySQL?
I thank those who answer me....

---

PS: I managed to do it ...

sudo apt-get install software-properties-common

apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
add-apt-repository 'deb [arch=amd64,i386] https://mirrors.evowise.com/mariadb/repo/10.2/ubuntu xenial main'
sudo apt update

curl -s -o /tmp/vst-install-ubuntu.sh https://vestacp.com/pub/vst-install-ubuntu.sh
sed -i -e "s/mysql\-/mariadb\-/g" /tmp/vst-install-ubuntu.sh

bash /tmp/vst-install-ubuntu.sh -n no -j yes

I'm answering myself ... In this way I managed to modify the installer and then install MariaDB 10.2 on Ubuntu 16.04 xenial.

It would be useful if, who must develop the installer also introduce these changes in order to install easier on Ubuntu also MariaDB (I am forced to install mariadb because I have software that is dependent on this DB) ...
Another solution does not exist, since there is incompatibility between MySQL 5.7 and MariaDB 10 ...
It is not possible to upgrade from one to another database ... I have tried all the variant in a VM ... and apart from installing from the beginning, with the installer, there is no other option ... obviously if one is good, can install all manualy but this would be another matter.

[malsony]

I suggest provide an option to administrators to choose MySQL or MariaDB, no matter what OS they are using.