{"id":3213,"date":"2026-05-01T10:31:02","date_gmt":"2026-05-01T01:31:02","guid":{"rendered":"https:\/\/www.blowfish.co.jp\/?p=3213"},"modified":"2026-05-01T10:31:02","modified_gmt":"2026-05-01T01:31:02","slug":"aws-rds-%e3%83%90%e3%83%83%e3%82%af%e3%82%a2%e3%83%83%e3%83%97%e3%83%bb%e6%a7%8b%e6%88%90","status":"publish","type":"post","link":"https:\/\/www.blowfish.co.jp\/?p=3213","title":{"rendered":"AWS RDS \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30fb\u69cb\u6210"},"content":{"rendered":"\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">1. \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u7a2e\u985e<\/h2>\n\n\n\n<p>RDS\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306b\u306f\u300c\u81ea\u52d5\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u300d\u3068\u300c\u624b\u52d5\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u300d\u306e2\u7a2e\u985e\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u81ea\u52d5\u30d0\u30c3\u30af\u30a2\u30c3\u30d7<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6bce\u65e51\u56de\u3001\u6307\u5b9a\u3057\u305f\u6642\u9593\u5e2f\u306b\u81ea\u52d5\u53d6\u5f97<\/li>\n\n\n\n<li>\u4fdd\u6301\u671f\u9593\uff1a1\u301c35\u65e5\uff080\u306b\u8a2d\u5b9a\u3059\u308b\u3068\u7121\u52b9\uff09<\/li>\n\n\n\n<li>\u30dd\u30a4\u30f3\u30c8\u30a4\u30f3\u30bf\u30a4\u30e0\u30ea\u30ab\u30d0\u30ea\uff08PITR\uff09\u304c\u53ef\u80fd<\/li>\n\n\n\n<li>\u4fdd\u6301\u671f\u9593\u3092\u904e\u304e\u308b\u3068\u81ea\u52d5\u524a\u9664\u3055\u308c\u308b<\/li>\n\n\n\n<li>RDS\u524a\u9664\u6642\u306b\u81ea\u52d5\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3082\u524a\u9664\u3055\u308c\u308b<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u624b\u52d5\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u4efb\u610f\u306e\u30bf\u30a4\u30df\u30f3\u30b0\u3067\u624b\u52d5\u53d6\u5f97<\/li>\n\n\n\n<li>\u4fdd\u6301\u671f\u9593\u306e\u5236\u9650\u306a\u3057\uff08\u660e\u793a\u7684\u306b\u524a\u9664\u3059\u308b\u307e\u3067\u4fdd\u6301\uff09<\/li>\n\n\n\n<li>PITR\u306f\u4e0d\u53ef\uff08\u53d6\u5f97\u6642\u70b9\u306b\u3057\u304b\u623b\u305b\u306a\u3044\uff09<\/li>\n\n\n\n<li>RDS\u524a\u9664\u5f8c\u3082\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306f\u6b8b\u308b<\/li>\n\n\n\n<li>\u30c7\u30d7\u30ed\u30a4\u524d\u30fb\u9577\u671f\u4fdd\u5b58\u30fb\u5225\u74b0\u5883\u3078\u306e\u79fb\u884c\u306b\u9069\u3057\u3066\u3044\u308b<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">2. \u81ea\u52d5\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3068\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u6700\u5927\u306e\u9055\u3044\uff1aPITR<\/h2>\n\n\n\n<p>\u81ea\u52d5\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3060\u3051\u304c\u6301\u3064\u6a5f\u80fd\u3067\u3001\u7279\u5b9a\u306e\u65e5\u6642\u306b\u5fa9\u5143\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th><\/th><th>\u81ea\u52d5\u30d0\u30c3\u30af\u30a2\u30c3\u30d7<\/th><th>\u624b\u52d5\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8<\/th><\/tr><\/thead><tbody><tr><td><strong>\u5fa9\u5143\u7c92\u5ea6<\/strong><\/td><td>\u4efb\u610f\u306e\u65e5\u6642\u306b\u5fa9\u5143\u53ef\u80fd<\/td><td>\u53d6\u5f97\u6642\u70b9\u306e\u307f<\/td><\/tr><tr><td><strong>\u4ed5\u7d44\u307f<\/strong><\/td><td>\u30d5\u30eb\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\uff0b\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u30ed\u30b0<\/td><td>\u30d5\u30eb\u30b3\u30d4\u30fc\u306e\u307f<\/td><\/tr><tr><td><strong>\u30ed\u30b0<\/strong><\/td><td>\u542b\u3080<\/td><td>\u542b\u307e\u306a\u3044<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">3. \u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8 vs dump\uff08\u8ad6\u7406\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\uff09<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u9805\u76ee<\/th><th>\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8<\/th><th>dump<\/th><\/tr><\/thead><tbody><tr><td><strong>\u53d6\u5f97\u65b9\u6cd5<\/strong><\/td><td>AWS\u304c\u30b9\u30c8\u30ec\u30fc\u30b8\u30ec\u30d9\u30eb\u3067\u53d6\u5f97<\/td><td>DB\u30a8\u30f3\u30b8\u30f3\u304cSQL\/\u30c7\u30fc\u30bf\u3092\u51fa\u529b<\/td><\/tr><tr><td><strong>\u51fa\u529b\u5f62\u5f0f<\/strong><\/td><td>AWS\u72ec\u81ea\u30d0\u30a4\u30ca\u30ea\u5f62\u5f0f<\/td><td>SQL\u30d5\u30a1\u30a4\u30eb \/ CSV\u306a\u3069<\/td><\/tr><tr><td><strong>\u53d6\u5f97\u30fb\u5fa9\u5143\u901f\u5ea6<\/strong><\/td><td>\u901f\u3044<\/td><td>\u9045\u3044\uff08DB\u30b5\u30a4\u30ba\u306b\u6bd4\u4f8b\uff09<\/td><\/tr><tr><td><strong>\u53ef\u642c\u6027<\/strong><\/td><td>RDS\u5185\u3067\u306e\u307f\u4f7f\u7528\u53ef\u80fd<\/td><td>\u3069\u3053\u3067\u3082\u4f7f\u7528\u53ef\u80fd<\/td><\/tr><tr><td><strong>\u7279\u5b9a\u30c6\u30fc\u30d6\u30eb\u306e\u307f<\/strong><\/td><td>\u274c \u4e0d\u53ef\uff08DB\u5168\u4f53\u306e\u307f\uff09<\/td><td>\u2705 \u53ef\u80fd<\/td><\/tr><tr><td><strong>RDS\u4ee5\u5916\u3078\u306e\u5fa9\u5143<\/strong><\/td><td>\u274c \u4e0d\u53ef<\/td><td>\u2705 \u53ef\u80fd\uff08\u30aa\u30f3\u30d7\u30ec\u7b49\uff09<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">dump\u304c\u5411\u3044\u3066\u3044\u308b\u5834\u9762<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u7279\u5b9a\u30c6\u30fc\u30d6\u30eb\u3060\u3051\u79fb\u884c\u3057\u305f\u3044<\/li>\n\n\n\n<li>RDS\u4ee5\u5916\u306e\u74b0\u5883\uff08\u30aa\u30f3\u30d7\u30ec\u30fb\u4ed6\u30af\u30e9\u30a6\u30c9\uff09\u306b\u79fb\u884c\u3057\u305f\u3044<\/li>\n\n\n\n<li>\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u4e2d\u8eab\u3092\u78ba\u8a8d\u30fb\u7de8\u96c6\u3057\u305f\u3044<\/li>\n\n\n\n<li>\u9577\u671f\u4fdd\u5b58\u3057\u3066S3\u306a\u3069\u306b\u4fdd\u7ba1\u3057\u305f\u3044<\/li>\n<\/ul>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>RDS\u9593\u306e\u79fb\u884c\uff08\u672c\u756a\u2192\u30b9\u30c6\u30fc\u30b8\u30f3\u30b0\u306a\u3069\uff09\u306f\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u304c\u6700\u9069\u3067\u3059\u3002<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">4. \u30de\u30eb\u30c1AZ\uff08\u30b9\u30bf\u30f3\u30d0\u30a4\uff09\u3068\u30ea\u30fc\u30c9\u30ec\u30d7\u30ea\u30ab\u306e\u9055\u3044<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u9805\u76ee<\/th><th>\u30de\u30eb\u30c1AZ\uff08\u30b9\u30bf\u30f3\u30d0\u30a4\uff09<\/th><th>\u30ea\u30fc\u30c9\u30ec\u30d7\u30ea\u30ab<\/th><\/tr><\/thead><tbody><tr><td><strong>\u76ee\u7684<\/strong><\/td><td>\u53ef\u7528\u6027\u30fb\u30d5\u30a7\u30a4\u30eb\u30aa\u30fc\u30d0\u30fc<\/td><td>\u8aad\u307f\u53d6\u308a\u8ca0\u8377\u5206\u6563<\/td><\/tr><tr><td><strong>\u8aad\u307f\u53d6\u308a\u306b\u4f7f\u3048\u308b\u304b<\/strong><\/td><td>\u274c \u4e0d\u53ef<\/td><td>\u2705 \u53ef\u80fd<\/td><\/tr><tr><td><strong>\u30d5\u30a7\u30a4\u30eb\u30aa\u30fc\u30d0\u30fc<\/strong><\/td><td>\u2705 \u81ea\u52d5<\/td><td>\u274c \u624b\u52d5<\/td><\/tr><tr><td><strong>\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3<\/strong><\/td><td>\u540c\u671f<\/td><td>\u975e\u540c\u671f<\/td><\/tr><tr><td><strong>\u30c7\u30fc\u30bf\u306e\u9045\u5ef6<\/strong><\/td><td>\u306a\u3057<\/td><td>\u30e9\u30b0\u3042\u308a<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u30de\u30eb\u30c1AZ\uff08\u30b9\u30bf\u30f3\u30d0\u30a4\uff09<\/h3>\n\n\n\n<p>\u30b9\u30bf\u30f3\u30d0\u30a4\u306f\u5f85\u6a5f\u5c02\u7528\u3067\u3001\u901a\u5e38\u6642\u306f\u30c8\u30e9\u30d5\u30a3\u30c3\u30af\u3092\u53d7\u3051\u307e\u305b\u3093\u3002\u30d7\u30e9\u30a4\u30de\u30ea\u306b\u969c\u5bb3\u304c\u767a\u751f\u3059\u308b\u3068\u81ea\u52d5\u7684\u306b\u30b9\u30bf\u30f3\u30d0\u30a4\u306b\u5207\u308a\u66ff\u308f\u308a\u307e\u3059\u3002\u540c\u671f\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u305f\u3081\u30c7\u30fc\u30bf\u640d\u5931\u304c\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\u901a\u5e38\u6642\uff1a\u30a2\u30d7\u30ea \u2192 \u30d7\u30e9\u30a4\u30de\u30ea\uff08\u8aad\u307f\u66f8\u304d\uff09\n                  \u2193 \u540c\u671f\n              \u30b9\u30bf\u30f3\u30d0\u30a4\uff08\u5f85\u6a5f\u4e2d\u30fb\u4f7f\u3048\u306a\u3044\uff09\n\n\u969c\u5bb3\u6642\uff1a\u30a2\u30d7\u30ea \u2192 \u30b9\u30bf\u30f3\u30d0\u30a4\uff08\u81ea\u52d5\u6607\u683c\u30fb\u5207\u308a\u66ff\u3048\uff09\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u30ea\u30fc\u30c9\u30ec\u30d7\u30ea\u30ab<\/h3>\n\n\n\n<p>\u901a\u5e38\u6642\u304b\u3089\u30a2\u30d7\u30ea\u306e\u8aad\u307f\u53d6\u308a\u30af\u30a8\u30ea\u3092\u53d7\u3051\u4ed8\u3051\u307e\u3059\u3002\u969c\u5bb3\u6642\u306e\u81ea\u52d5\u30d5\u30a7\u30a4\u30eb\u30aa\u30fc\u30d0\u30fc\u306f\u3055\u308c\u307e\u305b\u3093\u3002\u975e\u540c\u671f\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u305f\u3081\u82e5\u5e72\u306e\u30e9\u30b0\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\u901a\u5e38\u6642\uff1a\u30a2\u30d7\u30ea\uff08\u66f8\u304d\u8fbc\u307f\uff09 \u2192 \u30d7\u30e9\u30a4\u30de\u30ea\n                              \u2193 \u975e\u540c\u671f\n        \u30a2\u30d7\u30ea\uff08\u8aad\u307f\u53d6\u308a\uff09 \u2192 \u30ea\u30fc\u30c9\u30ec\u30d7\u30ea\u30ab\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">5. \u30de\u30eb\u30c1AZ\u306e\u540c\u671f\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u4ed5\u7d44\u307f<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u540c\u671f\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u6d41\u308c<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>\u2460 \u30a2\u30d7\u30ea\u304c\u66f8\u304d\u8fbc\u307f\u30ea\u30af\u30a8\u30b9\u30c8\n\u2461 \u30d7\u30e9\u30a4\u30de\u30ea\u304c\u30c7\u30fc\u30bf\u3092\u66f8\u304d\u8fbc\u307f\n\u2462 \u30b9\u30bf\u30f3\u30d0\u30a4\u3078\u540c\u671f\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\n\u2463 \u30b9\u30bf\u30f3\u30d0\u30a4\u306e\u66f8\u304d\u8fbc\u307f\u5b8c\u4e86\u3092\u78ba\u8a8d\n\u2464 \u30a2\u30d7\u30ea\u3078\u300c\u66f8\u304d\u8fbc\u307f\u5b8c\u4e86\u300d\u3092\u8fd4\u3059\n<\/code><\/pre>\n\n\n\n<p>\u2462\u2463\u304c\u5b8c\u4e86\u3059\u308b\u307e\u3067\u30a2\u30d7\u30ea\u306b\u5fdc\u7b54\u3092\u8fd4\u3055\u306a\u3044\u306e\u304c\u540c\u671f\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u7279\u5fb4\u3067\u3059\u3002\u3053\u308c\u306b\u3088\u308a\u30c7\u30fc\u30bf\u640d\u5931\u30bc\u30ed\u3092\u5b9f\u73fe\u3057\u3066\u3044\u307e\u3059\u304c\u3001\u66f8\u304d\u8fbc\u307f\u30ec\u30a4\u30c6\u30f3\u30b7\u304c\u5fae\u5897\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u30a8\u30f3\u30b8\u30f3\u5225\u306e\u5b9f\u88c5<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u30a8\u30f3\u30b8\u30f3<\/th><th>\u5b9f\u88c5\u65b9\u5f0f<\/th><\/tr><\/thead><tbody><tr><td><strong>MySQL \/ MariaDB<\/strong><\/td><td>Amazon\u72ec\u81ea\u306e\u540c\u671f\u30d6\u30ed\u30c3\u30af\u30ec\u30d9\u30eb\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3<\/td><\/tr><tr><td><strong>PostgreSQL<\/strong><\/td><td>WAL\uff08Write-Ahead Log\uff09\u306e\u30b9\u30c8\u30ea\u30fc\u30df\u30f3\u30b0\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3<\/td><\/tr><tr><td><strong>Oracle \/ SQL Server<\/strong><\/td><td>\u5404\u30a8\u30f3\u30b8\u30f3\u30cd\u30a4\u30c6\u30a3\u30d6\u306e\u540c\u671f\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u30d5\u30a7\u30a4\u30eb\u30aa\u30fc\u30d0\u30fc\u6642\u306e\u52d5\u4f5c<\/h3>\n\n\n\n<p>\u30d7\u30e9\u30a4\u30de\u30ea\u306b\u969c\u5bb3\u304c\u767a\u751f\u3057\u305f\u5834\u5408\u3001\u901a\u5e381\u301c2\u5206\u4ee5\u5185\u306b\u81ea\u52d5\u5207\u308a\u66ff\u3048\u304c\u884c\u308f\u308c\u307e\u3059\u3002DNS\u304c\u30b9\u30bf\u30f3\u30d0\u30a4\u306eIP\u306b\u5207\u308a\u66ff\u308f\u308b\u305f\u3081\u3001\u30a2\u30d7\u30ea\u306e\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u5909\u66f4\u306f\u4e0d\u8981\u3067\u3059\u3002\uff08\u63a5\u7d9a\u306e\u518d\u8a66\u884c\u306f\u5fc5\u8981\uff09<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">6. \u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u53d6\u5f97\u6642\u306e\u672c\u756a\u74b0\u5883\u3078\u306e\u5f71\u97ff<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u69cb\u6210<\/th><th>I\/O\u3078\u306e\u5f71\u97ff<\/th><th>\u5099\u8003<\/th><\/tr><\/thead><tbody><tr><td><strong>\u30b7\u30f3\u30b0\u30ebAZ<\/strong><\/td><td>\u3042\u308a<\/td><td>\u4e00\u6642\u7684\u306aI\/O\u505c\u6b62\u304c\u767a\u751f\u3059\u308b\u5834\u5408\u304c\u3042\u308b<\/td><\/tr><tr><td><strong>\u30de\u30eb\u30c1AZ<\/strong><\/td><td>\u307b\u307c\u306a\u3057<\/td><td>\u30b9\u30bf\u30f3\u30d0\u30a4\u304b\u3089\u53d6\u5f97\u3059\u308b\u305f\u3081\u5f71\u97ff\u304c\u5c0f\u3055\u3044<\/td><\/tr><tr><td><strong>Aurora<\/strong><\/td><td>\u306a\u3057<\/td><td>\u5206\u6563\u30b9\u30c8\u30ec\u30fc\u30b8\u306e\u305f\u3081\u5f71\u97ff\u306a\u3057<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u30de\u30eb\u30c1AZ\u69cb\u6210\u306e\u5834\u5408<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>\u672c\u756a\u30c8\u30e9\u30d5\u30a3\u30c3\u30af     \u2192 \u30d7\u30e9\u30a4\u30de\u30ea\uff08\u5f71\u97ff\u306a\u3057\uff09\n\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u53d6\u5f97 \u2192 \u30b9\u30bf\u30f3\u30d0\u30a4 \u2190 \u3053\u3053\u304b\u3089\u53d6\u5f97\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3078\u306e\u5f71\u97ff<\/h3>\n\n\n\n<p>\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u81ea\u4f53\u304c\u6b62\u307e\u308b\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u305f\u3060\u3057\u30b7\u30f3\u30b0\u30ebAZ\u306e\u30d7\u30e9\u30a4\u30de\u30ea\u304b\u3089\u53d6\u5f97\u3059\u308b\u5834\u5408\u3001I\/O\u8ca0\u8377\u4e0a\u6607\u306b\u3088\u308a\u30ea\u30fc\u30c9\u30ec\u30d7\u30ea\u30ab\u306e\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30e9\u30b0\u304c\u4e00\u6642\u7684\u306b\u5897\u52a0\u3059\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002\u30de\u30eb\u30c1AZ\u69cb\u6210\u3067\u306f\u30b9\u30bf\u30f3\u30d0\u30a4\u304b\u3089\u53d6\u5f97\u3059\u308b\u305f\u3081\u3001\u30d7\u30e9\u30a4\u30de\u30ea\u30fb\u30ea\u30fc\u30c9\u30ec\u30d7\u30ea\u30ab\u3068\u3082\u306b\u5f71\u97ff\u306f\u307b\u307c\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u53d6\u5f97\u5143\u306e\u81ea\u52d5\u5224\u5b9a<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u64cd\u4f5c<\/th><th>\u53d6\u5f97\u5143<\/th><\/tr><\/thead><tbody><tr><td><strong>\u81ea\u52d5\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\uff08\u30de\u30eb\u30c1AZ\uff09<\/strong><\/td><td>\u30b9\u30bf\u30f3\u30d0\u30a4\u304b\u3089\u81ea\u52d5\u53d6\u5f97<\/td><\/tr><tr><td><strong>\u624b\u52d5\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\uff08\u30de\u30eb\u30c1AZ\uff09<\/strong><\/td><td>\u30b9\u30bf\u30f3\u30d0\u30a4\u304b\u3089\u81ea\u52d5\u53d6\u5f97<\/td><\/tr><tr><td><strong>\u624b\u52d5\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\uff08\u30b7\u30f3\u30b0\u30ebAZ\uff09<\/strong><\/td><td>\u6307\u5b9a\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u304b\u3089\u53d6\u5f97\uff08\u81ea\u52d5\u5207\u66ff\u306a\u3057\uff09<\/td><\/tr><tr><td><strong>mysqldump\u306a\u3069\u306e\u30c4\u30fc\u30eb<\/strong><\/td><td>\u63a5\u7d9a\u5148\u6b21\u7b2c\uff08\u81ea\u5206\u3067\u5236\u5fa1\uff09<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\u30b7\u30f3\u30b0\u30ebAZ \uff0b \u30ea\u30fc\u30c9\u30ec\u30d7\u30ea\u30ab\u69cb\u6210\u306e\u5834\u5408\u3001\u81ea\u52d5\u7684\u306b\u30ec\u30d7\u30ea\u30ab\u304b\u3089\u53d6\u5f97\u3055\u308c\u307e\u305b\u3093\u3002\u30ec\u30d7\u30ea\u30ab\u304b\u3089\u53d6\u5f97\u3057\u305f\u3044\u5834\u5408\u306f\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u8b58\u5225\u5b50\u3092\u660e\u793a\u7684\u306b\u6307\u5b9a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">7. RDS\u306e\u30ed\u30fc\u30eb\u7a2e\u985e<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u30ed\u30fc\u30eb\u8868\u793a<\/th><th>\u610f\u5473<\/th><\/tr><\/thead><tbody><tr><td><strong>\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9<\/strong><\/td><td>\u30b7\u30f3\u30b0\u30eb\u69cb\u6210\u307e\u305f\u306f\u30de\u30eb\u30c1AZ\uff08\u30ec\u30d7\u30ea\u30ab\u306a\u3057\uff09<\/td><\/tr><tr><td><strong>\u30d7\u30e9\u30a4\u30de\u30ea<\/strong><\/td><td>\u30de\u30eb\u30c1AZ \u307e\u305f\u306f \u30ea\u30fc\u30c9\u30ec\u30d7\u30ea\u30ab\u306e\u89aa<\/td><\/tr><tr><td><strong>\u30b9\u30bf\u30f3\u30d0\u30a4<\/strong><\/td><td>\u30de\u30eb\u30c1AZ\u306e\u30b9\u30bf\u30f3\u30d0\u30a4\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9<\/td><\/tr><tr><td><strong>\u30ec\u30d7\u30ea\u30ab<\/strong><\/td><td>\u30ea\u30fc\u30c9\u30ec\u30d7\u30ea\u30ab<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">CLI\u3067\u306e\u78ba\u8a8d\u65b9\u6cd5<\/h3>\n\n\n\n<p><strong>\u30ea\u30fc\u30c9\u30ec\u30d7\u30ea\u30ab\u306e\u78ba\u8a8d<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>aws rds describe-db-instances \\\n  --db-instance-identifier your-db \\\n  --query 'DBInstances&#91;0].ReadReplicaDBInstanceIdentifiers'\n# \u7a7a\u914d\u5217 &#91;] \u3067\u3042\u308c\u3070\u30ea\u30fc\u30c9\u30ec\u30d7\u30ea\u30ab\u306a\u3057\n<\/code><\/pre>\n\n\n\n<p><strong>\u30de\u30eb\u30c1AZ\u306e\u78ba\u8a8d<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>aws rds describe-db-instances \\\n  --db-instance-identifier your-db \\\n  --query 'DBInstances&#91;0].MultiAZ'\n# true \u3067\u3042\u308c\u3070\u30de\u30eb\u30c1AZ\u69cb\u6210\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">8. \u672c\u756a\u2192\u30b9\u30c6\u30fc\u30b8\u30f3\u30b0\u74b0\u5883\u3078\u306e\u30c7\u30fc\u30bf\u79fb\u884c\u624b\u9806<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>\u672c\u756aRDS \u2192 \u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u53d6\u5f97 \u2192 \u30b9\u30c6\u30fc\u30b8\u30f3\u30b0RDS\u3068\u3057\u3066\u5fa9\u5143\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: \u672c\u756a\u74b0\u5883\u306e\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u53d6\u5f97<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>aws rds create-db-snapshot \\\n  --db-instance-identifier prod-db \\\n  --db-snapshot-identifier prod-snapshot-$(date +%Y%m%d)\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: \u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u5fa9\u5143\uff08\u30b9\u30c6\u30fc\u30b8\u30f3\u30b0\u7528DB\u3068\u3057\u3066\uff09<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>aws rds restore-db-instance-from-db-snapshot \\\n  --db-instance-identifier staging-db \\\n  --db-snapshot-identifier prod-snapshot-$(date +%Y%m%d) \\\n  --db-instance-class db.t3.medium \\\n  --db-subnet-group-name staging-subnet-group \\\n  --no-publicly-accessible\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: \u79fb\u884c\u5f8c\u306e\u5fc5\u9808\u5bfe\u5fdc<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u500b\u4eba\u60c5\u5831\u30fb\u6a5f\u5bc6\u30c7\u30fc\u30bf\u306e\u30de\u30b9\u30ad\u30f3\u30b0\uff08\u30e1\u30fc\u30eb\u30fb\u96fb\u8a71\u756a\u53f7\u30fb\u30d1\u30b9\u30ef\u30fc\u30c9\u7b49\uff09<\/li>\n\n\n\n<li>\u5916\u90e8\u9023\u643a\uff08\u6c7a\u6e08\u30fb\u901a\u77e5API\u7b49\uff09\u306e\u5411\u304d\u5148\u3092\u30b9\u30c6\u30fc\u30b8\u30f3\u30b0\u7528\u306b\u5909\u66f4<\/li>\n\n\n\n<li>VPC\u30fb\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\u304c\u30b9\u30c6\u30fc\u30b8\u30f3\u30b0\u7528\u306b\u306a\u3063\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d<\/li>\n\n\n\n<li>\u30a2\u30d7\u30ea\u306e\u63a5\u7d9a\u5148\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u3092\u66f4\u65b0<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u79fb\u884c\u6642\u306e\u6ce8\u610f\u70b9<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u78ba\u8a8d\u9805\u76ee<\/th><th>\u7406\u7531<\/th><\/tr><\/thead><tbody><tr><td><strong>VPC \/ \u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7<\/strong><\/td><td>\u672c\u756a\u3068\u6df7\u5728\u3055\u305b\u306a\u3044<\/td><\/tr><tr><td><strong>\u500b\u4eba\u60c5\u5831\u306e\u30de\u30b9\u30ad\u30f3\u30b0<\/strong><\/td><td>\u6cd5\u7684\u30ea\u30b9\u30af\uff08\u500b\u4eba\u60c5\u5831\u4fdd\u8b77\u6cd5\u7b49\uff09<\/td><\/tr><tr><td><strong>\u5916\u90e8API\u306e\u5411\u304d\u5148<\/strong><\/td><td>\u30b9\u30c6\u30fc\u30b8\u30f3\u30b0\u304b\u3089\u672c\u756aAPI\u3092\u53e9\u304b\u306a\u3044\u3088\u3046<\/td><\/tr><tr><td><strong>RDS\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u306e\u5909\u66f4<\/strong><\/td><td>\u30a2\u30d7\u30ea\u306e\u63a5\u7d9a\u5148\u3092\u5fc5\u305a\u66f4\u65b0<\/td><\/tr><tr><td><strong>\u6697\u53f7\u5316\u30ad\u30fc\uff08KMS\uff09<\/strong><\/td><td>\u5225\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u5834\u5408\u306f\u30ad\u30fc\u306e\u30b3\u30d4\u30fc\u304c\u5fc5\u8981<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>1. \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u7a2e\u985e RDS\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306b\u306f\u300c\u81ea\u52d5\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u300d\u3068\u300c\u624b\u52d5\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u300d\u306e2\u7a2e\u985e\u304c\u3042\u308a\u307e\u3059\u3002 \u81ea\u52d5\u30d0\u30c3\u30af\u30a2\u30c3\u30d7 \u624b\u52d5\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8 2. \u81ea\u52d5\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3068\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u6700\u5927\u306e\u9055\u3044\uff1aPITR [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"saved_in_kubio":false,"footnotes":""},"categories":[73,11,90,4],"tags":[],"class_list":["post-3213","post","type-post","status-publish","format-standard","hentry","category-aws","category-mysql","category-rds","category-tech"],"_links":{"self":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/3213","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3213"}],"version-history":[{"count":2,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/3213\/revisions"}],"predecessor-version":[{"id":3215,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/3213\/revisions\/3215"}],"wp:attachment":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3213"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3213"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3213"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}