MariaDB 10.11 is LTS - MariaDB.orgImportant news: MariaDB 10.11, which just was declared RC, is a long-term maintenance version. The industry standard term to refer to that concept is LTS (as in...
目次
インストール手順
幸いにして Rocky Linux 9 では 10.11 がモジュールとして提供されているため、WordPress 程度しか動かしていない私のVPSはトラブルもなくあっさり終了しました。
[yuuichi@ns ~]# sudo systemctl enable --now mariadb
Created symlink /etc/systemd/system/mysql.service → /usr/lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/mysqld.service → /usr/lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /usr/lib/systemd/system/mariadb.service.
データベースログインのテスト
[yuuichi@ns ~]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.11.10-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| phpmyadmin |
| wordpress |
+--------------------+
5 rows in set (0.002 sec)
MariaDB [(none)]> quit;
Bye
データベースのアップグレード処理
[yuuichi@ns ~]# sudo mysql_upgrade
Major version upgrade detected from 10.5.16-MariaDB to 10.11.10-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
performance_schema
phpmyadmin
phpmyadmin.pma__bookmark OK
phpmyadmin.pma__central_columns OK
phpmyadmin.pma__column_info OK
phpmyadmin.pma__designer_settings OK
phpmyadmin.pma__export_templates OK
phpmyadmin.pma__favorite OK
phpmyadmin.pma__history OK
phpmyadmin.pma__navigationhiding OK
phpmyadmin.pma__pdf_pages OK
phpmyadmin.pma__recent OK
phpmyadmin.pma__relation OK
phpmyadmin.pma__savedsearches OK
phpmyadmin.pma__table_coords OK
phpmyadmin.pma__table_info OK
phpmyadmin.pma__table_uiprefs OK
phpmyadmin.pma__tracking OK
phpmyadmin.pma__userconfig OK
phpmyadmin.pma__usergroups OK
phpmyadmin.pma__users OK
sys
sys.sys_config OK
wordpress
wordpress.wp_bwpup_backups OK
wordpress.wp_cbnetpo_ping_optimizer OK
wordpress.wp_cmplz_cookiebanners OK
wordpress.wp_cmplz_cookies OK
wordpress.wp_cmplz_dnsmpd OK
wordpress.wp_cmplz_services OK
wordpress.wp_commentmeta OK
wordpress.wp_comments OK
wordpress.wp_democracyA OK
wordpress.wp_democracyIP OK
wordpress.wp_democracyQ OK
wordpress.wp_dlm_api_keys OK
wordpress.wp_dlm_cookiemeta OK
wordpress.wp_dlm_cookies OK
wordpress.wp_dlm_downloads OK
wordpress.wp_dlm_order OK
wordpress.wp_dlm_order_customer OK
wordpress.wp_dlm_order_item OK
wordpress.wp_dlm_order_transaction OK
wordpress.wp_dlm_reports_log OK
wordpress.wp_dlm_session OK
wordpress.wp_dmsguestbook OK
wordpress.wp_download_log OK
wordpress.wp_download_monitor_file_meta OK
wordpress.wp_download_monitor_files OK
wordpress.wp_download_monitor_formats OK
wordpress.wp_download_monitor_log OK
wordpress.wp_download_monitor_relationships OK
wordpress.wp_download_monitor_stats OK
wordpress.wp_download_monitor_taxonomies OK
wordpress.wp_ewwwio_images OK
wordpress.wp_ewwwio_queue OK
wordpress.wp_golfresult OK
wordpress.wp_golftable OK
wordpress.wp_jetpack_sync_queue OK
wordpress.wp_legacy_upgrade_queue_content OK
wordpress.wp_legacy_upgrade_queue_downloads OK
wordpress.wp_lifestream_feeds OK
wordpress.wp_links OK
wordpress.wp_options OK
wordpress.wp_popularpostsdata OK
wordpress.wp_popularpostssummary OK
wordpress.wp_popularpoststransients OK
wordpress.wp_post2tag OK
wordpress.wp_postmeta OK
wordpress.wp_posts OK
wordpress.wp_pt_meta OK
wordpress.wp_pt_templates OK
wordpress.wp_quotescollection OK
wordpress.wp_ratings OK
wordpress.wp_redirection_404 OK
wordpress.wp_redirection_groups OK
wordpress.wp_redirection_items OK
wordpress.wp_redirection_logs OK
wordpress.wp_seo_title_tag_category OK
wordpress.wp_seo_title_tag_tag OK
wordpress.wp_seo_title_tag_url OK
wordpress.wp_sharebar OK
wordpress.wp_social_links OK
wordpress.wp_swell_balloon OK
wordpress.wp_tag_synonyms OK
wordpress.wp_tags OK
wordpress.wp_term_relationships OK
wordpress.wp_term_taxonomy OK
wordpress.wp_termmeta OK
wordpress.wp_terms OK
wordpress.wp_tm_taskmeta OK
wordpress.wp_tm_tasks OK
wordpress.wp_usermeta OK
wordpress.wp_users OK
wordpress.wp_wordbooker_errorlogs OK
wordpress.wp_wordbooker_fb_friend_lists OK
wordpress.wp_wordbooker_fb_friends OK
wordpress.wp_wordbooker_postcomments OK
wordpress.wp_wordbooker_postlogs OK
wordpress.wp_wordbooker_process_queue OK
wordpress.wp_wordbooker_userdata OK
wordpress.wp_wordbooker_userstatus OK
wordpress.wp_wpie_template OK
wordpress.wp_wpo_404_detector OK
wordpress.wp_yarpp_related_cache OK
Phase 7/8: uninstalling plugins
Phase 8/8: Running 'FLUSH PRIVILEGES'
OK
[yuuichi@ns ~]# sudo systemctl restart mariadb
[yuuichi@ns ~]# sudo systemctl status mariadb
● mariadb.service - MariaDB 10.11 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; preset: disabled)
Active: active (running) since Mon 2025-12-08 18:59:23 JST; 6s ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Process: 9924 ExecStartPre=/usr/libexec/mariadb-check-socket (code=exited, status=0/SUCCESS)
Process: 9947 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir mariadb.service (code=exited, status=0/SUCCESS)
Process: 9993 ExecStartPost=/usr/libexec/mariadb-check-upgrade (code=exited, status=0/SUCCESS)
Main PID: 9982 (mariadbd)
Status: "Taking your SQL requests now..."
Tasks: 12 (limit: 10671)
Memory: 199.7M (peak: 201.7M)
CPU: 213ms
CGroup: /system.slice/mariadb.service
└─9982 /usr/libexec/mariadbd --basedir=/usr
Dec 08 18:59:22 ns.u-1.net systemd[1]: Starting MariaDB 10.11 database server...
Dec 08 18:59:22 ns.u-1.net mariadb-prepare-db-dir[9947]: Database MariaDB is probably initialized in /var/lib/mysql alr>
Dec 08 18:59:22 ns.u-1.net mariadb-prepare-db-dir[9947]: If this is not the case, make sure the /var/lib/mysql is empty>
Dec 08 18:59:23 ns.u-1.net systemd[1]: Started MariaDB 10.11 database server.
アップグレード後の確認処理
[yuuichi@ns ~]# mysql -u root -p -e "SELECT user, host, plugin FROM mysql.user;"
Enter password:
+-------------+-----------+-----------------------+
| User | Host | plugin |
+-------------+-----------+-----------------------+
| mariadb.sys | localhost | mysql_native_password |
| root | localhost | mysql_native_password |
| mysql | localhost | mysql_native_password |
| wordpress | localhost | mysql_native_password |
+-------------+-----------+-----------------------+
[yuuichi@ns ~]# mysql -u root -p -e "SHOW VARIABLES LIKE 'character_set_server';"
Enter password:
+----------------------+--------+
| Variable_name | Value |
+----------------------+--------+
| character_set_server | latin1 |
+----------------------+--------+
[yuuichi@ns ~]# mysql -u root -p -e "SHOW VARIABLES LIKE 'collation_server';"
Enter password:
+------------------+-------------------+
| Variable_name | Value |
+------------------+-------------------+
| collation_server | latin1_swedish_ci |
+------------------+-------------------+
コメント