{"id":564,"date":"2014-10-30T22:03:07","date_gmt":"2014-10-30T13:03:07","guid":{"rendered":"http:\/\/www.uturtle.com\/blog\/?p=564"},"modified":"2014-10-30T23:17:03","modified_gmt":"2014-10-30T14:17:03","slug":"ubuntu%ec%97%90%ec%84%9c-mysql-%ec%9a%a9%eb%9f%89-%eb%b6%80%ec%a1%b1%ec%8b%9c-%ec%83%88%ed%8c%8c%ed%8b%b0%ec%85%98%ec%9c%bc%eb%a1%9c-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ed%8c%8c","status":"publish","type":"post","link":"https:\/\/www.jinukbaek.com\/blog\/ko\/archives\/564","title":{"rendered":"ubuntu\uc5d0\uc11c mysql \uc6a9\ub7c9 \ubd80\uc871\uc2dc \uc0c8\ud30c\ud2f0\uc158\uc73c\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud30c\uc77c \uc774\ub3d9 \ubc29\ubc95"},"content":{"rendered":"<p>1. \uc11c\ub860<br \/>\n\u00a0 mysql \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud30c\ud2f0\uc158\uc774 \ucee4\uc9c0\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud30c\uc77c\uc744 \uc0c8\ub85c\uc6b4 \ud30c\ud2f0\uc158\uc5d0 \uc62e\uae30\uace0 \uc2ec\ubcfc\ub9ad \ub9c1\ud06c\ub97c \uac78\uc5b4\uc11c \uc6a9\ub7c9\uc744 \ud655\ubcf4\ud558\ub294 \ubc29\ubc95\uc774 \uc788\ub2e4. \ud55c\ud3b8 \uc6b0\ubd84\ud22c\uc5d0\uc11c\ub294 apparmor\ub77c\uace0 \ud558\ub294 \uad8c\ud55c \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc774 \uc874\uc7ac\ud558\uc5ec\uc11c, \uc2ec\ubcfc\ub9ad \ub9c1\ud06c \ud6c4\uc5d0 \uc0c8\ub85c\uc6b4 \uacbd\ub85c(\ud30c\ud2f0\uc158)\uc5d0 \ub300\ud55c \uad8c\ud55c\uc744 \uc904 \ud544\uc694\uac00 \uc788\ub2e4.<br \/>\n\u00a0 \uc5ec\uae30\uc11c apparmor\uac00 \uc124\uce58\ub41c mysql \ud658\uacbd\uc5d0\uc11c \uc5b4\ub5bb\uac8c \ud30c\ud2f0\uc158\uc744 \ub9cc\ub4e4\uace0, \uacf5\uac04\uc744 \ud655\uc7a5\ud558\ub294\uc9c0 \uc54c\uc544 \ubcf8\ub2e4.<br \/>\n\u00a0<br \/>\n2. \uc218\ud589 \ubc29\ubc95<br \/>\n1) \ucd94\uac00\ud560 \ub514\uc2a4\ud06c \ub9c8\uc6b4\ud305 \ubc0f \ud3ec\uba67<br \/>\n\u00a0# fdisk -l \u00a0 \u00a0 \u00a0\/\/ \ud30c\ud2f0\uc158 \ud560\ub2f9 \uc0c1\ud0dc \ud655\uc778<br \/>\n\u00a0# fdisk \/dev\/xvdb \u00a0\/\/ \/dev\/xvdb : \ucd94\uac00\ub41c \ub514\uc2a4\ud06c \uc8fc\uc18c<br \/>\n\u00a0 \u00a0 n \ub204\ub8e8\uace0 \ud30c\ud2f0\uc158 \uc124\uc815(primary partition, cylinder etc)<br \/>\n\u00a0 \u00a0 w \ub20c\ub7ec\uc11c \uc800\uc7a5<br \/>\n\u00a0# mkfs.ext4 \/dev\/xvdb1 \u00a0 \u00a0 \/\/ ext4\ub85c \ud3ec\uba67<br \/>\n\u00a0# mount \/dev\/xvdb1 \/mnt\/mysql_disk1 \u00a0 \/\/ \ub9c8\uc6b4\ud305<br \/>\n\u00a0<br \/>\n\u00a0# blkid \u00a0 \u00a0 \/\/ \ucd94\uac00\ub41c \/dev\/xvdb1 \uc758 UUID \ud655\uc778<br \/>\n\u00a0# vi \/etc\/fstab \u00a0 \u00a0\/\/ \uc7ac\ubd80\ud305\uc2dc \ubc14\ub85c \uc790\ub3d9 \ub9c8\uc6b4\ud305\uc744 \uc704\ud574 \uc124\uc815<br \/>\n\u00a0 UUID=<<\/dev\/xvdb1\uc758 UUID>> \/mnt\/mysql_disk1 ext4 rw 0 0 \u00a0 \u00a0 # \uc81c\uc77c \uc544\ub798\uc904\uc5d0 \ucd94\uac00<br \/>\n\u00a0# df -h \u00a0 \u00a0 \/\/ \ub514\uc2a4\ud06c \uc6a9\ub7c9 \ud655\uc778<br \/>\n\u00a0<br \/>\n2) Apparmor \uc124\uc815\ud30c\uc77c \ubcc0\uacbd [1]<br \/>\n\u00a0&#8211; \uc6b0\ubd84\ud22c\ub294 \uc811\uadfc\uad00\ub9ac\ub97c \uc880 \ub354 \uc798 \ud558\uae30 \uc704\ud574 \ud30c\uc77c\uc5d0 \uad8c\ud55c\uc744 \uc0ac\uc6a9\uc790 \ub2e8\uc704\ub85c \uc9c0\uc815\ud558\ub294 \uac83\uc774 \uc544\ub2c8\ub77c, \uc2e4\ud589\ub418\uc5b4 \uc788\ub294 \ud504\ub85c\uadf8\ub7a8\uc774 \uc5b4\ub514\uc5d0 \uc811\uadfc\ud560 \uc218 \uc788\ub294\uc9c0\ub97c \uc124\uc815\ud568\uc73c\ub85c\uc368 \ud574\uacb0\ud558\uace0\uc790 \ud558\uc600\ub2e4. \uc774 \ud3b8\uc774 \uad00\ub9ac \uce21\uba74\uc5d0\uc11c \ub354 \uc774\ub4dd\uc774 \ud06c\ub2e4.<br \/>\n\u00a0<br \/>\n\u00a0# vi \/etc\/apparmor.d\/user.sbin.mysqld<br \/>\n\u00a0 \u00a0 \u00a0 # \uc81c\uc77c \uc544\ub798\uc904\uc5d0 \ucd94\uac00<br \/>\n\u00a0 \u00a0 \u00a0 \/mnt\/mysql_disk1\/mysql_data r,<br \/>\n\u00a0 \u00a0 \u00a0 \/mnt\/mysql_disk1\/mysql_data\/** rwk,<br \/>\n\u00a0<br \/>\n3) sql \uc11c\ubc84 \uc885\ub8cc<br \/>\n\u00a0 \u00a0 \u00a0# service mysql stop<br \/>\n4) \ub370\uc774\ud130\ud30c\uc77c\uc744 \uc0c8\ub85c \uc800\uc7a5\ud560 \ud070 \uc6a9\ub7c9\uc758 \ub514\uc2a4\ud06c\ub85c \ubcf5\uc0ac (ubuntu mysql\uc740 \/var\/lib\/mysql \uc5d0 \uc788\uc74c)<br \/>\n\u00a0 \u00a0 \u00a0# cd \/var\/lib\/mysql<br \/>\n\u00a0 \u00a0 \u00a0# cp -R * \/mnt\/mysql_disk1\/mysql_data<br \/>\n5) \uae30\uc874 \ud30c\uc77c \ubc31\uc5c5<br \/>\n\u00a0 \u00a0 \u00a0# mv \/var\/lib\/mysql \/var\/lib\/mysql_bak<br \/>\n6) \uc2ec\ubcfc\ub9ad \ub9c1\ud06c \uc5f0\uacb0<br \/>\n\u00a0 \u00a0 \u00a0# cd \/var\/lib<br \/>\n\u00a0 \u00a0 \u00a0# ln -s \/mnt\/mysql_disk1\/mysql_data mysql<br \/>\n7) sql \uc11c\ubc84 \ub2e4\uc2dc \ucf1c\uae30<br \/>\n\u00a0 \u00a0 \u00a0# service mysql start<br \/>\n8) DB\uc5d0 \uc798 \uc811\uc18d\ub418\ub098 \ud14c\uc2a4\ud2b8<br \/>\n\u00a0<br \/>\n3. \uc815 \ub9ac<br \/>\n\u00a0\ud30c\uc77c \ubcf5\uc0ac\ud558\ub294\ub370 \uaf64 \uc2dc\uac04\uc774 \uac78\ub9ac\uae30 \ub54c\ubb38\uc5d0 \ucd94\ud6c4\uc5d0\ub294 mysql\uc11c\ubc84\ub97c \ud558\ub098 \ub354 \uc900\ube44\ud558\uc5ec \ub370\uc774\ud130\ub97c \uc62e\uae30\ub3c4\ub85d \uc791\uc5c5\ud558\ub294 \uac83\uc774 \ub354 \uc88b\uc744 \uac83\uc73c\ub85c \uc608\uc0c1\ub41c\ub2e4. \uadf8\ub9ac\uace0 \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \ud30c\uc77c\uc744 \ud558\ub098\ub85c \ud558\uc9c0 \uc54a\uace0 \uc5ec\ub7ec\uac1c\ub85c \ub098\ub204\uc5b4\uc11c, \ud30c\uc77c \ub2e8\uc704\ub85c \uc2ec\ubcfc\ub9ad \ub9c1\ud06c\ub97c \uac78\uc5b4\uc11c \ud574\uacb0\ud558\ub294 \ubc29\ud5a5\uc774 \ub354 \uc88b\uc744 \uac83\uc774\ub77c\uace0 \uc0dd\uac01\ud55c\ub2e4.<br \/>\n\u00a0<br \/>\n4. \uad00\ub828 \uc790\ub8cc<br \/>\n[1]\u00a0Recover an Innodb mysql database from an EBS on Ec2, Stack Exchange\u00a0:\u00a0http:\/\/dba.stackexchange.com\/questions\/57424\/recover-an-innodb-mysql-database-from-an-ebs-on-ec2<br \/>\n[2]\u00a0https:\/\/blogs.oracle.com\/jsmyth\/entry\/running_out_of_physical_disk<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. \uc11c\ub860 \u00a0 mysql \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud30c\ud2f0\uc158\uc774 \ucee4\uc9c0\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud30c\uc77c\uc744 \uc0c8\ub85c\uc6b4 \ud30c\ud2f0\uc158\uc5d0 \uc62e\uae30\uace0 \uc2ec\ubcfc\ub9ad \ub9c1\ud06c\ub97c \uac78\uc5b4\uc11c \uc6a9\ub7c9\uc744 \ud655\ubcf4\ud558\ub294 \ubc29\ubc95\uc774<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[174,85],"tags":[236,192,247,232,237,235,234,233],"class_list":["post-564","post","type-post","status-publish","format-standard","hentry","category-computer-database","category-computer-linux","tag-apparmor","tag-mysql","tag-computer-database","tag-232","tag-237","tag-235","tag-234","tag-233"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8gT1J-96","_links":{"self":[{"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/posts\/564","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/comments?post=564"}],"version-history":[{"count":2,"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/posts\/564\/revisions"}],"predecessor-version":[{"id":566,"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/posts\/564\/revisions\/566"}],"wp:attachment":[{"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/media?parent=564"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/categories?post=564"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/tags?post=564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}