{"id":4916,"date":"2022-02-04T22:50:12","date_gmt":"2022-02-04T13:50:12","guid":{"rendered":"https:\/\/higherhope.net\/?p=4916"},"modified":"2024-04-10T21:42:02","modified_gmt":"2024-04-10T12:42:02","slug":"mariadb%e3%82%9210-3%e3%81%8b%e3%82%8910-5%e3%81%b8upgrade%e3%81%97%e3%81%a6%e3%81%bf%e3%81%9f%e3%80%82","status":"publish","type":"post","link":"https:\/\/higherhope.net\/?p=4916","title":{"rendered":"mariadb\u309210.3\u304b\u308910.5\u3078upgrade\u3057\u3066\u307f\u305f\u3002"},"content":{"rendered":"

mariadb\u309210.3\u304b\u308910.5\u3078upgrade\u3057\u3066\u307f\u305f\u30e1\u30e2<\/p>\n

OS\u306f
\n# cat \/etc\/redhat-release
\nCentOS Stream release 8<\/code><\/p>\n

\u73fe\u5728\u306emariadb\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u78ba\u8a8d
\n# mysql --version
\nmysql Ver 15.1 Distrib 10.3.28-MariaDB, for Linux (x86_64) using readline 5.1<\/code><\/p>\n

\u4f5c\u696d\u958b\u59cb\u306e\u524d\u306b\u5ff5\u306e\u305f\u3081DB\u3092\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u3066\u304a\u304d\u307e\u3059\u3002
\n# mysqldump -h localhost -u root -p --databases zabbix > zabbix.sql<\/code><\/p>\n

\u305d\u308c\u3067\u306f\u4f5c\u696d\u958b\u59cb\u3067\u3059\u3002
\n\u73fe\u5728\u306edefault\u3092\u78ba\u8a8d
\n# dnf module list mariadb
\n\u30e1\u30bf\u30c7\u30fc\u30bf\u306e\u671f\u9650\u5207\u308c\u306e\u6700\u7d42\u78ba\u8a8d: 0:39:59 \u6642\u9593\u524d\u306e 2022\u5e7402\u670804\u65e5 16\u664209\u520606\u79d2 \u306b\u5b9f\u65bd\u3057\u307e\u3057\u305f\u3002
\nCentOS Stream 8 - AppStream
\nName Stream Profiles Summary
\nmariadb 10.3 [d][e] client, galera, server [d] MariaDB Module
\nmariadb 10.5 client, galera, server [d] MariaDB Module
\n\u30d2\u30f3\u30c8: [d]efault, [e]nabled, [x]disabled, [i]nstalled<\/code>
\n\u73fe\u572810.3\u304cdefault\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002
\nmoduler\u30ea\u30bb\u30c3\u30c8\u3092\u304b\u3051\u3066
\n# dnf module reset mariadb<\/code><\/p>\n

10.5\u3092\u6307\u5b9a\u3057\u3066install
\n# dnf module install mariadb:10.5
\n\u7565\uff5e
\n\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u6e08\u307f:
\n mariadb-3:10.5.9-1.module_el8.5.0+732+7afc82e7.x86_64
\n mariadb-backup-3:10.5.9-1.module_el8.5.0+732+7afc82e7.x86_64
\n mariadb-common-3:10.5.9-1.module_el8.5.0+732+7afc82e7.x86_64
\n mariadb-errmsg-3:10.5.9-1.module_el8.5.0+732+7afc82e7.x86_64
\n mariadb-gssapi-server-3:10.5.9-1.module_el8.5.0+732+7afc82e7.x86_64
\n mariadb-server-3:10.5.9-1.module_el8.5.0+732+7afc82e7.x86_64
\n mariadb-server-utils-3:10.5.9-1.module_el8.5.0+732+7afc82e7.x86_64
\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6e08\u307f:
\n mysql-selinux-1.0.2-4.el8.noarch
\n\u5b8c\u4e86\u3057\u307e\u3057\u305f!<\/code><\/p>\n

\u78ba\u8a8d
\n# mysql --version
\nmysql Ver 15.1 Distrib 10.5.9-MariaDB, for Linux (x86_64) using EditLine wrapper<\/code><\/p>\n

dnf module\u3092\u4f7f\u3046\u3068\u7c21\u5358\u306bupgrade\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

mariadb\u309210.3\u304b\u308910.5\u3078upgrade\u3057\u3066\u307f\u305f\u30e1\u30e2 OS\u306f # cat \/etc\/redhat-release CentOS Stream release 8 \u73fe\u5728\u306emariadb\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u78ba\u8a8d # my… Continue reading → <\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[178,4,184],"tags":[180],"class_list":["post-4916","post","type-post","status-publish","format-standard","hentry","category-centos8","category-linux","category-mariadb","tag-centos8"],"yoast_head":"\nmariadb\u309210.3\u304b\u308910.5\u3078upgrade\u3057\u3066\u307f\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/higherhope.net\/?p=4916\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"mariadb\u309210.3\u304b\u308910.5\u3078upgrade\u3057\u3066\u307f\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\" \/>\n<meta property=\"og:description\" content=\"mariadb\u309210.3\u304b\u308910.5\u3078upgrade\u3057\u3066\u307f\u305f\u30e1\u30e2 OS\u306f # cat \/etc\/redhat-release CentOS Stream release 8 \u73fe\u5728\u306emariadb\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u78ba\u8a8d # my... Continue reading →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/higherhope.net\/?p=4916\" \/>\n<meta property=\"og:site_name\" content=\"\u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-04T13:50:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-10T12:42:02+00:00\" \/>\n<meta name=\"author\" content=\"higherhope\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@higherhope5963\" \/>\n<meta name=\"twitter:site\" content=\"@higherhope5963\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"higherhope\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"1\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/higherhope.net\/?p=4916#article\",\"isPartOf\":{\"@id\":\"https:\/\/higherhope.net\/?p=4916\"},\"author\":{\"name\":\"higherhope\",\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af\"},\"headline\":\"mariadb\u309210.3\u304b\u308910.5\u3078upgrade\u3057\u3066\u307f\u305f\u3002\",\"datePublished\":\"2022-02-04T13:50:12+00:00\",\"dateModified\":\"2024-04-10T12:42:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/higherhope.net\/?p=4916\"},\"wordCount\":14,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af\"},\"keywords\":[\"CentOS8\"],\"articleSection\":[\"CentOS8\",\"linux\",\"MariaDB\"],\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/higherhope.net\/?p=4916#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/higherhope.net\/?p=4916\",\"url\":\"https:\/\/higherhope.net\/?p=4916\",\"name\":\"mariadb\u309210.3\u304b\u308910.5\u3078upgrade\u3057\u3066\u307f\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\",\"isPartOf\":{\"@id\":\"https:\/\/higherhope.net\/#website\"},\"datePublished\":\"2022-02-04T13:50:12+00:00\",\"dateModified\":\"2024-04-10T12:42:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/higherhope.net\/?p=4916#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/higherhope.net\/?p=4916\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/higherhope.net\/?p=4916#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u30db\u30fc\u30e0\",\"item\":\"https:\/\/higherhope.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"mariadb\u309210.3\u304b\u308910.5\u3078upgrade\u3057\u3066\u307f\u305f\u3002\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/higherhope.net\/#website\",\"url\":\"https:\/\/higherhope.net\/\",\"name\":\"\u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\",\"description\":\"\u304a\u3063\u3055\u3093\u307e\u3060\u307e\u3060\u697d\u3067\u304d\u307e\u305b\u3093\u3002\",\"publisher\":{\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/higherhope.net\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af\",\"name\":\"higherhope\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/higherhope.net\/wp-content\/uploads\/2018\/09\/DSC_0367.jpg\",\"contentUrl\":\"https:\/\/higherhope.net\/wp-content\/uploads\/2018\/09\/DSC_0367.jpg\",\"width\":700,\"height\":394,\"caption\":\"higherhope\"},\"logo\":{\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/higherhope5963\"],\"url\":\"https:\/\/higherhope.net\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"mariadb\u309210.3\u304b\u308910.5\u3078upgrade\u3057\u3066\u307f\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/higherhope.net\/?p=4916","og_locale":"ja_JP","og_type":"article","og_title":"mariadb\u309210.3\u304b\u308910.5\u3078upgrade\u3057\u3066\u307f\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","og_description":"mariadb\u309210.3\u304b\u308910.5\u3078upgrade\u3057\u3066\u307f\u305f\u30e1\u30e2 OS\u306f # cat \/etc\/redhat-release CentOS Stream release 8 \u73fe\u5728\u306emariadb\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u78ba\u8a8d # my... Continue reading →","og_url":"https:\/\/higherhope.net\/?p=4916","og_site_name":"\u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","article_published_time":"2022-02-04T13:50:12+00:00","article_modified_time":"2024-04-10T12:42:02+00:00","author":"higherhope","twitter_card":"summary_large_image","twitter_creator":"@higherhope5963","twitter_site":"@higherhope5963","twitter_misc":{"\u57f7\u7b46\u8005":"higherhope","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"1\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/higherhope.net\/?p=4916#article","isPartOf":{"@id":"https:\/\/higherhope.net\/?p=4916"},"author":{"name":"higherhope","@id":"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af"},"headline":"mariadb\u309210.3\u304b\u308910.5\u3078upgrade\u3057\u3066\u307f\u305f\u3002","datePublished":"2022-02-04T13:50:12+00:00","dateModified":"2024-04-10T12:42:02+00:00","mainEntityOfPage":{"@id":"https:\/\/higherhope.net\/?p=4916"},"wordCount":14,"commentCount":0,"publisher":{"@id":"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af"},"keywords":["CentOS8"],"articleSection":["CentOS8","linux","MariaDB"],"inLanguage":"ja","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/higherhope.net\/?p=4916#respond"]}]},{"@type":"WebPage","@id":"https:\/\/higherhope.net\/?p=4916","url":"https:\/\/higherhope.net\/?p=4916","name":"mariadb\u309210.3\u304b\u308910.5\u3078upgrade\u3057\u3066\u307f\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","isPartOf":{"@id":"https:\/\/higherhope.net\/#website"},"datePublished":"2022-02-04T13:50:12+00:00","dateModified":"2024-04-10T12:42:02+00:00","breadcrumb":{"@id":"https:\/\/higherhope.net\/?p=4916#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/higherhope.net\/?p=4916"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/higherhope.net\/?p=4916#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/higherhope.net\/"},{"@type":"ListItem","position":2,"name":"mariadb\u309210.3\u304b\u308910.5\u3078upgrade\u3057\u3066\u307f\u305f\u3002"}]},{"@type":"WebSite","@id":"https:\/\/higherhope.net\/#website","url":"https:\/\/higherhope.net\/","name":"\u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","description":"\u304a\u3063\u3055\u3093\u307e\u3060\u307e\u3060\u697d\u3067\u304d\u307e\u305b\u3093\u3002","publisher":{"@id":"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/higherhope.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":["Person","Organization"],"@id":"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af","name":"higherhope","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/higherhope.net\/#\/schema\/person\/image\/","url":"https:\/\/higherhope.net\/wp-content\/uploads\/2018\/09\/DSC_0367.jpg","contentUrl":"https:\/\/higherhope.net\/wp-content\/uploads\/2018\/09\/DSC_0367.jpg","width":700,"height":394,"caption":"higherhope"},"logo":{"@id":"https:\/\/higherhope.net\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/x.com\/higherhope5963"],"url":"https:\/\/higherhope.net\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/posts\/4916","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/higherhope.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4916"}],"version-history":[{"count":11,"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/posts\/4916\/revisions"}],"predecessor-version":[{"id":5597,"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/posts\/4916\/revisions\/5597"}],"wp:attachment":[{"href":"https:\/\/higherhope.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4916"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/higherhope.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4916"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/higherhope.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4916"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}