{"id":3183,"date":"2019-10-12T13:27:49","date_gmt":"2019-10-12T04:27:49","guid":{"rendered":"http:\/\/blog.rutake.com\/techmemo\/?p=3183"},"modified":"2019-10-12T13:27:51","modified_gmt":"2019-10-12T04:27:51","slug":"mariadb-5-5%e3%81%8b%e3%82%8910-3%e3%81%ab%e3%82%a2%e3%83%83%e3%83%97%e3%82%b0%e3%83%ac%e3%83%bc%e3%83%89","status":"publish","type":"post","link":"https:\/\/blog.rutake.com\/techmemo\/2019\/10\/12\/mariadb-5-5%e3%81%8b%e3%82%8910-3%e3%81%ab%e3%82%a2%e3%83%83%e3%83%97%e3%82%b0%e3%83%ac%e3%83%bc%e3%83%89\/","title":{"rendered":"Mariadb 5.5\u304b\u308910.3\u306b\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9"},"content":{"rendered":"\n<p>CentOS7\u6a19\u6e96\u306eMariaDB\u306f5.5(MySQL 5.5\u76f8\u5f53)\u3067\u3042\u308b\u304c\u3001CentOS8\u3067\u306f10.3\u3068\u306a\u308aMySQL\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3067\u8a00\u3048\u30705.8\u76f8\u5f53(\u305f\u3060\u3057\u3001\u30d0\u30fc\u30b8\u30e7\u30f3\u304c\u9032\u3080\u306b\u3064\u308c\u3066\u6a5f\u80fd\u5dee\u5206\u3082\u51fa\u3066\u304d\u3066\u3044\u308b\u306e\u3067\u3042\u304f\u307e\u3067\u53c2\u8003\u7a0b\u5ea6\uff09\u3068\u306a\u308b\u3002<\/p>\n\n\n\n<p>\u3044\u304d\u306a\u308a10.3\u306b\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u3059\u308b\u306e\u306f\u6016\u3044\u306e\u3067\u3001\u8a66\u9a13\u7528VPS\u3067CentOS7\u304b\u3089MariaDB10.3\u306b\u3057\u3066\u307f\u3088\u3046\u3002\u3061\u306a\u307f\u306bMariaDB5.5\u306emysqldump\u30a4\u30e1\u30fc\u30b8\u306f10.3\u306b\u6d41\u3057\u8fbc\u3093\u3060\u3089user\u30c6\u30fc\u30d6\u30eb\u304c\u3059\u3067\u306b\u5b58\u5728\u3059\u308b\u3068\u306e\u30a8\u30e9\u30fc\u3067\u4f7f\u3048\u306a\u304b\u3063\u305f\u3068\u3044\u3046\uff01<\/p>\n\n\n\n<p>\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u81ea\u4f53\u306f\u516c\u5f0fHP\u306b\u4e57\u3063\u3066\u3044\u308b\u30ef\u30f3\u30e9\u30a4\u30ca\u30fc\u3067\u30ea\u30dd\u30b8\u30c8\u30ea\u3092\u8ffd\u52a0\u3057\u3066\u3001yum install\u3059\u308b\u3060\u3051\u3060\u3002\u81ea\u5206\u306e\u5834\u5408percona-toolkit\u3092\u5165\u308c\u3066\u3044\u305f\u306e\u3067\u305d\u3061\u3089\u304c\u30b3\u30f3\u30d5\u30ea\u30af\u30c8\u3057\u305f\u3002\u6ce3\u304f\u6ce3\u304f\u524a\u9664\uff08percona-toolkit\u307b\u3068\u3093\u3069\u4f7f\u3063\u3066\u306a\u3044\u3051\u3069\uff09<\/p>\n\n\n<p>yum list installed | grep percona<br \/>\nyum remove percona-release percona-toolkit<br \/>\n# repository\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<br \/>\ncurl -sS https:\/\/downloads.mariadb.com\/MariaDB\/mariadb_repo_setup | sudo bash<br \/>\n# mariadb 10.3\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<br \/>\nyum install MariaDB-server MariaDB-client<\/p>\n\n\n\n<p>\u7121\u4e8b\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u3057\u3066\u3001mysql\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u304b\u3089\u63a5\u7d9a\u6210\u529f\u3060\u304c\uff01<\/p>\n\n\n\n<p>mysqldump\u3057\u3066\u307f\u308b\u3068\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3002\u30cd\u30c3\u30c8\u306e\u60c5\u5831\u3092\u983c\u308a\u306bmysql_upgrade\u3057\u3066\u518d\u5b9f\u884c\u3067\u7121\u4e8b\u6210\u529f\uff01<\/p>\n\n\n<p># mysql \u5168\u4f53\u30d0\u30c3\u30af\u30a2\u30c3\u30d7<br \/>\nmysqldump -u root -p -x &#8211;flush-logs &#8211;master-data=2 &#8211;all-databases &#8211;events  > \/var\/tmp\/backupsql.sql<br \/>\n# \u30a8\u30e9\u30fc\uff01\uff01\uff01<br \/>\nmysqldump: Couldn&#8217;t execute &#8216;show events&#8217;: Cannot proceed, because event scheduler is disabled (1577)<br \/>\n# \u30d0\u30fc\u30b8\u30e7\u30f3\u9055\u3044\u306eDB\u3092\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u3059\u308b\uff01<br \/>\nmysql_upgrade -u root -p &#8211;verbose<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>CentOS7\u6a19\u6e96\u306eMariaDB\u306f5.5(MySQL 5.5\u76f8\u5f53)\u3067\u3042\u308b\u304c\u3001C &hellip; <a href=\"https:\/\/blog.rutake.com\/techmemo\/2019\/10\/12\/mariadb-5-5%e3%81%8b%e3%82%8910-3%e3%81%ab%e3%82%a2%e3%83%83%e3%83%97%e3%82%b0%e3%83%ac%e3%83%bc%e3%83%89\/\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7,147],"tags":[574,581],"_links":{"self":[{"href":"https:\/\/blog.rutake.com\/techmemo\/wp-json\/wp\/v2\/posts\/3183"}],"collection":[{"href":"https:\/\/blog.rutake.com\/techmemo\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.rutake.com\/techmemo\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.rutake.com\/techmemo\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.rutake.com\/techmemo\/wp-json\/wp\/v2\/comments?post=3183"}],"version-history":[{"count":1,"href":"https:\/\/blog.rutake.com\/techmemo\/wp-json\/wp\/v2\/posts\/3183\/revisions"}],"predecessor-version":[{"id":3184,"href":"https:\/\/blog.rutake.com\/techmemo\/wp-json\/wp\/v2\/posts\/3183\/revisions\/3184"}],"wp:attachment":[{"href":"https:\/\/blog.rutake.com\/techmemo\/wp-json\/wp\/v2\/media?parent=3183"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.rutake.com\/techmemo\/wp-json\/wp\/v2\/categories?post=3183"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.rutake.com\/techmemo\/wp-json\/wp\/v2\/tags?post=3183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}