MariaDB v10
MariaDB v10
When will Vesta integrate the MariaDB v10 on vst-install.sh script ?
-
- Support team
- Posts: 1096
- Joined: Sat Sep 06, 2014 9:58 pm
- Contact:
- Os: Debian 8x
- Web: apache + nginx
Re: MariaDB v10
If you install Ubuntu 16, Debian 9, or CentOS 7, the default MySQL installed is MariaDB only. Vesta installs default *available* pkg version in the default repos of the OS...
Pls be aware Debian 9 is still not supported officially
Pls be aware Debian 9 is still not supported officially
Re: MariaDB v10
My experience on Ubuntu 16 was that mysql was installed by default. This caused problems, as mysql was version 5.7, and mariadb 10.x corresponds to mysql 5.6. There are substantial differences in the table structure between 5.6 and 5.7, so effectively downgrading from mysql 5.7 to mariadb 10.1 was a lot of hassle.
I think your best approach is to manually install mariadb first, and then run the vesta install script, with the "no mysql, no postgresql" option. (Update: I tried this recently on a new install, and it didn't work, as phpmyadmin and roundcube were not installed: they require a database to operate, and they think there isn't one available. Maybe the installer should check for the mysql executable instead).
And to answer your question 'when', its been proposed as a feature, but not yet accepted.
https://github.com/serghey-rodin/vesta/issues/1204
I think your best approach is to manually install mariadb first, and then run the vesta install script, with the "no mysql, no postgresql" option. (Update: I tried this recently on a new install, and it didn't work, as phpmyadmin and roundcube were not installed: they require a database to operate, and they think there isn't one available. Maybe the installer should check for the mysql executable instead).
And to answer your question 'when', its been proposed as a feature, but not yet accepted.
https://github.com/serghey-rodin/vesta/issues/1204
Last edited by plutocrat on Fri Apr 13, 2018 4:07 am, edited 1 time in total.
Re: MariaDB v10
I'll try to install mariadb 10 before VESTA
Thanks
Thanks
Re: MariaDB v10
I have performed a snap-in migration, simply do the install will remove mysql and install mariadb and ask you if you want to migrate data, everything worked fine on Debian 8.
I upgraded to mariadb because of the username length, but VestaCP still prevent longer names than 16 character, anything I missed?
Code: Select all
apt-get install mariadb-server
I upgraded to mariadb because of the username length, but VestaCP still prevent longer names than 16 character, anything I missed?
Re: MariaDB v10
This will work on Debian as the migration is from mysql 5.5 to mariadb 10. For Ubuntu 16 and above, its much trickier as you're going from 5.7.Fchen wrote:I have performed a snap-in migration ... everything worked fine on Debian 8.
Re. Username size, you can check what your database is expecting with "show create table mysql.user;" which will display something like this.
Code: Select all
`User` char(80) COLLATE utf8_bin NOT NULL DEFAULT '',
Re: MariaDB v10
I have also 80 character per username, so there must be something in the VestaCP code.