We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on Vesta 2.0 and expect to release it by the end of 2024. Read more about it: https://vestacp.com/docs/vesta-2-development
[HOWTO] Fresh install MariaDB 10.1 with VestaCP Installer in Centos 6.8
[HOWTO] Fresh install MariaDB 10.1 with VestaCP Installer in Centos 6.8
Note 1: tested on Centos 6.8 MariaDB replacing mysql without problems.
Note3: tested in vesta 0.9.8-16
Note 2: Im using nano as texto editor feel free to use whatever you want (vim), but nano dont come with centos, you need to do:
Assuming you are starting from a fresh centos 6.8 minimal system.
1. First we install the mariaDB repo for CentOS 6.8 (source)
this will create a new file, paste this inside:
Exit and Save(Control + X in nano, then Y)
2. Update the system before vesta installation:
3. here you have two options, 1 get the modified installer i made(original installer is from vesta i only changed the mariadb part) or 2. download original installer and made the changes yourself
3.1 if you are lazy and want to use my installer:
then only do:
And thats it, your database is MariaDB 10.1.
3.2 now if you want to download the original installer and do the changes here we go:
open the downloaded file with your favorite editor (i will use nano):
on line 35 replace:
on line 609 replace:
on line 612 replace:
on line 960 replace:
on line 962 replace:
thats all!, now save and close file and run it:
Now you have MariaDB as database in your server.
Enjoy!
Note3: tested in vesta 0.9.8-16
Note 2: Im using nano as texto editor feel free to use whatever you want (vim), but nano dont come with centos, you need to do:
Code: Select all
yum install nano
Assuming you are starting from a fresh centos 6.8 minimal system.
1. First we install the mariaDB repo for CentOS 6.8 (source)
Code: Select all
nano /etc/yum.repos.d/MariaDB.repo
Code: Select all
# MariaDB 10.1 CentOS repository list - created 2016-08-26 22:02 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos6-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
2. Update the system before vesta installation:
Code: Select all
yum update
3.1 if you are lazy and want to use my installer:
Code: Select all
cd
wget http://www.eranecesario.com/vesta/vst-install-rhel.sh -O vst-install-rhel.sh
Code: Select all
bash vst-install-rhel.sh
3.2 now if you want to download the original installer and do the changes here we go:
Code: Select all
cd
wget http://vestacp.com/pub/vst-install-rhel.sh -O vst-install-rhel.sh
Code: Select all
nano vst-install-rhel.sh
Code: Select all
clamd spamassassin roundcubemail mysql mysql-server phpMyAdmin postgresql
with:
clamd spamassassin roundcubemail MariaDB-server MariaDB-client phpMyAdmin postgresql
on line 609 replace:
Code: Select all
yum -y --disablerepo=* --enablerepo="base,updates,nginx,epel,vesta,remi*"\
with:
yum -y --disablerepo=* --enablerepo="base,updates,nginx,mariadb,epel,vesta,remi*"\
on line 612 replace:
Code: Select all
yum -y --disablerepo=* --enablerepo="base,updates,nginx,epel,vesta" \
with:
yum -y --disablerepo=* --enablerepo="base,updates,nginx,epel,vesta,mariadb" \
on line 960 replace:
Code: Select all
service='mysqld'
with:
service='mysql'
on line 962 replace:
Code: Select all
service='mariadb'
with:
service='mysql'
thats all!, now save and close file and run it:
Code: Select all
bash vst-install-rhel.sh
Now you have MariaDB as database in your server.
Enjoy!
Re: [HOWTO] Fresh install MariaDB 10.1 with VestaCP Installer in Centos 6.8
This works, but you can just install mariadb after install vestacp
Just add repos, remove mysql and install mariadb is faster and works as well you say.
Just add repos, remove mysql and install mariadb is faster and works as well you say.
Re: [HOWTO] Fresh install MariaDB 10.1 with VestaCP Installer in Centos 6.8
Also, you may want to add this line to your my.cnf for MariaDB 10.1:
This way, your backup restorations will work correctly, otherwise MySQL users can't be created with "GRANT" statements as VestaCP does. This is because MariaDB 10.1 by default has sql_mode with NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER
Code: Select all
sql_mode = NO_ENGINE_SUBSTITUTION