Upgrade MariaDB Topic is solved

General questions about VestaCP
leisegang
Posts: 64
Joined: Mon Feb 29, 2016 7:24 pm

Upgrade MariaDB

Postby leisegang » Fri Apr 01, 2016 7:50 am

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.

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

Re: Upgrade MariaDB

Postby mehargags » Sat Apr 02, 2016 6:52 am

if you are on CentOS 7, you are already on MariaDB.

Code: Select all

mysql -V
to check results

leisegang
Posts: 64
Joined: Mon Feb 29, 2016 7:24 pm

Re: Upgrade MariaDB

Postby leisegang » Sat Apr 02, 2016 8:50 am

I am on version 5.5.44-MariaDB

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

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

Re: Upgrade MariaDB

Postby mehargags » Sat Apr 02, 2016 6:47 pm

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 !

RevengeFNF
Posts: 74
Joined: Sat Aug 02, 2014 6:50 pm

Re: Upgrade MariaDB  Topic is solved

Postby RevengeFNF » Thu Apr 07, 2016 1:35 am

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

leisegang
Posts: 64
Joined: Mon Feb 29, 2016 7:24 pm

Re: Upgrade MariaDB

Postby leisegang » Fri Apr 08, 2016 3:58 pm

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

andrewkoski
Posts: 2
Joined: Wed Sep 30, 2015 4:42 pm
Location: Chicago, Illinois
Contact:

Re: Upgrade MariaDB

Postby andrewkoski » Thu Apr 21, 2016 2:11 pm

To get your phpmyadmin back, just do this;
yum install phpmyadmin --enablerepo=remi

saam albert
Posts: 2
Joined: Tue Oct 04, 2016 10:55 pm

Re: Upgrade MariaDB

Postby saam albert » Tue Oct 04, 2016 11:02 pm

leisegang 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 ?
Last edited by saam albert on Thu Oct 06, 2016 4:41 am, edited 1 time in total.

Stesh
Posts: 265
Joined: Mon Nov 09, 2015 5:52 pm

Re: Upgrade MariaDB

Postby Stesh » Tue Oct 04, 2016 11:59 pm

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

usr999
Posts: 49
Joined: Sat Jul 25, 2015 3:37 pm

Re: Upgrade MariaDB

Postby usr999 » Wed Nov 22, 2017 3:56 am

Attach to topic this repo generator

https://downloads.mariadb.org/mariadb/repositories/


Return to “General Discussion”



Who is online

Users browsing this forum: No registered users and 3 guests

cron