{"id":1072,"date":"2021-07-10T20:56:28","date_gmt":"2021-07-10T11:56:28","guid":{"rendered":"https:\/\/manvscloud.com\/?p=1072"},"modified":"2021-07-10T20:56:28","modified_gmt":"2021-07-10T11:56:28","slug":"aws-rds-log-generation-general-slow-query-audit-logs","status":"publish","type":"post","link":"https:\/\/manvscloud.com\/?p=1072","title":{"rendered":"[AWS] RDS Log Generation (General, slow query, audit logs)"},"content":{"rendered":"\n<p>\uc548\ub155\ud558\uc138\uc694. ManVSCloud \uae40\uc218\ud604\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc624\ub298\uc740 \uc624\ub79c\ub9cc\uc5d0 AWS\uc5d0 \ub300\ud55c \ud3ec\uc2a4\ud305\uc785\ub2c8\ub2e4.<br>\ucd5c\uadfc ISMS-P\ub97c \uc900\ube44\uac00 \ud544\uc694\ud558\uc5ec RDS\uc5d0\uc11c \ub85c\uadf8\ub97c \ub0a8\uae30\ub294 \ubc29\ubc95\uc5d0 \ub300\ud55c \uc9c8\ubb38\uc744 \ubc1b\uc740 \uc801\uc774 \uc788\uc5b4 \uc774\ub97c \ube14\ub85c\uadf8\ub85c\ub3c4 \uacf5\uc720\ud558\uace0\uc790 \uc62c\ub9bd\ub2c8\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h3 class=\"has-white-color has-pale-cyan-blue-background-color has-text-color has-background wp-block-heading\"> RDS Log<\/h3>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"412\" height=\"189\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/10192350\/rds-log.png\" alt=\"\" class=\"wp-image-1082\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/10192350\/rds-log.png 412w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/10192350\/rds-log-300x138.png 300w\" sizes=\"(max-width: 412px) 100vw, 412px\" \/><\/figure><\/div>\n\n\n\n<p>RDS \uc0dd\uc131 \ub610\ub294 \uc218\uc815\uc2dc \uccb4\ud06c\ud560 \uc218 \uc788\ub294 \ub85c\uadf8 \ub0b4\ubcf4\ub0b4\uae30 \uc635\uc158\uc785\ub2c8\ub2e4.<br>\uc0dd\uac01\ubcf4\ub2e4 \uc774 \uae30\ub2a5\uc774 \ub85c\uadf8\ub97c \uc0dd\uc131\ud558\ub294 \uc635\uc158\uc778 \uac83\uc73c\ub85c \uc544\uc2dc\ub294 \ubd84\ub4e4\uc774 \uc788\uc5c8\uc2b5\ub2c8\ub2e4.<br>\uc704 \ub0b4\ubcf4\ub0b4\uae30\ub97c \uc804\ubd80 \uccb4\ud06c\ud558\uc5ec\ub3c4 \uc5d0\ub7ec \ub85c\uadf8\ub9cc \uc0dd\uc131\ub418\uace0 \ub098\uba38\uc9c0 \ub85c\uadf8\uac00 \uc0dd\uc131\uc774 \ub418\uc9c0 \uc54a\ub294 \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. (\uc5d0\ub7ec \ub85c\uadf8\ub294 Default\uac00 \uc0dd\uc131\uc774\ub77c \ub530\ub85c \uc124\uc815\ud558\uc9c0 \uc54a\uc544\ub3c4 \uc0dd\uc131\ub429\ub2c8\ub2e4.)<\/p>\n\n\n\n<p>\uc774 \uae30\ub2a5\uc740 \ub9d0 \uadf8\ub300\ub85c \ub85c\uadf8\ub97c CloudWatch Logs\ub85c \uac8c\uc2dc\ud560 \uc218 \uc788\ub3c4\ub85d \ub0b4\ubcf4\ub0b4\ub294 \uc635\uc158\uc774\uba70<br>\ub85c\uadf8\ub97c \uc0dd\uc131\ud558\ub294 \uc635\uc158\uc740 \ub530\ub85c \uc874\uc7ac\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc77c\ubc18 \ub85c\uadf8\uc640 \ub290\ub9b0 \ucffc\ub9ac \ub85c\uadf8\ub97c \uc0dd\uc131\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc544\ub798 \ucca8\ubd80\ub41c \uc774\ubbf8\uc9c0\uc640 \uac19\uc774 \ud30c\ub77c\ubbf8\ud130 \uadf8\ub8f9 \uc218\uc815\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"329\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234051\/parameter-1024x329.png\" alt=\"\" class=\"wp-image-1074\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234051\/parameter-1024x329.png 1024w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234051\/parameter-300x96.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234051\/parameter-768x247.png 768w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234051\/parameter-1536x494.png 1536w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234051\/parameter-1080x347.png 1080w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234051\/parameter.png 1664w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\uc77c\ubc18 \ub85c\uadf8\ub294 general_log\ub97c \uac80\uc0c9\ud558\uba74 \ub098\uc624\uace0 \uc2ac\ub85c\uc6b0 \ucffc\ub9ac\ub294 slow_query_log\ub77c\uace0 \uac80\uc0c9\ud558\uba74 \ub098\uc635\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub450 \uac12\uc744 1\ub85c \ubcc0\uacbd \ud574\uc90d\uc2dc\ub2e4. (1\ub85c \uc124\uc815\ud574\uc57c \ub85c\uadf8\uac00 \uc0dd\uc131\ub429\ub2c8\ub2e4.)<\/p>\n\n\n\n<p>\ud604\uc7ac \uc6b4\uc601\uc911\uc778 RDS \uc778\uc2a4\ud134\uc2a4\uc758 \ud30c\ub77c\ubbf8\ud130 \uadf8\ub8f9\uc774 default \ud30c\ub77c\ubbf8\ud130\ub85c \uc124\uc815\ub418\uc5b4 \uc788\ub2e4\uba74 \uc0ac\uc6a9\uc790 \uc9c0\uc815 \ud30c\ub77c\ubbf8\ud130 \uadf8\ub8f9\uc744 \uc0dd\uc131\ud558\uc5ec \ud30c\ub77c\ubbf8\ud130 \uc218\uc815 \ubc0f \ud30c\ub77c\ubbf8\ud130 \uadf8\ub8f9 \uc218\uc815\uc744 \uc9c4\ud589\ud569\ub2c8\ub2e4.<br>(RDS \uc778\uc2a4\ud134\uc2a4 [\uc218\uc815]\uc744 \uc774\uc6a9\ud558\uc5ec \ud30c\ub77c\ubbf8\ud130 \uadf8\ub8f9\uc744 \ubcc0\uacbd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.)<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/10194425\/question.jpg\" alt=\"\" class=\"wp-image-1083\" width=\"369\" height=\"369\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/10194425\/question.jpg 640w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/10194425\/question-300x300.jpg 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/10194425\/question-150x150.jpg 150w\" sizes=\"(max-width: 369px) 100vw, 369px\" \/><\/figure><\/div>\n\n\n\n<p>\uc5ec\uae30\uc11c \uc911\uc694\ud55c \uc810\uc740 \ub610 Down Time\uc758 \uc5ec\ubd80\uaca0\uc8e0.<br>\ud30c\ub77c\ubbf8\ud130 \uadf8\ub8f9\uc744 \ubcc0\uacbd\ud558\uac8c \ub420 \uacbd\uc6b0 \ub610\ub294 \ud30c\ub77c\ubbf8\ud130 \uac12\uc744 \uc218\uc815\ud558\uac8c \ub420 \uacbd\uc6b0 \uc7ac\ubd80\ud305\uc774 \ud544\uc694\ud558\uc5ec Down Time\uc774 \ubc1c\uc0dd\ud558\uac8c \ub420\uae4c\uc694? <\/p>\n\n\n\n<p>\uc815\ub2f5\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/10201510\/para.png\" alt=\"\" class=\"wp-image-1085\" width=\"512\" height=\"474\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/10201510\/para.png 692w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/10201510\/para-300x278.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/figure><\/div>\n\n\n\n<p>\uadf8\ub807\ub2e4\uba74 \ub3d9\uc801 \ud30c\ub77c\ubbf8\ud130\uc640 \uc815\uc801 \ud30c\ub77c\ubbf8\ud130\ub97c \uc5b4\ub5bb\uac8c \uad6c\ubd84\ud558\ub290\ub0d0?<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"559\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/10194608\/static-dynamic-1024x559.png\" alt=\"\" class=\"wp-image-1084\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/10194608\/static-dynamic-1024x559.png 1024w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/10194608\/static-dynamic-300x164.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/10194608\/static-dynamic-768x420.png 768w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/10194608\/static-dynamic-1080x590.png 1080w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/10194608\/static-dynamic.png 1155w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\ud30c\ub77c\ubbf8\ud130 \uadf8\ub8f9 \ub0b4\uc5d0 \ud30c\ub77c\ubbf8\ud130\ub4e4\uc744 \ubcf4\uba74 <strong>[\uc801\uc6a9 \uc720\ud615]<\/strong>\uc774 \uc788\uc2b5\ub2c8\ub2e4. <br><strong>Dynamic<\/strong>\uc774 \ub3d9\uc801 \ud30c\ub77c\ubbf8\ud130, <strong>Static<\/strong>\uc774 \uc815\uc801 \ud30c\ub77c\ubbf8\ud130\ub85c \uc218\uc815\uc774 \ud544\uc694\ud55c \ud30c\ub77c\ubbf8\ud130\ub97c \uac80\uc0c9\ud558\uc5ec <br>\ud574\ub2f9\ud558\ub294 \ud30c\ub77c\ubbf8\ud130\uc758 \uac12\uc774 \uc218\uc815\ub420 \uacbd\uc6b0 \uc7ac\ubd80\ud305\uc774 \ud544\uc694\ud55c\uac00?\ub97c \uc54c \uc218 \uc788\uc73c\ub2c8 \uc774\ub97c \ud655\uc778\ud558\uc5ec \uc801\uc808\ud55c \uc2dc\uac04\uc5d0 \uc791\uc5c5\uc744 \uc9c4\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h3 class=\"has-white-color has-vivid-red-background-color has-text-color has-background wp-block-heading\"> RDS Audit Log<\/h3>\n\n\n\n<p>\ud30c\ub77c\ubbf8\ud130 \uadf8\ub8f9\uae4c\uc9c0 \uc124\uc815\ud558\uc600\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \ud30c\ub77c\ubbf8\ud130 \uadf8\ub8f9\uc5d0\uc11c \uac10\uc0ac \ub85c\uadf8\ub294 \ucc3e\uc744 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \uadf8 \uc774\uc720\ub85c \uac10\uc0ac \ub85c\uadf8\ub294 \ud30c\ub77c\ubbf8\ud130 \uadf8\ub8f9\uc774 \uc544\ub2cc \uc635\uc158 \uadf8\ub8f9\uc5d0\uc11c \uc124\uc815\uc774 \ud544\uc694\ud558\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"575\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234100\/audit-00-1024x575.png\" alt=\"\" class=\"wp-image-1075\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234100\/audit-00-1024x575.png 1024w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234100\/audit-00-300x169.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234100\/audit-00-768x432.png 768w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234100\/audit-00-1080x607.png 1080w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234100\/audit-00.png 1155w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\uc635\uc158 \uadf8\ub8f9\uc5d0\uc11c \uac10\uc0ac \ub85c\uadf8\ub97c \uc124\uc815 \ud574\uc8fc\ub824\uba74 default \uc635\uc158 \uadf8\ub8f9\uc5d0\uc11c \uc0c8\ub85c \uc0dd\uc131\ud55c \uc635\uc158 \uadf8\ub8f9\uc73c\ub85c \ubcc0\uacbd\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"692\" height=\"813\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234104\/audit-01.png\" alt=\"\" class=\"wp-image-1076\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234104\/audit-01.png 692w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234104\/audit-01-255x300.png 255w\" sizes=\"(max-width: 692px) 100vw, 692px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"694\" height=\"596\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234230\/audit-03.jpg\" alt=\"\" class=\"wp-image-1080\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234230\/audit-03.jpg 694w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234230\/audit-03-300x258.jpg 300w\" sizes=\"(max-width: 694px) 100vw, 694px\" \/><\/figure>\n\n\n\n<p>\uc0c8\ub85c \uc0dd\uc131\ud55c \uc635\uc158 \uadf8\ub8f9\uc5d0\uc11c \uc704\uc640 \uac19\uc774 MARIADB_AUDIT_PLUGIN \uc635\uc158\uc744 \ucd94\uac00\ud558\uc5ec \uc124\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud06c\uac8c \uc0ac\uc6a9\ud558\uc2e4\ub9cc\ud55c \uc635\uc158\uc5d0 \ub300\ud574\uc11c\ub9cc \uac04\ub2e8\ud558\uac8c \uc124\uba85\ud558\uc790\uba74 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul><li><strong>SERVER_AUDIT_FILE_ROTATE_SIZE<\/strong> : \ub85c\uadf8 \ud30c\uc77c \uc6a9\ub7c9 \ud06c\uae30\ub97c \uc81c\ud55c\ud569\ub2c8\ub2e4. (1\u20131000000000)<br>\ucd5c\ub300 1GB\uae4c\uc9c0 \uc124\uc815 \uac00\ub2a5\ud558\uba70 Default \uac12\uc740 1000000 \uc785\ub2c8\ub2e4.<\/li><li><strong>SERVER_AUDIT_FILE_ROTATIONS<\/strong> : \ub85c\uadf8 \ud30c\uc77c\uc758 \ub85c\ud14c\uc774\uc158 \uc218\ub97c \uc124\uc815\ud569\ub2c8\ub2e4. (0-100)<br>\ucd5c\ub300 100\uac1c\uc758 \ud30c\uc77c\uae4c\uc9c0 \uc0dd\uc131\uac00\ub2a5\ud558\uba70 Default\uac12\uc740 9\uc785\ub2c8\ub2e4.<\/li><li><strong>SERVER_AUDIT_EVENTS<\/strong> : \ud2b9\uc815 \uc774\ubca4\ud2b8 \uc720\ud615\uc73c\ub85c \uc81c\ud55c\ud558\uc5ec \ub85c\uadf8\ub97c \ub0a8\uae41\ub2c8\ub2e4.<br>\uc774\ub97c \uc124\uc815\ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0 \ubaa8\ub4e0 \uc774\ubca4\ud2b8 \uc720\ud615\uc744 \ub0a8\uae30\uac8c \ub429\ub2c8\ub2e4.<br>Default \uac12\uc740 CONNECT, QUERY \uc785\ub2c8\ub2e4.<\/li><li><strong>SERVER_AUDIT_INCL_USERS<\/strong> : SERVER_AUDIT_EXCL_USERS\ubcf4\ub2e4 \uc6b0\uc120 \uc21c\uc704\uac00 \ub192\uc73c\uba70 \uae30\ub85d\ud560 \uc0ac\uc6a9\uc790\ub97c \ucd94\uac00\ud569\ub2c8\ub2e4. \ub610\ud55c \uac12\uc774 \uc5c6\uc744 \uacbd\uc6b0 \ub85c\uae45\uc5d0 \ubaa8\ub4e0 \uc0ac\uc6a9\uc790\ub97c \ub85c\uae45\ud569\ub2c8\ub2e4.(SERVER_AUDIT_INCL_USERS \uac12\uc5d0 admin\uc744 \ucd94\uac00\ud558\uace0 SERVER_AUDIT_EXCL_USERS \uac12\uc774 \ube44\uc5b4\uc788\ub2e4\uba74 admin \uacc4\uc815\uc5d0 \ub300\ud55c \ub85c\uadf8\ub9cc \ub0a8\uae41\ub2c8\ub2e4.)<\/li><li><strong>SERVER_AUDIT_EXCL_USERS<\/strong> : \uac12\uc5d0 \uc0ac\uc6a9\uc790\ub97c \ucd94\uac00\ud560 \uacbd\uc6b0 \ud574\ub2f9 \uc0ac\uc6a9\uc790\ub97c \ub85c\uadf8\uc5d0 \uae30\ub85d\uc774 \ub0a8\uc9c0\uc54a\uc2b5\ub2c8\ub2e4. (\ub85c\uadf8 \uc608\uc678 \ucc98\ub9ac \uacc4\uc815 \ucd94\uac00\ub77c\uace0 \ubcf4\uba74 \uc774\ud574\uac00 \uc27d\uc2b5\ub2c8\ub2e4.)<br>\uac12\uc774 \uc5c6\uc744 \uacbd\uc6b0 \ub85c\uae45\uc5d0 \uc608\uc678 \ucc98\ub9ac\ud560 \uc0ac\uc6a9\uc790\uac00 \uc5c6\ub2e4\ub77c\ub294 \uc758\ubbf8\uac00 \ub429\ub2c8\ub2e4.<\/li><li><strong>SERVER_AUDIT_QUERY_LOG_LIMIT<\/strong> : \ucffc\ub9ac \ubb38\uc790\uc5f4 \uae38\uc774\ub97c \uc81c\ud55c\ud569\ub2c8\ub2e4. (0\u20132147483647)<br>Default\uac12\uc740 1024\uc785\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"496\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234109\/audit-02-1024x496.png\" alt=\"\" class=\"wp-image-1077\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234109\/audit-02-1024x496.png 1024w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234109\/audit-02-300x145.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234109\/audit-02-768x372.png 768w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234109\/audit-02-1536x744.png 1536w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234109\/audit-02-1080x523.png 1080w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234109\/audit-02.png 1636w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\uc635\uc158 \ubcc0\uacbd \ubc0f \uc635\uc158 \uadf8\ub8f9 \ubcc0\uacbd\uc774 \uc644\ub8cc\ub418\uc5c8\ub2e4\uba74 RDS \ub85c\uadf8\uc5d0\uc11c \uc544\ub798 \uc774\ubbf8\uc9c0\uc640 \uac19\uc774 Audit.log\uac00 \uc0dd\uc131\ub418\ub294 \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"354\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234154\/rds-log-00-1024x354.png\" alt=\"\" class=\"wp-image-1078\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234154\/rds-log-00-1024x354.png 1024w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234154\/rds-log-00-300x104.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234154\/rds-log-00-768x265.png 768w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234154\/rds-log-00-1080x373.png 1080w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234154\/rds-log-00.png 1480w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Cloudwatch logs\ub85c \ub0b4\ubcf4\ub0b4\uae30 \uc124\uc815\uc744 \ud558\uac8c\ub420 \uacbd\uc6b0 CloudWatch \ub85c\uadf8 \uc774\ubca4\ud2b8\uc5d0\uc11c\ub3c4 \ub85c\uadf8\ub97c \uc790\uc138\ud788 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br>DB\uc5d0\uc11c show databases \ubc0f show tables\ub97c \uc785\ub825\ud574\ubcf4\uc558\ub294\ub370 Audit \ub85c\uadf8\uc5d0 \uadf8\ub300\ub85c \ub0a8\uc558\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"331\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234202\/cloudwatch-00-1024x331.png\" alt=\"\" class=\"wp-image-1079\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234202\/cloudwatch-00-1024x331.png 1024w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234202\/cloudwatch-00-300x97.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234202\/cloudwatch-00-768x248.png 768w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234202\/cloudwatch-00-1080x349.png 1080w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/07\/07234202\/cloudwatch-00.png 1535w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h3 class=\"has-white-color has-luminous-vivid-amber-background-color has-text-color has-background wp-block-heading\"> Aurora DB, Using advanced auditing<\/h3>\n\n\n\n<p>Aurora MySQL\uc5d0\uc11c\ub294 RDS MySQL\uacfc \ub2e4\ub974\uac8c \uace0\uae09 \uac10\uc0ac\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br>\uc124\uc815 \ubc29\ubc95\uc740 \ud06c\uac8c \uc5b4\ub835\uc9c0 \uc54a\uc544 \uc5b4\ub5a0\ud55c \uace0\uae09 \uac10\uc0ac \uae30\ub2a5\uc774 \uc788\ub294\uc9c0 \ub9c1\ud06c\ub9cc \ub0a8\uaca8\ub450\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n<div class=\"vlp-link-container vlp-layout-basic wp-block-visual-link-preview-link\"><a href=\"https:\/\/docs.aws.amazon.com\/ko_kr\/AmazonRDS\/latest\/AuroraUserGuide\/AuroraMySQL.Auditing.html\" class=\"vlp-link\" title=\"Amazon Aurora MySQL DB \ud074\ub7ec\uc2a4\ud130\uc5d0\uc11c \uace0\uae09 \uac10\uc0ac \uc0ac\uc6a9 - Amazon Aurora\" rel=\"nofollow\" target=\"_blank\"><\/a><div class=\"vlp-layout-zone-side\"><div class=\"vlp-block-2 vlp-link-image\"><img decoding=\"async\" src=\"https:\/\/docs.aws.amazon.com\/assets\/images\/aws_logo_dark.png\" style=\"max-width: 150px; max-height: 150px\" \/><\/div><\/div><div class=\"vlp-layout-zone-main\"><div class=\"vlp-block-0 vlp-link-title\">Amazon Aurora MySQL DB \ud074\ub7ec\uc2a4\ud130\uc5d0\uc11c \uace0\uae09 \uac10\uc0ac \uc0ac\uc6a9 &#8211; Amazon Aurora<\/div><div class=\"vlp-block-1 vlp-link-summary\">Amazon Aurora MySQL DB \ud074\ub7ec\uc2a4\ud130\uc5d0\uc11c \ud65c\ub3d9\uc744 \uac10\uc0ac\ud569\ub2c8\ub2e4.<\/div><\/div><\/div>\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h3 class=\"has-white-color has-cyan-bluish-gray-background-color has-text-color has-background wp-block-heading\"> Personal Comments<\/h3>\n\n\n\n<p>\uc624\ub298\uc740 \uc624\ub79c\ub9cc\uc5d0 AWS\uc758 RDS \ub85c\uadf8 \uc0dd\uc131 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uc558\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc544\ubb34\ub798\ub3c4 \uac10\uc0ac \ub85c\uadf8\ub97c \ub0a8\uae30\ub294 \ubd80\ubd84\uc740 ISMS-P\ub97c \uc900\ube44\ud558\uc2e4 \ub54c \ud544\uc694\ud55c \ubd80\ubd84\uc774\ub2c8 \uc774 \ubd80\ubd84\uc740 \uc5b4\ub290\uc815\ub3c4 \ub3c4\uc6c0\uc774 \ub418\uc2dc\ub9ac\ub77c \uc0dd\uac01\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uae34 \uae00 \uc77d\uc5b4\uc8fc\uc154\uc11c \uac10\uc0ac\ud569\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc548\ub155\ud558\uc138\uc694. ManVSCloud \uae40\uc218\ud604\uc785\ub2c8\ub2e4. \uc624\ub298\uc740 \uc624\ub79c\ub9cc\uc5d0 AWS\uc5d0 \ub300\ud55c \ud3ec\uc2a4\ud305\uc785\ub2c8\ub2e4.\ucd5c\uadfc ISMS-P\ub97c \uc900\ube44\uac00 \ud544\uc694\ud558\uc5ec RDS\uc5d0\uc11c \ub85c\uadf8\ub97c \ub0a8\uae30\ub294 \ubc29\ubc95\uc5d0 \ub300\ud55c \uc9c8\ubb38\uc744 \ubc1b\uc740 \uc801\uc774 \uc788\uc5b4 \uc774\ub97c \ube14\ub85c\uadf8\ub85c\ub3c4 \uacf5\uc720\ud558\uace0\uc790 \uc62c\ub9bd\ub2c8\ub2e4. RDS Log RDS \uc0dd\uc131 \ub610\ub294 \uc218\uc815\uc2dc \uccb4\ud06c\ud560 \uc218 \uc788\ub294 \ub85c\uadf8 \ub0b4\ubcf4\ub0b4\uae30 \uc635\uc158\uc785\ub2c8\ub2e4.\uc0dd\uac01\ubcf4\ub2e4 \uc774 \uae30\ub2a5\uc774 \ub85c\uadf8\ub97c \uc0dd\uc131\ud558\ub294 \uc635\uc158\uc778 \uac83\uc73c\ub85c \uc544\uc2dc\ub294 \ubd84\ub4e4\uc774 \uc788\uc5c8\uc2b5\ub2c8\ub2e4.\uc704 \ub0b4\ubcf4\ub0b4\uae30\ub97c \uc804\ubd80 \uccb4\ud06c\ud558\uc5ec\ub3c4 \uc5d0\ub7ec \ub85c\uadf8\ub9cc \uc0dd\uc131\ub418\uace0 \ub098\uba38\uc9c0 \ub85c\uadf8\uac00 \uc0dd\uc131\uc774 \ub418\uc9c0 \uc54a\ub294 \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. (\uc5d0\ub7ec \ub85c\uadf8\ub294 Default\uac00 \uc0dd\uc131\uc774\ub77c \ub530\ub85c \uc124\uc815\ud558\uc9c0 \uc54a\uc544\ub3c4 \uc0dd\uc131\ub429\ub2c8\ub2e4.) \uc774 \uae30\ub2a5\uc740 \ub9d0 \uadf8\ub300\ub85c \ub85c\uadf8\ub97c CloudWatch Logs\ub85c \uac8c\uc2dc\ud560 \uc218 \uc788\ub3c4\ub85d \ub0b4\ubcf4\ub0b4\ub294 \uc635\uc158\uc774\uba70\ub85c\uadf8\ub97c \uc0dd\uc131\ud558\ub294 \uc635\uc158\uc740 \ub530\ub85c \uc874\uc7ac\ud569\ub2c8\ub2e4. \uc77c\ubc18 \ub85c\uadf8\uc640 \ub290\ub9b0 \ucffc\ub9ac \ub85c\uadf8\ub97c \uc0dd\uc131\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc544\ub798 \ucca8\ubd80\ub41c \uc774\ubbf8\uc9c0\uc640 \uac19\uc774 \ud30c\ub77c\ubbf8\ud130 \uadf8\ub8f9 \uc218\uc815\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. \uc77c\ubc18 \ub85c\uadf8\ub294 general_log\ub97c \uac80\uc0c9\ud558\uba74 \ub098\uc624\uace0 \uc2ac\ub85c\uc6b0 \ucffc\ub9ac\ub294 slow_query_log\ub77c\uace0 \uac80\uc0c9\ud558\uba74 \ub098\uc635\ub2c8\ub2e4. \ub450 \uac12\uc744 1\ub85c \ubcc0\uacbd \ud574\uc90d\uc2dc\ub2e4. (1\ub85c \uc124\uc815\ud574\uc57c \ub85c\uadf8\uac00 \uc0dd\uc131\ub429\ub2c8\ub2e4.) \ud604\uc7ac \uc6b4\uc601\uc911\uc778 RDS \uc778\uc2a4\ud134\uc2a4\uc758 \ud30c\ub77c\ubbf8\ud130 \uadf8\ub8f9\uc774 default \ud30c\ub77c\ubbf8\ud130\ub85c \uc124\uc815\ub418\uc5b4 \uc788\ub2e4\uba74 \uc0ac\uc6a9\uc790 \uc9c0\uc815 \ud30c\ub77c\ubbf8\ud130 \uadf8\ub8f9\uc744 \uc0dd\uc131\ud558\uc5ec \ud30c\ub77c\ubbf8\ud130 \uc218\uc815 \ubc0f \ud30c\ub77c\ubbf8\ud130 \uadf8\ub8f9 \uc218\uc815\uc744 \uc9c4\ud589\ud569\ub2c8\ub2e4.(RDS \uc778\uc2a4\ud134\uc2a4 [\uc218\uc815]\uc744 \uc774\uc6a9\ud558\uc5ec \ud30c\ub77c\ubbf8\ud130 \uadf8\ub8f9\uc744 \ubcc0\uacbd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.) \uc5ec\uae30\uc11c \uc911\uc694\ud55c \uc810\uc740 \ub610 Down Time\uc758 \uc5ec\ubd80\uaca0\uc8e0.\ud30c\ub77c\ubbf8\ud130 \uadf8\ub8f9\uc744 \ubcc0\uacbd\ud558\uac8c \ub420 \uacbd\uc6b0 \ub610\ub294 \ud30c\ub77c\ubbf8\ud130 \uac12\uc744 \uc218\uc815\ud558\uac8c \ub420 \uacbd\uc6b0 \uc7ac\ubd80\ud305\uc774 \ud544\uc694\ud558\uc5ec Down Time\uc774 \ubc1c\uc0dd\ud558\uac8c \ub420\uae4c\uc694? \uc815\ub2f5\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. \uadf8\ub807\ub2e4\uba74 \ub3d9\uc801 \ud30c\ub77c\ubbf8\ud130\uc640 \uc815\uc801 \ud30c\ub77c\ubbf8\ud130\ub97c \uc5b4\ub5bb\uac8c \uad6c\ubd84\ud558\ub290\ub0d0? \ud30c\ub77c\ubbf8\ud130 \uadf8\ub8f9 \ub0b4\uc5d0 \ud30c\ub77c\ubbf8\ud130\ub4e4\uc744 \ubcf4\uba74 [\uc801\uc6a9 \uc720\ud615]\uc774 \uc788\uc2b5\ub2c8\ub2e4. Dynamic\uc774 \ub3d9\uc801 \ud30c\ub77c\ubbf8\ud130, Static\uc774 \uc815\uc801 \ud30c\ub77c\ubbf8\ud130\ub85c \uc218\uc815\uc774 \ud544\uc694\ud55c \ud30c\ub77c\ubbf8\ud130\ub97c \uac80\uc0c9\ud558\uc5ec \ud574\ub2f9\ud558\ub294 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"RDS LOG GENERATION (GENERAL, SLOW QUERY, AUDIT LOGS)","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[7,364,366,6,43,368,369,224,225,199,365,32,375,374,373,372,371,106,367,370],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/manvscloud.com\/index.php?rest_route=\/wp\/v2\/posts\/1072"}],"collection":[{"href":"https:\/\/manvscloud.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/manvscloud.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/manvscloud.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/manvscloud.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1072"}],"version-history":[{"count":3,"href":"https:\/\/manvscloud.com\/index.php?rest_route=\/wp\/v2\/posts\/1072\/revisions"}],"predecessor-version":[{"id":1086,"href":"https:\/\/manvscloud.com\/index.php?rest_route=\/wp\/v2\/posts\/1072\/revisions\/1086"}],"wp:attachment":[{"href":"https:\/\/manvscloud.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1072"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/manvscloud.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1072"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/manvscloud.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1072"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}