yasuです。
自宅サーバーで運用しているMariaDB 10.5を10.11にアップグレードした際のメモです。
目次（クリックで開閉）
アップグレード対象の構成
仮想基盤
| ハイパーバイザー | Proxmox VE 9.2.3 |
| CPU | Intel Xeon E5-2650L v4 ✕ 1 |
| メモリ | 64GB |
| ストレージ（ローカル用） | Crucial SSD BX500 240GB |
| ストレージ（仮想サーバ用） | NFS 2TB |
| ネットワークI/F | NB-INT-X520DA1-S |
| GPU | nVidia GTX680 |
MariaDB 10.5 仮想サーバ
| OS | AlmaLinux 9.8 |
| CPU | 1ソケット 4コア |
| メモリ | 4GB |
| ストレージ | 50GB |
MariaDBの全データベースをバックアップ
# mysqldump --all-databases --single-transaction --quick --events --routines --triggers -u root -p > all_databases.sql
Enter password: mariadbのrootユーザーのパスワードを入力して[Enter]キー押下MariaDB停止
# systemctl stop mariadbMariaDB10.11インストール
# dnf module switch-to mariadb:10.11
メタデータの期限切れの最終確認: 1:26:27 前の 2026年06月10日 15時34分03秒 に実施しました。
依存関係が解決しました。
=========================================================================================================================================================================
パッケージ アーキテクチャー バージョン リポジトリー サイズ
=========================================================================================================================================================================
アップグレード:
mariadb x86_64 3:10.11.15-2.module_el9.7.0+216+9e1456a6 appstream 1.8 M
mariadb-backup x86_64 3:10.11.15-2.module_el9.7.0+216+9e1456a6 appstream 6.7 M
mariadb-common x86_64 3:10.11.15-2.module_el9.7.0+216+9e1456a6 appstream 27 k
mariadb-errmsg x86_64 3:10.11.15-2.module_el9.7.0+216+9e1456a6 appstream 253 k
mariadb-gssapi-server x86_64 3:10.11.15-2.module_el9.7.0+216+9e1456a6 appstream 15 k
mariadb-server x86_64 3:10.11.15-2.module_el9.7.0+216+9e1456a6 appstream 10 M
mariadb-server-utils x86_64 3:10.11.15-2.module_el9.7.0+216+9e1456a6 appstream 262 k
モジュールストリームの有効化中:
mariadb 10.11
トランザクションの概要
=========================================================================================================================================================================
アップグレード 7 パッケージ
ダウンロードサイズの合計: 19 M
これでよろしいですか? [y/N]: y ←yを入力して[Enter]キー押下MariaDB起動
# systemctl start mariadbMariaDBアップグレード
# mariadb-upgrade
Major version upgrade detected from 10.5.22-MariaDB to 10.11.15-MariaDB. Check required!
Phase 1/8: Checking and upgrading mysql database
Processing databases
mysql
mysql.column_stats OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.global_priv OK
mysql.gtid_slave_pos OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.index_stats OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.roles_mapping OK
mysql.servers OK
mysql.table_stats OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.transaction_registry OK
Phase 2/8: Installing used storage engines... Skipped
Phase 3/8: Running 'mysql_fix_privilege_tables'
Phase 4/8: Fixing views
mysql.user OK
sys.host_summary OK
sys.host_summary_by_file_io OK
sys.host_summary_by_file_io_type OK
sys.host_summary_by_stages OK
sys.host_summary_by_statement_latency OK
sys.host_summary_by_statement_type OK
sys.innodb_buffer_stats_by_schema OK
sys.innodb_buffer_stats_by_table OK
sys.innodb_lock_waits OK
sys.io_by_thread_by_latency OK
sys.io_global_by_file_by_bytes OK
sys.io_global_by_file_by_latency OK
sys.io_global_by_wait_by_bytes OK
sys.io_global_by_wait_by_latency OK
sys.latest_file_io OK
sys.memory_by_host_by_current_bytes OK
sys.memory_by_thread_by_current_bytes OK
sys.memory_by_user_by_current_bytes OK
sys.memory_global_by_current_bytes OK
sys.memory_global_total OK
sys.metrics OK
sys.processlist OK
sys.ps_check_lost_instrumentation OK
sys.schema_auto_increment_columns OK
sys.schema_index_statistics OK
sys.schema_object_overview OK
sys.schema_redundant_indexes OK
sys.schema_table_lock_waits OK
sys.schema_table_statistics OK
sys.schema_table_statistics_with_buffer OK
sys.schema_tables_with_full_table_scans OK
sys.schema_unused_indexes OK
sys.session OK
sys.session_ssl_status OK
sys.statement_analysis OK
sys.statements_with_errors_or_warnings OK
sys.statements_with_full_table_scans OK
sys.statements_with_runtimes_in_95th_percentile OK
sys.statements_with_sorting OK
sys.statements_with_temp_tables OK
sys.user_summary OK
sys.user_summary_by_file_io OK
sys.user_summary_by_file_io_type OK
sys.user_summary_by_stages OK
sys.user_summary_by_statement_latency OK
sys.user_summary_by_statement_type OK
sys.version OK
sys.wait_classes_global_by_avg_latency OK
sys.wait_classes_global_by_latency OK
sys.waits_by_host_by_latency OK
sys.waits_by_user_by_latency OK
sys.waits_global_by_latency OK
sys.x$host_summary OK
sys.x$host_summary_by_file_io OK
sys.x$host_summary_by_file_io_type OK
sys.x$host_summary_by_stages OK
sys.x$host_summary_by_statement_latency OK
sys.x$host_summary_by_statement_type OK
sys.x$innodb_buffer_stats_by_schema OK
sys.x$innodb_buffer_stats_by_table OK
sys.x$innodb_lock_waits OK
sys.x$io_by_thread_by_latency OK
sys.x$io_global_by_file_by_bytes OK
sys.x$io_global_by_file_by_latency OK
sys.x$io_global_by_wait_by_bytes OK
sys.x$io_global_by_wait_by_latency OK
sys.x$latest_file_io OK
sys.x$memory_by_host_by_current_bytes OK
sys.x$memory_by_thread_by_current_bytes OK
sys.x$memory_by_user_by_current_bytes OK
sys.x$memory_global_by_current_bytes OK
sys.x$memory_global_total OK
sys.x$processlist OK
sys.x$ps_digest_95th_percentile_by_avg_us OK
sys.x$ps_digest_avg_latency_distribution OK
sys.x$ps_schema_table_statistics_io OK
sys.x$schema_flattened_keys OK
sys.x$schema_index_statistics OK
sys.x$schema_table_lock_waits OK
sys.x$schema_table_statistics OK
sys.x$schema_table_statistics_with_buffer OK
sys.x$schema_tables_with_full_table_scans OK
sys.x$session OK
sys.x$statement_analysis OK
sys.x$statements_with_errors_or_warnings OK
sys.x$statements_with_full_table_scans OK
sys.x$statements_with_runtimes_in_95th_percentile OK
sys.x$statements_with_sorting OK
sys.x$statements_with_temp_tables OK
sys.x$user_summary OK
sys.x$user_summary_by_file_io OK
sys.x$user_summary_by_file_io_type OK
sys.x$user_summary_by_stages OK
sys.x$user_summary_by_statement_latency OK
sys.x$user_summary_by_statement_type OK
sys.x$wait_classes_global_by_avg_latency OK
sys.x$wait_classes_global_by_latency OK
sys.x$waits_by_host_by_latency OK
sys.x$waits_by_user_by_latency OK
sys.x$waits_global_by_latency OK
Phase 5/8: Fixing table and database names
Phase 6/8: Checking and upgrading tables
Processing databases
information_schema
nextcloud_db
nextcloud_db.oc_accounts OK
nextcloud_db.oc_accounts_data OK
nextcloud_db.oc_activity OK
nextcloud_db.oc_activity_mq OK
nextcloud_db.oc_addressbookchanges OK
nextcloud_db.oc_addressbooks OK
nextcloud_db.oc_appconfig OK
nextcloud_db.oc_appconfig_ex OK
nextcloud_db.oc_authorized_groups OK
nextcloud_db.oc_authtoken OK
nextcloud_db.oc_bruteforce_attempts OK
nextcloud_db.oc_calendar_appt_bookings OK
nextcloud_db.oc_calendar_appt_configs OK
nextcloud_db.oc_calendar_invitations OK
nextcloud_db.oc_calendar_proposal_dats OK
nextcloud_db.oc_calendar_proposal_dts OK
nextcloud_db.oc_calendar_proposal_pts OK
nextcloud_db.oc_calendar_proposal_vts OK
nextcloud_db.oc_calendar_reminders OK
nextcloud_db.oc_calendar_resources OK
nextcloud_db.oc_calendar_resources_md OK
nextcloud_db.oc_calendar_rooms OK
nextcloud_db.oc_calendar_rooms_md OK
nextcloud_db.oc_calendarchanges OK
nextcloud_db.oc_calendarobjects OK
nextcloud_db.oc_calendarobjects_props OK
nextcloud_db.oc_calendars OK
nextcloud_db.oc_calendars_federated OK
nextcloud_db.oc_calendarsubscriptions OK
nextcloud_db.oc_cards OK
nextcloud_db.oc_cards_properties OK
nextcloud_db.oc_circles_circle OK
nextcloud_db.oc_circles_event OK
nextcloud_db.oc_circles_member OK
nextcloud_db.oc_circles_membership OK
nextcloud_db.oc_circles_mount OK
nextcloud_db.oc_circles_mountpoint OK
nextcloud_db.oc_circles_remote OK
nextcloud_db.oc_circles_share_lock OK
nextcloud_db.oc_circles_token OK
nextcloud_db.oc_collres_accesscache OK
nextcloud_db.oc_collres_collections OK
nextcloud_db.oc_collres_resources OK
nextcloud_db.oc_comments OK
nextcloud_db.oc_comments_read_markers OK
nextcloud_db.oc_dav_absence OK
nextcloud_db.oc_dav_cal_proxy OK
nextcloud_db.oc_dav_shares OK
nextcloud_db.oc_direct_edit OK
nextcloud_db.oc_directlink OK
nextcloud_db.oc_ex_apps OK
nextcloud_db.oc_ex_apps_daemons OK
nextcloud_db.oc_ex_apps_routes OK
nextcloud_db.oc_ex_deploy_options OK
nextcloud_db.oc_ex_event_handlers OK
nextcloud_db.oc_ex_occ_commands OK
nextcloud_db.oc_ex_settings_forms OK
nextcloud_db.oc_ex_speech_to_text OK
nextcloud_db.oc_ex_speech_to_text_q OK
nextcloud_db.oc_ex_task_processing OK
nextcloud_db.oc_ex_text_processing OK
nextcloud_db.oc_ex_text_processing_q OK
nextcloud_db.oc_ex_translation OK
nextcloud_db.oc_ex_translation_q OK
nextcloud_db.oc_ex_ui_files_actions OK
nextcloud_db.oc_ex_ui_scripts OK
nextcloud_db.oc_ex_ui_states OK
nextcloud_db.oc_ex_ui_styles OK
nextcloud_db.oc_ex_ui_top_menu OK
nextcloud_db.oc_federated_invites OK
nextcloud_db.oc_federated_reshares OK
nextcloud_db.oc_file_locks OK
nextcloud_db.oc_filecache OK
nextcloud_db.oc_filecache_extended OK
nextcloud_db.oc_files_metadata OK
nextcloud_db.oc_files_metadata_index OK
nextcloud_db.oc_files_reminders OK
nextcloud_db.oc_files_trash OK
nextcloud_db.oc_files_versions OK
nextcloud_db.oc_flow_checks OK
nextcloud_db.oc_flow_operations OK
nextcloud_db.oc_flow_operations_scope OK
nextcloud_db.oc_group_admin OK
nextcloud_db.oc_group_user OK
nextcloud_db.oc_groups OK
nextcloud_db.oc_jobs OK
nextcloud_db.oc_known_users OK
nextcloud_db.oc_login_flow_v2 OK
nextcloud_db.oc_mail_accounts OK
nextcloud_db.oc_mail_aliases OK
nextcloud_db.oc_mail_attachments OK
nextcloud_db.oc_mail_classifiers OK
nextcloud_db.oc_mail_coll_addresses OK
nextcloud_db.oc_mail_local_messages OK
nextcloud_db.oc_mail_mailboxes OK
nextcloud_db.oc_mail_message_tags OK
nextcloud_db.oc_mail_messages OK
nextcloud_db.oc_mail_messages_retention OK
nextcloud_db.oc_mail_messages_snoozed OK
nextcloud_db.oc_mail_provisionings OK
nextcloud_db.oc_mail_recipients OK
nextcloud_db.oc_mail_smime_certificates OK
nextcloud_db.oc_mail_tags OK
nextcloud_db.oc_mail_trusted_senders OK
nextcloud_db.oc_memories OK
nextcloud_db.oc_memories_covers OK
nextcloud_db.oc_memories_failures OK
nextcloud_db.oc_memories_livephoto OK
nextcloud_db.oc_memories_mapclusters OK
nextcloud_db.oc_memories_places OK
nextcloud_db.oc_memories_planet OK
nextcloud_db.oc_migrations OK
nextcloud_db.oc_mimetypes OK
nextcloud_db.oc_mounts OK
nextcloud_db.oc_notifications OK
nextcloud_db.oc_notifications_pushhash OK
nextcloud_db.oc_notifications_settings OK
nextcloud_db.oc_oauth2_access_tokens OK
nextcloud_db.oc_oauth2_clients OK
nextcloud_db.oc_open_local_editor OK
nextcloud_db.oc_photos_albums OK
nextcloud_db.oc_photos_albums_collabs OK
nextcloud_db.oc_photos_albums_files OK
nextcloud_db.oc_preferences OK
nextcloud_db.oc_preferences_ex OK
nextcloud_db.oc_preview_locations OK
nextcloud_db.oc_preview_versions OK
nextcloud_db.oc_previews OK
nextcloud_db.oc_privacy_admins OK
nextcloud_db.oc_profile_config OK
nextcloud_db.oc_properties OK
nextcloud_db.oc_ratelimit_entries OK
nextcloud_db.oc_reactions OK
nextcloud_db.oc_recent_contact OK
nextcloud_db.oc_schedulingobjects OK
nextcloud_db.oc_sec_signatory OK
nextcloud_db.oc_share OK
nextcloud_db.oc_share_external OK
nextcloud_db.oc_shares_limits OK
nextcloud_db.oc_storages OK
nextcloud_db.oc_storages_credentials OK
nextcloud_db.oc_systemtag OK
nextcloud_db.oc_systemtag_group OK
nextcloud_db.oc_systemtag_object_mapping OK
nextcloud_db.oc_taskprocessing_tasks OK
nextcloud_db.oc_text2image_tasks OK
nextcloud_db.oc_text_documents OK
nextcloud_db.oc_text_sessions OK
nextcloud_db.oc_text_steps OK
nextcloud_db.oc_textprocessing_tasks OK
nextcloud_db.oc_trusted_servers OK
nextcloud_db.oc_twofactor_backupcodes OK
nextcloud_db.oc_twofactor_providers OK
nextcloud_db.oc_twofactor_totp_secrets OK
nextcloud_db.oc_user_status OK
nextcloud_db.oc_user_transfer_owner OK
nextcloud_db.oc_users OK
nextcloud_db.oc_vcategory OK
nextcloud_db.oc_vcategory_to_object OK
nextcloud_db.oc_webauthn OK
nextcloud_db.oc_webhook_listeners OK
nextcloud_db.oc_webhook_tokens OK
performance_schema
sys
sys.sys_config OK
wordpress_db
wordpress_db.wp_actionscheduler_actions OK
wordpress_db.wp_actionscheduler_claims OK
wordpress_db.wp_actionscheduler_groups OK
wordpress_db.wp_actionscheduler_logs OK
wordpress_db.wp_cocoon_accesses OK
wordpress_db.wp_cocoon_affiliate_tags OK
wordpress_db.wp_cocoon_function_texts OK
wordpress_db.wp_cocoon_item_rankings OK
wordpress_db.wp_cocoon_speech_balloons OK
wordpress_db.wp_commentmeta OK
wordpress_db.wp_comments OK
wordpress_db.wp_links OK
wordpress_db.wp_options OK
wordpress_db.wp_postmeta OK
wordpress_db.wp_posts OK
wordpress_db.wp_ppress_coupons OK
wordpress_db.wp_ppress_customers OK
wordpress_db.wp_ppress_forms OK
wordpress_db.wp_ppress_formsmeta OK
wordpress_db.wp_ppress_meta_data OK
wordpress_db.wp_ppress_ordermeta OK
wordpress_db.wp_ppress_orders OK
wordpress_db.wp_ppress_plans OK
wordpress_db.wp_ppress_sessions OK
wordpress_db.wp_ppress_subscriptions OK
wordpress_db.wp_siteguard_history OK
wordpress_db.wp_siteguard_login OK
wordpress_db.wp_term_relationships OK
wordpress_db.wp_term_taxonomy OK
wordpress_db.wp_termmeta OK
wordpress_db.wp_terms OK
wordpress_db.wp_usermeta OK
wordpress_db.wp_users OK
wordpress_db.wp_wpc_accesslocks OK
wordpress_db.wp_wpc_login_fails OK
wordpress_db.wp_wpforms_logs OK
wordpress_db.wp_wpforms_payment_meta OK
wordpress_db.wp_wpforms_payments OK
wordpress_db.wp_wpforms_tasks_meta OK
wordpress_db.wp_wpmailsmtp_debug_events OK
wordpress_db.wp_wpmailsmtp_tasks_meta OK
Phase 7/8: uninstalling plugins
Phase 8/8: Running 'FLUSH PRIVILEGES'
OK設定ファイル修正
/etc/my.cnf.d/mariadb-server.cnf 内にグループ名[mariadb-10.5]の記載があるので、そこだけ[mariadb-10.11]に修正しました。
# vi /etc/my.cnf.d/mariadb-server.cnf
# This group is only read by MariaDB-10.5 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.5]
↓
[mariadb-10.11]
保存終了します。
# systemctl restart mariadb
動作確認
自宅サーバーでMariaDBを使っているサービスはWordPress（本ブログ）とNextCloudがあるのですが、MariaDBアップグレード後も特に不具合なく動いているので、無事アップグレードできたものと思われます。