{"id":159,"date":"2008-12-28T06:57:42","date_gmt":"2008-12-28T06:57:42","guid":{"rendered":"http:\/\/newblog.mix1009.net\/?p=159"},"modified":"2008-12-28T06:57:42","modified_gmt":"2008-12-28T06:57:42","slug":"%ea%b2%80%ec%83%89%ec%97%94%ec%a7%84-solr%eb%a1%9c-%ea%b5%90%ec%b2%b4","status":"publish","type":"post","link":"https:\/\/mix1009.net\/?p=159","title":{"rendered":"\uac80\uc0c9\uc5d4\uc9c4 Solr\ub85c \uad50\uccb4"},"content":{"rendered":"

\uc5ec\ud0dc\uae4c\uc9c0 \ud68c\uc0ac\uc5d0\uc11c \uc6b4\uc601\uc911\uc778 \uc11c\ube44\uc2a4\uc5d0\uc11c CLucene \uae30\ubc18\uc73c\ub85c \uc81c\uc791\ud55c \uc790\uccb4 \uac80\uc0c9\uc11c\ubc84\ub97c \uc0ac\uc6a9\ud588\uc5c8\ub294\ub370, \uc774\ubc88\uc5d0 Solr<\/a>\ub85c \uad50\uccb4\ud569\ub2c8\ub2e4. \uad50\uccb4 \uc774\uc720\ub294 \uac00\ub054\uc529 \uc11c\ubc84\uac00 \uc8fd\ub294 \uacbd\uc6b0\uac00 \uc0dd\uae30\ub294\ub370 \uc6d0\uc778\ud30c\uc545\uc774 \uc548\ub418\ub354\uad70\uc694. \uc8fc\ub85c \uc778\ub371\uc2f1\uc744 \uc5f4\uc2ec\ud788 \uc2dc\ud0a4\uba74 \uc8fd\uace0, \uc778\ub371\uc2f1\ud558\ub294 \ub3d9\uc548 \uac80\uc0c9\uc11c\ube44\uc2a4\uac00 \ub9ce\uc774 \ub290\ub824\uc9c0\ub354\uad70\uc694. \uadf8\ub798\uc11c \uc2e4\uc2dc\uac04 \uc778\ub371\uc2f1\uc774 \ud544\uc694\ud55c \uacbd\uc6b0\ub97c \uc81c\uc678\ud558\uace0\ub294 \ud558\ub8e8\uc5d0 \ud55c\ubc88\uc529 \ud55c\uac00\ud55c \uc2dc\uac04\uc5d0 \uc804\uccb4 \uc778\ub371\uc2f1\uc744 \uc624\ud504\ub77c\uc778\uc73c\ub85c \ud574\uc11c \uc778\ub371\uc2a4 \ub514\ub809\ud1a0\ub9ac\ub97c \uad50\uccb4\ud558\ub294 \ud615\ud0dc\ub85c \uc11c\ube44\uc2a4\ub97c \ud558\uace0 \uc788\uc5c8\uc2b5\ub2c8\ub2e4. \uc774\ub807\uac8c \uc6b4\uc601\ud558\uba74\uc11c \uc11c\ube44\uc2a4\uc5d0 \ud06c\uac8c \ubb38\uc81c\uac00 \uc788\uc9c0\ub294 \uc54a\uc558\uc9c0\ub9cc, C++\ub85c \uc791\uc131\ud558\ub2e4\ubcf4\ub2c8 \uc0c8\ub85c\uc6b4 \uc694\uad6c\uc0ac\ud56d\uc774 \ub4e4\uc5b4\uc62c\ub54c \uc81c\uac00 \uc9c1\uc811 \uc77c\uc744 \ucc98\ub9ac\ud558\uac8c \ub418\ub354\uad70\uc694.<\/p>\n

\uc608\uc804\uc5d4 Solr\ub77c\ub294 \uac70 \uc790\uccb4\uac00 \uc788\uc5c8\ub294\uc9c0 \ubab0\ub790\uc5c8\uace0, \uc790\ubc14\ub85c \ub418\uc5b4 \uc788\ub294 \ub8e8\uc52c\uc740 \uc880 \uac70\ubd80\uac10\uc774 \uc788\uc5c8\ub294\ub370.. Solr\uc758 \uae30\ub2a5\ub4e4\uc744 \ubcf4\ub2c8 \uc790\uccb4\uad6c\ud604\ud55c \uac80\uc0c9\uc5d4\uc9c4\uc744 \uc720\uc9c0\ubcf4\uc218\/\ud655\uc7a5\ud558\ub294 \uac70\ubcf4\ub2e4 \uc5ec\ub7ec\uac00\uc9c0 \uc7a5\uc810\ub4e4\uc774 \ub208\uc5d0 \ubcf4\uc774\ub354\uad70\uc694. \uba3c\uc800… \uc720\uc9c0\ubcf4\uc218 \uce21\uba74\uc5d0\uc11c XML\ub9cc \ud3b8\uc9d1\ud558\uba74, \uc2a4\ud0a4\ub9c8\ub97c \uc5c5\ub370\uc774\ud2b8\ud560\uc218 \uc788\ub294 \uc7a5\uc810\uc774 \uc788\uace0, \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \ub610\ud55c \uaf2d \ud544\uc694\ud55c \uae30\ub2a5\uc774\ub77c\ub294 \uc0dd\uac01\uc774 \ub4e4\ub354\uad70\uc694. \uadf8\ub9ac\uace0 HTTP \uae30\ubc18\uc73c\ub85c \ub3cc\uae30 \ub54c\ubb38\uc5d0 \uc5ec\ub7ec \uac80\uc0c9\uc11c\ubc84\ub97c \ub744\uc6b0\uace0 \ub85c\ub4dc\ubc38\ub79c\uc2f1\ub3c4 \uac00\ub2a5\ud558\uaca0\ub354\uad70\uc694… \uadf8\ub9ac\uace0 \uc131\ub2a5\ucd5c\uc801\ud654\ub97c \uc704\ud55c \uae30\ub2a5\ub4e4\uacfc \ubb38\uc11c\ub4e4… \uc544\uc9c1 \uc81c\ub300\ub85c \ubcf4\uc9c0\ub294 \ubabb\ud588\uc9c0\ub9cc \ub2e4\ub978 \uc774\ub4e4\uc758 \uacbd\ud5d8\uc5d0\uc11c \ubc30\uc6b8\uc218 \uc788\ub294\uac83\uc774 \ub9ce\uc744\uac70\ub77c \uc0dd\uac01\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n

\ub514\ube44\uc640 Solr\uc758 \ub3d9\uae30\ud654\ub294 Python\uc744 \uc774\uc6a9\ud574\uc11c \uc9c1\uc811 \uc791\uc131\ud588\uc2b5\ub2c8\ub2e4. Python\uc73c\ub85c \ub514\ube44\uc5d0\uc11c \ud544\ub4dc\ub4e4\uc744 \uc77d\uc5b4\ub4e4\uc5ec XML\ud654\ud558\uc5ec Solr\uc5d0 \uc800\uc7a5\ud588\uc2b5\ub2c8\ub2e4. \uc608\uc804\uc5d4 \ub514\ube44\uc758 \uc5c5\ub370\uc774\ud2b8\uac00 \uc77c\uc5b4\ub098\ub294 \ubd80\ubd84\uc5d0\uc11c \uc778\ub371\uc2f1\uc744 \ub2e4\uc2dc \ud558\ub3c4\ub85d \ub85c\uc9c1\uc744 \uc9f0\uc5c8\ub294\ub370… \uc774\uac8c \uad00\ub9ac\uac00 \uc798 \uc548\ub418\ub354\uad70\uc694. phpmyadmin\uc5d0\uc11c \ub514\ube44 \ud3b8\uc9d1\ud558\ub294 \uacbd\uc6b0\ub3c4 \uc788\uace0… \uc608\uc804\uc5d4 \ud558\ub8e8\uc5d0 \ud55c\ubc88\uc529 \uc804\uccb4 \uc778\ub371\uc2f1\uc744 \ub2e4\uc2dc\ud558\uc5ec \uc774\ub7f0 \ubb38\uc81c\ub97c \ud574\uacb0\ud588\uc5c8\ub294\ub370, \uc880\ub354 \uadfc\ubcf8\uc801\uc778 \ub300\ucc45\uc744 \ucc3e\uc544\uc57c\uaca0\ub354\uad70\uc694. MySQL 5.0\uc758 \ud2b8\ub9ac\uac70\ub97c \uc0ac\uc6a9\ud558\uc5ec\uc11c \ubcc0\ud654\uac00 \uc788\ub294 \ub370\uc774\ud0c0\ub97c \ucd94\uc801\ud558\uc5ec \uc790\ub3d9\uc73c\ub85c \ub514\ube44\uc640 Solr\uc640 \ub3d9\uae30\ud654 \ub418\uac8c \ud588\uc2b5\ub2c8\ub2e4. \ud604\uc7ac \uc0ac\uc6a9\uc911\uc778 MySQL\uc758 \ubc84\uc804\uc774 \ub300\ubd80\ubd84 4.X\ub77c \uac80\uc0c9\uc11c\ubc84\uc5d0 MySQL 5\ub97c \uc124\uce58\ud558\uace0, \ud544\uc694\ud55c \ud14c\uc774\ube14\ub9cc \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \ub418\uac8c \uc138\ud305\ud588\uc2b5\ub2c8\ub2e4. (\ucc38\uc870\ud558\ub294 \ub9c8\uc2a4\ud130 \ub514\ube44\uac00 \ub450\uac1c\ub77c \ud558\ub098\uc758 \uba38\uc2e0\uc5d0 \uc5ec\ub7ec\uac1c\uc758 MySQL \uc778\uc2a4\ud134\uc2a4\ub97c \ub3cc\ub9ac\ub294 \ubc29\ubc95\uc744 \uc774\uc6a9\ud588\uc2b5\ub2c8\ub2e4.) \uadf8\ub9ac\uace0 \ud2b8\ub9ac\uac70\ub97c \uc124\uce58\ud558\uc5ec \ubcc0\ud654\uac00 \uc788\ub294 \ubd80\ubd84\uc744 _changed_\uc5d0 \uc4f0\ub3c4\ub85d \ud588\uc2b5\ub2c8\ub2e4.<\/p>\n

create table _changed_ (no int NOT NULL auto_increment,
\nid varchar(100) character set utf8,
\ntype varchar(100) character set utf8,
\naction varchar(100) character set utf8,
\ndate datetime NOT NULL,
\nKEY no (no));<\/p>\n

create trigger tr_news_insert after insert on news
\nfor each row INSERT INTO _changed_ (id, type, action, date) values (NEW.no, “news”, “index”, NOW());<\/p>\n

create trigger tr_news_update before UPDATE on news
\nfor each row INSERT INTO _changed_ (id, type, action, date) values (NEW.no, “news”, “index”, NOW());<\/p>\n

create trigger tr_news_delete before DELETE on news
\nfor each row INSERT INTO _changed_ (id, type, action, date) values (OLD.no, “news”, “delete”, NOW());\n<\/div>\n

crontab\uc5d0\uc11c 1\ubd84\uc5d0 \ud55c\ubc88\uc529 _changed_ \ud14c\uc774\ube14\uc744 \ubcf4\uace0 Solr\uc5d0 \ubcc0\uacbd\ub41c \uc0ac\ud56d\uc744 \uc801\uc6a9\ud558\ub3c4\ub85d \ud588\uc2b5\ub2c8\ub2e4.<\/p>\n

\ub9ac\ud50c\ub9ac\ucf00\uc774\uc158\uc740 rsyncd\ub97c \uc774\uc6a9\ud558\ub3c4\ub85d \ub418\uc5b4\uc788\uc5b4\uc11c \ub8e8\uc52c\ucc98\ub7fc \uc5c5\ub370\uc774\ud2b8 \ud56d\ubaa9\ub9cc \ub2e4\ub978 \ud30c\uc77c\ub85c \uad00\ub9ac\ub418\ub294 \uacbd\uc6b0 \ud6a8\uc728\uc801\uc73c\ub85c \ub3d9\uae30\ud654\uac00 \uac00\ub2a5\ud569\ub2c8\ub2e4. \ub2e4\ub9cc optimize\ud560\ub54c\ub294 \ud30c\uc77c\ub4e4 \ubaa8\uc544\uc11c \uc804\uccb4\ub97c \ub2e4\uc2dc \uc4f0\uae30 \ub54c\ubb38\uc5d0 \ub9c8\uc2a4\ud130\uc5d0\uc11c \uc790\uc8fc optimize\ud558\ub294\uac70\ub294 \ucd94\ucc9c\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. <\/p>\n

\ub9c8\uc2a4\ud130\uc5d0\uc11c commit\ud560\ub54c snapshooter\ub97c \ud638\ucd9c\ud558\ub3c4\ub85d \ud558\uace0, slave\uc5d0\uc11c\ub294 5\ubd84\uc5d0 \ud55c\ubc88\uc529 snappuller\uc640 snapinstaller\ub97c \ud638\ucd9c\ud558\ub3c4\ub85d \ud588\uc2b5\ub2c8\ub2e4. slave\ub294 \ub530\ub85c \ub370\uc774\ud0c0\ub97c \ubcf5\uc0ac\ud560 \ud544\uc694\uac00 \uc5c6\uc5b4\uc11c slave \ud3f4\ub354\ub9cc \uc555\ucd95\ud574\ub450\uba74 \uc544\uc8fc \ube60\ub974\uace0 \uc27d\uac8c, \ub3d9\uae30\ud654\uc640 \uc11c\ube44\uc2a4\ub97c \ud560\uc218 \uc788\ub354\uad70\uc694. \ub514\ube44 \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158\uc774 \uc774\ub807\uac8c \ub420\uc218 \uc788\ub2e4\uba74.. \uc774\ub77c\ub294 \uc0dd\uac01\uc774 \ub4dc\ub124\uc694.<\/p>\n

php\uc5d0\uc11c\ub294 phps \ud3ec\ub9f7\uc73c\ub85c \uac80\uc0c9\uacb0\uacfc\ub97c \ubc1b\uc544\uac00\ub3c4\ub85d \ud588\uc2b5\ub2c8\ub2e4.<\/p>\n

[CODE type=php]
\n<?php
\n    function solr_search_get($args) {
\n      $sr = file_get_contents(“http:\/\/solrserver:solrport\/solr\/select?”.$args.”&wt=phps”);
\n      return unserialize($sr);
\n    }
\n    print_r(solr_search_get(“q=hello”));
\n?>
\n[\/HTML][\/CODE]<\/p>\n

\uc790\uccb4 \uc81c\uc791 CLucene \uac80\uc0c9\uc11c\ubc84\uc640 Solr\uc758 \ud37c\ud3ec\uba3c\uc2a4\ub294 … \ucc28\uc774\uac00 \uc880 \ub0a9\ub2c8\ub2e4. \ub2e4\ub978 \uc11c\ubc84\uc5d0\uc11c \ub3cc\ub824\uc11c \uc815\ud655\ud55c \ube44\uad50\ub294 \uc5b4\ub835\uc9c0\ub9cc, \uac80\uc0c9\uc18d\ub3c4\uc758 \ucc28\uc774\ub294 \ud06c\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. Solr \uc11c\ubc84\uc758 \uacbd\uc6b0 \ucd5c\uadfc\uc5d0 \ub4e4\uc5b4\uc628 \uc11c\ubc84\uc778\ub370 \uc131\ub2a5\uc740 \ube44\uc2b7\ud569\ub2c8\ub2e4. \uc778\ub371\uc2f1\uc740 \ud070 \ucc28\uc774\uac00 \ub0a9\ub2c8\ub2e4. \uc790\uccb4 \uac80\uc0c9 \uc11c\ubc84\uc758 \uacbd\uc6b0 20\ubd84\uc774\uba74 \uc804\uccb4 \uc778\ub371\uc2f1\uc744 \ud558\ub294\ub370, Solr\uc5d0\uc11c 50\ubd84 \uc815\ub3c4 \uac78\ub9bd\ub2c8\ub2e4. \uc544\ub9c8\ub3c4 XML\ub85c \ubcc0\ud658\ub418\uace0, HTTP\ub85c \ub370\uc774\ud0c0\uac00 \ub4e4\uc5b4\uac00\uc57c\ud574\uc11c \uc18d\ub3c4\ucc28\uc774\uac00 \ub9ce\uc774 \ub098\ub294\ub4ef\ud569\ub2c8\ub2e4. XML \ubcc0\ud658\uc744 python\uc73c\ub85c \ud558\ub294 \uac83\ub3c4 \uc131\ub2a5\uc5d0 \uc601\ud5a5\uc744 \uc8fc\uc5c8\uc744\ub4ef \ud558\ub124\uc694.<\/p>\n","protected":false},"excerpt":{"rendered":"

\uc5ec\ud0dc\uae4c\uc9c0 \ud68c\uc0ac\uc5d0\uc11c \uc6b4\uc601\uc911\uc778 \uc11c\ube44\uc2a4\uc5d0\uc11c CLucene \uae30\ubc18\uc73c\ub85c \uc81c\uc791\ud55c \uc790\uccb4 \uac80\uc0c9\uc11c\ubc84\ub97c \uc0ac\uc6a9\ud588\uc5c8\ub294\ub370, \uc774\ubc88\uc5d0 Solr\ub85c \uad50\uccb4\ud569\ub2c8\ub2e4. \uad50\uccb4 \uc774\uc720\ub294 \uac00\ub054\uc529 \uc11c\ubc84\uac00 \uc8fd\ub294 \uacbd\uc6b0\uac00 \uc0dd\uae30\ub294\ub370 \uc6d0\uc778\ud30c\uc545\uc774 \uc548\ub418\ub354\uad70\uc694. \uc8fc\ub85c \uc778\ub371\uc2f1\uc744 \uc5f4\uc2ec\ud788 \uc2dc\ud0a4\uba74 \uc8fd\uace0, \uc778\ub371\uc2f1\ud558\ub294 \ub3d9\uc548 \uac80\uc0c9\uc11c\ube44\uc2a4\uac00 \ub9ce\uc774 \ub290\ub824\uc9c0\ub354\uad70\uc694. \uadf8\ub798\uc11c \uc2e4\uc2dc\uac04 \uc778\ub371\uc2f1\uc774 \ud544\uc694\ud55c \uacbd\uc6b0\ub97c \uc81c\uc678\ud558\uace0\ub294 \ud558\ub8e8\uc5d0 \ud55c\ubc88\uc529 \ud55c\uac00\ud55c \uc2dc\uac04\uc5d0 \uc804\uccb4 \uc778\ub371\uc2f1\uc744 \uc624\ud504\ub77c\uc778\uc73c\ub85c \ud574\uc11c \uc778\ub371\uc2a4 \ub514\ub809\ud1a0\ub9ac\ub97c \uad50\uccb4\ud558\ub294 \ud615\ud0dc\ub85c \uc11c\ube44\uc2a4\ub97c \ud558\uace0 \uc788\uc5c8\uc2b5\ub2c8\ub2e4. \uc774\ub807\uac8c \uc6b4\uc601\ud558\uba74\uc11c […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[19],"tags":[65,138,139,67],"_links":{"self":[{"href":"https:\/\/mix1009.net\/index.php?rest_route=\/wp\/v2\/posts\/159"}],"collection":[{"href":"https:\/\/mix1009.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mix1009.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mix1009.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mix1009.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=159"}],"version-history":[{"count":0,"href":"https:\/\/mix1009.net\/index.php?rest_route=\/wp\/v2\/posts\/159\/revisions"}],"wp:attachment":[{"href":"https:\/\/mix1009.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mix1009.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=159"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mix1009.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}