Upgrade MariaDB

[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.

[mehargags]

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

Code: Select all

mysql -V

to check results

[leisegang]

I am on version 5.5.44-MariaDB

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

[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 !

[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

[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

[andrewkoski]

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

[saam albert]

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 ?

[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

[usr999]

Attach to topic this repo generator

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