We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
mySQL 5.5 upgrade to MariaDB 10.1
mySQL 5.5 upgrade to MariaDB 10.1
Hi,
I have now mySQL 5.5 and I want upgrade it.
Better choice is mySQL 5.6 , 5.7 or Maria DB 10.1 ?
This way to upgrade to MariaDB is correct?
My system is Debian 8.7
Thanks for help and opinion.
I have now mySQL 5.5 and I want upgrade it.
Better choice is mySQL 5.6 , 5.7 or Maria DB 10.1 ?
This way to upgrade to MariaDB is correct?
Code: Select all
apt-get install software-properties-common
apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
add-apt-repository 'deb [arch=amd64,i386] http://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/debian jessie main'
apt-get update
apt-get install mariadb-server -y
My system is Debian 8.7
Thanks for help and opinion.
Re: mySQL 5.5 upgrade to MariaDB 10.1
I tried this on an Ubuntu 16.04 server and it failed. There was some sort of error in converting the databases, and the upgrade failed.
If you try this, definitely back up your whole /var/lib/mysql directory, your /etc/my.cnf file and do a mysqldump for good measure.
If you can, try on an identical development server first.
Ubuntu 16.04 comes with mariadb-server already configured in the repositories. I tried this one first. When that failed, I tried the one from the mariadb repositories. That failed too. I'm still unsure where the problem lies. I'm thinking something to do with the innodb storage files, or perhaps some views didn't get translated across. Anyway, I"ll try again in the future when I have a bit of time.
Previously I've done a migration from mysql to mariadb on a Debian 7 box, and it was seamless, although there was a small problem with the init scripts firing off twice (one for mysql, one for mariadb), which resulted in errors, although the server still worked.
Some people in these forums have asked 'why bother to change?'. Personally, I've found the memory handling of mariadb a lot better, especially on low spec servers (<1Gb ram). Also it seems to use the swapfile less, which is related to memory usage.
If you try this, definitely back up your whole /var/lib/mysql directory, your /etc/my.cnf file and do a mysqldump for good measure.
If you can, try on an identical development server first.
Ubuntu 16.04 comes with mariadb-server already configured in the repositories. I tried this one first. When that failed, I tried the one from the mariadb repositories. That failed too. I'm still unsure where the problem lies. I'm thinking something to do with the innodb storage files, or perhaps some views didn't get translated across. Anyway, I"ll try again in the future when I have a bit of time.
Previously I've done a migration from mysql to mariadb on a Debian 7 box, and it was seamless, although there was a small problem with the init scripts firing off twice (one for mysql, one for mariadb), which resulted in errors, although the server still worked.
Some people in these forums have asked 'why bother to change?'. Personally, I've found the memory handling of mariadb a lot better, especially on low spec servers (<1Gb ram). Also it seems to use the swapfile less, which is related to memory usage.
Re: mySQL 5.5 upgrade to MariaDB 10.1
I upgrade my mySQL 5.5 to MariaDB 10.1 by this way and after the "mysql_upgrade'' is al right :)
Re: mySQL 5.5 upgrade to MariaDB 10.1
I did some more investigation on this ... will post the results in another thread, but the root of my problem is that the upgrade from mysql 5.7 to mariadb 10.0 on Ubuntu 10.04 .... is broken!
Can't believe that there's a bug relating to those specific versions, which is stopping what is meant to be a seamless upgrade, but that's what's going on. Summary: there was a change in the mysql.user table between mysql 5.6 and 5.7. More info here:
http://www.mail-archive.com/ubuntu-bugs ... 10064.html
https://jira.mariadb.org/browse/MDEV-11 ... ntId=90592
Glad to hear the 5.5 to 10 upgrade went OK. However Ubuntu 16.04 now installs mysql 5.7 by default, so I'm stuck with it.
Can't believe that there's a bug relating to those specific versions, which is stopping what is meant to be a seamless upgrade, but that's what's going on. Summary: there was a change in the mysql.user table between mysql 5.6 and 5.7. More info here:
http://www.mail-archive.com/ubuntu-bugs ... 10064.html
https://jira.mariadb.org/browse/MDEV-11 ... ntId=90592
Glad to hear the 5.5 to 10 upgrade went OK. However Ubuntu 16.04 now installs mysql 5.7 by default, so I'm stuck with it.
Re: mySQL 5.5 upgrade to MariaDB 10.1
Actually vestacp not work fine whit mysql 5.7plutocrat wrote:I did some more investigation on this ... will post the results in another thread, but the root of my problem is that the upgrade from mysql 5.7 to mariadb 10.0 on Ubuntu 10.04 .... is broken!
Can't believe that there's a bug relating to those specific versions, which is stopping what is meant to be a seamless upgrade, but that's what's going on. Summary: there was a change in the mysql.user table between mysql 5.6 and 5.7. More info here:
http://www.mail-archive.com/ubuntu-bugs ... 10064.html
https://jira.mariadb.org/browse/MDEV-11 ... ntId=90592
Glad to hear the 5.5 to 10 upgrade went OK. However Ubuntu 16.04 now installs mysql 5.7 by default, so I'm stuck with it.
Of course you can install vestacp ( clean install ) and then remove mysql 5.7, clean var/lib/mysql, install mariadb10, fix root user and password but upgrade in production is not recomended whitout backup.
Re: mySQL 5.5 upgrade to MariaDB 10.1
Sure, VestaCP works fine with mysql 5.7. MariaDB is just a personal preference. This time I'll just stick with mysql I guess.skamasle wrote: Actually vestacp not work fine whit mysql 5.7
Of course you can install vestacp ( clean install ) and then remove mysql 5.7, clean var/lib/mysql, install mariadb10, fix root user and password but upgrade in production is not recomended whitout backup.
The clean install of vesta and then upgrade to mariadb 10 also doesn't work, for the same reasons. The mysql_upgrade script of mariadb can't handle the changes to the mysql.user table in mysql 5.7 and fails. (although the root password remains the same). I actually tried the clean install thing first, several times, on a VM.
I also tried doing a mysqldump --all-databases from mysql 5.7, and then upgrade and restore into mariadb 10. Nope.
It seems the only thing that would work is to edit the vestacp install script and change the references to mysql to mariadb. If mariadb is on the system before any databases are created then all will be fine. I haven't tried this one yet. But my vestacp is up and running now, so maybe its too late for me.
I might also try a mysqldump mysql users > users.sql and then manually edit the users.sql until it works.
Ooops, sorry I should probably put all this stuff in another thread ... :-)
Re: mySQL 5.5 upgrade to MariaDB 10.1
plutocrat wrote:Sure, VestaCP works fine with mysql 5.7. MariaDB is just a personal preference. This time I'll just stick with mysql I guess.skamasle wrote: Actually vestacp not work fine whit mysql 5.7
Of course you can install vestacp ( clean install ) and then remove mysql 5.7, clean var/lib/mysql, install mariadb10, fix root user and password but upgrade in production is not recomended whitout backup.
The clean install of vesta and then upgrade to mariadb 10 also doesn't work, for the same reasons. The mysql_upgrade script of mariadb can't handle the changes to the mysql.user table in mysql 5.7 and fails. (although the root password remains the same). I actually tried the clean install thing first, several times, on a VM.
I also tried doing a mysqldump --all-databases from mysql 5.7, and then upgrade and restore into mariadb 10. Nope.
It seems the only thing that would work is to edit the vestacp install script and change the references to mysql to mariadb. If mariadb is on the system before any databases are created then all will be fine. I haven't tried this one yet. But my vestacp is up and running now, so maybe its too late for me.
I might also try a mysqldump mysql users > users.sql and then manually edit the users.sql until it works.
Ooops, sorry I should probably put all this stuff in another thread ... :-)
Check this to know acctual problems whit vesta and mysql 5.7 -> viewtopic.php?f=20&t=13239
This will fixed in v18 but you can have data loss if you restore backup ( lost passwords etc )
As I say in fresh install you can remove mysql, delete mysqldir install mariadb, fix root password, restore roundcube database and this will work, or, betther than this, you can modify installer, remove mysql and and mariadb in installer, is easy way, there are some topics in forum whit patch this and install mariadb by default in ubuntu.
Re: mySQL 5.5 upgrade to MariaDB 10.1
Or fix it from the get-go/installation step for ubuntu 16.04
apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
add-apt-repository 'deb [arch=amd64] http://nyc2.mirrors.digitalocean.com/ma ... 0.1/ubuntu xenial main'
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 ... -y no -f
apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
add-apt-repository 'deb [arch=amd64] http://nyc2.mirrors.digitalocean.com/ma ... 0.1/ubuntu xenial main'
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 ... -y no -f
Re: mySQL 5.5 upgrade to MariaDB 10.1
Interesting. That would have worked. But too late now, I'm already using mysql 5.7.noogen wrote:Or fix it from the get-go/installation step for ubuntu 16.04
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
Mariadb 10.0 was already in the Ubuntu 16.04 repositories in fact. Well on my install it was anyway.
Re: mySQL 5.5 upgrade to MariaDB 10.1
I may have a solution to the 5.7 downgrade. Started a new thread for it: viewtopic.php?f=14&t=13839