RHEL8 の MariaDB 10.3 で運用中のサーバーに Zabbix 6.0 LTS を導入することになった。
システム要求が MariaDB 10.5 なのでアップグレードした手順を記録しておきます。
バックアップ
先ずはバックアップを取ります。
#!/bin/bash
PATH=/usr/local/sbin:/usr/bin:/bin
# バックアップ先ディレクトリ
BACKDIR=/backup/mysql
# MySQLrootパスワード
ROOTPASS=xxxxxxxx
# バックアップ先ディレクトリ再作成
rm -rf $BACKDIR
mkdir -p $BACKDIR
# データベース名取得
DBLIST=`ls -p /var/lib/mysql | grep / | tr -d /`
# データベースごとにバックアップ
for dbname in $DBLIST
do
[ $dbname = "performance_schema" ] && continue
table_count=`mysql -u root -p$ROOTPASS -B -e "show tables" $dbname|wc -l`
[ $table_count -ne 0 ] &&
mysqldump --events -u root -p$ROOTPASS $dbname > $BACKDIR/$dbname.sql | logger -t mysqldump
doneスクリプトは下記のサイトのコピペです。今回は mysqldump でやりましたが phpMyAdmin でエクスポートするのも、お手軽で良いかもしれません。
MySQLデータベース自動バックアップ運用(mysqldump) - CentOSで自宅サーバー構築
MySQLデータベース自動バックアップ運用(mysqldump)
centossrv.com
MariaDB の入れ替え
MariaDB のストリームを確認
dnf module list mariadb
(out) Updating Subscription Management repositories.
(out)
(out) This system is registered with an entitlement server, but is not receiving updates. You can use subscription-manager to assign subscriptions.
(out)
(out) Last metadata expiration check: 2:38:52 ago on Tue 19 Jul 2022 01:12:17 PM JST.
(out) Red Hat Enterprise Linux 8 for x86_64 - AppStream from RHUI (RPMs)
(out) Name Stream Profiles Summary
(out) mariadb 10.3 [d][e] client, galera, server [d] MariaDB Module
(out) mariadb 10.5 client, galera, server [d] MariaDB Module
(out)
(out) Hint: [d]efault, [e]nabled, [x]disabled, [i]nstalledMariaDB のストリームを確認したところ、10.3 と 10.5 が候補にあります。
ストリームの切り替え
他のバージョンに切り替えたい場合は、一旦リセットします。
dnf module reset mariadb
(out) Updating Subscription Management repositories.
(out)
(out) This system is registered with an entitlement server, but is not receiving updates. You can use subscription-manager to assign subscriptions.
(out)
(out) Last metadata expiration check: 0:16:55 ago on Tue 19 Jul 2022 05:09:25 PM JST.
(out) Dependencies resolved.
(out) =============================================================================================================================================================
(out) Package Architecture Version Repository Size
(out) =============================================================================================================================================================
(out) Resetting modules:
(out) mariadb
(out)
(out) Transaction Summary
(out) =============================================================================================================================================================
(out)
(out) Is this ok [y/N]: y
(out) Complete!dnf module install mariadb:10.5
(out) Updating Subscription Management repositories.
(out)
(out) This system is registered with an entitlement server, but is not receiving updates. You can use subscription-manager to assign subscriptions.
(out)
(out) Last metadata expiration check: 0:17:41 ago on Tue 19 Jul 2022 05:09:25 PM JST.
(out) Dependencies resolved.
(out) =============================================================================================================================================================
(out) Package Architecture Version Repository Size
(out) =============================================================================================================================================================
(out) Upgrading:
(out) mariadb x86_64 3:10.5.13-1.module+el8.5.0+14125+d11efe18 rhel-8-appstream-rhui-rpms 6.2 M
(out) mariadb-backup x86_64 3:10.5.13-1.module+el8.5.0+14125+d11efe18 rhel-8-appstream-rhui-rpms 6.9 M
(out) mariadb-common x86_64 3:10.5.13-1.module+el8.5.0+14125+d11efe18 rhel-8-appstream-rhui-rpms 68 k
(out) mariadb-errmsg x86_64 3:10.5.13-1.module+el8.5.0+14125+d11efe18 rhel-8-appstream-rhui-rpms 240 k
(out) mariadb-gssapi-server x86_64 3:10.5.13-1.module+el8.5.0+14125+d11efe18 rhel-8-appstream-rhui-rpms 56 k
(out) mariadb-server x86_64 3:10.5.13-1.module+el8.5.0+14125+d11efe18 rhel-8-appstream-rhui-rpms 18 M
(out) mariadb-server-utils x86_64 3:10.5.13-1.module+el8.5.0+14125+d11efe18 rhel-8-appstream-rhui-rpms 1.2 M
(out) Installing dependencies:
(out) mysql-selinux noarch 1.0.2-6.el8 rhel-8-appstream-rhui-rpms 37 k
(out) Installing module profiles:
(out) mariadb/server
(out) Enabling module streams:
(out) mariadb 10.5
(out)
(out) Transaction Summary
(out) =============================================================================================================================================================
(out) Install 1 Package
(out) Upgrade 7 Packages
(out)
(out) Total download size: 33 M
(out) Is this ok [y/N]: y
(out) Downloading Packages:
(out) (1/8): mysql-selinux-1.0.2-6.el8.noarch.rpm 952 kB/s | 37 kB 00:00
(out) (2/8): mariadb-gssapi-server-10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64.rpm 861 kB/s | 56 kB 00:00
(out) (3/8): mariadb-10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64.rpm 59 MB/s | 6.2 MB 00:00
(out) (4/8): mariadb-common-10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64.rpm 1.5 MB/s | 68 kB 00:00
(out) (5/8): mariadb-errmsg-10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64.rpm 8.2 MB/s | 240 kB 00:00
(out) (6/8): mariadb-server-utils-10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64.rpm 25 MB/s | 1.2 MB 00:00
(out) (7/8): mariadb-backup-10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64.rpm 65 MB/s | 6.9 MB 00:00
(out) (8/8): mariadb-server-10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64.rpm 54 MB/s | 18 MB 00:00
(out) -------------------------------------------------------------------------------------------------------------------------------------------------------------
(out) Total 56 MB/s | 33 MB 00:00
(out) Running transaction check
(out) Transaction check succeeded.
(out) Running transaction test
(out) Transaction test succeeded.
(out) Running transaction
(out) Preparing : 1/1
(out) Running scriptlet: mariadb-common-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64 1/1
(out) Upgrading : mariadb-common-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64 1/15
(out) Upgrading : mariadb-errmsg-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64 2/15
(out) Running scriptlet: mysql-selinux-1.0.2-6.el8.noarch 3/15
(out) Installing : mysql-selinux-1.0.2-6.el8.noarch 3/15
(out) Running scriptlet: mysql-selinux-1.0.2-6.el8.noarch 3/15
(out) libsemanage.semanage_direct_install_info: Overriding mysql module at lower priority 100 with module at priority 200.
(out)
(out) Upgrading : mariadb-gssapi-server-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64 4/15
(out) Upgrading : mariadb-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64 5/15
(out) Upgrading : mariadb-server-utils-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64 6/15
(out) Upgrading : mariadb-backup-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64 7/15
(out) Running scriptlet: mariadb-server-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64 8/15
(out) Upgrading : mariadb-server-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64 8/15
(out) warning: /etc/my.cnf.d/mariadb-server.cnf created as /etc/my.cnf.d/mariadb-server.cnf.rpmnew
(out)
(out) Running scriptlet: mariadb-server-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64 8/15
(out) Cleanup : mariadb-3:10.3.32-2.module+el8.5.0+14124+14ced695.x86_64 9/15
(out) Running scriptlet: mariadb-server-3:10.3.32-2.module+el8.5.0+14124+14ced695.x86_64 10/15
(out) Cleanup : mariadb-server-3:10.3.32-2.module+el8.5.0+14124+14ced695.x86_64 10/15
(out) Running scriptlet: mariadb-server-3:10.3.32-2.module+el8.5.0+14124+14ced695.x86_64 10/15
(out) Cleanup : mariadb-gssapi-server-3:10.3.32-2.module+el8.5.0+14124+14ced695.x86_64 11/15
(out) Cleanup : mariadb-errmsg-3:10.3.32-2.module+el8.5.0+14124+14ced695.x86_64 12/15
(out) Cleanup : mariadb-common-3:10.3.32-2.module+el8.5.0+14124+14ced695.x86_64 13/15
(out) Cleanup : mariadb-backup-3:10.3.32-2.module+el8.5.0+14124+14ced695.x86_64 14/15
(out) Cleanup : mariadb-server-utils-3:10.3.32-2.module+el8.5.0+14124+14ced695.x86_64 15/15
(out) Running scriptlet: mysql-selinux-1.0.2-6.el8.noarch 15/15
(out) Running scriptlet: mariadb-server-utils-3:10.3.32-2.module+el8.5.0+14124+14ced695.x86_64 15/15
(out) Verifying : mysql-selinux-1.0.2-6.el8.noarch 1/15
(out) Verifying : mariadb-gssapi-server-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64 2/15
(out) Verifying : mariadb-gssapi-server-3:10.3.32-2.module+el8.5.0+14124+14ced695.x86_64 3/15
(out) Verifying : mariadb-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64 4/15
(out) Verifying : mariadb-3:10.3.32-2.module+el8.5.0+14124+14ced695.x86_64 5/15
(out) Verifying : mariadb-server-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64 6/15
(out) Verifying : mariadb-server-3:10.3.32-2.module+el8.5.0+14124+14ced695.x86_64 7/15
(out) Verifying : mariadb-common-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64 8/15
(out) Verifying : mariadb-common-3:10.3.32-2.module+el8.5.0+14124+14ced695.x86_64 9/15
(out) Verifying : mariadb-server-utils-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64 10/15
(out) Verifying : mariadb-server-utils-3:10.3.32-2.module+el8.5.0+14124+14ced695.x86_64 11/15
(out) Verifying : mariadb-errmsg-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64 12/15
(out) Verifying : mariadb-errmsg-3:10.3.32-2.module+el8.5.0+14124+14ced695.x86_64 13/15
(out) Verifying : mariadb-backup-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64 14/15
(out) Verifying : mariadb-backup-3:10.3.32-2.module+el8.5.0+14124+14ced695.x86_64 15/15
(out) Installed products updated.
(out)
(out) Upgraded:
(out) mariadb-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64 mariadb-backup-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64
(out) mariadb-common-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64 mariadb-errmsg-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64
(out) mariadb-gssapi-server-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64 mariadb-server-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64
(out) mariadb-server-utils-3:10.5.13-1.module+el8.5.0+14125+d11efe18.x86_64
(out) Installed:
(out) mysql-selinux-1.0.2-6.el8.noarch
(out)
(out) Complete!バージョンの確認
dnf module list mariadb
(out) Updating Subscription Management repositories.
(out)
(out) This system is registered with an entitlement server, but is not receiving updates. You can use subscription-manager to assign subscriptions.
(out)
(out) Last metadata expiration check: 0:35:02 ago on Tue 19 Jul 2022 05:09:25 PM JST.
(out) Red Hat Enterprise Linux 8 for x86_64 - AppStream from RHUI (RPMs)
(out) Name Stream Profiles Summary
(out) mariadb 10.3 [d] client, galera, server [d] MariaDB Module
(out) mariadb 10.5 [e] client, galera, server [d] [i] MariaDB Module
(out)
(out) Hint: [d]efault, [e]nabled, [x]disabled, [i]nstalled[e]nabled が 10.5 に切り替わり、プロファイルも [i]nstalled になりました。
mysql -V
(out) mysql Ver 15.1 Distrib 10.5.13-MariaDB, for Linux (x86_64) using EditLine wrapperまとめ
MariaDB 10.3 のサポートは 2023 年 5 月で終了するので、それまでに切り替えておきましょう。
コメント