当方のデータベースサーバーをMariaDB 11.8.3からMariaDB 11.8.6へアップデートしました。
概要
- 2026/02/04 MariaDB 11.8 (LTS) のマイナーバージョンアップMariaDB 11.8.6がリリースされました
- 当方のデータベースサーバーはMariaDB 10.5.27からMariaDB 11.8.3へメジャーアップグレードした以降、11.8.4, 11.8.5のマイナーバージョンアップをスルーしていたのですが、今回MariaDB 11.8.6へアップデートすることにしました
- なお、MariaDB 11.8.3アップグレード後のトラブルは今回のMariaDB 11.8.6へのアップデートで解消していました
手順
- データベースのバックアップ
- MariaDBの停止
- MariaDBのアップデート
- MariaDBの起動
データベースのバックアップ
- MaraDB推奨のMariabackupを使用します
MariaDB データのバックアップ | Red Hat Documentation
Mariabackupのインストール
# mariadb関連のインストール済パッケージを確認
$ sudo dnf list installed | grep mariadb
MariaDB-client.x86_64 11.8.3-1.el9 @mariadb
MariaDB-client-compat.noarch 11.8.3-1.el9 @mariadb
MariaDB-common.x86_64 11.8.3-1.el9 @mariadb
MariaDB-server.x86_64 11.8.3-1.el9 @mariadb
MariaDB-server-compat.noarch 11.8.3-1.el9 @mariadb
MariaDB-shared.x86_64 11.8.3-1.el9 @mariadb
galera-4.x86_64 26.4.23-1.el9 @mariadb
# Mariabackupのインストール
$ sudo dnf install -y MariaDB-backup
Last metadata expiration check: 2:22:16 ago on Tue 10 Feb 2026 05:32:27 AM JST.
Dependencies resolved.
=========================================================================================================================================================================================
Package Architecture Version Repository Size
=========================================================================================================================================================================================
Installing:
MariaDB-backup x86_64 11.8.6-1.el9 mariadb 7.7 M
Transaction Summary
=========================================================================================================================================================================================
Install 1 Package
Total download size: 7.7 M
Installed size: 32 M
Downloading Packages:
MariaDB-backup-11.8.6-1.el9.x86_64.rpm 5.7 MB/s | 7.7 MB 00:01
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 5.7 MB/s | 7.7 MB 00:01
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : MariaDB-backup-11.8.6-1.el9.x86_64 1/1
Running scriptlet: MariaDB-backup-11.8.6-1.el9.x86_64 1/1
Verifying : MariaDB-backup-11.8.6-1.el9.x86_64 1/1
Installed:
MariaDB-backup-11.8.6-1.el9.x86_64
Complete!
Mariabackupの実行
- Red Hatのドキュメンテーションを参考に実行しましたが、次のとおり、mariabackupではなく、mariadb-backupを使用するよう警告を受けています
mariabackup: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb-backup' instead
mariabackup: 非推奨のプログラム名です。将来のリリースで削除される予定です。代わりに '/usr/bin/mariadb-backup' を使用してください。
Google翻訳 - バックアップは完了しているようです
- なお、当初オプションのuser指定に別のユーザーを指定していたのですが、権限がないと指摘されてしまいました。
Mariabackup のユーザーは、RELOAD、LOCK TABLES、および REPLICATION CLIENT の権限が必要です。MariaDB データのバックアップ | Red Hat Documentation
- 確認したところ、REPLICATION CLIENTの権限が付与されていなかったので、rootで実行しています
# mariadb ユーザー権限確認 $ sudo mysql MariaDB [(none)]> show grants for 'hogehoge';
# Mariabackup実行
# 推奨プログラム名: mariadb-backup
$ sudo mariabackup --backup --target-dir /tmp/mariadb_backup --user=root
mariabackup: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb-backup' instead
[00] 2026-02-10 17:00:28 Connecting to MariaDB server host: localhost, user: root, password: not set, port: not set, socket: not set
[00] 2026-02-10 17:00:29 Using server version 11.8.3-MariaDB
mariabackup based on MariaDB server 11.8.6-MariaDB Linux (x86_64)
[00] 2026-02-10 17:00:29 uses posix_fadvise().
[00] 2026-02-10 17:00:29 cd to /var/lib/mysql/
[00] 2026-02-10 17:00:29 open files limit requested 0, set to 1024
[00] 2026-02-10 17:00:29 mariabackup: using the following InnoDB configuration:
[00] 2026-02-10 17:00:29 innodb_data_home_dir =
[00] 2026-02-10 17:00:29 innodb_data_file_path = ibdata1:12M:autoextend
[00] 2026-02-10 17:00:29 innodb_log_group_home_dir = ./
# 中略
[00] 2026-02-10 17:00:43 Backup created in directory '/tmp/mariadb_backup/'
[00] 2026-02-10 17:00:43 Writing backup-my.cnf
[00] 2026-02-10 17:00:43 ...done
[00] 2026-02-10 17:00:43 Writing mariadb_backup_info
[00] 2026-02-10 17:00:43 ...done
[00] 2026-02-10 17:00:43 Redo log (from LSN 1775186407 to 1843529043) was copied.
[00] 2026-02-10 17:00:43 completed OK!
# バックアップデータの確認
$ ls -laZ /tmp/mariadb_backup/
total 175832
drwxr-xr-x. 6 root root unconfined_u:object_r:user_tmp_t:s0 4096 Feb 10 17:00 .
drwxrwxrwt. 12 root root system_u:object_r:tmp_t:s0 4096 Feb 10 17:00 ..
-rw-r-----. 1 root root unconfined_u:object_r:user_tmp_t:s0 491520 Feb 10 17:00 aria_log.00000001
-rw-r-----. 1 root root unconfined_u:object_r:user_tmp_t:s0 52 Feb 10 17:00 aria_log_control
-rw-r-----. 1 root root unconfined_u:object_r:user_tmp_t:s0 285 Feb 10 17:00 backup-my.cnf
-rw-r-----. 1 root root unconfined_u:object_r:user_tmp_t:s0 79691776 Feb 10 17:00 ibdata1
-rw-r-----. 1 root root unconfined_u:object_r:user_tmp_t:s0 68354924 Feb 10 17:00 ib_logfile0
drwx------. 2 root root unconfined_u:object_r:user_tmp_t:s0 8192 Feb 10 17:00 jml_01
-rw-r-----. 1 root root unconfined_u:object_r:user_tmp_t:s0 107 Feb 10 17:00 mariadb_backup_checkpoints
-rw-r-----. 1 root root unconfined_u:object_r:user_tmp_t:s0 437 Feb 10 17:00 mariadb_backup_info
drwx------. 2 root root unconfined_u:object_r:user_tmp_t:s0 4096 Feb 10 17:00 mysql
drwx------. 2 root root unconfined_u:object_r:user_tmp_t:s0 20 Feb 10 17:00 performance_schema
drwx------. 2 root root unconfined_u:object_r:user_tmp_t:s0 8192 Feb 10 17:00 sys
-rw-r-----. 1 root root unconfined_u:object_r:user_tmp_t:s0 10485760 Feb 10 17:00 undo001
-rw-r-----. 1 root root unconfined_u:object_r:user_tmp_t:s0 10485760 Feb 10 17:00 undo002
-rw-r-----. 1 root root unconfined_u:object_r:user_tmp_t:s0 10485760 Feb 10 17:00 undo003
MariaDBの停止
- アップデート前にmariadbを停止します
# mariadbの停止
$ sudo systemctl stop mariadb
# mariadbの状態確認
$ sudo systemctl status mariadb
○ mariadb.service - MariaDB 11.8.3 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: inactive (dead) since Tue 2026-02-10 17:13:11 JST; 11s ago
Duration: 3month 2w 1h 32min 51.401s
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Process: 1700637 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && echo _WSREP_START_POSITION=$VAR > /var/lib>
Process: 1700648 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1700661 ExecStartPost=/bin/rm -f /var/lib/mysql/wsrep-start-position (code=exited, status=0/SUCCESS)
Main PID: 1700648 (code=exited, status=0/SUCCESS)
Status: "MariaDB server is down"
CPU: 1h 25min 16.059s
Feb 10 17:13:09 x210-131-209-119 mariadbd[1700648]: 2026-02-10 17:13:09 0 [Note] InnoDB: Starting shutdown...
Feb 10 17:13:09 x210-131-209-119 mariadbd[1700648]: 2026-02-10 17:13:09 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
Feb 10 17:13:09 x210-131-209-119 mariadbd[1700648]: 2026-02-10 17:13:09 0 [Note] InnoDB: Restricted to 2028 pages due to innodb_buf_pool_dump_pct=25
Feb 10 17:13:09 x210-131-209-119 mariadbd[1700648]: 2026-02-10 17:13:09 0 [Note] InnoDB: Buffer pool(s) dump completed at 260210 17:13:09
Feb 10 17:13:11 x210-131-209-119 mariadbd[1700648]: 2026-02-10 17:13:11 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Feb 10 17:13:11 x210-131-209-119 mariadbd[1700648]: 2026-02-10 17:13:11 0 [Note] InnoDB: Shutdown completed; log sequence number 1844255102; transaction id 1602337
Feb 10 17:13:11 x210-131-209-119 mariadbd[1700648]: 2026-02-10 17:13:11 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Feb 10 17:13:11 x210-131-209-119 systemd[1]: mariadb.service: Deactivated successfully.
Feb 10 17:13:11 x210-131-209-119 systemd[1]: Stopped MariaDB 11.8.3 database server.
Feb 10 17:13:11 x210-131-209-119 systemd[1]: mariadb.service: Consumed 1h 25min 16.059s CPU time.
MariaDBのアップデート
MariaDBの入手可能なバージョンの確認
- MariaDB 11.8 (LTS)最新のMariaDB 11.8.6が入手可能か確認します
# mariadb-serverの入手可能なバージョンの確認
$ sudo dnf --showduplicates list mariadb-server
[sudo] password for administrator:
Last metadata expiration check: 0:34:24 ago on Tue 10 Feb 2026 04:31:28 PM JST.
Installed Packages
MariaDB-server.x86_64 11.8.3-1.el9 @mariadb
Available Packages
MariaDB-server.x86_64 11.8.4-1.el9 mariadb
MariaDB-server.x86_64 11.8.5-1.el9 mariadb
MariaDB-server.x86_64 11.8.6-1.el9 mariadb
mariadb-server.x86_64 3:10.5.29-2.el9_6 appstream
mariadb-server.x86_64 3:10.5.29-3.el9_7 appstream
# mariadb-clientの入手可能なバージョンの確認
$ sudo dnf --showduplicates list mariadb-client
[sudo] password for administrator:
Last metadata expiration check: 0:40:39 ago on Tue 10 Feb 2026 04:31:28 PM JST.
Installed Packages
MariaDB-client.x86_64 11.8.3-1.el9 @mariadb
Available Packages
MariaDB-client.x86_64 11.8.4-1.el9 mariadb
MariaDB-client.x86_64 11.8.5-1.el9 mariadb
MariaDB-client.x86_64 11.8.6-1.el9 mariadb
MariaDBアップデート実施
# mariadbアップデート実施
$ sudo dnf update MariaDB-server MariaDB-client
Last metadata expiration check: 0:45:31 ago on Tue 10 Feb 2026 04:31:28 PM JST.
Dependencies resolved.
=========================================================================================================================================================================================
Package Architecture Version Repository Size
=========================================================================================================================================================================================
Upgrading:
MariaDB-client x86_64 11.8.6-1.el9 mariadb 9.5 M
MariaDB-server x86_64 11.8.6-1.el9 mariadb 19 M
Installing dependencies:
mysql-selinux noarch 1.0.14-1.el9_6 appstream 36 k
Transaction Summary
=========================================================================================================================================================================================
Install 1 Package
Upgrade 2 Packages
Total download size: 28 M
Is this ok [y/N]: y
Downloading Packages:
(1/3): mysql-selinux-1.0.14-1.el9_6.noarch.rpm 2.2 MB/s | 36 kB 00:00
(2/3): MariaDB-client-11.8.6-1.el9.x86_64.rpm 15 MB/s | 9.5 MB 00:00
(3/3): MariaDB-server-11.8.6-1.el9.x86_64.rpm 19 MB/s | 19 MB 00:00
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 16 MB/s | 28 MB 00:01
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Upgrading : MariaDB-client-11.8.6-1.el9.x86_64 1/5
Running scriptlet: mysql-selinux-1.0.14-1.el9_6.noarch 2/5
Installing : mysql-selinux-1.0.14-1.el9_6.noarch 2/5
Running scriptlet: mysql-selinux-1.0.14-1.el9_6.noarch 2/5
libsemanage.semanage_direct_install_info: Overriding mysql module at lower priority 100 with module at priority 200.
Running scriptlet: MariaDB-server-11.8.6-1.el9.x86_64 3/5
usermod: no changes
Upgrading : MariaDB-server-11.8.6-1.el9.x86_64 3/5
Running scriptlet: MariaDB-server-11.8.6-1.el9.x86_64 3/5
Running scriptlet: MariaDB-server-11.8.3-1.el9.x86_64 4/5
Cleanup : MariaDB-server-11.8.3-1.el9.x86_64 4/5
Running scriptlet: MariaDB-server-11.8.3-1.el9.x86_64 4/5
Cleanup : MariaDB-client-11.8.3-1.el9.x86_64 5/5
Running scriptlet: mysql-selinux-1.0.14-1.el9_6.noarch 5/5
Running scriptlet: MariaDB-server-11.8.6-1.el9.x86_64 5/5
Running scriptlet: MariaDB-client-11.8.3-1.el9.x86_64 5/5
Verifying : mysql-selinux-1.0.14-1.el9_6.noarch 1/5
Verifying : MariaDB-client-11.8.6-1.el9.x86_64 2/5
Verifying : MariaDB-client-11.8.3-1.el9.x86_64 3/5
Verifying : MariaDB-server-11.8.6-1.el9.x86_64 4/5
Verifying : MariaDB-server-11.8.3-1.el9.x86_64 5/5
Upgraded:
MariaDB-client-11.8.6-1.el9.x86_64 MariaDB-server-11.8.6-1.el9.x86_64
Installed:
mysql-selinux-1.0.14-1.el9_6.noarch
Complete!
# mariadb状態確認
# まだシャットダウン状態ですが、MariaDB 11.8.6のバージョンを確認できます
$ sudo systemctl status mariadb
○ mariadb.service - MariaDB 11.8.6 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: inactive (dead) since Tue 2026-02-10 17:13:11 JST; 5min ago
Duration: 3month 2w 1h 32min 51.401s
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Main PID: 1700648 (code=exited, status=0/SUCCESS)
Status: "MariaDB server is down"
CPU: 1h 25min 16.059s
Feb 10 17:13:09 x210-131-209-119 mariadbd[1700648]: 2026-02-10 17:13:09 0 [Note] InnoDB: Starting shutdown...
Feb 10 17:13:09 x210-131-209-119 mariadbd[1700648]: 2026-02-10 17:13:09 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
Feb 10 17:13:09 x210-131-209-119 mariadbd[1700648]: 2026-02-10 17:13:09 0 [Note] InnoDB: Restricted to 2028 pages due to innodb_buf_pool_dump_pct=25
Feb 10 17:13:09 x210-131-209-119 mariadbd[1700648]: 2026-02-10 17:13:09 0 [Note] InnoDB: Buffer pool(s) dump completed at 260210 17:13:09
Feb 10 17:13:11 x210-131-209-119 mariadbd[1700648]: 2026-02-10 17:13:11 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Feb 10 17:13:11 x210-131-209-119 mariadbd[1700648]: 2026-02-10 17:13:11 0 [Note] InnoDB: Shutdown completed; log sequence number 1844255102; transaction id 1602337
Feb 10 17:13:11 x210-131-209-119 mariadbd[1700648]: 2026-02-10 17:13:11 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Feb 10 17:13:11 x210-131-209-119 systemd[1]: mariadb.service: Deactivated successfully.
Feb 10 17:13:11 x210-131-209-119 systemd[1]: Stopped MariaDB 11.8.3 database server.
Feb 10 17:13:11 x210-131-209-119 systemd[1]: mariadb.service: Consumed 1h 25min 16.059s CPU time.
MariaDBの起動
- MariaDBを起動します
# mariadb起動
$ sudo systemctl start mariadb
# mariadb状態確認
$ sudo systemctl status mariadb
● mariadb.service - MariaDB 11.8.6 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Tue 2026-02-10 17:36:35 JST; 12s ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Process: 906120 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && echo _WSREP_START_POSITION=$VAR > /run/mari>
Process: 906144 ExecStartPost=/bin/rm -f /run/mariadb/wsrep-start-position /run/mariadb/wsrep-new-cluster (code=exited, status=0/SUCCESS)
Main PID: 906130 (mariadbd)
Status: "Taking your SQL requests now..."
Tasks: 13 (limit: 13398)
Memory: 140.2M
CPU: 1.669s
CGroup: /system.slice/mariadb.service
└─906130 /usr/sbin/mariadbd
Feb 10 17:36:34 x210-131-209-119 mariadbd[906130]: 2026-02-10 17:36:34 0 [Note] Plugin 'FEEDBACK' is disabled.
Feb 10 17:36:34 x210-131-209-119 mariadbd[906130]: 2026-02-10 17:36:34 0 [Note] Plugin 'wsrep-provider' is disabled.
Feb 10 17:36:34 x210-131-209-119 mariadbd[906130]: 2026-02-10 17:36:34 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Feb 10 17:36:35 x210-131-209-119 mariadbd[906130]: 2026-02-10 17:36:35 0 [Note] InnoDB: Buffer pool(s) load completed at 260210 17:36:35
Feb 10 17:36:35 x210-131-209-119 mariadbd[906130]: 2026-02-10 17:36:35 0 [Note] Server socket created on IP: '0.0.0.0', port: '3306'.
Feb 10 17:36:35 x210-131-209-119 mariadbd[906130]: 2026-02-10 17:36:35 0 [Note] Server socket created on IP: '::', port: '3306'.
Feb 10 17:36:35 x210-131-209-119 mariadbd[906130]: 2026-02-10 17:36:35 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
Feb 10 17:36:35 x210-131-209-119 mariadbd[906130]: 2026-02-10 17:36:35 0 [Note] /usr/sbin/mariadbd: ready for connections.
Feb 10 17:36:35 x210-131-209-119 mariadbd[906130]: Version: '11.8.6-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
Feb 10 17:36:35 x210-131-209-119 systemd[1]: Started MariaDB 11.8.6 database server.
# mariadb-upgradeは不要でした
# '両方とも 11.8 なので、11.8.6-MariaDB に対して再度 mariadb-upgrade を実行する必要はありません。'
$ sudo mariadb-upgrade -u hogehoge -p
Enter password:
This installation of MariaDB is already upgraded to 11.8.3-MariaDB.
There is no need to run mariadb-upgrade again for 11.8.6-MariaDB, because they're both 11.8.
You can use --force if you still want to run mariadb-upgrade
php-fpmのmysql.sockへの接続拒否トラブルの解消
- 次の記事で説明したMariaDB 11.8.3アップグレード後のトラブルは今回のMariaDB 11.8.6へのアップデートで解消していました
MariaDB 11.8 (LTS)へアップグレード
- 上記記事で説明のとおり、恐らくはMariaDB 11.8.4で解消していたのではないでしょうか
- 次のとおり、暫定的対処策だったSELinuxのカスタムポリシーを無効にした状態でもJoomla!の動作に問題ありません
# SELinuxの状態確認
$ sudo getenforce
Enforcing
# 読み込まれているモジュール名の確認 (myで始まるモジュール)
$ sudo semodule -l | grep '^my'
my_mysql_sock
mysql
mythtv
# audit2allowで作成したカスタムモジュールのmy_mysql_sockが読み込まれています
# カスタムモジュールmy_mysql_sockの無効化
$ sudo semodule -d my_mysql_sock
# 読み込まれているモジュール名の再確認 (myで始まるモジュール)
$ sudo semodule -l | grep '^my'
mysql
mythtv
# my_mysql_sockは読み込まれていません
# 念のため、auditログにAVC拒否を確認します
$ sudo ausearch -m avc -ts recent
<no matches>
# AVC拒否は記録されていません