We are starting CHRISTMAS Sale. Get 30% OFF on lifetime licenses with code: FYSKK72

MariaDB v10

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
zukiblue
Posts: 2
Joined: Sat Nov 18, 2017 12:49 am

MariaDB v10

Postby zukiblue » Sat Nov 18, 2017 12:51 am

When will Vesta integrate the MariaDB v10 on vst-install.sh script ?

mehargags
Moderators
Posts: 836
Joined: Sat Sep 06, 2014 9:58 pm
Contact:

Re: MariaDB v10

Postby mehargags » Sat Nov 18, 2017 5:33 pm

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

plutocrat
Posts: 84
Joined: Fri Jan 27, 2017 9:16 am

Re: MariaDB v10

Postby plutocrat » Mon Nov 20, 2017 10:15 am

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.

And to answer your question 'when', its been proposed as a feature, but not yet accepted.
https://github.com/serghey-rodin/vesta/issues/1204

zukiblue
Posts: 2
Joined: Sat Nov 18, 2017 12:49 am

Re: MariaDB v10

Postby zukiblue » Mon Nov 20, 2017 7:12 pm

I'll try to install mariadb 10 before VESTA

Thanks

Fchen
Posts: 3
Joined: Mon Nov 20, 2017 10:35 pm

Re: MariaDB v10

Postby Fchen » Thu Nov 23, 2017 6:46 pm

I have performed a snap-in migration, simply do

Code: Select all

apt-get install mariadb-server
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?

plutocrat
Posts: 84
Joined: Fri Jan 27, 2017 9:16 am

Re: MariaDB v10

Postby plutocrat » Fri Nov 24, 2017 4:05 am

Fchen wrote:I have performed a snap-in migration ... everything worked fine on Debian 8.


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.

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 '',

In my case the username can clearly be 80 characters. If you get the same and its still not working, I'd guess there's some check in the vestacp code which is not allowing longer names. https://github.com/serghey-rodin/vesta/issues/860


Return to “Database Server”



Who is online

Users browsing this forum: No registered users and 2 guests

cron