search

outroll / vesta

VESTA Control Panel
http://vestacp.com
GNU General Public License v3.0
2.92k stars 1.02k forks source link

MariaDB Option #1204

Open inetbiz opened 7 years ago

inetbiz commented 7 years ago

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

Skamasle commented 7 years ago

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 commented 7 years ago

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 commented 7 years ago

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

Vesta installs the OS stack.

plutocrat commented 7 years ago

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 commented 6 years ago

@inetbiz for all OS by default ?

ghost commented 6 years ago

Yes @anton-reutov https://github.com/serghey-rodin/vesta/issues/1204#issuecomment-328803571

inetbiz commented 6 years ago

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

tgd1973 commented 6 years ago

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 commented 2 years ago

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