{"id":11145,"date":"2021-01-03T12:20:35","date_gmt":"2021-01-03T03:20:35","guid":{"rendered":"https:\/\/bigriver.jp\/?p=11145"},"modified":"2021-01-03T12:20:35","modified_gmt":"2021-01-03T03:20:35","slug":"mysql-%e3%81%ae%e5%bc%95%e3%81%a3%e8%b6%8a%e3%81%97","status":"publish","type":"post","link":"https:\/\/www.bigriver.jp\/?p=11145","title":{"rendered":"MySQL \u306e\u5f15\u3063\u8d8a\u3057"},"content":{"rendered":"\n<p>\u3053\u306e\u30d6\u30ed\u30b0\u306eCMS\u306b\u306f WordPress \u3092\u5229\u7528\u3057\u3066\u3044\u307e\u3059\u3002\u3000\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f Alibaba Cloud ECS \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u4e0a\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3044\u308b MySQL \u3067\u3059\u3002\u3000\u4eca\u56de\u3001\u3053\u306e MySQL \u3092 Alibaba Cloud \u306e ApsaraDB RDS \u306b\u5f15\u3063\u8d8a\u3057\u307e\u3059\u3002\u3000<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"949\" height=\"501\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-31.png\" alt=\"\" class=\"wp-image-11221\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-31.png 949w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-31-300x158.png 300w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-31-768x405.png 768w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-31-940x496.png 940w\" sizes=\"auto, (max-width: 949px) 100vw, 949px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u30c4\u30fc\u30eb\u306b\u306f Alibaba Cloud \u304c\u63d0\u4f9b\u3059\u308b\u30de\u30cd\u30fc\u30b8\u30c9\u578b\u306e Data Transmission Service \u3092\u5229\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"955\" height=\"465\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-32.png\" alt=\"\" class=\"wp-image-11223\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-32.png 955w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-32-300x146.png 300w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-32-768x374.png 768w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-32-940x458.png 940w\" sizes=\"auto, (max-width: 955px) 100vw, 955px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u5f15\u3063\u8d8a\u3057\u3059\u308b\u7406\u7531\u3067\u3059\u304c\u5927\u3057\u305f\u7406\u7531\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u30001\u3064\u306f \u6628\u5e74\u306e Alibaba \u306e\u72ec\u8eab\u306e\u65e5\u306e\u30a4\u30d9\u30f3\u30c8\u306b \u5b89\u304fAlibaba Cloud \u306e\u30d7\u30ed\u30c0\u30af\u30c8\u3092\u8cfc\u5165\u51fa\u6765\u305f\u3053\u3068\uff0811\u6708\u306b\u8cfc\u5165\u3057\u3066\u3084\u3063\u3068\u4eca\u304b\u3089\u79fb\u884c\u3059\u308b\u306e\u3067\u3059\u304c\uff09\u30012\u3064\u76ee\u306f\u30b7\u30b9\u30c6\u30e0\u306e\u4fe1\u983c\u6027\u5411\u4e0a\u306e\u305f\u3081\u3067\u3059\u3002 ApsaraDB\u306b\u79fb\u884c\u3059\u308b\u3053\u3068\u3067\u8907\u6570\u306e\u30be\u30fc\u30f3\u306b MySQL \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306f\u5197\u9577\u5316\u3055\u308c\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3082\u81ea\u52d5\u5316\u3067\u304d\u307e\u3059\uff08\u4eca\u56de\u8cfc\u5165\u3057\u305fBasic \u306a\u306e\u3067\u975e\u30be\u30fc\u30f3\u5197\u9577\u5316\u3067\u3059\u304c\u3002\u5c06\u6765\u7684\u306b\u7c21\u5358\u306b\u5197\u9577\u5316\u3067\u304d\u308b\u3068\u3044\u3046\u3053\u3068\u3067\uff09\u3002\u307e\u305f\u3001Web \u30b5\u30fc\u30d3\u30b9\u3092\u5b9f\u884c\u3059\u308b\u30d5\u30ed\u30f3\u30c8\u30a8\u30f3\u30c9\u306eECS \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u5197\u9577\u5316\u3059\u308b\u3053\u3068\u3067Web\u30b5\u30fc\u30d3\u30b9\u3068DB\u306e\u5197\u9577\u5316\u3092\u5b9f\u73fe\u3067\u304d\u308b\u3068\u3044\u3046\u3053\u3068\u3082\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u5f15\u3063\u8d8a\u3057\u306e\u6d41\u308c\u306f\u4ee5\u4e0b\u3067\u3059\u3002<\/p>\n\n\n\n<ol class=\"is-style-sango-list-main-color wp-block-list\"><li>ApsaraDB RDS \u306e\u8cfc\u5165<\/li><li>ApsaraDB RDS \u306e\u521d\u671f\u8a2d\u5b9a<\/li><li>\u65e2\u5b58MySQL \u306e\u8abf\u6574<\/li><li>Data Transmission Service \u306b\u3088\u308b Database \u79fb\u884c<\/li><li>ApsaraDB RDS \u3067\u306e\u6a29\u9650\u8a2d\u5b9a<\/li><li>WordPress \u306e\u8a2d\u5b9a\u5909\u66f4\uff08\u63a5\u7d9aDB\u306e\u5207\u308a\u66ff\u3048\uff09<\/li><\/ol>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>1\u306e ApsaraDB RDS (MySQL) \u306e\u8cfc\u5165\u306f2020\u5e7411\u6708\u306b\u5b9f\u65bd\u6e08\u306e\u305f\u3081\u3001\u624b\u98062\u304b\u3089\u4ee5\u4e0b\u9032\u3081\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u76ee\u6b21<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69d62a094e837\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\" style='display:none' id=\"ez-toc-cssicon-toggle-item-69d62a094e837\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.bigriver.jp\/?p=11145\/#ApsaraDB_for_MySQL_%E3%81%AE%E5%88%9D%E6%9C%9F%E8%A8%AD%E5%AE%9A\" >ApsaraDB for MySQL \u306e\u521d\u671f\u8a2d\u5b9a<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.bigriver.jp\/?p=11145\/#%E6%97%A2%E5%AD%98_MySQL_%E3%81%AE%E8%AA%BF%E6%95%B4\" >\u65e2\u5b58 MySQL \u306e\u8abf\u6574<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.bigriver.jp\/?p=11145\/#Data_Transmission_Service_%E3%81%AB%E3%82%88%E3%82%8B_Database_%E7%A7%BB%E8%A1%8C\" >Data Transmission Service \u306b\u3088\u308b Database \u79fb\u884c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.bigriver.jp\/?p=11145\/#ApsaraDB_RDS_%E3%81%A7%E3%81%AE%E6%A8%A9%E9%99%90%E8%A8%AD%E5%AE%9A\" >ApsaraDB RDS \u3067\u306e\u6a29\u9650\u8a2d\u5b9a<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.bigriver.jp\/?p=11145\/#wordpress_%E3%81%AE%E8%A8%AD%E5%AE%9A%E5%A4%89%E6%9B%B4_%E6%8E%A5%E7%B6%9ADB%E3%81%AE%E5%88%87%E3%82%8A%E6%9B%BF%E3%81%88\" >wordpress \u306e\u8a2d\u5b9a\u5909\u66f4 (\u63a5\u7d9aDB\u306e\u5207\u308a\u66ff\u3048)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.bigriver.jp\/?p=11145\/#%E3%81%BE%E3%81%A8%E3%82%81\" >\u307e\u3068\u3081<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-sgb-headings sgb-heading\" id=\"i-0\"><span class=\"ez-toc-section\" id=\"ApsaraDB_for_MySQL_%E3%81%AE%E5%88%9D%E6%9C%9F%E8%A8%AD%E5%AE%9A\"><\/span><div class=\"sgb-heading__inner sgb-heading--type2\" style=\"background-color:#ffb36b;border-color:transparent;font-size:1.2em\"><span class=\"sgb-heading__text\" style=\"color:#FFF\">ApsaraDB for MySQL \u306e\u521d\u671f\u8a2d\u5b9a<\/span><\/div><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Alibaba Cloud \u30b3\u30f3\u30bd\u30fc\u30eb\u306b\u30ed\u30b0\u30a4\u30f3\u3057\u3001 ApsaraDB RDS \u306e\u7ba1\u7406\u753b\u9762\u306b\u79fb\u52d5\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-sango-with-border\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"273\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-1024x273.png\" alt=\"\" class=\"wp-image-11148\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-1024x273.png 1024w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-300x80.png 300w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-768x205.png 768w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-1536x410.png 1536w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-940x251.png 940w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image.png 1650w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u307e\u305a\u306f Database \u306e\u63a5\u7d9a\u7528\u306e\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-sango-with-border\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"380\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-1-1024x380.png\" alt=\"\" class=\"wp-image-11152\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-1-1024x380.png 1024w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-1-300x111.png 300w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-1-768x285.png 768w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-1-940x349.png 940w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-1.png 1311w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u9014\u4e2d\u306e\u753b\u9762\u306f\u7701\u7565\u3057\u307e\u3059\u304c wordpress \u7528\u3068 \u7ba1\u7406\u76ee\u7684\u306e2\u3064\u306e\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-sango-with-border\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"440\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-2-1024x440.png\" alt=\"\" class=\"wp-image-11154\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-2-1024x440.png 1024w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-2-300x129.png 300w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-2-768x330.png 768w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-2-940x404.png 940w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-2.png 1298w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>ApsaraDB RDS \u3078\u306e\u63a5\u7d9a\u3092\u8a31\u53ef\u3059\u308b IP\u30a2\u30c9\u30ec\u30b9\u3092 Whitelist \u3068\u3057\u3066\u767b\u9332\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u307e\u305a\u306f ECS \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"927\" height=\"584\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-9.png\" alt=\"\" class=\"wp-image-11170\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-9.png 927w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-9-300x189.png 300w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-9-768x484.png 768w\" sizes=\"auto, (max-width: 927px) 100vw, 927px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u6b21\u306f Data Transmission Service \u306eIP\u30a2\u30c9\u30ec\u30b9\u3067\u3059\u3002\u3053\u306e\u6642 Data Transmission Service \u304c\u4f7f\u7528\u3059\u308bIP\u30a2\u30c9\u30ec\u30b9\u3092\u628a\u63e1\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u3000<a href=\"https:\/\/www.alibabacloud.com\/help\/doc-detail\/176627.htm\">Alibaba Cloud Document Center <\/a>\u306b\u305d\u306e\u60c5\u5831\u306f\u3042\u308a\u307e\u3059\u3002\u3000\u79fb\u884c\u5143\u306e Database \u3092\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8\u306b\u516c\u958b\u3057\u305d\u306e\u30d1\u30d6\u30ea\u30c3\u30afIP\u30a2\u30c9\u30ec\u30b9\u306b\u63a5\u7d9a\u3059\u308b\u30d1\u30bf\u30fc\u30f3\u3068\u79fb\u884c\u5143\u306eDatabase \u304c ECS \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u4e0a\u306b\u3042\u308a\u30d7\u30e9\u30a4\u30d9\u30fc\u30c8IP\u30a2\u30c9\u30ec\u30b9\u3067\u79fb\u884c\u3059\u308b\u30d1\u30bf\u30fc\u30f3\u3068\u3067\u63a5\u7d9a\u5143\u306eIP\u30a2\u30c9\u30ec\u30b9\u306f\u5909\u308f\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u4ee5\u4e0b\u306e\u901a\u308a\u3001 Tokyo \u30ea\u30fc\u30b8\u30e7\u30f3\u3067\u306f 100.104.112.0\/24 \u304b\u3089\u306e\u63a5\u7d9a\u3092\u8a31\u53ef\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-sango-with-border\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"781\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-7-1024x781.png\" alt=\"\" class=\"wp-image-11167\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-7-1024x781.png 1024w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-7-300x229.png 300w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-7-768x586.png 768w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-7-940x717.png 940w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-7.png 1101w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u201c100.104.112.0\/24\u201d \u3092 RDS \u306e Whitelist \u306b\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-sango-with-border\"><img loading=\"lazy\" decoding=\"async\" width=\"631\" height=\"717\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-10.png\" alt=\"\" class=\"wp-image-11172\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-10.png 631w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-10-264x300.png 264w\" sizes=\"auto, (max-width: 631px) 100vw, 631px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u6700\u7d42\u7684\u306b RDS \u306e Whitelist \u306f\u4ee5\u4e0b\u306e\u72b6\u614b\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-sango-with-border\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"500\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-11-1024x500.png\" alt=\"\" class=\"wp-image-11173\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-11-1024x500.png 1024w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-11-300x147.png 300w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-11-768x375.png 768w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-11-940x459.png 940w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-11.png 1447w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-sgb-headings sgb-heading\" id=\"i-1\"><span class=\"ez-toc-section\" id=\"%E6%97%A2%E5%AD%98_MySQL_%E3%81%AE%E8%AA%BF%E6%95%B4\"><\/span><div class=\"sgb-heading__inner sgb-heading--type2\" style=\"background-color:#ffb36b;border-color:transparent;font-size:1.2em\"><span class=\"sgb-heading__text\" style=\"color:#FFF\">\u65e2\u5b58 MySQL \u306e\u8abf\u6574<\/span><\/div><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u3053\u306e\u5f8c\u306e\u624b\u9806\u3067 Alibaba Cloud Data Transmission Service \u306b\u3088\u308a\u65e2\u5b58\u306e MySQL \u304b\u3089 ApsaraDB RDS (MySQL) \u306b\u30c7\u30fc\u30bf\u3092\u79fb\u884c\u3059\u308b\u306e\u3067\u3059\u304c\u3001\u30a2\u30ab\u30a6\u30f3\u30c8\u3084\u305d\u306e\u6a29\u9650\u306a\u3069\u65e2\u5b58\u306e MySQL \u3078\u63a5\u7d9a\u3067\u304d\u308b\u3088\u3046\u8abf\u6574\u3057\u307e\u3059\u3002\u3000\u74b0\u5883\u306b\u4f9d\u5b58\u3059\u308b\u90e8\u5206\u306f\u3042\u308a\u307e\u3059\u304c\u3001\u4ee5\u4e0b\u304c\u8abf\u6574\u306e\u5bfe\u8c61\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"is-style-sango-list-main-color wp-block-list\"><li>MySQL \u306e\u6a29\u9650\uff08\u30a2\u30ab\u30a6\u30f3\u30c8\u3001\u4ed8\u4e0e\u3057\u305f\u6a29\u9650\u3001\u63a5\u7d9a\u5143IP\u30a2\u30c9\u30ec\u30b9\uff09<\/li><li>MySQL \u306e\u30d0\u30a4\u30f3\u30c9\u3059\u308bIP\u30a2\u30c9\u30ec\u30b9<\/li><li>OS \u306e Firewall (iptables \/ Firewalld nado)<\/li><li>Alibaba Cloud \u306e Security Group<\/li><\/ol>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u79c1\u306e\u74b0\u5883\u3067\u306f MySQL \u3092 Internet \u306b\u306f\u516c\u958b\u3057\u3066\u3044\u307e\u305b\u3093\u3002\u3000Security Group \u3067\u3082 MySQL \u306e\u30dd\u30fc\u30c8\u306f\u516c\u958b\u3057\u3066\u304a\u3089\u305a\u3001OS \u306e firewalld \u3067\u3082Block\u3057\u3001\u307e\u305f\u3001MySQL \u3067\u3082 \u30dd\u30fc\u30c8\u3092\u30d0\u30a4\u30f3\u30c9\u3059\u308b IP \u30a2\u30c9\u30ec\u30b9\u306f loopback \u30a2\u30c9\u30ec\u30b9\u306b\u9650\u5b9a\u3057\u3066\u3044\u307e\u3059\u3002\u3000\u3068\u3044\u3046\u3053\u3068\u30671\u30682\u306e\u307f\u5bfe\u51e6\u3092\u884c\u3044\u307e\u3059\u3002\u30003\u30684\u3067\u3059\u304c Data Transmission Service \u306f\u30d7\u30e9\u30a4\u30d9\u30fc\u30c8\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b\u305f\u3081\u7279\u306b\u4eca\u56de\u306f\u8a2d\u5b9a\u5909\u66f4\u306f\u4e0d\u8981\u3067\u3057\u305f\u3002<\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u307e\u305a\u306f MySQL \u306e\u8a2d\u5b9a\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002 wordpress\u63a5\u7d9a\u7528\u306e\u30a2\u30ab\u30a6\u30f3\u30c8\u3082 \u7279\u6a29\u30a2\u30ab\u30a6\u30f3\u30c8\u3082IP\u30a2\u30c9\u30ec\u30b9\uff08Data Transmission Service \u306eIP\u30a2\u30c9\u30ec\u30b9\u3068\u306a\u308b 100.104.112.135 ) \u3067\u306e\u63a5\u7d9a\u306f\u51fa\u6765\u306a\u3044\u72b6\u614b\u3067\u3059\u3002<\/p>\n\n\n<div id=\"\">\n<figure class=\"wp-block-table\"><table class=\"has-subtle-light-gray-background-color has-background\"><tbody><tr><td>mysql&gt; <strong>show grants for \u2018wordpressuser\u2019@\u2019100.104.112.0\/24\u2019;<\/strong><br>ERROR 1141 (42000): There is no such grant defined for user \u2018wordpressuser\u2019 on host \u2018100.104.112.0\/24\u2019<br><\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u4eca\u56de\u306f\u9762\u5012\u306a\u306e\u3067\u7de9\u304f\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u8a2d\u5b9a\u3092\u884c\u3044\u307e\u3059\u3002\uff08\u5f8c\u8ff0\u3057\u307e\u3059\u304c\u3001\u4ee5\u4e0b\u306e\u8a2d\u5b9a\u306f\u8aa4\u308a\u3067\u3059\u3002 netmask\u306f \/24 \u3067\u306f\u306a\u304f 255.255.255.0 \u5f62\u5f0f\u3067\u6307\u5b9a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\uff09<\/p>\n\n\n<div id=\"\">\n<figure class=\"wp-block-table\"><table class=\"has-subtle-light-gray-background-color has-background\"><tbody><tr><td>\uff03\u6a29\u9650\u4ed8\u4e0e<br>mysql&gt; <strong>grant all on <em>*.*<\/em> to \u2018wordpressuser\u2019@\u2019100.104.112.0\/24\u2019 identified by \u2018&lt;password&gt;\u2019;<\/strong><br>Query OK, 0 rows affected, 1 warning (0.00 sec)<br><br>\uff03\u4ed8\u4e0e\u3057\u305f\u6a29\u9650\u306e\u78ba\u8a8d<br>mysql&gt; <strong>show grants for \u2018wordpressuser\u2019@\u2019100.104.112.0\/24\u2019;<\/strong><br>+\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-+<br>| Grants for wordpressuser@100.104.112.0 |<br>+\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-+<br>| GRANT ALL PRIVILEGES ON <em>.<\/em> TO \u2018wordpressuser\u2019@\u2019100.104.112.0\/24\u2019 |<br>+\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-+<br>1 row in set (0.00 sec)<br><br><\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u6b21\u306b\u3001\u201dmysqld.cnf\u201d \u306e\u201dbind-address\u201d \u306b ECS \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u30d7\u30e9\u30a4\u30d9\u30fc\u30c8 IP \u30a2\u30c9\u30ec\u30b9\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002\u3000\u30d5\u30a1\u30a4\u30eb\u3092\u4fdd\u5b58\u5f8c\u3001\u201dsystemctl restart mysql.service\u201d \u3067 MySQL \u3092\u518d\u8d77\u52d5\u3057\u307e\u3059\u3002<\/p>\n\n\n<div id=\"\">\n<figure class=\"wp-block-table\"><table class=\"has-subtle-light-gray-background-color has-background\"><tbody><tr><td>#<br>Instead of skip-networking the default is now to listen only on<br>localhost which is more compatible and is not less secure.<br>bind-address = 127.0.0.1<br><strong>bind-address = 172.24.203.118<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-sgb-headings sgb-heading\" id=\"i-2\"><span class=\"ez-toc-section\" id=\"Data_Transmission_Service_%E3%81%AB%E3%82%88%E3%82%8B_Database_%E7%A7%BB%E8%A1%8C\"><\/span><div class=\"sgb-heading__inner sgb-heading--type2\" style=\"background-color:#ffb36b;border-color:transparent;font-size:1.2em\"><span class=\"sgb-heading__text\" style=\"color:#FFF\">Data Transmission Service \u306b\u3088\u308b Database \u79fb\u884c<\/span><\/div><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Alibaba Cloud \u30b3\u30f3\u30bd\u30fc\u30eb\u306b\u30ed\u30b0\u30a4\u30f3\u3057\u3001 Data Transmission Service \u306e\u7ba1\u7406\u753b\u9762\u306b\u30a2\u30af\u30bb\u30b9\u3057\u307e\u3059\u3002\u3000<\/p>\n\n\n\n<p>\u305d\u3053\u304b\u3089 \u201cCreate Migration Task\u201d \u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-sango-with-border\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"436\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-3-1024x436.png\" alt=\"\" class=\"wp-image-11155\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-3-1024x436.png 1024w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-3-300x128.png 300w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-3-768x327.png 768w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-3-1536x654.png 1536w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-3-940x400.png 940w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-3.png 1551w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u307e\u305a\u306f\u3001\u79fb\u884c\u5143\u306e\u65e2\u5b58\u306e MySQL \u306b\u63a5\u7d9a\u3059\u308b\u305f\u3081\u306e\u60c5\u5831\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u3000\u4eca\u56de\u306f\u201d<strong>User-Created Database in ECS Instance<\/strong>\u201c\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u3067\u3001\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8\u306b MySQL \u3092\u516c\u958b\u3059\u308b\u3053\u3068\u306a\u304f\u79fb\u884c\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-sango-with-border\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"605\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-4-1024x605.png\" alt=\"\" class=\"wp-image-11161\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-4-1024x605.png 1024w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-4-300x177.png 300w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-4-768x454.png 768w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-4-940x555.png 940w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-4.png 1334w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u201cTest Connectivity\u201d \u304b\u3089 Data Transmission Service \u304b\u3089 \u79fb\u884c\u5143\u306e MySQL \u3078\u306e\u63a5\u7d9a\u6027\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002 \u201cPassed\u201d \u3068\u8868\u793a\u3055\u308c\u308c\u3070\u554f\u984c\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-sango-with-border\"><img loading=\"lazy\" decoding=\"async\" width=\"487\" height=\"186\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-5.png\" alt=\"\" class=\"wp-image-11162\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-5.png 487w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-5-300x115.png 300w\" sizes=\"auto, (max-width: 487px) 100vw, 487px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u5931\u6557\u3059\u308b\u3068\u304d\u306f\u539f\u56e0\u306e\u8aac\u660e\u306e\u30a6\u30a3\u30f3\u30c9\u30a6\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u3000\u4f8b\u3048\u3070\u4ee5\u4e0b\u306e\u4f8b\u3067\u306f\u3001\u63a5\u7d9a\u5143IP\u30a2\u30c9\u30ec\u30b9\u3092 MySQL \u306b\u6b63\u3057\u304f\u8a2d\u5b9a\u3057\u3066\u3044\u306a\u3044\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3059 (Access denied for user \u2018wordpressuser\u2019@\u2019100.104.112.135\u2019)\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-sango-with-border\"><img loading=\"lazy\" decoding=\"async\" width=\"630\" height=\"451\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-6.png\" alt=\"\" class=\"wp-image-11164\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-6.png 630w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-6-300x215.png 300w\" sizes=\"auto, (max-width: 630px) 100vw, 630px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u6b21\u306f\u79fb\u884c\u5148\u3068\u306a\u308b ApsaraDB RDS \u306e\u60c5\u5831\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u305d\u306e\u3042\u3068\u3067\u201dTest Connectivity\u201d \u3067\u63a5\u7d9a\u6027\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002 \u201cPassed\u201d \u3068\u8868\u793a\u3055\u308c\u308c\u3070 OK\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-sango-with-border\"><img loading=\"lazy\" decoding=\"async\" width=\"932\" height=\"337\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-14.png\" alt=\"\" class=\"wp-image-11177\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-14.png 932w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-14-300x108.png 300w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-14-768x278.png 768w\" sizes=\"auto, (max-width: 932px) 100vw, 932px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u6b21\u306b\u3001\u79fb\u884c\u3059\u308b Database \u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u3000<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-sango-with-border\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"595\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-15-1024x595.png\" alt=\"\" class=\"wp-image-11178\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-15-1024x595.png 1024w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-15-300x174.png 300w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-15-768x446.png 768w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-15-1536x892.png 1536w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-15-940x546.png 940w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-15.png 1561w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u4eca\u56de\u306f\u201dsys\u201d\u306f\u79fb\u884c\u5bfe\u8c61\u3068\u305b\u305a\u3001\u201dwordpress\u201d\u306e\u307f\u79fb\u884c\u5bfe\u8c61\u3068\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-sango-with-border\"><img loading=\"lazy\" decoding=\"async\" width=\"1025\" height=\"445\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-16.png\" alt=\"\" class=\"wp-image-11179\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-16.png 1025w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-16-300x130.png 300w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-16-768x333.png 768w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-16-940x408.png 940w\" sizes=\"auto, (max-width: 1025px) 100vw, 1025px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u6b21\u306ePrecheck \u3067 Error \u3068\u306a\u308a\u307e\u3057\u305f\u3002 \u201cError: Get schema list failed, reason[Access denied for user \u2018wordpressuser\u2019@\u2019100.104.112.52\u2019 (using password:YES)\u201d \u3068\u306e\u3053\u3068\u3067\u3001\u79fb\u884c\u5143\u306eMySQL \u306b\u5bfe\u3057\u3066\u6307\u5b9a\u3057\u305f\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u306f\u63a5\u7d9a\u304c\u62d2\u5426\u3055\u308c\u305f\u3088\u3046\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-sango-with-border\"><img loading=\"lazy\" decoding=\"async\" width=\"573\" height=\"223\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-17.png\" alt=\"\" class=\"wp-image-11180\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-17.png 573w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-17-300x117.png 300w\" sizes=\"auto, (max-width: 573px) 100vw, 573px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u4e0a\u8a18\u306e\u30a8\u30e9\u30fc\u306f\u5358\u7d14\u306b \u79fb\u884c\u5143\u306eMySQL \u3067 \u201cflush privileges\u201d \u3092\u5b9f\u884c\u3057\u3066\u3044\u306a\u304b\u3063\u305f\u305f\u3081\u3067\u3057\u305f\u3002\u3000<\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u3084\u3063\u3068 Precheck \u306e\u51e6\u7406\u304c\u958b\u59cb\u3055\u308c\u305f\u306e\u3067\u3059\u304c\u3001\u307e\u305f\u30a8\u30e9\u30fc\u3067\u3059\u3002 \u201cCheck whether the DTS server can connect to the source database.\u201d \u3068\u306e\u3053\u3068\u3067\u3001Data Transmission Service \u304b\u3089\u79fb\u884c\u5143\u3078\u306eMySQL\u306e\u63a5\u7d9a\u306b\u554f\u984c\u304c\u3042\u308b\u3088\u3046\u3067\u3059\u3002\u3000<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-sango-with-border\"><img loading=\"lazy\" decoding=\"async\" width=\"524\" height=\"321\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-19.png\" alt=\"\" class=\"wp-image-11184\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-19.png 524w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-19-300x184.png 300w\" sizes=\"auto, (max-width: 524px) 100vw, 524px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u30a8\u30e9\u30fc\u306e\u8a73\u7d30\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002 \u201cThe username or password of the source database is incorrect.\u201d \u3068\u306e\u3053\u3068\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-sango-with-border\"><img loading=\"lazy\" decoding=\"async\" width=\"611\" height=\"512\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-20.png\" alt=\"\" class=\"wp-image-11185\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-20.png 611w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-20-300x251.png 300w\" sizes=\"auto, (max-width: 611px) 100vw, 611px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u524d\u306e\u30b9\u30c6\u30c3\u30d7\u3067\u306e\u63a5\u7d9a\u30c6\u30b9\u30c8\u3067\u306f\u6210\u529f\u3057\u3066\u3044\u305f\u306e\u3067\u3059\u304c\u3001\u3001\u3001\u5931\u6557\u3068\u306e\u3053\u3068\u3002\u3000\u79fb\u884c\u5143\u306e MySQL \u306e\u30ed\u30b0\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002\u3000\u6700\u7d42\u884c\u306e Access denied \u306b\u7740\u76ee\u3057\u307e\u3059\u3002\u9001\u4fe1\u5143 \u201c100.104.112.0\u201d \u304b\u3089\u306e\u63a5\u7d9a\u3092\u62d2\u5426\u3057\u305f\u3068\u306e\u3053\u3068\u3002 \u3000\u3057\u304b\u3057\u3001\u30db\u30b9\u30c8\u30a2\u30c9\u30ec\u30b9\u304c\u201d0\u2033 \u306f\u3061\u3087\u3063\u3068\u6c17\u6301\u3061\u308f\u308b\u3044\u3067\u3059\u306d\u3002\u3000\u307e\u3042\u3001\u5404\u30d1\u30d6\u30ea\u30c3\u30af\u30af\u30e9\u30a6\u30c9\u3068\u3082\u4eee\u60f3\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u306f\u30aa\u30f3\u30d7\u30ec\u30df\u30b9\u306e\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u3068\u306f\u4f3c\u3066\u975e\u306a\u308b\u4e16\u754c\u3067\u306f\u3042\u308a\u307e\u3059\u304c\u3002<\/p>\n\n\n<div id=\"\">\n<figure class=\"wp-block-table\"><table class=\"has-subtle-light-gray-background-color has-background\"><tbody><tr><td>root@bigriver3:\/var\/log\/mysql# tail error.log<br>2021-01-03T01:38:11.422140Z 2099 [Note] Got an error reading communication packets<br>2021-01-03T01:38:21.460368Z 2101 [Note] Got an error reading communication packets<br>2021-01-03T01:39:04.100342Z 2100 [Note] Aborted connection 2100 to db: \u2018unconnected\u2019 user: \u2018wordpressuser\u2019 host: \u2018100.104.112.135\u2019 (Got an error reading communication packets)<br>2021-01-03T01:39:10.939456Z 2104 [Note] Got an error reading communication packets<br>2021-01-03T01:39:49.736212Z 2106 [Note] Got an error reading communication packets<br>2021-01-03T01:40:01.466310Z 2108 [Note] Got an error reading communication packets<br><strong>2021-01-03T01:40:01.854061Z 2109 [Note] Access denied for user \u2018wordpressuser\u2019@\u2019100.104.112.0\u2019 (using password: YES)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u518d\u5ea6\u3001MySQL \u306b\u5272\u308a\u5f53\u3066\u305f\u6a29\u9650\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002\u3000subnet mask \u306f 24 bit \u3092\u6307\u5b9a\u3057\u3066\u3044\u307e\u3059\u3002\u3000<\/p>\n\n\n<div id=\"\">\n<figure class=\"wp-block-table\"><table class=\"has-subtle-light-gray-background-color has-background\"><tbody><tr><td>mysql&gt; <strong>show grants for \u2018wordpressuser\u2019@\u2019100.104.112.0\/24\u2019;<\/strong><br>+\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-+<br>| Grants for wordpressuser@100.104.112.0\/24 |<br>+\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-+<br>| GRANT ALL PRIVILEGES ON <em>.<\/em> TO \u2018wordpressuser\u2019@\u2019100.104.112.0\/24\u2019 |<br>+\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-+<br>1 row in set (0.00 sec)<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u3082\u3057\u304b\u3057\u3066\u3068\u601d\u3044\u3001MySQL \u306e\u30de\u30cb\u30e5\u30a2\u30eb\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002\u3000netmask \u306f \u201c\/24\u2033 \u3067\u306f\u306a\u304f\u201d255.255.255.0\u201d \u3068\u6307\u5b9a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3057\u305f\u3002\u3082\u3057\u304f\u306f \u201c%\u201d \u3092\u5229\u7528\u3057\u305f\u30ef\u30a4\u30eb\u30c9\u30ab\u30fc\u30c9\u8868\u8a18\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-sango-with-border\"><img loading=\"lazy\" decoding=\"async\" width=\"808\" height=\"865\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-21.png\" alt=\"\" class=\"wp-image-11187\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-21.png 808w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-21-280x300.png 280w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-21-768x822.png 768w\" sizes=\"auto, (max-width: 808px) 100vw, 808px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u518d\u5ea6\u3001MySQL \u306e\u30a2\u30af\u30bb\u30b9\u6a29\u3092\u4ee5\u4e0b\u306e\u901a\u308a\u898b\u76f4\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n<div id=\"\">\n<figure class=\"wp-block-table\"><table class=\"has-subtle-light-gray-background-color has-background\"><tbody><tr><td>mysql&gt; <strong>show grants for \u2018wordpressuser\u2019@\u2019100.104.112.0\/255.255.255.0\u2019;<\/strong><br>+\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014+<br>| Grants for wordpressuser@100.104.112.0\/255.255.255.0 |<br>+\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014+<br>| GRANT ALL PRIVILEGES ON <em>.<\/em> TO \u2018wordpressuser\u2019@\u2019100.104.112.0\/255.255.255.0\u2019 |<br>+\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014+<br>1 row in set (0.00 sec)<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Data Transmission Service \u306b\u623b\u308a\u518d\u5ea6 Precheck \u3092\u5b9f\u884c\u3057\u307e\u3059\u3002\u6210\u529f\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"526\" height=\"470\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-22.png\" alt=\"\" class=\"wp-image-11189\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-22.png 526w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-22-300x268.png 300w\" sizes=\"auto, (max-width: 526px) 100vw, 526px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u3053\u3053\u3067 Data Transmission Service \u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306b\u3069\u306e\u30bf\u30a4\u30d7\u3092\u8cfc\u5165\u3059\u308b\u304b\u9078\u629e\u3057\u307e\u3059\u3002 small \u3067\u3082\u5927\u4e08\u592b\u3060\u3068\u306f\u601d\u3044\u307e\u3059\u304c\u3001\u65e2\u5b9a\u306e medium \u306e\u307e\u307e\u9032\u3081\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-sango-with-border\"><img loading=\"lazy\" decoding=\"async\" width=\"520\" height=\"463\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-23.png\" alt=\"\" class=\"wp-image-11192\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-23.png 520w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-23-300x267.png 300w\" sizes=\"auto, (max-width: 520px) 100vw, 520px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Data Transmission Service \u306e\u8cfc\u5165\u5f8c\u306b Migration Task \u306f\u3059\u3050\u306b\u958b\u59cb\u3055\u308c\u307e\u3059\u3002\u3000\u30c7\u30fc\u30bf\u91cf\u304c\u5c11\u306a\u3044\u3053\u3068\u3082\u3042\u308a1\u5206\u307b\u3069\u3067\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-sango-with-border\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"409\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-27-1024x409.png\" alt=\"\" class=\"wp-image-11196\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-27-1024x409.png 1024w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-27-300x120.png 300w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-27-768x307.png 768w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-27-940x375.png 940w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-27.png 1195w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>View Details \u304b\u3089\u79fb\u884c\u30c7\u30fc\u30bf\u306e\u8a73\u7d30\u3082\u78ba\u8a8d\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-sango-with-border\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"653\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-28-1024x653.png\" alt=\"\" class=\"wp-image-11198\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-28-1024x653.png 1024w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-28-300x191.png 300w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-28-768x490.png 768w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-28-940x599.png 940w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-28.png 1184w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-sgb-headings sgb-heading\" id=\"i-3\"><span class=\"ez-toc-section\" id=\"ApsaraDB_RDS_%E3%81%A7%E3%81%AE%E6%A8%A9%E9%99%90%E8%A8%AD%E5%AE%9A\"><\/span><div class=\"sgb-heading__inner sgb-heading--type2\" style=\"background-color:#ffb36b;border-color:transparent;font-size:1.2em\"><span class=\"sgb-heading__text\" style=\"color:#FFF\">ApsaraDB RDS \u3067\u306e\u6a29\u9650\u8a2d\u5b9a<\/span><\/div><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Data Transmission Service  \u306b\u3088\u308b\u79fb\u884c\u304c\u5b8c\u4e86\u3057\u305f\u3053\u3068\u3067\u3001ApsaraDB RDS \u4e0a\u306bDatabase \u304c\u4f5c\u6210\u3055\u308c\u307e\u3057\u305f\u3002\u3000\u3053\u306e Database \u306b WordPress \u304b\u3089\u63a5\u7d9a\u3059\u308b\u30a2\u30ab\u30a6\u30f3\u30c8\u306b\u9069\u5207\u306a\u6a29\u9650\u3092\u4ed8\u4e0e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>ApsaraDB RDS \u306e\u7ba1\u7406\u753b\u9762\u304b\u3089 Accounts \u306b\u79fb\u52d5\u3057\u3001Edit Account Permissions \u304b\u3089\u4eca\u56de\u5bfe\u8c61\u3068\u306a\u308b database \u201cwordpress\u201d \u306b\u6a29\u9650\u3092\u4ed8\u4e0e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-sango-with-border\"><img loading=\"lazy\" decoding=\"async\" width=\"727\" height=\"453\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-29.png\" alt=\"\" class=\"wp-image-11201\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-29.png 727w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-29-300x187.png 300w\" sizes=\"auto, (max-width: 727px) 100vw, 727px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-sgb-headings sgb-heading\" id=\"i-4\"><span class=\"ez-toc-section\" id=\"wordpress_%E3%81%AE%E8%A8%AD%E5%AE%9A%E5%A4%89%E6%9B%B4_%E6%8E%A5%E7%B6%9ADB%E3%81%AE%E5%88%87%E3%82%8A%E6%9B%BF%E3%81%88\"><\/span><div class=\"sgb-heading__inner sgb-heading--type2\" style=\"background-color:#ffb36b;border-color:transparent;font-size:1.2em\"><span class=\"sgb-heading__text\" style=\"color:#FFF\">wordpress \u306e\u8a2d\u5b9a\u5909\u66f4 (\u63a5\u7d9aDB\u306e\u5207\u308a\u66ff\u3048)<\/span><\/div><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u6700\u5f8c\u306bwordpress \u306e\u8a2d\u5b9a\u3092\u5909\u66f4\u3057\u3001\u63a5\u7d9a\u3059\u308b MySQL \u3092\u4eca\u56de\u79fb\u884c\u3057\u305f ApsaraDB RDS \u306b\u5207\u308a\u66ff\u3048\u307e\u3059\u3002 \u592a\u5b57\u306b\u3057\u305f3\u304b\u6240\u3092\u5909\u66f4\u3057\u307e\u3059\u3002 DB_USER \u3068 DB_PASSWORD \u306f ApsaraDB RDS \u306b\u4f5c\u6210\u3057\u305f\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002 DB_HOST \u306b\u306f ApsaraDB RDS \u306e Internal Endpoint \u306e\u30a2\u30c9\u30ec\u30b9\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p><strong>wp-config.php<\/strong><\/p>\n\n\n<div id=\"\">\n<figure class=\"wp-block-table\"><table class=\"has-subtle-light-gray-background-color has-background\"><tbody><tr><td>\/\/ ** MySQL settings \u2013 You can get this info from your web host ** \/\/<br>\/** The name of the database for WordPress *\/<br>define(\u2018DB_NAME\u2019, \u2018wordpress\u2019);<br>\/** MySQL database username *\/<br>define(\u2018DB_USER\u2019, \u2018<strong>wordpressuser<\/strong>\u2018);<br>\/** MySQL database password *\/<br>define(\u2018DB_PASSWORD\u2019, \u2018<strong>&lt;password&gt;<\/strong>\u2018);<br>\/** MySQL hostname *\/<br>define(\u2018DB_HOST\u2019, <strong>\u2018rm-0iwy89d077of47i0v70070.mysql.japan.rds.aliyuncs.com<\/strong>\u2018);<br>\/** Database Charset to use in creating database tables. *\/<br>define(\u2018DB_CHARSET\u2019, \u2018utf8\u2019);<br>\/** The Database Collate type. Don\u2019t change this if in doubt. *\/<br>define(\u2018DB_COLLATE\u2019, \u201d);<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u79fb\u884c\u5143\u306e MySQL \u306e\u30b5\u30fc\u30d3\u30b9\u3092\u505c\u6b62\u3057\u3001\u81ea\u52d5\u8d77\u52d5\u3082\u7121\u52b9\u5316\u3057\u307e\u3059\u3002<\/p>\n\n\n<div id=\"\">\n<figure class=\"wp-block-table\"><table class=\"has-subtle-light-gray-background-color has-background\"><tbody><tr><td>root@bigriver3:~# <strong>systemctl stop mysql.service<\/strong><br>root@bigriver3:~# <strong>systemctl disable mysql.service<\/strong><br>Synchronizing state of mysql.service with SysV service script with \/lib\/systemd\/systemd-sysv-install.<br>Executing: \/lib\/systemd\/systemd-sysv-install disable mysql<br>root@bigriver3:~# <strong>systemctl status mysql.service<\/strong><br>\u25cf mysql.service \u2013 MySQL Community Server<br>Loaded: loaded (\/lib\/systemd\/system\/mysql.service; disabled; vendor preset: e<br>Active: inactive (dead)<br>Dec 26 11:29:23 bigriver3 systemd[1]: Starting MySQL Community Server\u2026<br>Dec 26 11:29:25 bigriver3 systemd[1]: Started MySQL Community Server.<br>Jan 01 20:51:23 bigriver3 systemd[1]: Stopping MySQL Community Server\u2026<br>Jan 01 20:51:25 bigriver3 systemd[1]: Stopped MySQL Community Server.<br>Jan 01 20:51:25 bigriver3 systemd[1]: Starting MySQL Community Server\u2026<br>Jan 01 20:51:25 bigriver3 systemd[1]: Started MySQL Community Server.<br>Jan 03 10:45:55 bigriver3 systemd[1]: Stopping MySQL Community Server\u2026<br>Jan 03 10:45:57 bigriver3 systemd[1]: Stopped MySQL Community Server.<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u63a5\u7d9a\u5148\u304c\u5207\u308a\u66ff\u308f\u3063\u305f\u304b\u3069\u3046\u304b\u306f tcpdump \u3067\u30d1\u30b1\u30c3\u30c8\u30ad\u30e3\u30d7\u30c1\u30e3\u3057\u3066\u78ba\u8a8d\u3057\u307e\u3059\u3002\u3000172.24.203.127.mysql \u306b\u63a5\u7d9a\u3057\u3066\u3044\u308b\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3059\u3002 172.24.203.127 \u306f ApsaraDB RDS \u306e Internal Endpoint \u306e\u30d7\u30e9\u30a4\u30d9\u30fc\u30c8IP\u30a2\u30c9\u30ec\u30b9\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"659\" height=\"486\" src=\"https:\/\/bigriver.jp\/wp-content\/uploads\/2021\/01\/image-30.png\" alt=\"\" class=\"wp-image-11208\" srcset=\"https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-30.png 659w, https:\/\/www.bigriver.jp\/wp-content\/uploads\/2021\/01\/image-30-300x221.png 300w\" sizes=\"auto, (max-width: 659px) 100vw, 659px\"><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u3053\u308c\u3067\u5207\u308a\u66ff\u3048\u306f\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-sgb-headings sgb-heading\" id=\"i-5\"><span class=\"ez-toc-section\" id=\"%E3%81%BE%E3%81%A8%E3%82%81\"><\/span><div class=\"sgb-heading__inner sgb-heading--type2\" style=\"background-color:#ffb36b;border-color:transparent;font-size:1.2em\"><span class=\"sgb-heading__text\" style=\"color:#FFF\">\u307e\u3068\u3081<\/span><\/div><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u4eca\u56de\u3001 ECS \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u4e0a\u306e MySQL \u3092 ApsaraDB RDS \u306b\u79fb\u884c\u3067\u304d\u308b\u3053\u3068\u3001\u305d\u306e\u969b\u306b Data Transmission Service \u3092\u5229\u7528\u3059\u308b\u3053\u3068\u3067\u7c21\u5358\u304b\u3064\u78ba\u5b9f\u306b\u305d\u3057\u3066\u307b\u307c\u30b3\u30b9\u30c8\u3092\u304b\u3051\u305a\u306b\u5b9f\u65bd\u3067\u304d\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3057\u305f\u3002\u3000Incremental \u3067\u306e\u540c\u671f\u3082\u53ef\u80fd\u306a\u305f\u3081\u3001\u5927\u5bb9\u91cf\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u5834\u5408\u306f\u4e8b\u524d\u306b\u521d\u56de\u540c\u671f\u3092\u5b9f\u65bd\u3057\u3001\u3042\u3068\u306f\u672c\u756a\u5207\u308a\u66ff\u3048\u307e\u3067\u306f\u6bce\u65e5\u5dee\u5206\u540c\u671f\u3092\u5b9f\u884c\u3059\u308b\u3068\u3044\u3046\u3088\u3046\u306a\u5207\u308a\u66ff\u3048\u65b9\u5f0f\u3092\u5229\u7528\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002 <\/p>\n\n\n\n<p>\u4eca\u56de\u306f\u79fb\u884c\u3067\u5229\u7528\u3057\u307e\u3057\u305f\u304c\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30b5\u30a4\u30c8\u306b\u914d\u7f6e\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u306e\u540c\u671f\u306a\u3069\u306b\u3082\u4f7f\u3048\u307e\u3059\uff08\u4eca\u56de\u5229\u7528\u3057\u305f Migration Task \u3067\u306f\u306a\u304fData Synchronization Task \u3092\u5229\u7528\uff09\u3002\u3000\u3000\u307e<\/p>\n\n\n\n<p>\u307e\u305f\u3001 Data Transmission Service \u3067\u306f\u7570\u306a\u308b\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u9593\u306e\u79fb\u884c\u3082\u53ef\u80fd\u3067\u3059\u3002\u3000 MySQL \u304b\u3089 MySQL \u306f\u3082\u3061\u308d\u3093 PostgreSQL \u3084 Oracle\u3001\u305d\u306e\u4ed6Alibaba Cloud \u306ePolarDB \u3084 AnalyticsDB \u3001DRDS \u306a\u3069\u69d8\u3005\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u79fb\u884c\u30d1\u30b9\u3092\u63d0\u4f9b\u3057\u3066\u3044\u307e\u3059\u3002\u3000\u79fb\u884c\u5143\u306f MySQL \u3060\u3051\u3067\u306f\u306a\u304f MS SQL Server \u3084 PostgreSQL \u3001Oracle \u306a\u3069\u3053\u3061\u3089\u3082\u8c4a\u5bcc\u306a\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u63d0\u4f9b\u3057\u3066\u3044\u307e\u3059\u3002\u8a73\u7d30\u306f <a href=\"https:\/\/www.alibabacloud.com\/help\/doc-detail\/176064.htm\">Document Center<\/a>\u3092\u78ba\u8a8d\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u4ee5\u4e0a<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3053\u306e\u30d6\u30ed\u30b0\u306eCMS\u306b\u306f WordPress \u3092\u5229\u7528\u3057\u3066\u3044\u307e\u3059\u3002\u3000\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f Alibaba Cloud ECS \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u4e0a\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3044\u308b MySQL \u3067\u3059\u3002\u3000\u4eca\u56de\u3001\u3053\u306e MySQL \u3092 Alibaba C &#8230; <\/p>\n","protected":false},"author":1,"featured_media":11225,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":{"0":"post-11145","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-alibaba-cloud","8":"entry"},"views":4666,"_links":{"self":[{"href":"https:\/\/www.bigriver.jp\/index.php?rest_route=\/wp\/v2\/posts\/11145","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bigriver.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bigriver.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bigriver.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bigriver.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11145"}],"version-history":[{"count":10,"href":"https:\/\/www.bigriver.jp\/index.php?rest_route=\/wp\/v2\/posts\/11145\/revisions"}],"predecessor-version":[{"id":11224,"href":"https:\/\/www.bigriver.jp\/index.php?rest_route=\/wp\/v2\/posts\/11145\/revisions\/11224"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bigriver.jp\/index.php?rest_route=\/wp\/v2\/media\/11225"}],"wp:attachment":[{"href":"https:\/\/www.bigriver.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11145"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bigriver.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11145"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bigriver.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}