{"id":2331,"date":"2025-03-24T08:47:40","date_gmt":"2025-03-23T23:47:40","guid":{"rendered":"https:\/\/dexall.co.jp\/articles\/?p=2331"},"modified":"2025-03-24T08:48:03","modified_gmt":"2025-03-23T23:48:03","slug":"%e3%80%90%e4%bf%9d%e5%ad%98%e7%89%88%e3%80%91terraform%e3%81%a7%e4%bd%9c%e3%82%8baws-rds%e7%92%b0%e5%a2%83%e6%a7%8b%e7%af%89%e5%ae%8c%e5%85%a8%e3%82%ac%e3%82%a4%e3%83%892024-%e3%80%9c%e5%ae%9f","status":"publish","type":"post","link":"https:\/\/dexall.co.jp\/articles\/?p=2331","title":{"rendered":"\u3010\u4fdd\u5b58\u7248\u3011Terraform\u3067\u4f5c\u308bAWS RDS\u74b0\u5883\u69cb\u7bc9\u5b8c\u5168\u30ac\u30a4\u30c92024 \u301c\u5b9f\u8df5\u7684\u306a11\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\u301c"},"content":{"rendered":"\n<div class=\"toc\"><br \/>\n<b>Warning<\/b>:  Undefined array key \"is_admin\" in <b>\/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/sango-theme\/library\/gutenberg\/dist\/classes\/Toc.php<\/b> on line <b>116<\/b><br \/>\n<br \/>\n<b>Warning<\/b>:  Undefined array key \"is_category_top\" in <b>\/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/sango-theme\/library\/gutenberg\/dist\/classes\/Toc.php<\/b> on line <b>121<\/b><br \/>\n<br \/>\n<b>Warning<\/b>:  Undefined array key \"is_top\" in <b>\/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/sango-theme\/library\/gutenberg\/dist\/classes\/Toc.php<\/b> on line <b>128<\/b><br \/>\n    <div id=\"toc_container\" class=\"sgb-toc--bullets js-smooth-scroll\" data-dialog-title=\"\u76ee\u6b21\">\n      <p class=\"toc_title\">\u76ee\u6b21 <\/p>\n      <ul class=\"toc_list\">  <li class=\"first\">    <a href=\"#i-0\">Terraform\u3092\u4f7f\u7528\u3057\u305fRDS\u69cb\u7bc9\u306e\u57fa\u790e\u77e5\u8b58<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-1\">Terraform\u3068\u306f<\/a>      <\/li>      <li>        <a href=\"#i-2\">Terraform\u3068RDS\u306e\u95a2\u4fc2\u6027\u3092\u7406\u89e3\u3059\u308b<\/a>      <\/li>      <li>        <a href=\"#i-3\">Terraform\u3067\u5b9a\u7fa9\u3067\u304d\u308bRDS\u306e\u4e3b\u8981\u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8<\/a>      <\/li>      <li>        <a href=\"#i-4\">\u4e3b\u8981\u306a\u8a2d\u5b9a\u9805\u76ee\u306e\u89e3\u8aac<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-5\">\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-6\">\u5b9f\u8df5\u7684\u306aRDS\u74b0\u5883\u69cb\u7bc9\u306e\u305f\u3081\u306eTerraform\u5b9f\u88c5\u4f8b<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-7\">\u57fa\u672c\u7684\u306aRDS\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u4f5c\u6210\u65b9\u6cd5<\/a>      <\/li>      <li>        <a href=\"#i-8\">\u30de\u30eb\u30c1AZ\u69cb\u6210\u306e\u5b9f\u88c5\u624b\u9806<\/a>      <\/li>      <li>        <a href=\"#i-9\">\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3068\u30ea\u30b9\u30c8\u30a2\u8a2d\u5b9a\u306e\u5b9f\u88c5<\/a>      <\/li>      <li>        <a href=\"#i-10\">\u30ea\u30bd\u30fc\u30b9\u8a2d\u5b9a\u306e\u30dd\u30a4\u30f3\u30c8<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-11\">\u5b9f\u88c5\u6642\u306e\u6ce8\u610f\u70b9<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-12\">\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u3068\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u6700\u9069\u5316<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-13\">IAM\u3068\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\u306e\u9069\u5207\u306a\u8a2d\u5b9a<\/a>      <\/li>      <li>        <a href=\"#i-14\">\u6697\u53f7\u5316\u30aa\u30d7\u30b7\u30e7\u30f3\u306e\u5b9f\u88c5\u65b9\u6cd5<\/a>      <\/li>      <li>        <a href=\"#i-15\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/a>      <\/li>      <li>        <a href=\"#i-16\">\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30c1\u30a7\u30c3\u30af\u30ea\u30b9\u30c8<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-17\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u30dd\u30a4\u30f3\u30c8<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-18\">\u904b\u7528\u7ba1\u7406\u306e\u305f\u3081\u306e\u9ad8\u5ea6\u306a\u8a2d\u5b9a<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-19\">\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0\u3068\u30a2\u30e9\u30fc\u30c8\u8a2d\u5b9a\u306e\u5b9f\u88c5<\/a>      <\/li>      <li>        <a href=\"#i-20\">\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u30a6\u30a3\u30f3\u30c9\u30a6\u3068\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u6226\u7565<\/a>      <\/li>      <li>        <a href=\"#i-21\">\u76e3\u8996\u30e1\u30c8\u30ea\u30af\u30b9\u4e00\u89a7<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-22\">\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u8a08\u753b\u306e\u30dd\u30a4\u30f3\u30c8<\/a>      <\/li>    <\/ul>  <\/li>  <li class=\"last\">    <a href=\"#i-23\">\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0\u3068\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-24\">\u3088\u304f\u3042\u308b\u554f\u984c\u3068\u305d\u306e\u89e3\u6c7a\u65b9\u6cd5<\/a>      <\/li>      <li>        <a href=\"#i-25\">\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0\u30ac\u30a4\u30c9<\/a>      <\/li>      <li>        <a href=\"#i-26\">\u672c\u756a\u74b0\u5883\u3067\u306e\u904b\u7528\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/a>      <\/li>      <li>        <a href=\"#i-27\">\u672c\u756a\u74b0\u5883\u30c1\u30a7\u30c3\u30af\u30ea\u30b9\u30c8<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-28\">\u30a4\u30f3\u30d5\u30e9\u30b9\u30c8\u30e9\u30af\u30c1\u30e3\u30b3\u30fc\u30c9\u7ba1\u7406<\/a>      <\/li>    <\/ul>  <\/li><\/ul>\n      <a href=\"#\" class=\"sgb-toc-button js-toc-button\" rel=\"nofollow\" data-open-dialog=\"true\"><i class=\"fa fa-list\"><\/i><span class=\"sgb-toc-button__text\">\u76ee\u6b21\u3078<\/span><\/a>\n    <\/div><\/div><h2 class=\"wp-block-heading\" id=\"i-0\">Terraform\u3092\u4f7f\u7528\u3057\u305fRDS\u69cb\u7bc9\u306e\u57fa\u790e\u77e5\u8b58<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-1\">Terraform\u3068\u306f<\/h3>\n\n\n\n<p>Terraform\u306fHashiCorp\u304c\u958b\u767a\u3057\u305f\u30a4\u30f3\u30d5\u30e9\u30b9\u30c8\u30e9\u30af\u30c1\u30e3\u30fb\u30a2\u30ba\u30fb\u30b3\u30fc\u30c9\uff08IaC\uff09\u30c4\u30fc\u30eb\u3067\u3059\u3002AWS\u306eRDS\u3092\u542b\u3080\u5404\u7a2e\u30ea\u30bd\u30fc\u30b9\u3092\u3001\u30b3\u30fc\u30c9\u3067\u5ba3\u8a00\u7684\u306b\u7ba1\u7406\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-2\">Terraform\u3068RDS\u306e\u95a2\u4fc2\u6027\u3092\u7406\u89e3\u3059\u308b<\/h3>\n\n\n\n<p>Terraform\u3067RDS\u3092\u7ba1\u7406\u3059\u308b\u30e1\u30ea\u30c3\u30c8\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u30a4\u30f3\u30d5\u30e9\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u7ba1\u7406<\/strong>: Git\u306a\u3069\u3067RDS\u69cb\u6210\u306e\u5909\u66f4\u5c65\u6b74\u3092\u8ffd\u8de1\u53ef\u80fd<\/li>\n\n\n\n<li><strong>\u74b0\u5883\u306e\u518d\u73fe\u6027<\/strong>: \u672c\u756a\/\u958b\u767a\/\u691c\u8a3c\u74b0\u5883\u3092\u540c\u3058\u30b3\u30fc\u30c9\u3067\u69cb\u7bc9\u53ef\u80fd<\/li>\n\n\n\n<li><strong>\u81ea\u52d5\u5316<\/strong>: \u30d7\u30ed\u30d3\u30b8\u30e7\u30cb\u30f3\u30b0\u3084\u8a2d\u5b9a\u5909\u66f4\u3092\u81ea\u52d5\u5316<\/li>\n\n\n\n<li><strong>\u30c9\u30ea\u30d5\u30c8\u691c\u77e5<\/strong>: \u624b\u52d5\u5909\u66f4\u3055\u308c\u305f\u8a2d\u5b9a\u306e\u691c\u51fa\u304c\u5bb9\u6613<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-3\">Terraform\u3067\u5b9a\u7fa9\u3067\u304d\u308bRDS\u306e\u4e3b\u8981\u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>RDS\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u57fa\u672c\u8a2d\u5b9a<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">resource \"aws_db_instance\" \"example\" {\n  identifier        = \"example-database\"\n  engine            = \"mysql\"\n  engine_version    = \"8.0.28\"\n  instance_class    = \"db.t3.micro\"\n  allocated_storage = 20\n\n  # \u8a8d\u8a3c\u60c5\u5831\n  username = \"admin\"\n  password = \"your_password_here\"\n\n  # \u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u8a2d\u5b9a\n  vpc_security_group_ids = [aws_security_group.rds.id]\n  db_subnet_group_name   = aws_db_subnet_group.example.name\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30b5\u30d6\u30cd\u30c3\u30c8\u30b0\u30eb\u30fc\u30d7<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">resource \"aws_db_subnet_group\" \"example\" {\n  name       = \"example-subnet-group\"\n  subnet_ids = [aws_subnet.private1.id, aws_subnet.private2.id]\n\n  tags = {\n    Name = \"Example DB subnet group\"\n  }\n}<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u30d1\u30e9\u30e1\u30fc\u30bf\u30b0\u30eb\u30fc\u30d7<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">resource \"aws_db_parameter_group\" \"example\" {\n  family = \"mysql8.0\"\n  name   = \"example-paramgroup\"\n\n  parameter {\n    name  = \"character_set_server\"\n    value = \"utf8mb4\"\n  }\n\n  parameter {\n    name  = \"collation_server\"\n    value = \"utf8mb4_unicode_ci\"\n  }\n}<\/pre>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li><strong>\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">resource \"aws_security_group\" \"rds\" {\n  name        = \"example-rds-sg\"\n  description = \"Security group for RDS instance\"\n  vpc_id      = aws_vpc.main.id\n\n  ingress {\n    from_port       = 3306\n    to_port         = 3306\n    protocol        = \"tcp\"\n    security_groups = [aws_security_group.app.id]\n  }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-4\">\u4e3b\u8981\u306a\u8a2d\u5b9a\u9805\u76ee\u306e\u89e3\u8aac<\/h3>\n\n\n<div id=\"id-b72aa9fc-cdb1-44cd-aacf-da79f84e1e32\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u8a2d\u5b9a\u9805\u76ee<\/th><th>\u8aac\u660e<\/th><th>\u91cd\u8981\u5ea6<\/th><\/tr><\/thead><tbody><tr><td>engine<\/td><td>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a8\u30f3\u30b8\u30f3\u306e\u7a2e\u985e\uff08MySQL, PostgreSQL\u7b49\uff09<\/td><td>\u5fc5\u9808<\/td><\/tr><tr><td>instance_class<\/td><td>\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u30bf\u30a4\u30d7\uff08\u6027\u80fd\u3068\u30b3\u30b9\u30c8\u306b\u5f71\u97ff\uff09<\/td><td>\u5fc5\u9808<\/td><\/tr><tr><td>allocated_storage<\/td><td>\u30b9\u30c8\u30ec\u30fc\u30b8\u30b5\u30a4\u30ba\uff08GB\uff09<\/td><td>\u5fc5\u9808<\/td><\/tr><tr><td>backup_retention_period<\/td><td>\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u4fdd\u6301\u671f\u9593\uff08\u65e5\u6570\uff09<\/td><td>\u63a8\u5968<\/td><\/tr><tr><td>multi_az<\/td><td>\u30de\u30eb\u30c1AZ\u914d\u7f6e\u306e\u6709\u52b9\u5316<\/td><td>\u63a8\u5968<\/td><\/tr><tr><td>storage_encrypted<\/td><td>\u30b9\u30c8\u30ec\u30fc\u30b8\u306e\u6697\u53f7\u5316<\/td><td>\u63a8\u5968<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"i-5\">\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u547d\u540d\u898f\u5247\u306e\u7d71\u4e00<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u74b0\u5883\u3084\u7528\u9014\u3092\u8b58\u5225\u3067\u304d\u308b\u547d\u540d\u898f\u5247\u3092\u63a1\u7528<\/li>\n\n\n\n<li>\u30d7\u30ec\u30d5\u30a3\u30c3\u30af\u30b9\u3084\u30b5\u30d5\u30a3\u30c3\u30af\u30b9\u306e\u4e00\u8cab\u3057\u305f\u4f7f\u7528<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30e2\u30b8\u30e5\u30fc\u30eb\u5316<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u518d\u5229\u7528\u53ef\u80fd\u306a\u30e2\u30b8\u30e5\u30fc\u30eb\u3068\u3057\u3066RDS\u8a2d\u5b9a\u3092\u7ba1\u7406<\/li>\n\n\n\n<li>\u74b0\u5883\u5dee\u5206\u306fvariables\u3067\u5438\u53ce<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u5bfe\u7b56<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>IAM\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u8a8d\u8a3c\u306e\u6d3b\u7528<\/li>\n\n\n\n<li>\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\u306e\u6700\u5c0f\u6a29\u9650\u8a2d\u5b9a<\/li>\n\n\n\n<li>\u30b9\u30c8\u30ec\u30fc\u30b8\u6697\u53f7\u5316\u306e\u6709\u52b9\u5316<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-6\">\u5b9f\u8df5\u7684\u306aRDS\u74b0\u5883\u69cb\u7bc9\u306e\u305f\u3081\u306eTerraform\u5b9f\u88c5\u4f8b<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-7\">\u57fa\u672c\u7684\u306aRDS\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u4f5c\u6210\u65b9\u6cd5<\/h3>\n\n\n\n<p>\u57fa\u672c\u7684\u306aRDS\u69cb\u6210\u306e\u30b3\u30fc\u30c9\u4f8b\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># \u30d7\u30ed\u30d0\u30a4\u30c0\u30fc\u8a2d\u5b9a\nprovider \"aws\" {\n  region = \"ap-northeast-1\"\n}\n\n# VPC\u8a2d\u5b9a\nresource \"aws_vpc\" \"main\" {\n  cidr_block = \"10.0.0.0\/16\"\n\n  tags = {\n    Name = \"main\"\n  }\n}\n\n# \u30b5\u30d6\u30cd\u30c3\u30c8\u8a2d\u5b9a\nresource \"aws_subnet\" \"private1\" {\n  vpc_id     = aws_vpc.main.id\n  cidr_block = \"10.0.1.0\/24\"\n  availability_zone = \"ap-northeast-1a\"\n}\n\nresource \"aws_subnet\" \"private2\" {\n  vpc_id     = aws_vpc.main.id\n  cidr_block = \"10.0.2.0\/24\"\n  availability_zone = \"ap-northeast-1c\"\n}\n\n# RDS\u30b5\u30d6\u30cd\u30c3\u30c8\u30b0\u30eb\u30fc\u30d7\nresource \"aws_db_subnet_group\" \"main\" {\n  name       = \"main\"\n  subnet_ids = [aws_subnet.private1.id, aws_subnet.private2.id]\n}\n\n# RDS\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\nresource \"aws_db_instance\" \"main\" {\n  identifier        = \"main-db\"\n  engine            = \"mysql\"\n  engine_version    = \"8.0.28\"\n  instance_class    = \"db.t3.micro\"\n  allocated_storage = 20\n\n  db_name  = \"myappdb\"\n  username = \"admin\"\n  password = var.db_password\n\n  db_subnet_group_name   = aws_db_subnet_group.main.name\n  vpc_security_group_ids = [aws_security_group.rds.id]\n\n  skip_final_snapshot = true\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-8\">\u30de\u30eb\u30c1AZ\u69cb\u6210\u306e\u5b9f\u88c5\u624b\u9806<\/h3>\n\n\n\n<p>\u9ad8\u53ef\u7528\u6027\u3092\u5b9f\u73fe\u3059\u308b\u30de\u30eb\u30c1AZ\u69cb\u6210\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">resource \"aws_db_instance\" \"main\" {\n  # \u57fa\u672c\u8a2d\u5b9a\u306f\u524d\u8ff0\u3068\u540c\u3058\n\n  multi_az               = true\n  backup_retention_period = 7\n  backup_window          = \"03:00-04:00\"\n  maintenance_window     = \"Mon:04:00-Mon:05:00\"\n\n  auto_minor_version_upgrade = true\n\n  # \u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u8a2d\u5b9a\n  max_allocated_storage = 1000  # \u30b9\u30c8\u30ec\u30fc\u30b8\u306e\u81ea\u52d5\u30b9\u30b1\u30fc\u30ea\u30f3\u30b0\u4e0a\u9650\n  monitoring_interval   = 60    # \u62e1\u5f35\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0\u9593\u9694\n  monitoring_role_arn   = aws_iam_role.rds_monitoring.arn\n\n  # \u707d\u5bb3\u5bfe\u7b56\u8a2d\u5b9a\n  deletion_protection = true\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-9\">\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3068\u30ea\u30b9\u30c8\u30a2\u8a2d\u5b9a\u306e\u5b9f\u88c5<\/h3>\n\n\n\n<p>\u81ea\u52d5\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3068\u5fa9\u5143\u30dd\u30a4\u30f3\u30c8\u306e\u8a2d\u5b9a\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># S3\u30d0\u30b1\u30c3\u30c8\uff08\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u4fdd\u5b58\u7528\uff09\nresource \"aws_s3_bucket\" \"backup\" {\n  bucket = \"my-rds-backup-bucket\"\n}\n\nresource \"aws_s3_bucket_public_access_block\" \"backup\" {\n  bucket = aws_s3_bucket.backup.id\n\n  block_public_acls       = true\n  block_public_policy     = true\n  ignore_public_acls      = true\n  restrict_public_buckets = true\n}\n\n# RDS\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u8a2d\u5b9a\nresource \"aws_db_instance\" \"main\" {\n  # \u57fa\u672c\u8a2d\u5b9a\u306f\u524d\u8ff0\u3068\u540c\u3058\n\n  backup_retention_period = 14\n  backup_window          = \"03:00-04:00\"\n\n  # \u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u8a2d\u5b9a\n  copy_tags_to_snapshot = true\n\n  # \u81ea\u52d5\u30de\u30a4\u30ca\u30fc\u30d0\u30fc\u30b8\u30e7\u30f3\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\n  auto_minor_version_upgrade = true\n\n  # Performance Insights\u8a2d\u5b9a\n  performance_insights_enabled = true\n  performance_insights_retention_period = 7\n}\n\n# CloudWatch\u30a2\u30e9\u30fc\u30e0\uff08\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5931\u6557\u691c\u77e5\u7528\uff09\nresource \"aws_cloudwatch_metric_alarm\" \"backup_failed\" {\n  alarm_name          = \"rds-backup-failed\"\n  comparison_operator = \"GreaterThanThreshold\"\n  evaluation_periods  = \"1\"\n  metric_name         = \"BackupFailed\"\n  namespace           = \"AWS\/RDS\"\n  period             = \"300\"\n  statistic          = \"Sum\"\n  threshold          = \"0\"\n\n  dimensions = {\n    DBInstanceIdentifier = aws_db_instance.main.id\n  }\n\n  alarm_description = \"RDS\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5931\u6557\u3092\u691c\u77e5\"\n  alarm_actions     = [aws_sns_topic.alerts.arn]\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-10\">\u30ea\u30bd\u30fc\u30b9\u8a2d\u5b9a\u306e\u30dd\u30a4\u30f3\u30c8<\/h3>\n\n\n<div id=\"id-10e22ddb-0323-4f6c-9819-d2c88290dfa8\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u8a2d\u5b9a\u9805\u76ee<\/th><th>\u63a8\u5968\u5024<\/th><th>\u8aac\u660e<\/th><\/tr><\/thead><tbody><tr><td>multi_az<\/td><td>true<\/td><td>\u672c\u756a\u74b0\u5883\u3067\u306f\u5fc5\u9808<\/td><\/tr><tr><td>backup_retention_period<\/td><td>7-35\u65e5<\/td><td>\u8981\u4ef6\u306b\u5fdc\u3058\u3066\u8abf\u6574<\/td><\/tr><tr><td>deletion_protection<\/td><td>true<\/td><td>\u672c\u756a\u74b0\u5883\u3067\u306f\u5fc5\u9808<\/td><\/tr><tr><td>monitoring_interval<\/td><td>60\u79d2<\/td><td>\u6a19\u6e96\u7684\u306a\u76e3\u8996\u9593\u9694<\/td><\/tr><tr><td>performance_insights_enabled<\/td><td>true<\/td><td>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u5206\u6790\u306b\u6709\u7528<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"i-11\">\u5b9f\u88c5\u6642\u306e\u6ce8\u610f\u70b9<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30ea\u30bd\u30fc\u30b9\u540d\u306e\u4e00\u610f\u6027<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30b0\u30ed\u30fc\u30d0\u30eb\u3067\u4e00\u610f\u306a\u30ea\u30bd\u30fc\u30b9\u540d\u306e\u4f7f\u7528<\/li>\n\n\n\n<li>\u74b0\u5883\u8b58\u5225\u5b50\u306e\u30d7\u30ec\u30d5\u30a3\u30c3\u30af\u30b9\u4ed8\u4e0e<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u8a2d\u5b9a<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30d1\u30b9\u30ef\u30fc\u30c9\u306f\u5909\u6570\u5316\u3057\u3066\u7ba1\u7406<\/li>\n\n\n\n<li>\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\u306e\u9069\u5207\u306a\u8a2d\u5b9a<\/li>\n\n\n\n<li>\u6697\u53f7\u5316\u306e\u6709\u52b9\u5316<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30b3\u30b9\u30c8\u6700\u9069\u5316<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u30b5\u30a4\u30ba\u306e\u9069\u5207\u306a\u9078\u629e<\/li>\n\n\n\n<li>\u4e0d\u8981\u306a\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u524a\u9664<\/li>\n\n\n\n<li>\u81ea\u52d5\u30b9\u30b1\u30fc\u30ea\u30f3\u30b0\u306e\u4e0a\u9650\u8a2d\u5b9a<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-12\">\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u3068\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u6700\u9069\u5316<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-13\">IAM\u3068\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\u306e\u9069\u5207\u306a\u8a2d\u5b9a<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># IAM\u30ed\u30fc\u30eb\nresource \"aws_iam_role\" \"rds_monitoring\" {\n  name = \"rds-monitoring-role\"\n\n  assume_role_policy = jsonencode({\n    Version = \"2012-10-17\"\n    Statement = [\n      {\n        Action = \"sts:AssumeRole\"\n        Effect = \"Allow\"\n        Principal = {\n          Service = \"monitoring.rds.amazonaws.com\"\n        }\n      }\n    ]\n  })\n}\n\n# \u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\nresource \"aws_security_group\" \"rds\" {\n  name   = \"rds-sg\"\n  vpc_id = aws_vpc.main.id\n\n  ingress {\n    from_port       = 3306\n    to_port         = 3306\n    protocol        = \"tcp\"\n    security_groups = [aws_security_group.app.id]\n    description     = \"Allow MySQL access from application\"\n  }\n\n  egress {\n    from_port   = 0\n    to_port     = 0\n    protocol    = \"-1\"\n    cidr_blocks = [\"0.0.0.0\/0\"]\n  }\n\n  lifecycle {\n    create_before_destroy = true\n  }\n}\n\n# IAM\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u8a8d\u8a3c\u306e\u8a2d\u5b9a\nresource \"aws_db_instance\" \"main\" {\n  # \u65e2\u5b58\u306e\u8a2d\u5b9a\u306b\u8ffd\u52a0\n  iam_database_authentication_enabled = true\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-14\">\u6697\u53f7\u5316\u30aa\u30d7\u30b7\u30e7\u30f3\u306e\u5b9f\u88c5\u65b9\u6cd5<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># KMS\u30ad\u30fc\nresource \"aws_kms_key\" \"rds\" {\n  description             = \"KMS key for RDS encryption\"\n  deletion_window_in_days = 7\n  enable_key_rotation     = true\n}\n\nresource \"aws_kms_alias\" \"rds\" {\n  name          = \"alias\/rds-encryption\"\n  target_key_id = aws_kms_key.rds.key_id\n}\n\n# \u6697\u53f7\u5316\u8a2d\u5b9a\u4ed8\u304dRDS\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\nresource \"aws_db_instance\" \"main\" {\n  # \u65e2\u5b58\u306e\u8a2d\u5b9a\u306b\u8ffd\u52a0\n  storage_encrypted = true\n  kms_key_id       = aws_kms_key.rds.arn\n\n  # SSL\u63a5\u7d9a\u306e\u5f37\u5236\n  parameter_group_name = aws_db_parameter_group.main.name\n}\n\n# \u30d1\u30e9\u30e1\u30fc\u30bf\u30b0\u30eb\u30fc\u30d7\uff08SSL\u5f37\u5236\uff09\nresource \"aws_db_parameter_group\" \"main\" {\n  family = \"mysql8.0\"\n\n  parameter {\n    name  = \"require_secure_transport\"\n    value = \"ON\"\n  }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-15\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># \u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u7528\u30d1\u30e9\u30e1\u30fc\u30bf\u30b0\u30eb\u30fc\u30d7\nresource \"aws_db_parameter_group\" \"performance\" {\n  family = \"mysql8.0\"\n  name   = \"performance-optimized\"\n\n  parameter {\n    name  = \"innodb_buffer_pool_size\"\n    value = \"{DBInstanceClassMemory*3\/4}\"\n  }\n\n  parameter {\n    name  = \"max_connections\"\n    value = \"1000\"\n  }\n\n  parameter {\n    name  = \"slow_query_log\"\n    value = \"1\"\n  }\n\n  parameter {\n    name  = \"long_query_time\"\n    value = \"2\"\n  }\n}\n\n# \u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30a4\u30f3\u30b5\u30a4\u30c8\u8a2d\u5b9a\nresource \"aws_db_instance\" \"main\" {\n  # \u65e2\u5b58\u306e\u8a2d\u5b9a\u306b\u8ffd\u52a0\n  parameter_group_name               = aws_db_parameter_group.performance.name\n  performance_insights_enabled       = true\n  performance_insights_retention_period = 7\n  monitoring_interval               = 60\n  monitoring_role_arn              = aws_iam_role.rds_monitoring.arn\n\n  # \u30aa\u30fc\u30c8\u30b9\u30b1\u30fc\u30ea\u30f3\u30b0\u8a2d\u5b9a\n  max_allocated_storage            = 1000\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-16\">\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30c1\u30a7\u30c3\u30af\u30ea\u30b9\u30c8<\/h3>\n\n\n<div id=\"id-87c888cf-2a60-420b-b194-43c4e66f93dc\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u9805\u76ee<\/th><th>\u5b9f\u88c5\u65b9\u6cd5<\/th><th>\u91cd\u8981\u5ea6<\/th><\/tr><\/thead><tbody><tr><td>\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u5206\u96e2<\/td><td>\u30d7\u30e9\u30a4\u30d9\u30fc\u30c8\u30b5\u30d6\u30cd\u30c3\u30c8\u914d\u7f6e<\/td><td>\u5fc5\u9808<\/td><\/tr><tr><td>\u30a2\u30af\u30bb\u30b9\u5236\u5fa1<\/td><td>\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7<\/td><td>\u5fc5\u9808<\/td><\/tr><tr><td>\u30c7\u30fc\u30bf\u6697\u53f7\u5316<\/td><td>KMS + storage_encrypted<\/td><td>\u5fc5\u9808<\/td><\/tr><tr><td>\u901a\u4fe1\u6697\u53f7\u5316<\/td><td>SSL\/TLS\u5f37\u5236<\/td><td>\u63a8\u5968<\/td><\/tr><tr><td>\u8a8d\u8a3c\u5f37\u5316<\/td><td>IAM\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u8a8d\u8a3c<\/td><td>\u63a8\u5968<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"i-17\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u30dd\u30a4\u30f3\u30c8<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u30b5\u30a4\u30b8\u30f3\u30b0<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u306b\u9069\u3057\u305f\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u30af\u30e9\u30b9\u9078\u629e<\/li>\n\n\n\n<li>\u30e1\u30e2\u30ea\u3068CPU\u306e\u4f7f\u7528\u7387\u76e3\u8996<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30b9\u30c8\u30ec\u30fc\u30b8\u6700\u9069\u5316<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30d7\u30ed\u30d3\u30b8\u30e7\u30f3\u30c9IOPS\u4f7f\u7528\u5224\u65ad<\/li>\n\n\n\n<li>\u81ea\u52d5\u30b9\u30b1\u30fc\u30ea\u30f3\u30b0\u95be\u5024\u8a2d\u5b9a<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u76e3\u8996\u4f53\u5236<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Performance Insights\u6d3b\u7528<\/li>\n\n\n\n<li>CloudWatch\u30e1\u30c8\u30ea\u30af\u30b9\u8a2d\u5b9a<\/li>\n\n\n\n<li>\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u30ed\u30b0\u5206\u6790<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-18\">\u904b\u7528\u7ba1\u7406\u306e\u305f\u3081\u306e\u9ad8\u5ea6\u306a\u8a2d\u5b9a<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-19\">\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0\u3068\u30a2\u30e9\u30fc\u30c8\u8a2d\u5b9a\u306e\u5b9f\u88c5<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># CloudWatch\u30a2\u30e9\u30fc\u30e0\u8a2d\u5b9a\nresource \"aws_cloudwatch_metric_alarm\" \"cpu_utilization\" {\n  alarm_name          = \"rds-high-cpu\"\n  comparison_operator = \"GreaterThanThreshold\"\n  evaluation_periods  = \"2\"\n  metric_name         = \"CPUUtilization\"\n  namespace           = \"AWS\/RDS\"\n  period             = \"300\"\n  statistic          = \"Average\"\n  threshold          = \"80\"\n\n  dimensions = {\n    DBInstanceIdentifier = aws_db_instance.main.id\n  }\n\n  alarm_actions = [aws_sns_topic.alerts.arn]\n}\n\nresource \"aws_cloudwatch_metric_alarm\" \"free_storage\" {\n  alarm_name          = \"rds-low-storage\"\n  comparison_operator = \"LessThanThreshold\"\n  evaluation_periods  = \"1\"\n  metric_name         = \"FreeStorageSpace\"\n  namespace           = \"AWS\/RDS\"\n  period             = \"300\"\n  statistic          = \"Average\"\n  threshold          = \"20000000000\" # 20GB\n\n  dimensions = {\n    DBInstanceIdentifier = aws_db_instance.main.id\n  }\n\n  alarm_actions = [aws_sns_topic.alerts.arn]\n}\n\n# SNS\u30c8\u30d4\u30c3\u30af\nresource \"aws_sns_topic\" \"alerts\" {\n  name = \"rds-alerts\"\n}\n\n# CloudWatch\u30ed\u30b0\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\nresource \"aws_db_instance\" \"main\" {\n  # \u65e2\u5b58\u306e\u8a2d\u5b9a\u306b\u8ffd\u52a0\n  enabled_cloudwatch_logs_exports = [\n    \"error\",\n    \"general\",\n    \"slowquery\"\n  ]\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-20\">\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u30a6\u30a3\u30f3\u30c9\u30a6\u3068\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u6226\u7565<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># \u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u8a2d\u5b9a\u4ed8\u304dRDS\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\nresource \"aws_db_instance\" \"main\" {\n  # \u65e2\u5b58\u306e\u8a2d\u5b9a\u306b\u8ffd\u52a0\n  maintenance_window = \"Mon:03:00-Mon:04:00\"\n  backup_window      = \"02:00-03:00\"\n\n  auto_minor_version_upgrade = true\n  allow_major_version_upgrade = false\n\n  # \u30d6\u30eb\u30fc\u30b0\u30ea\u30fc\u30f3\u30c7\u30d7\u30ed\u30a4\u30e1\u30f3\u30c8\u7528\u30bf\u30b0\n  tags = {\n    Environment = var.environment\n    Version     = var.db_version\n  }\n}\n\n# \u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u671f\u9593\u4e2d\u306e\u30a2\u30e9\u30fc\u30c8\u6291\u5236\nresource \"aws_cloudwatch_metric_alarm\" \"cpu_utilization\" {\n  # \u65e2\u5b58\u306e\u8a2d\u5b9a\u306b\u8ffd\u52a0\n  treat_missing_data = \"ignore\"\n\n  tags = {\n    MaintenanceWindow = \"Mon:03:00-Mon:04:00\"\n  }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-21\">\u76e3\u8996\u30e1\u30c8\u30ea\u30af\u30b9\u4e00\u89a7<\/h3>\n\n\n<div id=\"id-5829b3e8-5695-47cd-a768-5cb5db9f5ae7\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u30e1\u30c8\u30ea\u30af\u30b9<\/th><th>\u95be\u5024<\/th><th>\u30a2\u30e9\u30fc\u30c8\u6761\u4ef6<\/th><\/tr><\/thead><tbody><tr><td>CPUUtilization<\/td><td>80%<\/td><td>5\u5206\u9593\u30672\u56de\u8d85\u904e<\/td><\/tr><tr><td>FreeStorageSpace<\/td><td>20GB<\/td><td>\u5373\u6642\u30a2\u30e9\u30fc\u30c8<\/td><\/tr><tr><td>DatabaseConnections<\/td><td>\u63a5\u7d9a\u4e0a\u9650\u306e80%<\/td><td>5\u5206\u9593\u30673\u56de\u8d85\u904e<\/td><\/tr><tr><td>ReadIOPS\/WriteIOPS<\/td><td>\u30d7\u30ed\u30d3\u30b8\u30e7\u30f3\u5024\u306e90%<\/td><td>15\u5206\u9593\u30673\u56de\u8d85\u904e<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"i-22\">\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u8a08\u753b\u306e\u30dd\u30a4\u30f3\u30c8<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u6226\u7565<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30de\u30a4\u30ca\u30fc\u30d0\u30fc\u30b8\u30e7\u30f3\u81ea\u52d5\u9069\u7528<\/li>\n\n\n\n<li>\u30e1\u30b8\u30e3\u30fc\u30d0\u30fc\u30b8\u30e7\u30f3\u624b\u52d5\u9069\u7528<\/li>\n\n\n\n<li>\u4e8b\u524d\u30c6\u30b9\u30c8\u74b0\u5883\u3067\u306e\u691c\u8a3c<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u30a6\u30a3\u30f3\u30c9\u30a6\u8a2d\u5b9a<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30a6\u30a3\u30f3\u30c9\u30a6\u3068\u306e\u91cd\u8907\u56de\u907f<\/li>\n\n\n\n<li>\u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u3092\u8003\u616e\u3057\u305f\u6642\u9593\u5e2f\u8a2d\u5b9a<\/li>\n\n\n\n<li>\u8907\u6570\u30ea\u30fc\u30b8\u30e7\u30f3\u306e\u8003\u616e<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u904b\u7528\u81ea\u52d5\u5316<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5b9a\u671f\u7684\u306a\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u53d6\u5f97<\/li>\n\n\n\n<li>\u30d1\u30e9\u30e1\u30fc\u30bf\u30b0\u30eb\u30fc\u30d7\u306e\u5909\u66f4\u7ba1\u7406<\/li>\n\n\n\n<li>\u30e1\u30c8\u30ea\u30af\u30b9\u30d9\u30fc\u30b9\u306e\u81ea\u52d5\u30b9\u30b1\u30fc\u30ea\u30f3\u30b0<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-23\">\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0\u3068\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-24\">\u3088\u304f\u3042\u308b\u554f\u984c\u3068\u305d\u306e\u89e3\u6c7a\u65b9\u6cd5<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30ea\u30bd\u30fc\u30b9\u4f5c\u6210\u5931\u6557<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># \u554f\u984c\uff1aVPC\u8a2d\u5b9a\u306e\u4e0d\u5099\nresource \"aws_db_instance\" \"main\" {\n  # \u6b63\u3057\u3044VPC\u8a2d\u5b9a\n  db_subnet_group_name = aws_db_subnet_group.main.name\n  vpc_security_group_ids = [aws_security_group.rds.id]\n\n  # \u53ef\u7528\u6027\u30be\u30fc\u30f3\u306e\u660e\u793a\u7684\u6307\u5b9a\n  availability_zone = \"ap-northeast-1a\"\n}\n\n# \u89e3\u6c7a\u7b56\uff1a\u30b5\u30d6\u30cd\u30c3\u30c8\u30b0\u30eb\u30fc\u30d7\u306e\u78ba\u8a8d\nresource \"aws_db_subnet_group\" \"main\" {\n  name = \"main\"\n  subnet_ids = [\n    aws_subnet.private1.id,\n    aws_subnet.private2.id\n  ]\n\n  tags = {\n    Name = \"Main DB subnet group\"\n  }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u554f\u984c<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># \u76e3\u8996\u8a2d\u5b9a\u306e\u5f37\u5316\nresource \"aws_cloudwatch_metric_alarm\" \"performance\" {\n  alarm_name          = \"rds-performance-degradation\"\n  comparison_operator = \"GreaterThanThreshold\"\n  evaluation_periods  = \"3\"\n  metric_name         = \"ReadLatency\"\n  namespace           = \"AWS\/RDS\"\n  period             = \"300\"\n  statistic          = \"Average\"\n  threshold          = \"0.01\"\n\n  dimensions = {\n    DBInstanceIdentifier = aws_db_instance.main.id\n  }\n\n  alarm_actions = [aws_sns_topic.alerts.arn]\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-25\">\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0\u30ac\u30a4\u30c9<\/h3>\n\n\n<div id=\"id-18022644-1145-41d1-97fa-87f57e323ada\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u554f\u984c<\/th><th>\u4e3b\u306a\u539f\u56e0<\/th><th>\u89e3\u6c7a\u7b56<\/th><\/tr><\/thead><tbody><tr><td>terraform apply\u5931\u6557<\/td><td>\u4f9d\u5b58\u95a2\u4fc2\u306e\u4e0d\u5099<\/td><td>\u4f9d\u5b58\u30ea\u30bd\u30fc\u30b9\u306e\u660e\u793a\u7684\u6307\u5b9a<\/td><\/tr><tr><td>\u63a5\u7d9a\u30a8\u30e9\u30fc<\/td><td>\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\u8a2d\u5b9a<\/td><td>\u30a4\u30f3\u30d0\u30a6\u30f3\u30c9\u30eb\u30fc\u30eb\u78ba\u8a8d<\/td><\/tr><tr><td>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u4f4e\u4e0b<\/td><td>\u30ea\u30bd\u30fc\u30b9\u4e0d\u8db3<\/td><td>\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u30af\u30e9\u30b9\u5909\u66f4<\/td><\/tr><tr><td>\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5931\u6557<\/td><td>\u30b9\u30c8\u30ec\u30fc\u30b8\u5bb9\u91cf\u4e0d\u8db3<\/td><td>\u81ea\u52d5\u30b9\u30b1\u30fc\u30ea\u30f3\u30b0\u8a2d\u5b9a<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"i-26\">\u672c\u756a\u74b0\u5883\u3067\u306e\u904b\u7528\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u5909\u66f4\u7ba1\u7406\u30d7\u30ed\u30bb\u30b9<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># \u5909\u66f4\u5c65\u6b74\u7ba1\u7406\nresource \"aws_db_instance\" \"main\" {\n  # \u30d0\u30fc\u30b8\u30e7\u30f3\u7ba1\u7406\u30bf\u30b0\n  tags = {\n    ManagedBy = \"Terraform\"\n    Version   = var.infrastructure_version\n    LastModified = timestamp()\n  }\n\n  # \u610f\u56f3\u3057\u306a\u3044\u5909\u66f4\u9632\u6b62\n  lifecycle {\n    prevent_destroy = true\n    ignore_changes = [\n      password,\n      latest_restorable_time\n    ]\n  }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u5f37\u5316<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># \u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u8a2d\u5b9a\nresource \"aws_db_instance\" \"main\" {\n  # \u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\n  storage_encrypted = true\n  deletion_protection = true\n  skip_final_snapshot = false\n  final_snapshot_identifier = \"${var.environment}-final-snapshot\"\n\n  # IAM\u8a8d\u8a3c\u306e\u6709\u52b9\u5316\n  iam_database_authentication_enabled = true\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-27\">\u672c\u756a\u74b0\u5883\u30c1\u30a7\u30c3\u30af\u30ea\u30b9\u30c8<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30c7\u30d7\u30ed\u30a4\u30e1\u30f3\u30c8\u524d<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u4f9d\u5b58\u95a2\u4fc2\u306e\u78ba\u8a8d<\/li>\n\n\n\n<li>\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u8a2d\u5b9a\u306e\u691c\u8a3c<\/li>\n\n\n\n<li>\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u6226\u7565\u306e\u78ba\u8a8d<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u904b\u7528\u30d5\u30a7\u30fc\u30ba<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u76e3\u8996\u4f53\u5236\u306e\u78ba\u7acb<\/li>\n\n\n\n<li>\u5b9a\u671f\u7684\u306a\u8a2d\u5b9a\u30ec\u30d3\u30e5\u30fc<\/li>\n\n\n\n<li>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u8a08\u753b<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u8a08\u753b\u7684\u306a\u30d0\u30fc\u30b8\u30e7\u30f3\u30a2\u30c3\u30d7<\/li>\n\n\n\n<li>\u30d1\u30e9\u30e1\u30fc\u30bf\u8abf\u6574\u306e\u5f71\u97ff\u78ba\u8a8d<\/li>\n\n\n\n<li>\u30c0\u30a6\u30f3\u30bf\u30a4\u30e0\u6700\u5c0f\u5316\u6226\u7565<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-28\">\u30a4\u30f3\u30d5\u30e9\u30b9\u30c8\u30e9\u30af\u30c1\u30e3\u30b3\u30fc\u30c9\u7ba1\u7406<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># \u30b9\u30c6\u30fc\u30c8\u7ba1\u7406\nterraform {\n  backend \"s3\" {\n    bucket = \"terraform-state-bucket\"\n    key    = \"rds\/production.tfstate\"\n    region = \"ap-northeast-1\"\n\n    encrypt = true\n    dynamodb_table = \"terraform-locks\"\n  }\n}\n\n# \u74b0\u5883\u5909\u6570\nvariable \"environment\" {\n  type = string\n  description = \"Environment name (e.g., prod, staging)\"\n}\n\nlocals {\n  common_tags = {\n    Environment = var.environment\n    ManagedBy   = \"Terraform\"\n    Project     = \"RDS-Infrastructure\"\n  }\n}<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Warning: Undefined array key &#8220;is_admin&#8221; in \/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/ &#8230; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":{"0":"post-2331","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-aws","7":"nothumb"},"_links":{"self":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/2331","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2331"}],"version-history":[{"count":1,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/2331\/revisions"}],"predecessor-version":[{"id":2332,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/2331\/revisions\/2332"}],"wp:attachment":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2331"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2331"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2331"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}