{"id":16880,"date":"2017-08-26T22:02:27","date_gmt":"2017-08-26T13:02:27","guid":{"rendered":"http:\/\/w3devlabs.net\/wp\/?p=16880"},"modified":"2017-08-26T22:02:27","modified_gmt":"2017-08-26T13:02:27","slug":"mariadb-%ec%84%a4%ec%b9%98%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/w3devlabs.net\/wp\/?p=16880","title":{"rendered":"MariaDB \uc124\uce58\ud558\uae30"},"content":{"rendered":"

MariaDB \uc124\uce58\ud558\uae30<\/h3>\n

MariaDB\ub780 \uc704\ud0a4\ubc31\uacfc\uc5d0\uc11c \uc544\ub798\uc640 \uac19\uc774 \uc815\uc758\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n

\u201cMariaDB\ub294 \uc624\ud508 \uc18c\uc2a4\uc758 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c(RDBMS)\uc774\ub2e4. MySQL\uacfc \ub3d9\uc77c\ud55c \uc18c\uc2a4 \ucf54\ub4dc\ub97c \uae30\ubc18\uc73c\ub85c \ud558\uba70, GPL v2 \ub77c\uc774\uc120\uc2a4\ub97c \ub530\ub978\ub2e4. \uc624\ub77c\ud074 \uc18c\uc720\uc758 \ud604\uc7ac \ubd88\ud655\uc2e4\ud55c MySQL\uc758 \ub77c\uc774\uc120\uc2a4 \uc0c1\ud0dc\uc5d0 \ubc18\ubc1c\ud558\uc5ec \ub9cc\ub4e4\uc5b4\uc84c\uc73c\uba70, \ubc30\ud3ec\uc790\ub294 \ubaac\ud2f0 \ud504\ub85c\uadf8\ub7a8 AB(Monty Program AB)\uc640 \uc800\uc791\uad8c\uc744 \uacf5\uc720\ud574\uc57c \ud55c\ub2e4. \uc774\uac83\uc740 MySQL\uacfc \ub192\uc740 \ud638\ud658\uc131\uc744 \uc720\uc9c0\ud558\uae30 \uc704\ud568\uc774\uba70, MySQL APIs\uc640 \uba85\ub839\uc5d0 \uc815\ud655\ud788 \ub9e4\uce6d\ud558\uc5ec, \ub77c\uc774\ube0c\ub7ec\ub9ac \ubc14\uc774\ub108\ub9ac\uc640 \uc0c1\uc751\ud568\uc744 \uc81c\uacf5\ud558\uc5ec \uad50\uccb4 \uac00\ub2a5\uc131\uc744 \ub192\uc774\uace0\uc790 \ud568\uc774\ub2e4. \ub9c8\ub9ac\uc544 DB\uc5d0\ub294 \uc0c8\ub85c\uc6b4 \uc800\uc7a5 \uc5d4\uc9c4\uc778 \uc544\ub9ac\uc544(Aria)\ubfd0\ub9cc \uc544\ub2c8\ub77c, InnoDB\ub97c \uad50\uccb4\ud560 \uc218 \uc788\ub294 XtraDB \uc800\uc7a5 \uc5d4\uc9c4\uc744 \ud3ec\ud568\ud558\uace0 \uc788\ub2e4. \uc774\uac83\uc740 \ud2b8\ub79c\uc7ad\uc158\uacfc \ube44\ud2b8\ub79c\uc7ad\uc158 \uc5d4\uc9c4 \uadf8\ub9ac\uace0 \ubbf8\ub798\uc5d0 \ub098\uc62c MySQL \ud310\uc5d0 \ub300\uc751\ud558\uace0\uc790 \ud568\uc77c \uac83\uc774\ub2e4.
\ub9c8\ub9ac\uc544 DB\uc758 \uc8fc\uc694 \uac1c\ubc1c\uc790\ub294 MySQL\uacfc \ubaac\ud2f0 \ud504\ub85c\uadf8\ub7a8 AB\ub97c \uc124\ub9bd\ud55c \ub9c8\uc774\ud074 \ubaac\ud2f0 \uc640\uc774\ub4dc\ub2c8\uc5b4\uc2a4(Michael Monty Widenius)\uc774\ub2e4. \uadf8\ub294 \uc774\uc804\uc5d0 \uc790\uc2e0\uc758 \ud68c\uc0ac, MySQL AB\ub97c \uc36c\ub9c8\uc774\ud06c\ub85c\uc2dc\uc2a4\ud15c\uc988\uc5d0 10\uc5b5 \ub2ec\ub7ec\uc5d0 \ud310\ub9e4\ub97c \ud55c \uc801\uc774 \uc788\uc73c\uba70, \ub9c8\ub9ac\uc544 DB\ub294 \uadf8\uc758 \ub458\uc9f8 \ub538\uc778 \ub9c8\ub9ac\uc544\uc758 \uc774\ub984\uc744 \ub534 \uac83\uc774\ub2e4.\u201d<\/p>\n

MariaDB\ub294 MySQL\uc758 \ubd88\ud655\uc2e4\ud55c \ub77c\uc774\uc13c\uc2a4\ub54c\ubb38\uc5d0 \ub9cc\ub4e4\uc5b4 \uc84c\ub2e4\uace0 \ub098\uc624\ub124\uc694. MariaDB\ub294 MySQL\uacfc \uac70\uc758 \ub3d9\uc77c\ud558\uba70 \ub77c\uc774\uc13c\uc2a4\ub85c\ubd80\ud130 \uc880\ub354 \uc790\uc720\ub86d\uc2b5\ub2c8\ub2e4. <\/p>\n

\ub610\ud55c <\/p>\n

\u201c\ub9c8\ub9ac\uc544DB\ub294 MySQL\uacfc \uc18c\uc2a4\ucf54\ub4dc\ub97c \uac19\uc774 \ud558\ubbc0\ub85c \uc0ac\uc6a9\ubc29\ubc95\uacfc \uad6c\uc870\uac00 MySQL\uacfc \ub3d9\uc77c\ud558\ub2e4.\u201d<\/p>\n

\uc704\uc640 \uac19\uc740 \uc774\uc720\ub85c MySQL\ub300\uc2e0\uc5d0 MariaDB\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0\ub3c4 \ub9ce\uc2b5\ub2c8\ub2e4. <\/p>\n

MariaDB\ub97c \uc0ac\uc6a9\ud558\ub824\uba74 \uba3c\uc800 \ud504\ub85c\uadf8\ub7a8\uc744 \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc544\uc57c\ud569\ub2c8\ub2e4. <\/p>\n

MariaDB \ub2e4\uc6b4\ub85c\ub4dc \uc0ac\uc774\ud2b8 : https:\/\/downloads.mariadb.org\/<\/a><\/p>\n

<\/p>\n

\uc6f9\uc0ac\uc774\ud2b8\uc5d0 \ub4e4\uc5b4\uac00\uba74 \uc704\uc640 \uac19\uc774 \ub098\uc635\ub2c8\ub2e4. <\/p>\n

<\/p>\n

\ud604\uc7ac \uac00\uc7a5\ucd5c\uc2e0\ubc84\uc804\uc740 10.3.0 \uc774\uc9c0\ub9cc \uc548\uc815\ud654 \ubc84\uc804\uc778 10.2.8 \ubc84\uc804\uc744 \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc544\uc11c \uc0ac\uc6a9\ud560 \uac83\uc785\ub2c8\ub2e4. <\/p>\n

<\/p>\n

\uc708\ub3c4\uc6a9 64\ube44\ud2b8\ub97c \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc2b5\ub2c8\ub2e4. 32\ube44\ud2b8\uc778\uacbd\uc6b0 32\ube44\ud2b8\ub85c \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc73c\uba74 \ub429\ub2c8\ub2e4.<\/p>\n

<\/p>\n

\uc624\ub978\ucabd \ud558\ub2e8\uc758 No thanks \u2026 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4. <\/p>\n

<\/p>\n

\uc124\uce58\ud30c\uc77c\uc744 \uc2e4\ud589\ud558\uba74 \uc704\uc640 \uac19\uc774 \uc124\uce58 \ucd08\uae30\ud654\uba74\uc774 \ub098\uc635\ub2c8\ub2e4. <\/p>\n

Next\ubc84\ud2bc\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4.<\/p>\n

<\/p>\n

\ub77c\uc774\uc13c\uc2a4 \ub3d9\uc758\ub97c \ud074\ub9ad\ud558\uace0 Next\ub97c \ud074\ub9ad\ud569\ub2c8\ub2e4.<\/p>\n

<\/p>\n

\uc124\uce58 \uc635\uc158\uc744 \uc120\ud0dd\ud558\ub294 \ud654\uba74\uc785\ub2c8\ub2e4.<\/p>\n

<\/p>\n

\uc800\ub294 \uc124\uce58\uc704\uce58\ub97c c:\/apm\/mariadb\ub85c \uc120\ud0dd\ud558\uc600\uc2b5\ub2c8\ub2e4.<\/p>\n

<\/p>\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc790 root\uc758 \ube44\ubc00\ubc88\ud638\ub97c \uc785\ub825\ud569\ub2c8\ub2e4. <\/p>\n

Next \ubc84\ud2bc\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4.<\/p>\n

<\/p>\n

\uc11c\ube44\uc2a4 \uc774\ub984\uacfc \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud3ec\ud2b8\ubc88\ud638\ub97c \ud655\uc778\ud558\uace0 Next\ubc84\ud2bc\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4.<\/p>\n

<\/p>\n

\ud53c\ub4dc\ubc31\uad00\ub828 \uc785\ub2c8\ub2e4. \uadf8\ub0e5 Next \ud074\ub9ad\ud558\uc138\uc694.<\/p>\n

<\/p>\n

MariaDB\ub97c \uc124\uce58\ud569\ub2c8\ub2e4. Install \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uc138\uc694. <\/p>\n

<\/p>\n

\ubaa8\ub4e0 \uc124\uce58\uac00 \uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4. <\/p>\n

<\/p>\n

\uc708\ub3c4\uc5d0\uc11c \uc708\ub3c4\ud0a4\ub97c \ub204\ub974\uace0 maria\ub77c\uace0 \uc785\ub825\ud558\uba74 \uc704\uc640 \uac19\uc774 \ud504\ub85c\uadf8\ub7a8 \ub9ac\uc2a4\ud2b8\uac00 \ub098\ud0c0\ub0a9\ub2c8\ub2e4. \uc5ec\uae30\uc138\uc5b4 MySQL Client(MariaDB 10.3 (x64))\ub97c \uc120\ud0dd\ud569\ub2c8\ub2e4. <\/p>\n

<\/p>\n

\ube44\ubc00\ubc88\ud638\ub97c \uc785\ub825\ud558\uace0 \uc5d4\ud130\ud0a4\ub97c \uc785\ub825\ud558\uba74 \uc704\uc640\uac19\uc774 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uc18d\ud569\ub2c8\ub2e4. <\/p>\n

<\/p>\n

show databases;<\/p>\n

\ub97c \uc785\ub825\ud558\uba74 \ud604\uc7ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. <\/p>\n

\uc774\uc0c1\uacfc \uac19\uc774 MariaDB\uc758 \uc124\uce58\uacfc\uc815\uc744 \uc0b4\ud3b4\ubcf4\uc558\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"

MariaDB \uc124\uce58\ud558\uae30 MariaDB\ub780 \uc704\ud0a4\ubc31\uacfc\uc5d0\uc11c \uc544\ub798\uc640 \uac19\uc774 \uc815\uc758\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \u201cMariaDB\ub294 \uc624\ud508 \uc18c\uc2a4\uc758 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c(RDBMS)\uc774\ub2e4. MySQL\uacfc \ub3d9\uc77c\ud55c \uc18c\uc2a4 \ucf54\ub4dc\ub97c \uae30\ubc18\uc73c\ub85c \ud558\uba70, GPL v2 \ub77c\uc774\uc120\uc2a4\ub97c \ub530\ub978\ub2e4. \uc624\ub77c\ud074 \uc18c\uc720\uc758 \ud604\uc7ac \ubd88\ud655\uc2e4\ud55c MySQL\uc758 \ub77c\uc774\uc120\uc2a4 \uc0c1\ud0dc\uc5d0 \ubc18\ubc1c\ud558\uc5ec \ub9cc\ub4e4\uc5b4\uc84c\uc73c\uba70, \ubc30\ud3ec\uc790\ub294 \ubaac\ud2f0 \ud504\ub85c\uadf8\ub7a8 AB(Monty Program AB)\uc640 \uc800\uc791\uad8c\uc744 \uacf5\uc720\ud574\uc57c \ud55c\ub2e4. \uc774\uac83\uc740 MySQL\uacfc \ub192\uc740 \ud638\ud658\uc131\uc744 \uc720\uc9c0\ud558\uae30 \uc704\ud568\uc774\uba70, MySQL APIs\uc640 \uba85\ub839\uc5d0 \uc815\ud655\ud788 \ub9e4\uce6d\ud558\uc5ec, \ub77c\uc774\ube0c\ub7ec\ub9ac … <\/p>\n

\ub354 \ubcf4\uae30 “MariaDB \uc124\uce58\ud558\uae30”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[5418],"tags":[18565,5291,5542],"class_list":["post-16880","post","type-post","status-publish","format-standard","hentry","category-5418","tag-mariadb","tag-5291","tag-5542","entry"],"_links":{"self":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/16880","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=16880"}],"version-history":[{"count":1,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/16880\/revisions"}],"predecessor-version":[{"id":16881,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/16880\/revisions\/16881"}],"wp:attachment":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=16880"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=16880"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=16880"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}