MariaDB - как обновить с 5.5 до 10


Материал из Wiki - Iphoster - 'the best ever support'

Перейти к: навигация, поиск

Самые выгодные сервера в рунете


MariaDB - как обновить с 5.5 до 10 (CentOS 6 - 64 bit)

Удаляем старую версию 5.5

# service mysql stop
# yum remove MariaDB*

Меняем репозиторий с 5.5 на 10

# cat /etc/yum.repos.d/mariadb.repo
#[mariadb]
#name = MariaDB
#baseurl = http://yum.mariadb.org/5.5/centos6-amd64
#gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
#gpgcheck=1 
# http://mariadb.org/mariadb/repositories/ [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.0/centos6-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB


# yum repolist
# yum install mysql-server mysql-client
Loaded plugins: fastestmirror
Setting up Install Process
Loading mirror speeds from cached hostfile
* base: centos.quelquesmots.fr
* epel: mirror.imt-systems.com
* extras: centos.quelquesmots.fr
* updates: centos.quelquesmots.fr
extras                                                                                                                        | 3.4 kB     00:00
extras/primary_db                                                                                                             |  34 kB     00:00
Package mysql-server is obsoleted by MariaDB-Galera-server, trying to install MariaDB-Galera-server-10.0.24-1.el6.x86_64 instead
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-Galera-server.x86_64 0:10.0.24-1.el6 will be installed
--> Processing Dependency: MariaDB-common for package: MariaDB-Galera-server-10.0.24-1.el6.x86_64
--> Processing Dependency: galera for package: MariaDB-Galera-server-10.0.24-1.el6.x86_64
---> Package MariaDB-client.x86_64 0:10.0.24-1.el6 will be installed
--> Running transaction check
---> Package MariaDB-common.x86_64 0:10.0.24-1.el6 will be installed
--> Processing Dependency: MariaDB-compat for package: MariaDB-common-10.0.24-1.el6.x86_64
---> Package galera.x86_64 0:25.3.14-1.rhel6.el6 will be installed
--> Running transaction check
---> Package MariaDB-compat.x86_64 0:10.0.24-1.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=========================================================================================  ============================================================
Package                                    Arch                        Version                                   Repository                    Size
========================================================================================== ===========================================================
Installing:
MariaDB-Galera-server                      x86_64                      10.0.24-1.el6                             mariadb                       34 M
MariaDB-client                             x86_64                      10.0.24-1.el6                             mariadb                       11 M
Installing for dependencies:
MariaDB-common                             x86_64                      10.0.24-1.el6                             mariadb                       41 k
MariaDB-compat                             x86_64                      10.0.24-1.el6                             mariadb                      2.7 M
galera                                     x86_64                      25.3.14-1.rhel6.el6                       mariadb                      8.5 M
Transaction Summary
========================================================================================== ===========================================================
Install       5 Package(s) 
Total download size: 57 M Installed size: 237 M Is this ok [y/N]: y Downloading Packages: (1/5): MariaDB-Galera-10.0.24-centos6-x86_64-server.rpm | 34 MB 00:02 (2/5): MariaDB-10.0.24-centos6-x86_64-client.rpm | 11 MB 00:00 (3/5): MariaDB-10.0.24-centos6-x86_64-common.rpm | 41 kB 00:00 (4/5): MariaDB-10.0.24-centos6-x86_64-compat.rpm | 2.7 MB 00:00 (5/5): galera-25.3.14-1.rhel6.el6.x86_64.rpm | 8.5 MB 00:00 ----------------------------------------------------------------------------------------------------------------------------------------------------- Total 13 MB/s | 57 MB 00:04


# cp -r my.cnf.rpmsave /etc/my.cnf
# service mysql start
# mysql_upgrade


Link:

Индекс цитирования