This shows you the differences between two versions of the page.
upgrade_using_ius [2019/02/26 18:51] k2patel [Stop mariadb and install] |
upgrade_using_ius [2020/08/10 02:35] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Upgrade using iUS ====== | ||
- | ==== Enable iUS repository ==== | ||
- | Follow guide available at [[https://ius.io/GettingStarted/ | iUS ]] | ||
- | |||
- | ==== Stop mariadb and install ==== | ||
- | <code bash> | ||
- | systemctl stop mariadb | ||
- | yum install mysql yum-plugin-replace | ||
- | yum replace mariadb-server --replace-with mariadb101u-server | ||
- | </code> | ||
- | |||
- | ==== Setup file limit for mariadb ==== | ||
- | File limit require to upgrade mariadb. | ||
- | <code bash> | ||
- | mkdir /etc/systemd/system/mariadb.service.d | ||
- | </code> | ||
- | |||
- | <code ini /etc/systemd/system/mariadb.service.d/limit.conf> | ||
- | [Service] | ||
- | LimitNOFILE=320000 | ||
- | </code> | ||
- | |||
- | ==== Start mariadb ==== | ||
- | <code bash> | ||
- | systemctl start mariadb | ||
- | </code> | ||
- | |||
- | ==== Finalize Upgrade ==== | ||
- | <code bash> | ||
- | mysqlcheck --no-defaults --check-upgrade --auto-repair --databases mysql -p | ||
- | mysqlcheck --no-defaults --check-upgrade --all-databases --auto-repair --write-binlog -p | ||
- | mysqlcheck --no-defaults --all-databases --fix-db-names --fix-table-names --write-binlog -p | ||
- | mysql_upgrade | ||
- | </code> |