Vesta Control Panel - Forum

Community Forum
https://forum.vestacp.com/

Upgrade MariaDB

https://forum.vestacp.com/viewtopic.php?f=10&t=11076

Page 1 of 1

Upgrade MariaDB

Posted: Fri Apr 01, 2016 7:50 am
by leisegang
I saw on this forum that i can use this guide to upgrade MariaDB
http://www.liquidweb.com/kb/how-to-upgr ... -centos-7/

Is this OK, or will the upgrade of vesta "break" my server?
Will this install in the same location as mariadb is now?

I am asking before i do this to be shure not to break the server.

Re: Upgrade MariaDB

Posted: Sat Apr 02, 2016 6:52 am
by mehargags
if you are on CentOS 7, you are already on MariaDB.

Code: Select all

mysql -V
to check results

Re: Upgrade MariaDB

Posted: Sat Apr 02, 2016 8:50 am
by leisegang
I am on version 5.5.44-MariaDB

But I want to upgrade it to 5.6 or 10. Is that easy?

Re: Upgrade MariaDB

Posted: Sat Apr 02, 2016 6:47 pm
by mehargags
absolutely... peace of cake - just head to official repo and follow the instructions. While installing, DO NOT change your mysql pass, just press enter to skip it and you will be all good !

Re: Upgrade MariaDB

Posted: Thu Apr 07, 2016 1:35 am
by RevengeFNF
Just make this steps:

nano /etc/yum.repos.d/MariaDB10.repo
# MariaDB 10.1 CentOS repository list
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
systemctl stop mariadb
yum remove mariadb-server mariadb mariadb-libs
yum install MariaDB-server MariaDB-client
systemctl start mariadb
systemctl enable mariadb
mysql_upgrade

Re: Upgrade MariaDB

Posted: Fri Apr 08, 2016 3:58 pm
by leisegang
When doing that phpMyAdmin is uninstalled.

Code: Select all

Apr 07 08:34:05 Erased: 1:mariadb-server-5.5.44-2.el7.centos.x86_64
Apr 07 08:34:07 Erased: phpMyAdmin-4.4.15.5-1.el7.noarch
Apr 07 08:34:07 Erased: php-mysql-5.4.45-4.el7.remi.x86_64
Apr 07 08:34:07 Erased: 1:mariadb-5.5.44-2.el7.centos.x86_64
Apr 07 08:34:07 Erased: perl-DBD-MySQL-4.023-5.el7.x86_64
Apr 07 08:34:07 Erased: 1:net-snmp-5.7.2-24.el7.x86_64
Apr 07 08:34:08 Erased: 1:mariadb-libs-5.5.44-2.el7.centos.x86_64

Apr 07 08:44:04 Installed: MariaDB-common-10.1.13-1.el7.centos.x86_64
Apr 07 08:44:14 Installed: MariaDB-client-10.1.13-1.el7.centos.x86_64
Apr 07 08:44:14 Installed: jemalloc-3.6.0-1.el7.x86_64
Apr 07 08:44:14 Installed: boost-program-options-1.53.0-25.el7.x86_64
Apr 07 08:44:16 Installed: galera-25.3.15-1.rhel7.el7.centos.x86_64
Apr 07 08:44:43 Installed: MariaDB-server-10.1.13-1.el7.centos.x86_64
when trying to install with yum install phpmyadmin i get this:

Code: Select all

yum install phpmyadmin
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.nl.leaseweb.net
 * epel: ftp.nluug.nl
 * extras: ftp.nluug.nl
 * remi-safe: remi.mirrors.cu.be
 * updates: ftp.nluug.nl
 * webtatic: uk.repo.webtatic.com
Resolving Dependencies
--> Running transaction check
---> Package phpMyAdmin.noarch 0:4.4.15.5-1.el7 will be installed
--> Processing Dependency: php-mysqli >= 5.3.7 for package: phpMyAdmin-4.4.15.5-1.el7.noarch
--> Running transaction check
---> Package php-mysqlnd.x86_64 0:5.4.16-36.el7_1 will be installed
--> Processing Dependency: php-pdo(x86-64) = 5.4.16-36.el7_1 for package: php-mysqlnd-5.4.16-36.el7_1.x86_64
--> Finished Dependency Resolution
Error: Package: php-mysqlnd-5.4.16-36.el7_1.x86_64 (base)
           Requires: php-pdo(x86-64) = 5.4.16-36.el7_1
           Installed: php-pdo-5.4.45-4.el7.remi.x86_64 (@remi)
               php-pdo(x86-64) = 5.4.45-4.el7.remi
           Available: php-pdo-5.4.16-36.el7_1.x86_64 (base)
               php-pdo(x86-64) = 5.4.16-36.el7_1
           Available: php54w-pdo-5.4.45-2.w7.x86_64 (webtatic)
               php-pdo(x86-64) = 5.4.45-2.w7
           Available: php55w-pdo-5.5.32-1.w7.x86_64 (webtatic)
               php-pdo(x86-64) = 5.5.32-1.w7
           Available: php55w-pdo-5.5.33-1.w7.x86_64 (webtatic)
               php-pdo(x86-64) = 5.5.33-1.w7
           Available: php56w-pdo-5.6.18-1.w7.x86_64 (webtatic)
               php-pdo(x86-64) = 5.6.18-1.w7
           Available: php56w-pdo-5.6.19-1.w7.x86_64 (webtatic)
               php-pdo(x86-64) = 5.6.19-1.w7
           Available: php70w-pdo-7.0.3-1.w7.x86_64 (webtatic)
               php-pdo(x86-64) = 7.0.3-1.w7
           Available: php70w-pdo-7.0.4-1.w7.x86_64 (webtatic)
               php-pdo(x86-64) = 7.0.4-1.w7
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

Re: Upgrade MariaDB

Posted: Thu Apr 21, 2016 2:11 pm
by andrewkoski
To get your phpmyadmin back, just do this;
yum install phpmyadmin --enablerepo=remi

Re: Upgrade MariaDB

Posted: Tue Oct 04, 2016 11:02 pm
by saam albert
[color=#000000]leisegang[/color] wrote:When doing that phpMyAdmin is uninstalled.

Code: Select all

Apr 07 08:34:05 Erased: 1:mariadb-server-5.5.44-2.el7.centos.x86_64
Apr 07 08:34:07 Erased: phpMyAdmin-4.4.15.5-1.el7.noarch
Apr 07 08:34:07 Erased: php-mysql-5.4.45-4.el7.remi.x86_64
Apr 07 08:34:07 Erased: 1:mariadb-5.5.44-2.el7.centos.x86_64
Apr 07 08:34:07 Erased: perl-DBD-MySQL-4.023-5.el7.x86_64
Apr 07 08:34:07 Erased: 1:net-snmp-5.7.2-24.el7.x86_64
Apr 07 08:34:08 Erased: 1:mariadb-libs-5.5.44-2.el7.centos.x86_64

Apr 07 08:44:04 Installed: MariaDB-common-10.1.13-1.el7.centos.x86_64
Apr 07 08:44:14 Installed: MariaDB-client-10.1.13-1.el7.centos.x86_64
Apr 07 08:44:14 Installed: jemalloc-3.6.0-1.el7.x86_64
Apr 07 08:44:14 Installed: boost-program-options-1.53.0-25.el7.x86_64
Apr 07 08:44:16 Installed: galera-25.3.15-1.rhel7.el7.centos.x86_64
Apr 07 08:44:43 Installed: MariaDB-server-10.1.13-1.el7.centos.x86_64
when trying to install with yum install phpmyadmin i get this:

Code: Select all

yum install phpmyadmin
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.nl.leaseweb.net
 * epel: ftp.nluug.nl
 * extras: ftp.nluug.nl
 * remi-safe: remi.mirrors.cu.be
 * updates: ftp.nluug.nl
 * webtatic: uk.repo.webtatic.com
Resolving Dependencies
--> Running transaction check
---> Package phpMyAdmin.noarch 0:4.4.15.5-1.el7 will be installed
--> Processing Dependency: php-mysqli >= 5.3.7 for package: phpMyAdmin-4.4.15.5-1.el7.noarch
--> Running transaction check
---> Package php-mysqlnd.x86_64 0:5.4.16-36.el7_1 will be installed
--> Processing Dependency: php-pdo(x86-64) = 5.4.16-36.el7_1 for package: php-mysqlnd-5.4.16-36.el7_1.x86_64
--> Finished Dependency Resolution
Error: Package: php-mysqlnd-5.4.16-36.el7_1.x86_64 (base)
           Requires: php-pdo(x86-64) = 5.4.16-36.el7_1
           Installed: php-pdo-5.4.45-4.el7.remi.x86_64 (@remi)
               php-pdo(x86-64) = 5.4.45-4.el7.remi
           Available: php-pdo-5.4.16-36.el7_1.x86_64 (base)
               php-pdo(x86-64) = 5.4.16-36.el7_1
           Available: php54w-pdo-5.4.45-2.w7.x86_64 (webtatic)
               php-pdo(x86-64) = 5.4.45-2.w7
           Available: php55w-pdo-5.5.32-1.w7.x86_64 (webtatic)
               php-pdo(x86-64) = 5.5.32-1.w7
           Available: php55w-pdo-5.5.33-1.w7.x86_64 (webtatic)
               php-pdo(x86-64) = 5.5.33-1.w7
           Available: php56w-pdo-5.6.18-1.w7.x86_64 (webtatic)
               php-pdo(x86-64) = 5.6.18-1.w7
           Available: php56w-pdo-5.6.19-1.w7.x86_64 (webtatic)
               php-pdo(x86-64) = 5.6.19-1.w7
           Available: php70w-pdo-7.0.3-1.w7.x86_64 (webtatic)
               php-pdo(x86-64) = 7.0.3-1.w7
           Available: php70w-pdo-7.0.4-1.w7.x86_64 (webtatic)
               php-pdo(x86-64) = 7.0.4-1.w7
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
I mess up with this script. Is there any other route ?

Re: Upgrade MariaDB

Posted: Tue Oct 04, 2016 11:59 pm
by Stesh
For Centos

1. Remove webtatic repo, add remi repo
2. Create file /etc/yum.repos.d/mariadb.repo

Code: Select all

# MariaDB 10.1 CentOS repository list - created 2016-01-25 00:03 UTC
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
3. service mariadb stop
4. yum update
5. service mysql start
6. mysql_upgrade

Profit

Re: Upgrade MariaDB

Posted: Wed Nov 22, 2017 3:56 am
by usr999
Attach to topic this repo generator

https://downloads.mariadb.org/mariadb/repositories/
All times are UTC
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/