Skip to content

Instantly share code, notes, and snippets.

@yoyosan

yoyosan/mariadb.md

Created December 11, 2020 07:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yoyosan/84f6aa0cbe027f17ed32514f66463042 to your computer and use it in GitHub Desktop.
Save yoyosan/84f6aa0cbe027f17ed32514f66463042 to your computer and use it in GitHub Desktop.
Download ZIP
MariaDB 10.2 upgrade on CentOS 7
Raw
mariadb.md

A MySQL or MariaDB server package (MariaDB-server-10.1.48-1.el7.centos.x86_64) is installed.

Upgrading directly from MySQL 10.1 to MariaDB 10.2 may not be safe in all cases. A manual dump and restore using mysqldump is recommended. It is important to review the MariaDB manual's Upgrading section for version-specific incompatibilities.

A manual upgrade is required.

  • Ensure that you have a complete, working backup of your data and my.cnf files

  • Shut down the MySQL server cleanly

  • Remove the existing MySQL packages. Usually this command will list the packages you should remove: rpm -qa | grep -i '^mysql-'

    You may choose to use 'rpm --nodeps -ev ' to remove the package which contains the mysqlclient shared library. The library will be reinstalled by the MariaDB-shared package.

  • Install the new MariaDB packages supplied by MariaDB Foundation

  • Ensure that the MariaDB server is started

  • Run the 'mysql_upgrade' program

This is a brief description of the upgrade process. Important details can be found in the MariaDB manual, in the Upgrading section.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment