MariaDB - как обновить с 5.5 до 10
Материал из Wiki - Iphoster - the best ever hosting and support. 2005 - 2024
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:
