Smooth migration of MySQL to MariaDB with Yum in CentOS

This article mainly introduces "smooth migration of MySQL to MariaDB with Yum in CentOS". In daily operation, it is believed that many people have doubts about smooth migration of MySQL to MariaDB with Yum in CentOS. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "smooth migration of MySQL to MariaDB with Yum in CentOS". Next, please follow the editor to study!

The VPS operating system is CentOS 6 Magi MySQL version 5.5.31 (using the REMI source).

a. Configure the installation source for MariaDB first.

Currently, the main version of MariaDB is MariaDB 5.5.33a Stable. Save the following installation source configuration as MariaDB.repo and upload it to the server's / etc/yum.repos.d folder:

For CentOS 6 32 bit:

The code is as follows:

[mariadb] name = MariaDB enable=1 priority=3 baseurl = http://yum.mariadb.org/5.5.33a/centos6-x86/ gpgkey= https://yum.mariadb.org/rpm-GPG-KEY-MariaDB gpgcheck=1

For CentOS 6 64 bit:

The code is as follows:

[mariadb] name = MariaDB enable=1 priority=3 baseurl = http://yum.mariadb.org/5.5.33a/centos6-amd64/ gpgkey= https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1

b. Then perform the system upgrade directly.

The code is as follows:

Yum update-skip-broken

MariaDB-related installation packages will be installed, unneeded MySQL packages will be uninstalled, and the system will not need to be patched after the upgrade.

At this point, the study on "smooth migration of MySQL to MariaDB with Yum in CentOS" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!