{"id":809,"date":"2015-05-18T15:57:20","date_gmt":"2015-05-19T00:57:20","guid":{"rendered":"http:\/\/blog.box.kr\/?p=809"},"modified":"2015-05-18T15:57:20","modified_gmt":"2015-05-19T00:57:20","slug":"scrap-replication-startup-options","status":"publish","type":"post","link":"https:\/\/blog.box.kr\/?p=809","title":{"rendered":"[scrap] Replication Startup Options"},"content":{"rendered":"

http:\/\/simonshin.egloos.com\/2247545<\/a><\/p>\n

 <\/p>\n

\ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc2a4\ud0c0\ud2b8\uc5c5 \uc635\uc158\ub4e4<\/h2>\n

\uc774 \uc139\uc158\uc5d0\uc11c\ub294 \uc5ec\ub7ec\ubd84\uc774 \uc2ac\ub808\uc774\ube0c \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc11c\ubc84\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc635\uc158\ub4e4\uc5d0 \ub300\ud574 \uc124\uba85\ud558\uae30\ub85c \ud55c\ub2e4. <\/span>\uc774 \uc635\uc158\ub4e4\uc740 \uba85\ub839\uc5b4 \ub77c\uc778 \ub610\ub294 \uc635\uc158 \ud30c\uc77c\uc5d0\uc11c \uc9c0\uc815\ud560 \uc218 \uc788\ub2e4.<\/span><\/p>\n

\n<\/div>\n

\ub9c8\uc2a4\ud130\uc640 \uac01 \uc2ac\ub808\uc774\ube0c\uc5d0\uc11c, <\/span>\uc5ec\ub7ec\ubd84\uc740 \uace0\uc720\uc758 \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 ID<\/span>\ub97c \uc124\uc815\ud558\uae30 \uc704\ud574\uc11c \ubc18\ub4dc\uc2dc server-id<\/span><\/b><\/code>\uc635\uc158\uc744 \uc0ac\uc6a9\ud574\uc57c \ud55c\ub2e4. <\/span>\uac01 \uc11c\ubc84\uc758 \uacbd\uc6b0, <\/span>\uc5ec\ub7ec\ubd84\uc740 1 <\/span>\uc5d0\uc11c 232<\/sup> \u2013 1 <\/span>\uc0ac\uc774\uc758 \uc591\uc218 \uc815\uc218 \uc911\uc758 \uace0\uc720 \uac12\uc744 \uc0ac\uc6a9\ud574\uc57c \ud558\uace0 \uac01 ID<\/span>\ub294 \ubc18\ub4dc\uc2dc \ub2e4\ub978 ID<\/span>\uc640 \uad6c\ubd84\uc774 \ub418\uc5b4\uc57c \ud55c\ub2e4. <\/span>\uc608: <\/b><\/span>server-id=3<\/span><\/b><\/code>.<\/span><\/p>\n

\n<\/div>\n

\ubc14\uc774\ub108\ub9ac \ub85c\uae45\uc744 \uc81c\uc5b4\ud558\uae30 \uc704\ud55c \ub9c8\uc2a4\ud130 \uc635\uc158\ub4e4\uc740 Section\u00a05.12.3, \u201c\ubc14\uc774\ub108\ub9ac<\/span><\/span> \ub85c\uadf8<\/span><\/span>\u201d<\/span>\uc5d0\uc11c \uc124\uba85\uc744 \ud55c\ub2e4.<\/span><\/p>\n

\n<\/div>\n

\uc5b4\ub5a4 \uc2ac\ub808\uc774\ube0c \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc635\uc158\ub4e4\uc740 \uc2ac\ub808\uc774\ube0c\uac00 \uadf8 \uc635\uc158 \uac12\uc744 \uac00\uc9c0\uace0 \uc2dc\uc791\ub420 \ub54c master.info<\/span><\/code>\ud30c\uc77c\uc774 \uc874\uc7ac\ud55c\ub2e4\uba74 \ubb34\uc2dc\uac00 \ub418\ub294 \uac83\uacfc \uac19\uc740 \ud615\ud0dc\ub85c \ud2b9\ubcc4\ud788 \ucde8\uae09\ub418\ub294 \uac83\ub4e4\uc774 \uc788\ub2e4. <\/span>\uc544\ub798\uc758 \uc635\uc158\ub4e4\uc774 \uc774\ub7f0 \ubc29\uc2dd\uc73c\ub85c \ucc98\ub9ac\ub41c\ub2e4:<\/span><\/p>\n

\n<\/div>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--master-host<\/span><\/code><\/p>\n

\n<\/div>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--master-user<\/span><\/code><\/p>\n

\n<\/div>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--master-password<\/span><\/code><\/p>\n

\n<\/div>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--master-port<\/span><\/code><\/p>\n

\n<\/div>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--master-connect-retry<\/span><\/code><\/p>\n

\n<\/div>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--master-ssl<\/span><\/code><\/p>\n

\n<\/div>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--master-ssl-ca<\/span><\/code><\/p>\n

\n<\/div>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--master-ssl-capath<\/span><\/code><\/p>\n

\n<\/div>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--master-ssl-cert<\/span><\/code><\/p>\n

\n<\/div>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--master-ssl-cipher<\/span><\/code><\/p>\n

\n<\/div>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--master-ssl-key<\/span><\/code><\/p>\n

\n<\/div>\n

MySQL 5.0<\/span>\uc758 master.info<\/span><\/code>\ud30c\uc77c \ud3ec\ub9f7\uc740 SSL <\/span>\uc635\uc158\uacfc \uc0c1\uc751\ub418\ub294 \uac12\uc744 \uac00\uc9c4\ub2e4. <\/span>\ub610\ud55c, <\/span>\uc774 \ud30c\uc77c \ud3ec\ub9f7\uc740 \uc790\uc2e0\uc758 \uccab \ub77c\uc778\uc5d0 \ud30c\uc77c\uc758 \uc804\uccb4 \ub77c\uc778 \uc218\ub97c \uac00\uc9c0\uace0 \uc788\ub2e4. <\/span>\ub9cc\uc77c \uad6c\ud615 \uc11c\ubc84 (4.1.1 <\/span>\uc774\uc804 \ubc84\uc804)<\/span>\ub97c \uc0c8\ub85c\uc6b4 \ubc84\uc804\uc73c\ub85c \uc5c5\uadf8\ub808\uc774\ub4dc \ud55c\ub2e4\uba74,<\/span>\uc0c8\ub85c\uc6b4 \uc11c\ubc84\ub294 \uc2dc\uc791 \uc2dc\uc810\uc5d0 \uc790\ub3d9\uc73c\ub85c master.info<\/span><\/code>\ud30c\uc77c\uc744 \uc0c8\ub85c\uc6b4 \ud3ec\ub9f7\uc73c\ub85c \uc5c5\uadf8\ub808\uc774\ub4dc \uc2dc\ud0a8\ub2e4. <\/span>\ud558\uc9c0\ub9cc, <\/span>\uc0c8 \ubc84\uc804\uc5d0\uc11c \uad6c\ud615 \ubc84\uc804\uc73c\ub85c \ub2e4\uc6b4\uadf8\ub808\uc774\ub4dc\ub97c \ud558\ub294 \uacbd\uc6b0\uc5d0\ub294, <\/span>\uad6c\ud615 \ubc84\uc804\uc758 \uc11c\ubc84\ub97c \ub9e8 \ucc98\uc74c \uc2dc\uc791\ud558\uae30 \uc804\uc5d0, <\/span>\uc218\ub3d9\uc73c\ub85c \ucc98\uc74c \ub77c\uc778\uc744 \uc81c\uac70\ud574\uc57c \ud55c\ub2e4.<\/span><\/p>\n

\n<\/div>\n

\uc2ac\ub808\uc774\ube0c \uc11c\ubc84\uac00 \uc2dc\uc791\ub420 \ub54c master.info<\/span><\/code>\ud30c\uc77c\uc774 \uc874\uc7ac\ud558\uc9c0 \uc54a\ub294\ub2e4\uba74, <\/span>\uc2ac\ub808\uc774\ube0c\ub294 \uc635\uc158 \ud30c\uc77c \ub610\ub294 \uba85\ub839\uc5b4 \ub77c\uc778\uc5d0\uc11c \uc9c0\uc815\ud55c \uc635\uc158\uc5d0 \ub300\ud55c \uac12\uc744 \uc0ac\uc6a9\ud55c\ub2e4. <\/span>\uc11c\ubc84\ub97c \ub9e8 \ucc98\uc74c \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc11c\ubc84\ub85c \uad6c\ub3d9 \uc2dc\ud0a4\uac70\ub098, <\/span>\ub610\ub294 RESET SLAVE<\/span><\/b><\/code>\ub97c \uad6c\ub3d9 \uc2dc\ud0a8 \ud6c4\uc5d0 \uc2ac\ub808\uc774\ube0c\ub97c \uc167 \ub2e4\uc6b4\ud558\uace0 \ub2e4\uc2dc \uc2dc\uc791\ud558\uba74 \uc774\ub7f0 \uc77c\uc774 \ubc1c\uc0dd\ud55c\ub2e4.<\/span><\/p>\n

\n<\/div>\n

\uc2ac\ub808\uc774\ube0c \uc11c\ubc84\ub97c \uc2dc\uc791\ud560 \ub54c master.info<\/span><\/code>\ud30c\uc77c\uc774 \uc874\uc7ac\ud55c\ub2e4\uba74, <\/span>\uc11c\ubc84\ub294 \uc774 \ud30c\uc77c\uc758 \ub0b4\uc6a9\uc744 \uc0ac\uc6a9\ud558\uac8c \ub418\uba70 \ud30c\uc77c\uc5d0 \uc62c\ub77c\uc640 \uc788\ub294 \uac12\uc5d0 \ub300\uc751\ub418\ub294 \uc635\uc158\ub4e4\uc740 \ubb34\uc2dc\ub97c \ud55c\ub2e4. <\/span>\ub530\ub77c\uc11c, <\/span>\ub9cc\uc77c \uc5ec\ub7ec\ubd84\uc774 master.info<\/span><\/code>\ud30c\uc77c\uc5d0 \uc788\ub294 \uac12\uc5d0 \ub300\uc751\ub418\ub294 \uc2a4\ud0c0\ud2b8\uc5c5 \uc635\uc158 \uac12\uacfc\ub294 \ub2e4\ub978 \uac83\uc744 \uc0ac\uc6a9\ud574\uc11c \uc2ac\ub808\uc774\ube0c \uc11c\ubc84\ub97c \uc2dc\uc791\ud55c\ub2e4\uba74, <\/span>\ub2e4\ub974\uac8c \uc801\uc6a9\ub41c \uac12\uc740 \ubb34\uc2dc\uac00 \ub418\ub294\ub370, <\/span>\uadf8 \uc774\uc720\ub294 \uc11c\ubc84\uac00 master.info<\/span><\/code>\ud30c\uc77c \uac12\uc744 \uacc4\uc18d \uc0ac\uc6a9\ud558\uae30 \ub54c\ubb38\uc774\ub2e4. <\/span>\ub2e4\ub978 \uac12\uc744 \uc0ac\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294, <\/span>\ubc18\ub4dc\uc2dc master.info<\/span><\/code>\ud30c\uc77c\uc744 \uc81c\uac70\ud55c \ub2e4\uc74c\uc5d0 \uc7ac \uc2dc\uc791\uc744 \ud558\uac70\ub098 \ub610\ub294 \uc2ac\ub808\uc774\ube0c\uac00 \uad6c\ub3d9\ud558\uace0 \uc788\ub294 \ub3d9\uc548\uc5d0 \uadf8 \uac12\uc744 \ub9ac\uc14b\ud558\uae30 \uc704\ud55c CHANGE MASTER TO<\/span><\/b><\/code>\uba85\ub839\ubb38\uc744 \uc0ac\uc6a9\ud574\uc11c \uc7ac \uc2dc\uc791\uc744 \ud558\ub3c4\ub85d \ud55c\ub2e4.<\/span><\/p>\n

\n<\/div>\n

\uc5ec\ub7ec\ubd84\uc774 \uc774 \uc635\uc158\uc744 my.cnf<\/span><\/code>\ud30c\uc77c\uc5d0 \uc9c0\uc815\ud588\ub2e4\uace0 \uac00\uc815\ud558\uc790:<\/span><\/p>\n

\n<\/div>\n
[mysqld]<\/span><\/pre>\n
master-host=<\/span>some_host<\/span><\/span><\/pre>\n
\uc11c\ubc84\ub97c \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc2ac\ub808\uc774\ube0c\ub85c \ucc98\uc74c \uad6c\ub3d9\ud558\uba74, <\/span>\uc11c\ubc84\ub294 my.cnf<\/span><\/code>\ud30c\uc77c\uc5d0\uc11c \uadf8 \uc635\uc158\uc744 \uc77d\uc5b4\uc11c \uc0ac\uc6a9\ud55c\ub2e4. <\/span>\uadf8\ub7f0 \ub2e4\uc74c\uc5d0, <\/span>\uc11c\ubc84\ub294 \uadf8 \uac12\uc744 master.info<\/span><\/code>\ud30c\uc77c\uc5d0 \uae30\ub85d\ud55c\ub2e4. <\/span>\ub2e4\uc74c \ubc88\uc5d0 \uc11c\ubc84\ub97c \uad6c\ub3d9\ud558\uba74, <\/span>\uc11c\ubc84\ub294 master.info<\/span><\/code>\ud30c\uc77c\uc5d0\uc11c\ub9cc \ub9c8\uc2a4\ud130 \ud638\uc2a4\ud2b8 \uac12\uc744 \uc77d\uac8c \ub418\uace0 \uc635\uc158 \ud30c\uc77c\uc5d0 \uc788\ub294 \uac12\uc744 \ubb34\uc2dc\ub97c \ud55c\ub2e4. <\/span>\ub9cc\uc77c \uc5ec\ub7ec\ubd84\uc774 some_other_host<\/span><\/span>\uc758 \ub9c8\uc2a4\ud130 \ud638\uc2a4\ud2b8\ub97c \ub2ec\ub9ac \uc9c0\uc815\ud558\uae30 \uc704\ud574my.cnf<\/span><\/code>\ud30c\uc77c\uc744 \uc218\uc815\ud55c\ub2e4\uace0 \ud558\ub354\ub77c\ub3c4, <\/span>\ubcc0\uacbd \ub0b4\uc6a9\uc740 \uc801\uc6a9\ub418\uc9c0 \uc54a\ub294\ub2e4. <\/span>\ubcc0\uacbd \ub0b4\uc6a9\uc774 \uc801\uc6a9\ub418\ub3c4\ub85d \ud558\uae30 \uc704\ud574\uc11c\ub294 CHANGE MASTER TO<\/span><\/b><\/code>\ub97c \uc0ac\uc6a9\ud574\uc57c \ud55c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\uc704\uc5d0\uc11c \uc124\uba85\ud558\uc600\ub4ef\uc774, <\/span>\uc11c\ubc84\ub294 \uc2a4\ud0c0\ud2b8\uc5c5 \uc635\uc158 \ub300\uc2e0\uc5d0 \uc774\ubbf8 \uc874\uc7ac\ud558\uace0 \uc788\ub294 master.info<\/span><\/code>\ud30c\uc77c\uc5d0 \uc6b0\uc120\uad8c\uc744 \uc8fc\uae30 \ub54c\ubb38\uc5d0, <\/span>\uc774 \uac12\ub4e4\uc5d0 \ub300\ud574\uc11c\ub294 \uc2a4\ud0c0\ud2b8\uc5c5 \uc635\uc158\uc744 \uc804\ud600 \uba3c\uc800 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uac8c \ub418\ubbc0\ub85c, <\/span>CHANGE MASTER TO<\/span><\/b><\/code>\uba85\ub839\ubb38\uc744 \uc0ac\uc6a9\ud574\uc11c \uc774 \uac12\ub4e4\uc744 \ub300\uc2e0 \uc9c0\uc815\ud558\ub3c4\ub85d \ud55c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\uc544\ub798\uc758 \uc608\ubb38\uc740 \uc2ac\ub808\uc774\ube0c \uc11c\ubc84\ub97c \uad6c\uc131\ud558\uae30 \uc704\ud574 \uc2a4\ud0c0\ud2b8\uc5c5 \uc635\uc158\uc744 \ubcf4\ub2e4 \uad11\ubc94\uc704\ud558\uac8c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \ubcf4\uc5ec\uc8fc\ub294 \uac83\uc774\ub2e4:<\/span><\/p>\n
\n<\/div>\n
[mysqld]<\/span><\/pre>\n
server-id=2<\/span><\/pre>\n
master-host=db-master.mycompany.com<\/span><\/pre>\n
master-port=3306<\/span><\/pre>\n
master-user=pertinax<\/span><\/pre>\n
master-password=freitag<\/span><\/pre>\n
master-connect-retry=60<\/span><\/pre>\n
report-host=db-slave.mycompany.com<\/span><\/pre>\n
\uc544\ub798\uc758 \ub9ac\uc2a4\ud2b8\ub294 \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uc81c\uc5b4\ud558\ub294\ub370 \uc0ac\uc6a9\ud558\ub294 \uc2a4\ud0c0\ud2b8\uc5c5 \uc635\uc158\uc744 \uc124\uba85\ud558\ub294 \uac83\uc774\ub2e4. <\/span>\uc774 \uc635\uc158\ub4e4 \uc911\uc758 \ub9ce\uc740 \uac83\ub4e4\uc740 \uc11c\ubc84\uac00 \uad6c\ub3d9\ub418\uace0 \uc788\ub294 \ub3d9\uc548 CHANGE MASTER TO<\/span><\/b><\/code>\uba85\ub839\ubb38\uc744 \uc0ac\uc6a9\ud574\uc11c \ub9ac\uc14b \uc2dc\ud0ac \uc218\uac00 \uc788\ub2e4. <\/span>--replicate-*<\/span><\/code>\uc635\uc158\uacfc \uac19\uc740 \uac83\ub4e4\uc740 \uc2ac\ub808\uc774\ube0c \uc11c\ubc84\uac00 \uc2dc\uc791\ub420 \ub54c\uc5d0\ub9cc \uc124\uc815\ub420 \uc218 \uc788\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--log-slave-updates<\/span><\/code><\/p>\n
\n<\/div>\n
\uc77c\ubc18\uc801\uc73c\ub85c, <\/span>\uc2ac\ub808\uc774\ube0c\ub294 \ub9c8\uc2a4\ud130 \uc11c\ubc84\uc5d0\uc11c \uc804\ub2ec \ubc1b\uc740 \uc5c5\ub370\uc774\ud2b8\uc5d0 \ub300\ud574\uc11c\ub294 \uc790\uc2e0\uc758 \ubc14\uc774\ub108\ub9ac \ub85c\uadf8\uc5d0 \uae30\ub85d\ud558\uc9c0 \uc54a\ub294\ub2e4. <\/span>\uc774 \uc635\uc158\uc740 SQL <\/span>\uc4f0\ub808\ub4dc\uac00 \uc2e4\ud589\ud55c \uc5c5\ub370\uc774\ud2b8\ub97c \uc790\uc2e0\uc758 \ubc14\uc774\ub108\ub9ac \ub85c\uadf8\uc5d0 \uae30\ub85d\ud558\ub3c4\ub85d \ub9cc\ub4e0\ub2e4.<\/span>\uc2ac\ub808\uc774\ube0c\uac00 \ubc14\uc774\ub108\ub9ac \ub85c\uae45\uc744 \ud65c\uc131\ud654 \uc2dc\ud0a4\uae30 \uc704\ud55c --log-bin<\/span><\/code>\uc635\uc158\uacfc \ud568\uaed8 \uc2dc\uc791\ub418\uc5b4\uc57c \uc774 \uc635\uc158\uc774 \uc801\uc6a9\ub41c\ub2e4.<\/span>--log-slave-updates<\/span><\/code>\ub294 \uc5ec\ub7ec\ubd84\uc774 \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc11c\ubc84\ub97c \uc11c\ub85c \uc5f0\uacb0 (chain) <\/span>\ud560 \ub54c \uc0ac\uc6a9\ud558\ub294 \uac83\uc774\ub2e4. <\/span>\uc608\ub97c \ub4e4\uba74, <\/span>\uc544\ub798\uc640 \uac19\uc740 \ubc30\uc5f4\uc744 \uc0ac\uc6a9\ud574\uc11c \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc11c\ubc84\ub97c \uc124\uc815\ud55c\ub2e4\uace0 \uac00\uc815\ud558\uc790:<\/span><\/p>\n
\n<\/div>\n
A -> B -> C<\/span><\/pre>\n
\uc5ec\uae30\uc5d0\uc11c, A<\/span>\ub294 \uc2ac\ub808\uc774\ube0cB<\/span>\uc5d0 \ub300\ud55c \ub9c8\uc2a4\ud130 \uc5ed\ud560\uc744 \ud558\uace0, B<\/span>\ub294 \uc2ac\ub808\uc774\ube0c C<\/span>\uc5d0 \ub300\ud574 \ub9c8\uc2a4\ud130 \uc5ed\ud560\uc744 \ud55c\ub2e4. <\/span>\uc774\ub807\uac8c \ub3d9\uc791\ud558\uae30 \uc704\ud574\uc11c\ub294, B<\/span>\uac00 \ubc18\ub4dc\uc2dc \ub9c8\uc2a4\ud130\uc778 \ub3d9\uc2dc\uc5d0 \uc2ac\ub808\uc774\ube0c\uac00 \ub418\uc5b4\uc57c \ud55c\ub2e4. <\/span>\ubc14\uc774\ub108\ub9ac \ub85c\uae45\uc744 \ud65c\uc131\ud654 \uc2dc\ud0a4\uae30 \uc704\ud574 A<\/span>\uc640 B <\/span>\ubaa8\ub450\uc5d0\uc11c --log-bin<\/span><\/code>\uc635\uc158\uc744 \uc2e4\ud589\ud574\uc57c \ud558\uace0, A<\/span>\uc5d0\uc11c \ubc1b\uc740 \uc5c5\ub370\uc774\ud2b8\ub97c B<\/span>\uac00 \uc790\uc2e0\uc758 \ubc14\uc774\ub108\ub9ac \ub85c\uadf8\uc5d0 \uae30\ub85d\ud560 \uc218 \uc788\ub3c4\ub85d B<\/span>\ub294 --log-slave-updates<\/span><\/code>\uc635\uc158\uc744 \uc2e4\ud589\ud574\uc57c \ud55c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--log-warnings<\/span><\/code><\/p>\n
\n<\/div>\n
\uc774 \uc635\uc158\uc740 \uc5d0\ub7ec \ub85c\uadf8\uc5d0 \ubcf4\ub2e4 \uc790\uc138\ud55c \uba54\uc2dc\uc9c0\ub97c \uae30\ub85d\ud558\uac8c\ub054 \ub9cc\ub4e0\ub2e4. <\/span>\ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uad00\uc810\uc5d0\uc11c \ubcf4\uba74, <\/span>\uc11c\ubc84\ub294 \ub124\ud2b8\uc6cc\ud06c\/<\/span>\uc811\uc18d \uc2e4\ud328 \ud6c4\uc5d0 \uc9c0\uc18d\uc801\uc73c\ub85c \uc811\uc18d\uc744 \ub2e4\uc2dc \uc2dc\ub3c4\ud558\ub294 \uacbd\uace0\ubb38\uc744 \ub9cc\ub4e4\uba70, <\/span>\uac01\uac01\uc758 \uc2ac\ub808\uc774\ube0c\uac00 \uc5b4\ub5bb\uac8c \uc2dc\uc791\ub418\ub294\uc9c0\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \uc5ec\ub7ec\ubd84\uc5d0\uac8c \uc54c\ub824 \uc900\ub2e4. <\/span>\uc774 \uc635\uc158\uc740 \ub514\ud3f4\ud2b8\ub85c \ud65c\uc131\ud654 \ub41c\ub2e4; <\/span>\uc774\uac83\uc744 \ube44\ud65c\uc131\ud654 \uc2dc\ud0a4\uae30 \uc704\ud574\uc11c\ub294, <\/span>--skip-log-warnings<\/span><\/code>\ub97c \uc0ac\uc6a9\ud55c\ub2e4. <\/span>\ub2e8\uc808\ub41c \uc811\uc18d\uc740 \uc774 \uac12\uc774 1<\/span>\ubcf4\ub2e4 \ud06c\uc9c0 \uc54a\ub294 \ud55c \uc5d0\ub7ec \ub85c\uadf8\uc5d0 \uae30\ub85d\ub418\uc9c0 \uc54a\ub294\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--master-connect-retry=<\/span><\/code>seconds<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\ub9c8\uc2a4\ud130\uac00 \ub2e4\uc6b4 \ub418\uac70\ub098 \ub610\ub294 \uc811\uc18d\uc774 \ub04a\uc5b4\uc9c0\ub294 \uacbd\uc6b0\uc5d0, <\/span>\ub9c8\uc2a4\ud130\uc5d0 \uc7ac \uc811\uc18d\uc744 \uc2dc\ub3c4\ud558\uae30 \uc804\uc5d0 \uc2ac\ub808\uc774\ube0c \uc4f0\ub808\ub4dc\uac00 \uc2ac\ub9bd (sleep)<\/span>\ud558\ub294 \uc2dc\uac04. <\/span>master.info<\/span>\ud30c\uc77c\uc5d0 \uc788\ub294 \uac12\uc774 \uc6b0\uc120\uad8c\uc744 \uac00\uc9c4\ub2e4. <\/span>\uc124\uc815\ub418\uc9c0 \uc54a\uc73c\uba74, <\/span>\ub514\ud3f4\ud2b8\ub294 60<\/span>\uc774 \ub41c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--master-host=<\/span><\/code>host_name<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\ub9c8\uc2a4\ud130 \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc11c\ubc84\uc758 \ud638\uc2a4\ud2b8 \uc774\ub984 \ub610\ub294 IP <\/span>\ubc88\ud638. <\/span>master.info<\/span>\uc5d0 \uc788\ub294 \uac12\uc774 \uc6b0\uc120\uad8c\uc744 \uac16\ub294\ub2e4. <\/span>\ub9c8\uc2a4\ud130 \ud638\uc2a4\ud2b8\uac00 \uc9c0\uc815\ub418\uc9c0 \uc54a\uc73c\uba74, <\/span>\uc2ac\ub808\uc774\ube0c \uc4f0\ub808\ub4dc\ub294 \uc2dc\uc791\ub418\uc9c0 \uc54a\ub294\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--master-info-file=<\/span><\/code>file_name<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\uc2ac\ub808\uc774\ube0c\uac00 \ub9c8\uc2a4\ud130 \uc815\ubcf4\ub97c \uae30\ub85d\ud558\ub294 \ud30c\uc77c\uc758 \uc774\ub984. <\/span>\ub514\ud3f4\ud2b8\ub294 \ub370\uc774\ud130 \ub514\ub809\ud1a0\ub9ac\uc5d0 \uc788\ub294 mysql.info<\/span>\uac00 \ub41c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--master-password=<\/span><\/code>password<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\uc2ac\ub808\uc774\ube0c\uac00 \ub9c8\uc2a4\ud130\uc5d0 \uc811\uc18d\uc744 \ud560 \ub54c \uc2ac\ub808\uc774\ube0c \uc4f0\ub808\ub4dc\uac00 \uc778\uc99d\uc6a9\uc73c\ub85c \uc0ac\uc6a9\ud558\ub294 \uacc4\uc815\uc758 \ud328\uc2a4\uc6cc\ub4dc.<\/span>master.info<\/span>\ud30c\uc77c\uc5d0 \uc788\ub294 \uac12\uc774 \uc6b0\uc120\uad8c\uc744 \uac00\uc9c0\uac8c \ub41c\ub2e4. <\/span>\uc124\uc815\uc774 \ub418\uc5b4 \uc788\uc9c0 \uc54a\uc73c\uba74, <\/span>\ud328\uc2a4\uc6cc\ub4dc\uac00 \ube44\uc5b4 \uc788\ub2e4\uace0 \uac04\uc8fc\ub41c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--master-port=<\/span><\/code>port_number<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\ub9c8\uc2a4\ud130\uac00 \uc2ac\ub808\uc774\ube0c \uc811\uc18d\uc744 \uae30\ub2e4\ub9ac\ub294 (listening) TCP\/IP <\/span>\ud3ec\ud2b8 \ubc88\ud638. <\/span>master.info<\/span>\ud30c\uc77c\uc5d0 \uc788\ub294 \uac12\uc774 \uc6b0\uc120\uad8c\uc744 \uac00\uc9c4\ub2e4. <\/span>\uc124\uc815\uc774 \ub418\uc5b4 \uc788\uc9c0 \uc54a\uc73c\uba74, <\/span>\uc124\uc815\uc774 \ucef4\ud30c\uc77c \ub418\uc5b4 \uc788\ub2e4\uace0 \uac00\uc815\uc744 \ud55c\ub2e4 (<\/span>\uc77c\ubc18\uc801\uc778 \uacbd\uc6b0 3306).<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--master-retry-count=<\/span><\/code>count<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\uc2ac\ub808\uc774\ube0c\uac00 \ub9c8\uc2a4\ud130\uc5d0 \uc811\uc18d\uc744 \uc2dc\ub3c4\ud558\ub294 \ud69f\uc218 (<\/span>\uc811\uc18d \ud3ec\uae30 \uc804\uae4c\uc9c0).<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--master-ssl<\/span><\/code>, <\/span>--master-ssl-ca=<\/span><\/code>file_name<\/span><\/i><\/span>, <\/span>--master-ssl-capath=<\/span><\/code>directory_name<\/span><\/i><\/span>, <\/span>--master-ssl-cert=<\/span><\/code>file_name<\/span><\/i><\/span>, <\/span>--master-ssl-cipher=<\/span><\/code>cipher_list<\/span><\/i><\/span>, <\/span>--master-ssl-key=<\/span><\/code>file_name<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\uc774 \uc635\uc158\uc740 SSL<\/span>\uc744 \uc0ac\uc6a9\ud558\ub294 \ub9c8\uc2a4\ud130 \uc11c\ubc84 \ubcf4\uc548 \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc811\uc18d \uc124\uc815\uc6a9\uc73c\ub85c \uc0ac\uc6a9\ub41c\ub2e4. <\/span>\uac01\uac01\uc758 \uc758\ubbf8\ub294Section\u00a05.9.7.5, \u201cSSL \uba85\ub839\uc5b4<\/span><\/span> \uc635\uc158<\/span><\/span>\u201d<\/span>\uc5d0\uc11c \uc124\uba85\ud558\uace0 \uc788\ub294 --ssl<\/span><\/code>, <\/span>--ssl-ca<\/span><\/code>, <\/span>--ssl-capath<\/span><\/code>, <\/span>--ssl-cert<\/span><\/code>,<\/span>--ssl-cipher<\/span><\/code>, <\/span>--ssl-key<\/span><\/code>\uc635\uc158\ub4e4\uacfc \uac19\ub2e4. <\/span>master.info<\/span>\ud30c\uc77c\uc5d0 \uc788\ub294 \uac12\ub4e4\uc774 \uc6b0\uc120\uad8c\uc774 \uc788\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--master-user=<\/span><\/code>user_name<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\uc2ac\ub808\uc774\ube0c\uac00 \uc11c\ubc84\uc5d0 \uc811\uc18d\uc744 \ud560 \ub54c \uc2ac\ub808\uc774\ube0c \uc4f0\ub808\ub4dc\uac00 \uc778\uc99d\uc744 \uc704\ud574 \uc0ac\uc6a9\ud558\ub294 \uacc4\uc815\uc758 \uc0ac\uc6a9\uc790 \uc774\ub984. <\/span>\uc774 \uacc4\uc815\uc740 \ubc18\ub4dc\uc2dc REPLICATION SLAVE<\/span><\/b><\/code>\uad8c\ud55c\uc744 \uac00\uc9c0\uace0 \uc788\uc5b4\uc57c \ud55c\ub2e4. <\/span>master.info<\/span>\ud30c\uc77c \uac12\uc774 \uc6b0\uc120\uad8c\uc774 \uc788\ub2e4. <\/span>\ub9cc\uc77c \ub9c8\uc2a4\ud130 \uc0ac\uc6a9\uc790 \uc774\ub984\uc774 \uc124\uc815\ub418\uc9c0 \uc54a\uc558\ub2e4\uba74, <\/span>\uc0ac\uc6a9\uc790 \uc774\ub984\uc744 test<\/span><\/b><\/code>\ub77c\uace0 \uac00\uc815\ud55c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--max-relay-log-size=<\/span><\/code>size<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\uc11c\ubc84\uac00 \uc790\ub3d9\uc73c\ub85c \ub9b4\ub808\uc774 \ub85c\uadf8 \ud30c\uc77c\uc744 \uc21c\ud658\uc2dc\ud0a4\ub294 \ud06c\uae30. <\/span>\uc790\uc138\ud55c \uc815\ubcf4\ub294 Section\u00a06.3.4, \u201c\ub9ac\ud50c\ub9ac\ucf00\uc774\uc158<\/span><\/span>\ub9b4\ub808\uc774<\/span><\/span> \ubc0f<\/span><\/span> \uc0c1\ud0dc<\/span><\/span> \ud30c\uc77c<\/span><\/span>\u201d<\/span>\ub97c \ucc38\uc870\ud560 \uac83.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--read-only<\/span><\/code><\/p>\n
\n<\/div>\n
\uc2ac\ub808\uc774\ube0c\ub294 \uc790\uc2e0\uc758 \uc4f0\ub808\ub4dc\uac00 \ubcf4\ub0b4\uac70\ub098 SUPER<\/span><\/b><\/code>\uad8c\ud55c \uc0ac\uc6a9\uc790\uac00 \ubcf4\ub0b4\ub294 \uc5c5\ub370\uc774\ud2b8 \uc774\uc678\uc5d0\ub294 \uc5b4\ub5a0\ud55c \uc5c5\ub370\uc774\ud2b8\ub3c4 \ud558\uc9c0 \ubabb\ud558\ub3c4\ub85d \ud55c\ub2e4. <\/span>\uc989, <\/span>\uc2ac\ub808\uc774\ube0c \uc11c\ubc84\uac00 \ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0\uc11c \uc624\ub294 \uc5c5\ub370\uc774\ud2b8\ub97c \ubc1b\uc544\ub4e4\uc774\uc9c0 \ubabb\ud558\ub3c4\ub85d \ub9cc\ub4dc\ub294 \uc635\uc158\uc774\ub2e4. MySQL 5.0.16 <\/span>\uc774\ud6c4\uc5d0\ub294 TEMPORARY<\/span><\/b><\/code> <\/b>\ud14c\uc774\ube14\uc5d0 \uc774 \uc635\uc158\uc744 \uc801\uc6a9\ud560 \uc218 \uc5c6\uac8c \ub418\uc5c8\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--relay-log=<\/span><\/code>file_name<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\ub9b4\ub808\uc774 \ub85c\uadf8\uc6a9 \uc774\ub984. <\/span>\ub514\ud3f4\ud2b8 \uc774\ub984\uc740 host_name<\/span><\/i><\/span>-relay-bin.<\/span><\/code>nnnnnn<\/span><\/i><\/span>\uc774\uba70, <\/span>\uc5ec\uae30\uc5d0\uc11c host_name<\/span><\/i><\/span>\uc740 \uc2ac\ub808\uc774\ube0c \uc11c\ubc84 \ud638\uc2a4\ud2b8 \uc774\ub984\uc774\uba70, <\/span>nnnnnn<\/span><\/i><\/span>\ub294 \ub9b4\ub808\uc774 \ub85c\uadf8\uac00 \uc774\ub9cc\ud07c\uc758 \uc2dc\ud000\uc2a4 \ub3d9\uc548 \uc0dd\uc131\ub418\uc5c8\uc74c\uc744 \uac00\ub9ac\ud0a4\ub294 \uac83\uc774\ub2e4.<\/span>\ud638\uc2a4\ud2b8 \uc774\ub984\uacfc\ub294 \ubb34\uad00\ud55c \ub9b4\ub808\uc774 \ub85c\uadf8 \uc774\ub984\uc744 \uc0dd\uc131\ud558\uace0\uc790 \ud558\ub294 \uacbd\uc6b0, <\/span>\ub610\ub294 \ub9b4\ub808\uc774 \ub85c\uadf8\uac00 \uc810\uc810 \ucee4\uc9c0\uace0(<\/span>\uadf8\ub9ac\uace0 max_relay_log_size<\/span><\/b><\/code>\uc758 \ud06c\uae30\ub97c \uc904\uc774\uace0 \uc2f6\uc9c0 \uc54a\uc73c\uba70) <\/span>\uadf8\ub9ac\uace0 \uc774 \ub9b4\ub808\uc774 \ub85c\uadf8\ub4e4\uc744 \ub370\uc774\ud130 \ub514\ub809\ud1a0\ub9ac\uac00 \uc544\ub2cc \ub2e4\ub978 \uacf3\uc5d0 \uc800\uc7a5\ud558\uace0 \uc2f6\uc740 \uacbd\uc6b0, <\/span>\ub610\ub294 \ub514\uc2a4\ud06c \uac04 \ub85c\ub4dc \ubc38\ub7f0\uc2f1\uc744 \ud1b5\ud574 \uc18d\ub3c4\ub97c \uc99d\uac00 \uc2dc\ud0a4\uace0\uc790 \ud560 \uacbd\uc6b0\uc5d0 \uc774 \uc635\uc158\uc744 \uc9c0\uc815\ud560 \uc218\uac00 \uc788\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--relay-log-index=<\/span><\/code>file_name<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\ub9b4\ub808\uc774 \ub85c\uadf8 \uc778\ub371\uc2a4 \ud30c\uc77c\uc758 \uc774\ub984. <\/span>\ub514\ud3f4\ud2b8 \uc774\ub984\uc740 \ub370\uc774\ud130 \ub514\ub809\ud1a0\ub9ac \ub0b4\uc5d0 \uc788\ub294 host_name<\/span><\/i><\/span>-relay-bin.index<\/span>\uc774\uba70, <\/span>\uc5ec\uae30\uc5d0\uc11c host_name<\/span><\/i><\/span>\uc740 \uc2ac\ub808\uc774\ube0c \uc11c\ubc84\uc758 \uc774\ub984\uc774 \ub41c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--relay-log-info-file=<\/span><\/code>file_name<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\ub9b4\ub808\uc774 \ub85c\uadf8 \uc815\ubcf4\ub97c \uae30\ub85d\ud558\uae30 \uc704\ud55c \ud30c\uc77c\uc758 \uc774\ub984. <\/span>\ub514\ud3f4\ud2b8 \uc774\ub984\uc740 \ub370\uc774\ud130 \ub514\ub809\ud1a0\ub9ac \ub0b4\uc5d0 \uc788\ub294 relay-log.info<\/span>\uac00 \ub41c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--relay-log-purge={0|1}<\/span><\/code><\/p>\n
\n<\/div>\n
\ub9b4\ub808\uc774 \ub85c\uadf8\uac00 \ub354 \uc774\uc0c1 \ud544\uc694 \uc5c6\uac8c \ub418\ub294 \uc21c\uac04\uc5d0 \uc790\ub3d9\uc73c\ub85c \uc774 \ub85c\uadf8\ub97c \ube44\uc6cc \ubc84\ub9ac\ub294 (purging)<\/span>\uac83\uc744 \ud65c\uc131\ud654 \ub610\ub294 \ube44 \ud65c\uc131\ud654 \uc2dc\ud0b4. <\/span>\ub514\ud3f4\ud2b8\ub294 1 (<\/span>\ud65c\uc131\ud654)<\/span>\uc784. <\/span>\uc774\uac83\uc740 SET GLOBAL relay_log_purge = <\/span><\/b><\/code>N<\/span><\/i><\/b><\/span>\uc744 \uc0ac\uc6a9\ud574\uc11c \ub3d9\uc801\uc73c\ub85c \ubcc0\uacbd \uc2dc\ud0ac \uc218 \uc788\ub294 \uae00\ub85c\ubc8c \ubcc0\uc218\uc774\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--relay-log-space-limit=<\/span><\/code>size<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\uc774 \uc635\uc158\uc740 \uc2ac\ub808\uc774\ube0c\uc5d0 \uc788\ub294 \ubaa8\ub4e0 \ub9b4\ub808\uc774 \ub85c\uadf8 \uc804\uccb4\uc758 \ucd5c\ub300 \ud06c\uae30 (<\/span>\ubc14\uc774\ud2b8 \ub2e8\uc704)<\/span>\ub97c \uc9c0\uc815\ud55c\ub2e4. <\/span>\uc774 \uac12\uc774 0<\/span>\uc774\uba74 \u201c<\/span>\uc81c\ud55c \uc5c6\uc74c (no limit)<\/span>\u201d<\/span>\uc744 \uc758\ubbf8\ud55c\ub2e4. <\/span>\uc81c\ud55c\ub41c \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \uac00\uc9c0\uace0 \uc788\ub294 \uc2ac\ub808\uc774\ube0c \uc11c\ubc84 \ud638\uc2a4\ud2b8\uc5d0 \uc720\uc6a9\ud55c \uc635\uc158\uc774\ub2e4. <\/span>\uc81c\ud55c \uac12\uc5d0 \ub3c4\ub2ec\ud558\uba74, I\/O <\/span>\uc4f0\ub808\ub4dc\ub294 SQL <\/span>\uc4f0\ub808\ub4dc\uac00 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uace0 \uc788\ub294 \ub9b4\ub808\uc774 \ub85c\uadf8\ub97c \uac00\uc838\uc640\uc11c \uc81c\uac70\ud558\uae30 \uc804\uae4c\uc9c0 \ub9c8\uc2a4\ud130 \uc11c\ubc84\uc5d0\uc11c \uc624\ub294 \ubc14\uc774\ub108\ub9ac \ub85c\uadf8 \uc774\ubca4\ud2b8\ub97c \uc77d\uc9c0 \uc54a\ub294\ub2e4. <\/span>\uc774 \uc81c\ud55c \uac12\uc740 \uc808\ub300\uc801\uc778 \uac83\uc774 \uc544\ub2c8\ub77c\ub294 \uac83\uc744 \uc54c\uc544\ub450\uc790: SQL<\/span>\uc4f0\ub808\ub4dc\ub294 \ub9b4\ub808\uc774 \ub85c\uadf8\ub97c \uc0ad\uc81c\ud558\uae30 \uc804\uc5d0 \ubcf4\ub2e4 \ub9ce\uc740 \uc774\ubca4\ud2b8\ub97c \ud544\uc694\ub85c \ud558\ub294 \uacbd\uc6b0\uac00 \uc788\ub2e4. <\/span>\uc774\ub7ec\ud55c \uacbd\uc6b0\uc5d0\ub294, I\/O <\/span>\uc4f0\ub808\ub4dc\ub294 SQL <\/span>\uc4f0\ub808\ub4dc\uac00 \uba87\uba87 \ub9b4\ub808\uc774 \ub85c\uadf8\ub97c \uc0ad\uc81c\ud560 \uc218 \uc788\uc744 \ub54c\uae4c\uc9c0 \uc81c\ud55c\uce58\ub97c \ucd08\uacfc\ud558\uac8c \ub418\ub294\ub370, <\/span>\uadf8\ub807\uac8c \ud558\uc9c0 \uc54a\uc73c\uba74 \ub370\ub4dc\ub77d (deadlock)<\/span>\uc774 \uc0dd\uae38 \uc218 \uc788\uae30 \ub54c\ubb38\uc774\ub2e4.<\/span>\uc5ec\ub7ec\ubd84\uc740 --max-relay-log-size<\/span><\/code>(<\/span>\ub610\ub294 --max-relay-log-size<\/span><\/code>\uac00 0 <\/span>\uc77c \uacbd\uc6b0\uc5d0\ub294,<\/span>--max-binlog-size<\/span><\/code>) <\/span>\uac12\uc758 \ub450 \ubc30 \ubcf4\ub2e4\ub294 \uc791\uac8c --relay-log-space-limit <\/span><\/code>\uac12\uc744 \uc124\uc815\ud558\uc9c0 \ub9d0\uc544\uc57c \ud55c\ub2e4. <\/span>\uadf8\ub807\uc9c0 \uc54a\uc73c\uba74, <\/span>--relay-log-space-limit<\/span><\/code>\uac00 \ucd08\uacfc\ub418\uae30 \ub54c\ubb38\uc5d0 I\/O <\/span>\uc4f0\ub808\ub4dc\ub294 \uc0ac\uc6a9 \uac00\ub2a5 \uacf5\uac04\uc744 \uae30\ub2e4\ub9ac\uac8c \ub418\uc9c0\ub9cc, SQL <\/span>\uc4f0\ub808\ub4dc\ub294 \uae68\ub057\uc774 \ube44\uc6cc\uc57c \ud560 \ub9b4\ub808\uc774 \ub85c\uadf8\ub97c \uac00\uc9c0\uc9c0 \uc54a\uac8c \ub418\uace0, <\/span>\ub530\ub77c\uc11c I\/O <\/span>\uc4f0\ub808\ub4dc\ub97c \ub9cc\uc871\uc2dc\ud0a4\uc9c0 \ubabb\ud558\uac8c \ub41c\ub2e4. <\/span>\uc774\uac83\uc740 I\/O<\/span>\uc4f0\ub808\ub4dc\uac00 \uc784\uc2dc\uc801\uc73c\ub85c --relay-log-space-limit<\/span><\/code>\ub97c \ubb34\uc2dc\ud558\uac8c\ub054 \ub9cc\ub4e4\uc5b4 \ubc84\ub9b0\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--replicate-do-db=<\/span><\/code>db_name<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\ub514\ud3f4\ud2b8 \ub370\uc774\ud130 \ubca0\uc774\uc2a4 (<\/span>\uc989, <\/span>USE<\/span><\/b><\/code>\uac00 \uc120\ud0dd\ud558\ub294 \uac83)<\/span>\uac00 db_name<\/span><\/i><\/span>\uc778 \uacf3\uc5d0\uc11c\ub294 \uba85\ub839\ubb38 \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uc81c\ud55c\ud558\ub3c4\ub85d \uc11c\ubc84\uc5d0\uac8c \uc9c0\uc2dc\ud55c\ub2e4. <\/span>\ud55c \uac1c \uc774\uc0c1\uc758 \ub370\uc774\ud130 \ubca0\uc774\uc2a4\ub97c \uc9c0\uc815\ud558\uae30 \uc704\ud574\uc11c\ub294, <\/span>\uac01\uac01\uc758 \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \ubcc4\ub85c \ud55c \ubc88\uc529 \uc774 \uc635\uc158\uc744 \uc0ac\uc6a9\ud55c\ub2e4. <\/span>\uc774 \uc635\uc158\uc744 \uc0ac\uc6a9\ud558\uba74, <\/span>\uc11c\ub85c \ub2e4\ub978 \ub370\uc774\ud130 \ubca0\uc774\uc2a4\ub97c \uc120\ud0dd\ud588\uac70\ub098 \ub610\ub294 \uc544\ubb34\ub7f0 \ub370\uc774\ud130 \ubca0\uc774\uc2a4\ub3c4 \uc120\ud0dd\ud558\uc9c0 \uc54a\ub294 \ub3d9\uc548\uc5d0\ub294 UPDATE <\/span><\/b><\/code>some_db.some_table<\/span><\/i><\/span> <\/code>SET<\/span><\/b><\/code>foo='bar'<\/span><\/code>\uc640 \uac19\uc774 \ud06c\ub85c\uc2a4–<\/span>\ub370\uc774\ud130\ubca0\uc774\uc2a4 (cross-database) <\/span>\uba85\ub839\ubb38\uc744 \ubcf5\uc81c\ud558\uc9c0 \uc54a\ub294\ub2e4\ub294 \uc810\uc744 \uc54c\uc544\ub450\uc790.<\/span><\/p>\n
\n<\/div>\n
\uc5ec\ub7ec\ubd84\uc774 \uc608\uc0c1\ud558\ub294 \uac83\uacfc\ub294 \ub2e4\ub974\uac8c \ub3d9\uc791\ud558\ub294 \uc608\ub97c \ubcf4\uc790: <\/span>\ub9cc\uc77c \uc2ac\ub808\uc774\ube0c\uac00 --replicate-do-db=sales<\/span><\/code>\uc640 \ud568\uaed8 \uc2dc\uc791\ub418\uace0 \uc5ec\ub7ec\ubd84\uc774 \ub9c8\uc2a4\ud130\uc5d0\uc11c \uc544\ub798\uc640 \uac19\uc740 \uba85\ub839\ubb38\uc744 \uc785\ub825\ud588\ub2e4\uba74, <\/span>UPDATE<\/span><\/b><\/code>\uba85\ub839\ubb38\uc740 \ubcf5\uc81c\ub418\uc9c0 \uc54a\ub294\ub2e4:<\/span><\/p>\n
\n<\/div>\n
USE prices;<\/span><\/pre>\n
UPDATE sales.january SET amount=amount+1000;<\/span><\/pre>\n
\uc774\ub807\uac8c \u201c<\/span>\ub514\ud3f4\ud2b8 \ub370\uc774\ud130 \ubca0\uc774\uc2a4\ub97c \ub2e8\uc9c0 \uac80\uc0ac\ub9cc \ud558\ub294\u201d <\/span>\ub3d9\uc791\uc774 \uc77c\uc5b4\ub098\ub294 \uc8fc\ub41c \uc774\uc720\ub294, <\/span>\uba85\ub839\ubb38 \ud558\ub098\ub9cc \uac00\uc9c0\uace0\uc11c\ub294 \uba85\ub839\ubb38\uc744 \ubcf5\uc81c\ud560\uc9c0 \ub610\ub294 \ud558\uc9c0 \ub9d0\uc544\uc57c \ud560\uc9c0\ub97c \uc54c\uae30\uac00 \uc5b4\ub835\uae30 \ub54c\ubb38\uc774\ub2e4 (<\/span>\uc608\ub97c \ub4e4\uba74, <\/span>\ub9cc\uc57d\uc5d0 \uc5ec\ub7ec\ubd84\uc774 \ub2e4\uc911–<\/span>\ud14c\uc774\ube14 DELETE<\/span><\/b><\/code>\uba85\ub839\ubb38 \ub610\ub294 \uc5ec\ub7ec \uac1c\uc758 \ub370\uc774\ud130 \ubca0\uc774\uc2a4\ub97c \ub118\ub098\ub4dc\ub294 \ub2e4\uc911–<\/span>\ud14c\uc774\ube14 UPDATE<\/span><\/b><\/code>\uba85\ub839\ubb38\uc744 \uc0ac\uc6a9 \uc911\uc77c \uacbd\uc6b0). <\/span>\uc804\uccb4 \ub370\uc774\ud130 \ubca0\uc774\uc2a4\ub97c \uac80\uc0c9\ud560 \ud544\uc694\uac00 \uc5c6\ub294 \uacbd\uc6b0\uc5d0\ub294, <\/span>\ub2f9\uc5f0\ud788 \ub514\ud3f4\ud2b8 \ub370\uc774\ud130 \ubca0\uc774\uc2a4\ub9cc \uac80\uc0ac\ud558\ub294 \uac83\uc774 \ube60\ub97c \uac83\uc774\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\ub9cc\uc77c \uc5ec\ub7ec\ubd84\uc774 \ud06c\ub85c\uc2a4–<\/span>\ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc5c5\ub370\uc774\ud2b8\ub97c \uc218\ud589\ud560 \ud544\uc694\uac00 \uc5c6\ub2e4\uba74, <\/span>--replicate-wild-do-table=<\/span><\/code>db_name<\/span><\/i><\/span>.%<\/span><\/code>\ub97c \ub300\uc2e0 \uc0ac\uc6a9\ud55c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--replicate-do-table=<\/span><\/code>db_name.tbl_name<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\uc9c0\uc815\ub41c \ud14c\uc774\ube14\ub85c \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \ud558\ub294 \uac83\uc744 \uc81c\ud55c\ud558\ub3c4\ub85d \uc2ac\ub808\uc774\ube0c \uc4f0\ub808\ub4dc\uc5d0\uac8c \uc9c0\uc2dc\ud55c\ub2e4. <\/span>\ud55c \uac1c \uc774\uc0c1\uc758 \ud14c\uc774\ube14\uc744 \uc9c0\uc815\ud558\uae30 \uc704\ud574\uc11c\ub294, <\/span>\uac01\uac01\uc758 \ud14c\uc774\ube14 \ubcc4\ub85c \ud55c \ubc88\uc529 \uc774 \uc635\uc158\uc744 \uc0ac\uc6a9\ud55c\ub2e4. <\/span>\uc774 \uc635\uc158\uc740--replicate-do-db<\/span><\/code>\uc640\ub294 \ubc18\ub300\ub85c, <\/span>\ud06c\ub85c\uc2a4–<\/span>\ub370\uc774\ud130 \ubca0\uc774\uc2a4\uc5d0 \ub300\ud574\uc11c\ub3c4 \ub3d9\uc791\uc744 \ud55c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--replicate-ignore-db=<\/span><\/code>db_name<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\ub514\ud3f4\ud2b8 \ub370\uc774\ud130 \ubca0\uc774\uc2a4\uac00 (<\/span>\uc989, <\/span>USE<\/span><\/b><\/code>\uac00 \uc120\ud0dd\ud558\ub294 \uac83) <\/span>db_name<\/span><\/i><\/span>\uc778 \uacf3\uc5d0\uc11c\ub294 \ubaa8\ub4e0 \uba85\ub839\ubb38\uc744 \ubcf5\uc81c\ud558\uc9c0 \uc54a\ub3c4\ub85d \uc11c\ubc84\uc5d0\uac8c \uc9c0\uc2dc\ud55c\ub2e4. <\/span>\ud55c \uac1c \uc774\uc0c1\uc758 \ub370\uc774\ud130 \ubca0\uc774\uc2a4\ub97c \ubb34\uc2dc\ud558\ub3c4\ub85d \ud558\uae30 \uc704\ud574\uc11c\ub294, <\/span>\uac01\uac01\uc758 \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \ubcc4\ub85c \ud55c\ubc88\uc529 \uc774 \uc635\uc158\uc744 \uc0ac\uc6a9\ud55c\ub2e4. <\/span>\ub9cc\uc77c \uc5ec\ub7ec\ubd84\uc774 \ud06c\ub85c\uc2a4–<\/span>\ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc5c5\ub370\uc774\ud2b8\ub97c \uc0ac\uc6a9\ud558\uace0 \uc788\uace0 \uc774\ub7ec\ud55c \ub370\uc774\ud130 \ubca0\uc774\uc2a4\ub4e4\uc774 \uc5c5\ub370\uc774\ud2b8 \ub418\ub294 \uac83\uc744 \uc6d0\ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0\uc5d0\ub294, <\/span>\uc774 \uc635\uc158\uc744 \uc0ac\uc6a9\ud558\uc9c0 \ub9d0\ub3c4\ub85d \ud55c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\uc5ec\ub7ec\ubd84\uc774 \uae30\ub300\ud558\ub294 \uac83\ucc98\ub7fc \ub3d9\uc791\ud558\uc9c0 \uc54a\ub294 \uc608\ub97c \ubcf4\uc790: <\/span>\ub9cc\uc77c \uc2ac\ub808\uc774\ube0c\uac00 --replicate-ignore-db=sales<\/span><\/code>\uc640 \ud568\uaed8 \uc2dc\uc791\ub418\uace0 \uc5ec\ub7ec\ubd84\uc774 \uc544\ub798\uc640 \uac19\uc740 \uba85\ub839\ubb38\uc744 \ub9c8\uc2a4\ud130\uc5d0\uc11c \uc785\ub825\ud558\uc600\ub2e4\uba74, <\/span>UPDATE<\/span><\/b><\/code>\uba85\ub839\ubb38\uc740 \ubcf5\uc81c\ub418\uc9c0 \uc54a\ub294\ub2e4:<\/span><\/p>\n
\n<\/div>\n
USE prices;<\/span><\/pre>\n
UPDATE sales.january SET amount=amount+1000;<\/span><\/pre>\n
\ub9cc\uc77c \ud06c\ub85c\uc2a4–<\/span>\ub370\uc774\ud130 \ubca0\uc774\uc2a4\uc758 \uc5c5\ub370\uc774\ud2b8\ub97c \uc2e4\ud589\ud558\uace0\uc790 \ud55c\ub2e4\uba74, <\/span>--replicate-wild-ignore-table=<\/span><\/code>db_name<\/span><\/i><\/span>.%<\/span><\/code>\ub97c \ub300\uc2e0 \uc0ac\uc6a9\ud55c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--replicate-ignore-table=<\/span><\/code>db_name.tbl_name<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\ub3d9\uc77c\ud55c \uba85\ub839\ubb38\uc774 \ub2e4\ub978 \ubaa8\ub4e0 \ud14c\uc774\ube14\uc744 \uc5c5\ub370\uc774\ud2b8\ud558\ub354\ub77c\ub3c4, <\/span>\uc9c0\uc815 \ud14c\uc774\ube14 \uc5c5\ub370\uc774\ud2b8 \uba85\ub839\ubb38\uc740 \ubaa8\ub450 \ubcf5\uc81c\ud558\uc9c0 \ub9d0\ub3c4\ub85d \uc2ac\ub808\uc774\ube0c\uc5d0\uac8c \uc9c0\uc2dc\ud55c\ub2e4. <\/span>\ud55c \uac1c \uc774\uc0c1\uc758 \ud14c\uc774\ube14\uc744 \ubb34\uc2dc\ud558\ub3c4\ub85d \uc9c0\uc815\ud558\uae30 \uc704\ud574\uc11c\ub294, <\/span>\uac01\uac01\uc758 \ud14c\uc774\ube14 \ubcc4\ub85c \ud55c\ubc88\uc529 \uc774 \uc635\uc158\uc744 \uc0ac\uc6a9\ud55c\ub2e4. <\/span>\uc774\uac83\uc740 --replicate-ignore-db<\/span><\/code>\uc640\ub294 \ubc18\ub300\ub85c, <\/span>\ud06c\ub85c\uc2a4–<\/span>\ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc5c5\ub370\uc774\ud2b8\ub97c \uc2e4\ud589\ud55c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--replicate-rewrite-db=<\/span><\/code>from_name<\/span><\/i><\/span>-><\/span><\/code>to_name<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\ub9c8\uc2a4\ud130 \uc0c1\uc5d0\uc11c \ub514\ud3f4\ud2b8 \ub370\uc774\ud130 \ubca0\uc774\uc2a4 (<\/span>\uc989, <\/span>USE<\/span><\/b><\/code>\uac00 \uc120\ud0dd\ud558\ub294 \uac83)<\/span>\uac00 from_name<\/span><\/i><\/span>\uc600\ub2e4\uba74, <\/span>\uadf8\uac83\uc744to_name<\/span><\/i><\/span>\ub85c \ud574\uc11d\ud558\ub3c4\ub85d \uc2ac\ub808\uc774\ube0c\uc5d0\uac8c \uc9c0\uc2dc\ud55c\ub2e4. <\/span>\ud14c\uc774\ube14\uc744 \ud3ec\ud568\ud558\ub294 \uba85\ub839\ubb38\uc5d0\ub9cc \uc601\ud5a5\uc744 \uc8fc\uba70 (<\/span>CREATE DATABASE<\/span><\/b><\/code>, <\/span><\/b>DROP DATABASE<\/span><\/b><\/code>,<\/span><\/b>\uadf8\ub9ac\uace0 ALTER DATABASE<\/span><\/b><\/code>\uc640 \uac19\uc740 \uba85\ub839\ubb38\uc740 \uc81c\uc678), <\/span>\ub9c8\uc2a4\ud130\uc5d0\uc11c \ub514\ud3f4\ud2b8 \ub370\uc774\ud130 \ubca0\uc774\uc2a4\uac00from_name<\/span><\/i><\/span>\uc77c \uacbd\uc6b0\uc5d0\ub9cc \uc601\ud5a5\uc744 \uc900\ub2e4. <\/span>\uc774\uac83\uc740 \ud06c\ub85c\uc2a4–<\/span>\ub370\uc774\ud130 \ubca0\uc774\uc2a4\ub97c \uc5c5\ub370\uc774\ud2b8 \ud558\uc9c0\ub294 \uc54a\ub294\ub2e4. <\/span>\ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc774\ub984\uc744 \ud574\uc11d\ud558\ub294 \uac83\uc740 --replicate-*<\/span><\/code>\uaddc\uce59\uc744 \ud14c\uc2a4\ud2b8 \ud558\uae30 \uc804\uc5d0 \uc774\ub8e8\uc5b4 \uc9c4\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\ub9cc\uc77c \uc774 \uc635\uc158\uc744 \uba85\ub839\uc5b4 \ub77c\uc778\uc5d0\uc11c \uc0ac\uc6a9\ud558\uace0 \u2018<\/span>><\/span><\/b><\/code>\u2019 <\/span>\ubb38\uc790\uac00 \uba85\ub839\uc5b4 \ud574\uc11d\uae30\uc5d0\uc11c \ud2b9\uc218 \ubb38\uc790\ub85c \ubc1b\uc544 \ub4e4\uc5ec\uc9c4\ub2e4\uba74, <\/span>\uc778\uc6a9 \ubd80\ud638\ub97c \uc0ac\uc6a9\ud574\uc11c \uc774 \uc635\uc158 \uac12\uc744 \uc9c0\uc815\ud558\ub3c4\ub85d \ud55c\ub2e4. <\/span>\uc608\ub97c \ub4e4\uba74:<\/span><\/p>\n
\n<\/div>\n
shell> <\/span>mysqld --replicate-rewrite-db=\"<\/span><\/span>olddb<\/span><\/i><\/span>-><\/span><\/span>newdb<\/span><\/i><\/span>\"<\/span><\/span><\/pre>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--replicate-same-server-id<\/span><\/code><\/p>\n
\n<\/div>\n
\uc2ac\ub808\uc774\ube0c \uc11c\ubc84\uc5d0\uc11c \uc0ac\uc6a9\ub428. <\/span>\uc77c\ubc18\uc801\uc73c\ub85c \uc5ec\ub7ec\ubd84\uc740 \ub514\ud3f4\ud2b8 \uc124\uc815 \uac12\uc778 0<\/span>\uc744 \uc0ac\uc6a9\ud558\ub294\ub370, <\/span>\uc774\uac83\uc740 \uc21c\ud658 \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 (circular replication)<\/span>\uc5d0 \uc758\ud55c \ubb34\ud55c \ub8e8\ud504\ub97c \ubc29\uc9c0\ud55c\ub2e4. <\/span>\ub9cc\uc77c 1<\/span>\ub85c \uc124\uc815\ud55c\ub2e4\uba74, <\/span>\uc2ac\ub808\uc774\ube0c\ub294 \uc790\uc2e0\uc758 \uc11c\ubc84 ID<\/span>\ub97c \uac00\uc9c0\uace0 \uc788\ub294 \uc774\ubca4\ud2b8\ub97c \uac74\ub108 \ub744\uc9c0 \uc54a\uac8c \ub41c\ub2e4. 1<\/span>\ub85c \uc124\uc815\ud558\ub294 \uacbd\uc6b0\ub294 \uac70\uc758 \uc5c6\ub2e4. <\/span>\ub9cc\uc57d\uc5d0 --log-slave-updates<\/span><\/code>\uac00 \uc0ac\uc6a9\ub41c\ub2e4\uba74, 1<\/span>\ub85c \uc124\uc815\ud560 \uc218 \uc5c6\uac8c \ub41c\ub2e4. <\/span>\ub514\ud3f4\ud2b8\ub85c, <\/span>\uc2ac\ub808\uc774\ube0c I\/O <\/span>\uc4f0\ub808\ub4dc\ub294 \ubc14\uc774\ub108\ub9ac \ub85c\uadf8 \uc774\ubca4\ud2b8\uac00 \uc2ac\ub808\uc774\ube0c \uc11c\ubc84 ID<\/span>\ub97c \uac00\uc9c0\uace0 \uc788\ub294 \uacbd\uc6b0\uc5d0\ub294 \uadf8\uac83\uc744 \ub9b4\ub808\uc774 \ub85c\uadf8\uc5d0 \uae30\ub85d\uc870\ucc28 \ud558\uc9c0 \uc54a\ub294\ub2e4\ub294 \uac83\uc744 \uc54c\uc544\ub450\uc790 (<\/span>\uc774\uac83\uc740 \ub514\uc2a4\ud06c \uc0ac\uc6a9\ub7c9\uc744 \uc808\uac10\uc2dc\ud0a4\ub294\ub370 \ub3c4\uc6c0\uc774 \ub41c\ub2e4). <\/span>\ub530\ub77c\uc11c, <\/span>--replicate-same-server-id<\/span><\/code>\ub97c \uc0ac\uc6a9\ud558\uace0\uc790 \ud55c\ub2e4\uba74, <\/span>\uc2ac\ub808\uc774\ube0c SQL <\/span>\uc4f0\ub808\ub4dc\uac00 \uc2e4\ud589\ud558\uae38 \uc6d0\ud558\ub294 \uc774\ubca4\ud2b8\ub97c \uc77d\uac8c\ub054 \ub9cc\ub4e4\uae30 \uc804\uc5d0 \uc774 \uc635\uc158\uacfc \ud568\uaed8 \uc2ac\ub808\uc774\ube0c\uac00 \uc2e4\ud589\ub418\ub3c4\ub85d \ud574\uc57c \ud55c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--replicate-wild-do-table=<\/span><\/code>db_name.tbl_name<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\uc5c5\ub370\uc774\ud2b8\ub41c \ubaa8\ub4e0 \ud14c\uc774\ube14\uc774 \uc9c0\uc815 \ub370\uc774\ud130 \ubca0\uc774\uc2a4\uc640 \ud14c\uc774\ube14 \uc774\ub984 \ud328\ud134\uc744 \ub9e4\uce58 (match)<\/span>\ud558\ub294 \uacf3\uc5d0\uc11c\ub294 \uba85\ub839\ubb38 \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uc81c\ud55c\ud558\ub3c4\ub85d \uc2ac\ub808\uc774\ube0c \uc4f0\ub808\ub4dc\uc5d0\uac8c \uc9c0\uc2dc\ud55c\ub2e4. <\/span>\uc774\ub7ec\ud55c \ud328\ud134\uc5d0\ub294 \u2018<\/span>%<\/span><\/b><\/code>\u2019 <\/span>\ubc0f \u2018<\/span>_<\/span><\/b><\/code>\u2019 <\/span>\uc640\uc77c\ub4dc \uce74\ub4dc \ubb38\uc790\uac00 \ud3ec\ud568\ub420 \uc218 \uc788\ub294\ub370, <\/span>\uc774\uac83\ub4e4\uc740 LIKE<\/span><\/b><\/code>\ud328\ud134–<\/span>\ub9e4\uce6d \uc5f0\uc0b0\uc790\uc5d0 \ub300\ud55c \uac83\uacfc \ub3d9\uc77c\ud55c \uc758\ubbf8\ub97c \uac00\uc9c4\ub2e4. <\/span>\ud55c \uac1c \uc774\uc0c1\uc758 \ud14c\uc774\ube14\uc744 \uc9c0\uc815\ud558\uae30 \uc704\ud574\uc11c\ub294, <\/span>\uac01\uac01\uc758 \ud14c\uc774\ube14 \ubcc4\ub85c \ud55c\ubc88\uc529 \uc774 \uc635\uc158\uc744 \uc0ac\uc6a9\ud55c\ub2e4. <\/span>\uc774\uac83\uc740 \ud06c\ub85c\uc2a4–<\/span>\ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc5c5\ub370\uc774\ud2b8\ub97c \uc2e4\ud589\ud55c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\uc608\uc81c: <\/span>--replicate-wild-do-table=foo%.bar%<\/span><\/code>\ub294 \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc774\ub984\uc774 foo<\/span><\/b><\/code>\ub85c \uc2dc\uc791\ub418\uace0 \ud14c\uc774\ube14 \uc774\ub984\uc774bar<\/span><\/b><\/code>\ub85c \uc2dc\uc791\ub418\ub294 \uacf3\uc5d0\uc11c \ud14c\uc774\ube14\uc744 \uc0ac\uc6a9\ud558\ub294 \uc5c5\ub370\uc774\ud2b8\ub9cc\uc744 \ubcf5\uc81c\ud55c\ub2e4<\/p>\n
\n<\/div>\n
\ub9cc\uc77c \ud14c\uc774\ube14 \uc774\ub984 \ud328\ud134\uc774 %<\/span><\/b><\/code>\uc774\ub77c\uba74, <\/span>\ubaa8\ub4e0 \ud14c\uc774\ube14 \uc774\ub984 \ubc0f \ub370\uc774\ud130\ubca0\uc774\uc2a4–<\/span>\ub808\ubca8 \uba85\ub839\ubb38\uc5d0\ub3c4 \uc801\uc6a9\ub418\ub294 \uc635\uc158\ub4e4\uc744 \ub9e4\uce58 (match)<\/span>\ud55c\ub2e4 (<\/span>CREATE DATABASE<\/span><\/b><\/code>, <\/span><\/b>DROP DATABASE<\/span><\/b><\/code>,<\/span><\/b>\uadf8\ub9ac\uace0 ALTER DATABASE<\/span><\/b><\/code>). <\/span>\uc608\ub97c \ub4e4\uba74, <\/span>\ub9cc\uc77c \uc5ec\ub7ec\ubd84\uc774 --replicate-wild-do-table=foo%.%<\/span><\/code>\ub97c \uc0ac\uc6a9\ud55c\ub2e4\uba74, <\/span>\ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc774\ub984\uc774 \ud328\ud134 foo%<\/span><\/b><\/code>\uc640 \ub9e4\uce58\uac00 \ub418\ub294 \uacbd\uc6b0\uc5d0 \ub370\uc774\ud130 \ubca0\uc774\uc2a4–<\/span>\ub808\ubca8 \uba85\ub839\ubb38\uc744 \ubcf5\uc81c\ud55c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\ub370\uc774\ud130 \ubca0\uc774\uc2a4 \ub610\ub294 \ud14c\uc774\ube14 \uc774\ub984 \ud328\ud134\uc5d0 \uc640\uc77c\ub4dc \uce74\ub4dc \ubb38\uc790\ub97c \ud3ec\ud568 \uc2dc\ud0a4\uae30 \uc704\ud574\uc11c\ub294, <\/span>\uadf8 \ubb38\uc790\ub4e4\uc744 \ubc31\uc2ac\ub808\uc2dc (backslash)<\/span>\ub97c \uc0ac\uc6a9\ud574\uc11c \uc81c\uc678 (escape) <\/span>\uc2dc\ud0a8\ub2e4. <\/span>\uc608\ub97c \ub4e4\uba74, <\/span>my_own%db<\/span><\/b><\/code>\ub77c\ub294 \uc774\ub984\uc758 \ub370\uc774\ud130 \ubca0\uc774\uc2a4\uc5d0 \uc788\ub294 \ubaa8\ub4e0 \ud14c\uc774\ube14\uc740 \ubcf5\uc81c\ud558\uc9c0\ub9cc, <\/span>my1ownAABCdb<\/span><\/b><\/code>\ub370\uc774\ud130 \ubca0\uc774\uc2a4\ub85c\ubd80\ud130\ub294 \ud14c\uc774\ube14\uc744 \ubcf5\uc81c\ud558\uace0 \uc2f6\uc9c0 \uc54a\ub2e4\uba74,<\/span>\uc5ec\ub7ec\ubd84\uc740 \u2018<\/span>_<\/span><\/b><\/code>\u2019 <\/span>\uc640 \u2018<\/span>%<\/span><\/b><\/code>\u2019 <\/span>\ubb38\uc790\ub97c \ub2e4\uc74c\uacfc \uac19\uc774 \uc81c\uc678 (escape)<\/span>\uc2dc\ucf1c\uc57c \ud55c\ub2e4: <\/span>--replicate-wild-do-table=my_own%db<\/span><\/code>. <\/span>\ub9cc\uc77c \uc5ec\ub7ec\ubd84\uc774 \uba85\ub839\uc5b4 \ub77c\uc778\uc5d0\uc11c \uc774 \uc635\uc158\uc744 \uc0ac\uc6a9\ud55c\ub2e4\uba74, <\/span>\uc5ec\ub7ec\ubd84\uc774 \uc0ac\uc6a9\ud558\ub294 \uba85\ub839\uc5b4 \ud574\uc11d\uae30\uc5d0 \ub530\ub77c\uc11c \uc778\uc6a9 \ubd80\ud638\ub098 \uc774\uc911 (double) <\/span>\ubc31\uc2ac\ub798\uc2dc\ub97c \uc0ac\uc6a9\ud574\uc11c \uc635\uc158 \uac12\uc744 \uc9c0\uc815\ud574\uc57c \ud55c\ub2e4. <\/span>\uc608\ub97c \ub4e4\uba74,bash<\/strong><\/span>\uc258\uc744 \uc0ac\uc6a9\ud560 \uacbd\uc6b0\uc5d0\ub294, <\/span>--replicate-wild-do-table=my\\_own\\%db<\/span><\/code>\ub77c\uace0 \uc785\ub825\ud574\uc57c \ud55c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--replicate-wild-ignore-table=<\/span><\/code>db_name.tbl_name<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\uc8fc\uc5b4\uc9c4 \uc640\uc77c\ub4dc\uce74\ub4dc \ud328\ud134\uacfc \ud14c\uc774\ube14\uc774 \ud558\ub098\ub77c\ub3c4 \ub9e4\uce58\uac00 \ub418\ub294 \uacf3\uc5d0\uc11c\ub294 \uba85\ub839\ubb38 \ubcf5\uc81c\ub97c \ud558\uc9c0 \ubabb\ud558\ub3c4\ub85d \uc2ac\ub808\uc774\ube0c \uc4f0\ub808\ub4dc\uc5d0\uac8c \uc9c0\uc2dc\ud55c\ub2e4. <\/span>\ud55c \uac1c \uc774\uc0c1\uc758 \ud14c\uc774\ube14\uc744 \ubb34\uc2dc\ud558\ub3c4\ub85d \uc9c0\uc815\ud558\uae30 \uc704\ud574\uc11c\ub294, <\/span>\uac01\uac01\uc758 \ud14c\uc774\ube14 \ubcc4\ub85c \ud55c\ubc88\uc529 \uc774 \uc635\uc158\uc744 \uc0ac\uc6a9\ud55c\ub2e4. <\/span>\uc774\uac83\uc740 \ud06c\ub85c\uc2a4–<\/span>\ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc5c5\ub370\uc774\ud2b8\ub97c \uc2e4\ud589\ud55c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\uc608\uc81c: <\/span>--replicate-wild-ignore-table=foo%.bar%<\/span><\/code>\ub294 \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc774\ub984\uc774 foo<\/span><\/b><\/code>\ub85c \uc2dc\uc791\ub418\uace0 \ud14c\uc774\ube14 \uc774\ub984\uc774 bar<\/span><\/b><\/code>\ub85c \uc2dc\uc791\ub418\ub294 \uacf3\uc5d0\uc11c \ud14c\uc774\ube14\uc744 \uc0ac\uc6a9\ud558\ub294 \uc5c5\ub370\uc774\ud2b8\ub294 \ubcf5\uc81c\ud558\uc9c0 \uc54a\ub294\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\ub9e4\uce6d \uc791\uc5c5\uc774 \uc5b4\ub5bb\uac8c \uc774\ub8e8\uc5b4\uc9c0\ub294\uc9c0\uc5d0 \ub300\ud574\uc11c\ub294, <\/span>--replicate-wild-do-table<\/span><\/code>\uc635\uc158\uc744 \uc124\uba85\ud558\ub294 \ubd80\ubd84\uc744 \ucc38\uace0\ud55c\ub2e4. <\/span>\uc635\uc158 \uac12\uc5d0 \uc640\uc77c\ub4dc\uce74\ub4dc \ubb38\uc790\ub97c \ud3ec\ud568\ud558\uae30 \uc704\ud55c \uaddc\uce59\uc740 --replicate-wild-ignore-table<\/span><\/code>\uc5d0 \uc801\uc6a9\ub418\ub294 \uac83\uacfc \ub3d9\uc77c\ud558\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--report-host=<\/span><\/code>slave_name<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\uc2ac\ub808\uc774\ube0c \ub4f1\ub85d (registration)<\/span>\uc744 \ud558\ub294 \ub3d9\uc548\uc5d0 \ub9c8\uc2a4\ud130\uc5d0 \ubcf4\uace0\ub418\ub294 \uc2ac\ub808\uc774\ube0c \ud638\uc2a4\ud2b8 \uc774\ub984 \ub610\ub294 IP <\/span>\ubc88\ud638.<\/span>\uc774\uac83\uc740 \ub9c8\uc2a4\ud130 \uc11c\ubc84\uc5d0\uc11c SHOW SLAVE HOSTS<\/span><\/b><\/code>\uc2e4\ud589\ud558\uba74 \uc5bb\uc744 \uc218 \uc788\ub2e4. <\/span>\uc2ac\ub808\uc774\ube0c\ub97c \ub9c8\uc2a4\ud130\uc5d0 \ub4f1\ub85d\ud558\uace0 \uc2f6\uc9c0 \uc54a\uc744 \uacbd\uc6b0\uc5d0\ub294 \uc774 \uac12\uc744 \uc124\uc815\ud558\ub294 \uc54a\ub294\ub2e4. <\/span>\uc2ac\ub808\uc774\ube0c \uc811\uc18d \ud6c4\uc5d0 TCP\/IP <\/span>\uc18c\ucf13\uc5d0\uc11c \uc2ac\ub808\uc774\ube0c IP <\/span>\ubc88\ud638\ub97c \ub9c8\uc2a4\ud130\uac00 \ub2e8\uc21c\ud788 \uc77d\ub294 \uac83\uc73c\ub85c\ub294 \ucda9\ubd84\ud558\uc9c0 \ubabb\ud558\ub2e4\ub294 \uc810\uc744 \uc54c\uc544\ub450\uc790. NAT<\/span>\ubc0f \ub2e4\ub978 \ub77c\uc6b0\ud305 (routing) <\/span>\uc774\uc288 \ub54c\ubb38\uc5d0, <\/span>\uadf8 IP<\/span>\ub294 \ub9c8\uc2a4\ud130 \ub610\ub294 \ub2e4\ub978 \ud638\uc2a4\ud2b8\uc5d0\uc11c \uc2ac\ub808\uc774\ube0c\ub85c \uc811\uc18d\uc744 \ud558\uae30 \uc704\ud55c \uc720\ud6a8\ud55c \uac12\uc774 \uc544\ub2d0 \uc218\ub3c4 \uc788\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--report-port=<\/span><\/code>slave_port_num<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\uc2ac\ub808\uc774\ube0c\uac00 \ub4f1\ub85d\ub418\ub294 \ub3d9\uc548\uc5d0 \ub9c8\uc2a4\ud130\uc5d0 \ubcf4\uace0\ub418\ub294 \uc2ac\ub808\uc774\ube0c \uc811\uc18d\uc6a9 TCP\/IP <\/span>\ud3ec\ud2b8 \ubc88\ud638. <\/span>\uc2ac\ub808\uc774\ube0c\uac00 \ub514\ud3f4\ud2b8 \ud3ec\ud2b8\uac00 \uc544\ub2cc \uac83\uc744 \uc8fc\ubaa9 (listen)<\/span>\ud558\uac70\ub098 \ub610\ub294 \uc5ec\ub7ec\ubd84\uc774 \ub9c8\uc2a4\ud130 \uc11c\ubc84 \ub610\ub294 \ub2e4\ub978 \ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0\uc11c \uc2ac\ub808\uc774\ube0c\ub85c \uc811\uc18d\uc744 \ud558\uae30 \uc704\ud55c \ud2b9\ubcc4 \ud130\ub110 (tunnel)<\/span>\uc744 \uac00\uc9c0\uace0 \uc788\ub294 \uacbd\uc6b0\uc5d0\ub9cc \uc774 \uac12\uc744 \uc124\uc815\ud55c\ub2e4. <\/span>\ud655\uc2e0\uc774 \uc5c6\ub2e4\uba74, <\/span>\uc774 \uac12\uc744 \uc124\uc815\ud558\uc9c0 \uc54a\ub3c4\ub85d \ud55c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--skip-slave-start<\/span><\/code><\/p>\n
\n<\/div>\n
\uc11c\ubc84\uac00 \uc2dc\uc791\ub420 \ub54c \uc2ac\ub808\uc774\ube0c \uc4f0\ub808\ub4dc\ub97c \uc2dc\uc791\ud558\uc9c0 \ub9d0\ub3c4\ub85d \uc11c\ubc84\uc5d0\uac8c \uc9c0\uc2dc\ud55c\ub2e4. <\/span>\ub098\uc911\uc5d0 \uc2ac\ub808\uc774\ube0c \uc4f0\ub808\ub4dc\ub97c \uc2dc\uc791\ud558\uae30 \uc704\ud574\uc11c\ub294, <\/span>START SLAVE<\/span><\/b><\/code>\uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud55c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--slave_compressed_protocol={0|1}<\/span><\/code><\/p>\n
\n<\/div>\n
\uc774 \uc635\uc158\uc774 1<\/span>\ub85c \uc124\uc815\ub418\uba74, <\/span>\uc2ac\ub808\uc774\ube0c\/<\/span>\ub9c8\uc2a4\ud130 \ud504\ub85c\ud1a0\ucf5c\uc5d0 \ub300\ud574\uc11c \uc555\ucd95\uc744 \uc0ac\uc6a9\ud55c\ub2e4 (<\/span>\uc591\ucabd \uc11c\ubc84\uac00 \ubaa8\ub450 \uc9c0\uc6d0\uc744 \ud560 \uacbd\uc6b0).<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--slave-load-tmpdir=<\/span><\/code>file_name<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\uc2ac\ub808\uc774\ube0c\uac00 \uc784\uc2dc \ud30c\uc77c\uc744 \ub9cc\ub4dc\ub294 \ub514\ub809\ud1a0\ub9ac\uc758 \uc774\ub984. <\/span>\uc774 \uc635\uc158\uc740 tmpdir<\/span><\/code>\uc2dc\uc2a4\ud15c \ubcc0\uc218 \uac12\uacfc \ub3d9\uc77c\ud55c \uac83\uc744 \ub514\ud3f4\ud2b8\ub85c \uc0ac\uc6a9\ud55c\ub2e4. <\/span>\uc2ac\ub808\uc774\ube0c SQL <\/span>\uc4f0\ub808\ub4dc\uac00 LOAD DATA INFILE<\/span><\/b><\/code>\uba85\ub839\ubb38\uc744 \ubcf5\uc81c\ud560 \ub54c, <\/span>\uc774 \uc4f0\ub808\ub4dc\ub294 \ub9b4\ub808\uc774 \ub85c\uadf8\uc5d0\uc11c \uc77d\uc5b4 \uc640\uc11c \uc784\uc2dc \ud30c\uc77c\uc5d0 \uc800\uc7a5\ud560 \ud30c\uc77c\uc744 \ucd94\ucd9c\ud558\uace0, <\/span>\uadf8 \ud30c\uc77c\uc744 \ud14c\uc774\ube14\uc5d0 \uc804\ub2ec\ud55c\ub2e4. <\/span>\ub9cc\uc77c \ub9c8\uc2a4\ud130\uc5d0 \uc788\ub294 \uadf8 \ud30c\uc77c\uc774 \ub9e4\uc6b0 \ud070 \uac83\uc774\ub77c\uba74, <\/span>\uc2ac\ub808\uc774\ube0c\uc5d0 \uc788\ub294 \uc784\uc2dc \ud30c\uc77c\ub3c4 \uc5ed\uc2dc \ud070 \uac83\uc774 \ub41c\ub2e4. <\/span>\ub530\ub77c\uc11c, <\/span>\uc774 \uc635\uc158\uc740 \ucda9\ubd84\ud55c \uc0ac\uc6a9 \uac00\ub2a5 \uacf5\uac04\uc744 \uac00\uc9c0\uace0 \uc788\ub294 \ud30c\uc77c \uc2dc\uc2a4\ud15c \ub514\ub809\ud1a0\ub9ac\uc5d0 \uc784\uc2dc \ud30c\uc77c\uc744 \uc800\uc7a5\ud558\ub3c4\ub85d \uc2ac\ub808\uc774\ube0c\uc5d0 \uc9c0\uc2dc\ud560 \ub54c \uad8c\uc7a5\ud560 \ub9cc\ud55c \uac83\uc774 \ub41c\ub2e4. <\/span>\uadf8\uc640 \uac19\uc740 \uacbd\uc6b0, <\/span>\ub9b4\ub808\uc774 \ub85c\uadf8 \uc5ed\uc2dc \ud06c\uac8c \ub418\uba70, <\/span>\ub530\ub77c\uc11c \uadf8 \ud30c\uc77c \uc2dc\uc2a4\ud15c\uc5d0 \ub9b4\ub808\uc774 \ub85c\uadf8\ub97c \ub193\uc544\ub450\uae30 \uc704\ud574\uc11c\ub294 --relay-log<\/span><\/code>\uc635\uc158\uc744 \ub610\ud55c \uc0ac\uc6a9\ud560 \ud544\uc694\uac00 \uc788\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\uc774 \uc635\uc158\uc73c\ub85c \uc9c0\uc815\ub41c \ub514\ub809\ud1a0\ub9ac\ub294 \ub514\uc2a4\ud06c \uae30\ubc18\uc758 \ud30c\uc77c \uc2dc\uc2a4\ud15c (<\/span>\uba54\ubaa8\ub9ac \uae30\ubc18\uc774 \uc544\ub2d8)<\/span>\uc5d0 \uc704\uce58\ud574\uc57c \ud558\ub294\ub370,<\/span>\uadf8 \uc774\uc720\ub294 LOAD DATA INFILE<\/span><\/b><\/code>\uc744 \ubcf5\uc81c\ud558\uae30 \uc704\ud55c \uc784\uc2dc \ud30c\uc77c\uc740 \uba38\uc2e0\uc774 \uc7ac \uc2dc\uc791\ub420 \ub54c\uc5d0\ub3c4 \uc874\uc7ac\ud558\uace0 \uc788\uc5b4\uc57c \ud558\uae30 \ub54c\ubb38\uc774\ub2e4. <\/span>\ub610\ud55c, <\/span>\uadf8 \ub514\ub809\ud1a0\ub9ac\ub294 \uc2dc\uc2a4\ud15c \uc2a4\ud0c0\ud2b8\uc5c5 \uacfc\uc815 \uc911\uc5d0 OS<\/span>\uac00 \uc81c\uac70\ud560 \uc218 \uc5c6\ub294 \uac83\uc774 \ub418\uc5b4\uc57c \ud55c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--slave-net-timeout=<\/span><\/code>seconds<\/span><\/i><\/span><\/p>\n
\n<\/div>\n
\uc811\uc18d\uc774 \ub04a\uc5b4\uc84c\uace0, <\/span>\uc77d\uae30\uac00 \uc911\ub2e8 \ub418\uc5c8\uc73c\uba70, <\/span>\ub530\ub77c\uc11c \uc7ac \uc811\uc18d\uc744 \uc2dc\ub3c4\ud574\uc57c \ud55c\ub2e4\uace0 \uc2ac\ub808\uc774\ube0c\uac00 \ud310\ub2e8\uc744 \ud558\uae30 \uc804\uc5d0, <\/span>\ub9c8\uc2a4\ud130\uc5d0\uc11c \uc624\ub294 \ub370\uc774\ud130\ub97c \uae30\ub2e4\ub9ac\ub294 \ub300\uae30 \uc2dc\uac04. <\/span>\uccab \ubc88\uc9f8 \uc7ac \uc811\uc18d\uc740 \uc774 \ud0c0\uc784 \uc544\uc6c3\uc774 \ub05d\ub098\uba74 \uc989\uc2dc \uc2dc\ub3c4\ub41c\ub2e4. <\/span>\uc7ac \uc2dc\ub3c4 \uac04\uaca9 (interval)<\/span>\uc740 --master-connect-retry<\/span><\/code>\uc635\uc158\uc73c\ub85c \uc81c\uc5b4\ud560 \uc218 \uc788\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>--slave-skip-errors=[<\/span><\/code>err_code1<\/span><\/i><\/span>,<\/span><\/code>err_code2<\/span><\/i><\/span>,...|all]<\/span><\/code><\/p>\n
\n<\/div>\n
\uc77c\ubc18\uc801\uc73c\ub85c, <\/span>\uc2ac\ub808\uc774\ube0c\uc5d0\uc11c \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ub418\uba74 \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158\uc740 \uc911\ub2e8\uc774 \ub41c\ub2e4. <\/span>\uc774\ub97c \ud1b5\ud574 \uc5ec\ub7ec\ubd84\uc740 \ub370\uc774\ud130\uc758 \uc77c\uad00\uc131\uc744 \uc218\ub3d9\uc73c\ub85c \ud574\uacb0\ud560 \uc218 \uc788\uac8c \ub41c\ub2e4. <\/span>\uc774 \uc635\uc158\uc740 \uc635\uc158 \uac12\uc5d0 \uc5f4\uac70\ub418\uc5b4 \uc788\ub294 \uc5d0\ub7ec \uc911\uc758 \ud558\ub098\ub97c \uba85\ub839\ubb38\uc774 \ub9ac\ud134 \ud558\ub354\ub77c\ub3c4 \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uacc4\uc18d \uc9c4\ud589\ud558\ub3c4\ub85d \uc2ac\ub808\uc774\ube0c SQL <\/span>\uc4f0\ub808\ub4dc\uc5d0\uac8c \uc9c0\uc2dc\ud55c\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\uc5ec\ub7ec\ubd84\uc774 \uc5d0\ub7ec \ubc1c\uc0dd \uc6d0\uc778\uc5d0 \ub300\ud574 \ucda9\ubd84\ud788 \uc774\ud574\ud558\uace0 \uc788\uc9c0 \uc54a\uc73c\uba74 \uc774 \uc635\uc158\uc744 \uc0ac\uc6a9\ud558\uc9c0 \ub9d0\ub3c4\ub85d \ud55c\ub2e4. <\/span>\ub9cc\uc77c \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc124\uc815\uacfc \ud074\ub77c\uc774\uc5b8\ud2b8 \ud504\ub85c\uadf8\ub7a8\uc5d0 \uc624\ub958\uac00 \uc5c6\uace0 (no bug), MySQL <\/span>\uc790\uccb4\uc5d0\ub3c4 \uc624\ub958\uac00 \uc5c6\ub2e4\uba74, <\/span>\ub9ac\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uc911\ub2e8 \uc2dc\ud0a4\ub294 \uc5d0\ub7ec\ub294 \uacb0\ucf54 \ubc1c\uc0dd\ud558\uc9c0 \uc54a\ub294\ub2e4.<\/span><\/p>\n
\n<\/div>\n
\uc5d0\ub7ec \ucf54\ub4dc\uc5d0 \ub300\ud574\uc11c\ub294, <\/span>\uc2ac\ub808\uc774\ube0c \uc5d0\ub7ec \ub85c\uadf8\uc640 SHOW SLAVE STATUS<\/span><\/b><\/code>\uacb0\uacfc\uc5d0 \ub098\uc640 \uc788\ub294 \uc5d0\ub7ec \uba54\uc2dc\uc9c0 \ubc88\ud638\ub97c \uc0ac\uc6a9\ud55c\ub2e4.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
http:\/\/simonshin.egloos.com\/2247545   \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc2a4\ud0c0\ud2b8\uc5c5 \uc635\uc158\ub4e4 \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \uc5ec\ub7ec\ubd84\uc774 \uc2ac\ub808\uc774\ube0c \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc11c\ubc84\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc635\uc158\ub4e4\uc5d0 \ub300\ud574 \uc124\uba85\ud558\uae30\ub85c \ud55c\ub2e4. \uc774 \uc635\uc158\ub4e4\uc740 \uba85\ub839\uc5b4 \ub77c\uc778 \ub610\ub294 \uc635\uc158 \ud30c\uc77c\uc5d0\uc11c \uc9c0\uc815\ud560 \uc218 \uc788\ub2e4. \ub9c8\uc2a4\ud130\uc640 \uac01 \uc2ac\ub808\uc774\ube0c\uc5d0\uc11c, \uc5ec\ub7ec\ubd84\uc740 \uace0\uc720\uc758 \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 ID\ub97c \uc124\uc815\ud558\uae30 \uc704\ud574\uc11c \ubc18\ub4dc\uc2dc server-id\uc635\uc158\uc744 \uc0ac\uc6a9\ud574\uc57c \ud55c\ub2e4. \uac01 \uc11c\ubc84\uc758 \uacbd\uc6b0, \uc5ec\ub7ec\ubd84\uc740 1 \uc5d0\uc11c 232 \u2013 1 \uc0ac\uc774\uc758 \uc591\uc218 \uc815\uc218 \uc911\uc758 \uace0\uc720 \uac12\uc744 \uc0ac\uc6a9\ud574\uc57c \ud558\uace0 \uac01 ID\ub294 \ubc18\ub4dc\uc2dc \ub2e4\ub978 ID\uc640 \uad6c\ubd84\uc774 \ub418\uc5b4\uc57c \ud55c\ub2e4. \uc608: server-id=3. \ubc14\uc774\ub108\ub9ac \ub85c\uae45\uc744 \uc81c\uc5b4\ud558\uae30 \uc704\ud55c \ub9c8\uc2a4\ud130 \uc635\uc158\ub4e4\uc740 Section\u00a05.12.3, \u201c\ubc14\uc774\ub108\ub9ac \ub85c\uadf8\u201d\uc5d0\uc11c \uc124\uba85\uc744 \ud55c\ub2e4. \uc5b4\ub5a4 \uc2ac\ub808\uc774\ube0c \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc635\uc158\ub4e4\uc740 \uc2ac\ub808\uc774\ube0c\uac00 \uadf8 \uc635\uc158 \uac12\uc744 \uac00\uc9c0\uace0 \uc2dc\uc791\ub420 \ub54c master.info\ud30c\uc77c\uc774 \uc874\uc7ac\ud55c\ub2e4\uba74 \ubb34\uc2dc\uac00 \ub418\ub294 \uac83\uacfc \uac19\uc740 \ud615\ud0dc\ub85c \ud2b9\ubcc4\ud788 \ucde8\uae09\ub418\ub294 \uac83\ub4e4\uc774 \uc788\ub2e4. \uc544\ub798\uc758 \uc635\uc158\ub4e4\uc774 \uc774\ub7f0 \ubc29\uc2dd\uc73c\ub85c \ucc98\ub9ac\ub41c\ub2e4: \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 –master-host \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 –master-user \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 –master-password \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 –master-port \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 –master-connect-retry \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 –master-ssl \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 –master-ssl-ca \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 –master-ssl-capath \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 –master-ssl-cert \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 –master-ssl-cipher \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 –master-ssl-key MySQL 5.0\uc758 master.info\ud30c\uc77c \ud3ec\ub9f7\uc740 SSL \uc635\uc158\uacfc \uc0c1\uc751\ub418\ub294 \uac12\uc744 \uac00\uc9c4\ub2e4. \ub610\ud55c, \uc774 \ud30c\uc77c \ud3ec\ub9f7\uc740 \uc790\uc2e0\uc758 \uccab \ub77c\uc778\uc5d0 \ud30c\uc77c\uc758 \uc804\uccb4 \ub77c\uc778 \uc218\ub97c \uac00\uc9c0\uace0 \uc788\ub2e4. \ub9cc\uc77c \uad6c\ud615 \uc11c\ubc84 (4.1.1 \uc774\uc804 \ubc84\uc804)\ub97c \uc0c8\ub85c\uc6b4 \ubc84\uc804\uc73c\ub85c \uc5c5\uadf8\ub808\uc774\ub4dc \ud55c\ub2e4\uba74,\uc0c8\ub85c\uc6b4 \uc11c\ubc84\ub294 \uc2dc\uc791 \uc2dc\uc810\uc5d0 \uc790\ub3d9\uc73c\ub85c master.info\ud30c\uc77c\uc744 \uc0c8\ub85c\uc6b4 \ud3ec\ub9f7\uc73c\ub85c \uc5c5\uadf8\ub808\uc774\ub4dc \uc2dc\ud0a8\ub2e4. \ud558\uc9c0\ub9cc, \uc0c8 \ubc84\uc804\uc5d0\uc11c \uad6c\ud615 \ubc84\uc804\uc73c\ub85c \ub2e4\uc6b4\uadf8\ub808\uc774\ub4dc\ub97c \ud558\ub294 \uacbd\uc6b0\uc5d0\ub294, \uad6c\ud615 \ubc84\uc804\uc758 \uc11c\ubc84\ub97c \ub9e8 \ucc98\uc74c \uc2dc\uc791\ud558\uae30 \uc804\uc5d0, \uc218\ub3d9\uc73c\ub85c \ucc98\uc74c \ub77c\uc778\uc744 \uc81c\uac70\ud574\uc57c \ud55c\ub2e4. \uc2ac\ub808\uc774\ube0c \uc11c\ubc84\uac00 \uc2dc\uc791\ub420 \ub54c master.info\ud30c\uc77c\uc774 \uc874\uc7ac\ud558\uc9c0 \uc54a\ub294\ub2e4\uba74, \uc2ac\ub808\uc774\ube0c\ub294 \uc635\uc158 \ud30c\uc77c \ub610\ub294 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"ngg_post_thumbnail":0,"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[12,5],"tags":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5q9Zn-d3","jetpack-related-posts":[{"id":803,"url":"https:\/\/blog.box.kr\/?p=803","url_meta":{"origin":809,"position":0},"title":"[scrap]mysqldump \uc635\uc158 \ubc0f \uc0ac\uc6a9\ubc95","date":"2015-05-18","format":false,"excerpt":"http:\/\/egloos.zum.com\/simonshin\/v\/2247509 \u00a0 1. mysqldump \uc635\uc158 \uc911 binary log \uc758 \ud3ec\uc9c0\uc158 \uc815\ubcf4 \uac19\uc774 dump \ud558\uae30 \/usr\/local\/mysql\/bin\/mysqldump -uroot -p --master-data=2\u00a0 > \/data\/\u2026\/backup.sql \uc774 \uba85\ub839\uc5b4 \uc911\uc5d0\uc11c \"--master-data=2\" \uc635\uc158\uc744 \uc8fc\uac8c \ub418\uba74 \ub364\ud504 \uc2dc\uc810\uc758 binary log\uc758 \ud3ec\uc9c0\uc158 \uc815\ubcf4\uac00 \uac19\uc774 Dump \ub418\uac8c \ub41c\ub2e4. Dump\ub41c \ud30c\uc77c\uc744 \uc5d0\ub514\ud130\ub85c \uc5f4\uc5b4\ubcf4\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \ub0b4\uc6a9\uc774 \ub098\uc628\ub2e4. 2. Table Lock \uac78\uae30 FLUSH\u2026","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":807,"url":"https:\/\/blog.box.kr\/?p=807","url_meta":{"origin":809,"position":1},"title":"[scrap] mysql – dual master replication","date":"2015-05-18","format":false,"excerpt":"http:\/\/simonshin.egloos.com\/2247518 \/etc\/my.cnf \ud30c\uc77c \ub0b4\uc6a9 Below is what needs to be added to the configuration for Server A: server-id = 1 replicate-same-server-id = 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/\uc2ac\ub808\uc774\ube0c \uc11c\ubc84\uc5d0\uc11c \uc0ac\uc6a9\ub428. \uc77c\ubc18\uc801\uc73c\ub85c\ub294 \ub514\ud3f4\ud2b8 \uc124\uc815 \uac12\uc778 0\uc744 \uc0ac\uc6a9\ud558\ub294\ub370, \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/\uc774 \uac12\uc740 \uc21c\ud658 \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158(circular replication)\uc5d0 \uc758\ud55c \ubb34\ud55c \ub8e8\ud504\ub97c \ubc29\uc9c0\ud569\ub2c8\ub2e4. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/\uc774 \uac12\uc744 1\ub85c \uc124\uc815\ud55c\ub2e4\uba74, \uc2ac\ub808\uc774\ube0c\ub294 \uc790\uc2e0\uc758 \uc11c\ubc84\u2026","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":61,"url":"https:\/\/blog.box.kr\/?p=61","url_meta":{"origin":809,"position":2},"title":"WebtoB + JEUS + web application","date":"2014-06-12","format":false,"excerpt":"WebtoB + JEUS + web application webgosu.egloos.com\/9123240 1. WebtoB \uc124\uce58 1.1 \uc124\uce58\ud30c\uc77c, \ub77c\uc774\uc13c\uc2a4(license.dat)\uc900\ube44 1.2 \ub77c\uc774\uc13c\uc2a4 \uc801\uc6a9 : webtoB4.1licenselicense.dat 2. WebToB \uc2e4\ud589 2.1 \uc2e4\ud589\ud30c\uc77c\uc0dd\uc131(wsconfig) --> \ud658\uacbd\ud30c\uc77c \ucef4\ud30c\uc77c : wscfl -i [\ud658\uacbd\ud30c\uc77c] 2.2 \uc2e4\ud589 : wsboot --> wsboot -w (handler\uac00 process\ub4e4\uc744 \ud655\uc778\ud558\uba70 booting->\uc548\uc815\uc801\uc778 booting) 2.3 \uc885\ub8cc : wsdown --> wsdown -i (\uc9c8\uc758\ub97c\u2026","rel":"","context":"In "JEUS & WEBToB"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":379,"url":"https:\/\/blog.box.kr\/?p=379","url_meta":{"origin":809,"position":3},"title":"[\ud38c]\ube60\ub974\uac8c \ud6dd\uc5b4 \ubcf4\ub294 node.js","date":"2014-09-15","format":false,"excerpt":"http:\/\/bcho.tistory.com\/889 \ube60\ub974\uac8c \ud6dd\uc5b4 \ubcf4\ub294 node.js - #6 MongoDB \uc5f0\ub3d9 (mongo-native) \ud074\ub77c\uc6b0\ub4dc \ucef4\ud4e8\ud305 & NoSQL\/Vert.x & Node.js\u00a0|\u00a02014\/04\/03 23:49\u00a0|\u00a0Posted by\u00a0\uc870\ub300\ud611 \ube60\ub974\uac8c \ud6dd\uc5b4\ubcf4\ub294\u00a0node.js #6- mongo-native \ubaa8\ub4c8\uc744 \uc774\uc6a9\ud55c MongoDB \uc5f0\ub3d9 \uc870\ub300\ud611\u00a0(http:\/\/bcho.tistory.com Persistence\u00a0\uc5f0\ub3d9 node.js\ub294\u00a0DB\ub098\u00a0NoSQL\ub4f1\uc758 \uc5f0\ub3d9\uc744 \uc9c0\uc6d0\ud558\ub294\ub370,\u00a0\uc774 \uc5ed\uc2dc \ucca0\uc800\ud558\uac8c\u00a0non-blocking io\u00a0\ubc29\uc2dd\uc73c\ub85c \ub3d9\uc791\ud55c\ub2e4.\u00a0\uc989\u00a0db\u00a0\uc5f0\uacb0\u00a0socket\uc744 \uc5f4\uc5b4\uc11c\u00a0query\ub97c \ub358\uc838\ub193\uace0, query\u00a0\uacb0\uacfc\uac00 \uc624\uba74 \uc774\ubca4\ud2b8\ub97c \ubc1b\uc544\uc11c\u00a0callback\u00a0\ud568\uc218\ub85c \ucc98\ub9ac\ud558\ub294 \uc21c\uc11c\uc774\ub2e4. \uadf8\ub7ec\uba74 \uc5ec\uae30\uc11c\ub294 \uba87\uac00\uc9c0\u00a0persistence\u00a0\uc5f0\ub3d9 \ubc29\uc2dd\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\ub3c4\ub85d \ud55c\ub2e4.\u2026","rel":"","context":"In "\ucc38\uace0\ub97c \uc704\ud55c \uc800\uc7a5\ubb3c"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":514,"url":"https:\/\/blog.box.kr\/?p=514","url_meta":{"origin":809,"position":4},"title":"word2Vec.. \uae30\uacc4\ud559\uc2b5\uc758 \ud604\uc2e4\ud654..","date":"2014-12-28","format":false,"excerpt":"\uc694\uc998 \uba38\uc2e0\ub7ec\ub2dd \uc5d0 \ub300\ud574\uc11c \ucacc \ubcf4\uace0 \uc788\ub294\ub370.. \uc2e0\uae30\ud55c \uc54c\uace0\ub9ac\uc998 \ubc1c\uacac.. word2Vec \uc774\ub77c\ub294 \uc54c\uace0\ub9ac\uc998\uc778\ub370.. \u00a0\ub9d0 \uadf8\ub300\ub85c.. \ub2e8\uc5b4\ub4e4\uc744 vector\uc5d0 \ub123\uc5b4\uc11c \uac80\uc0c9\uc5d0 \ud65c\uc6a9\ud55c\ub2e4\ub294 \uc598\uae30\uc774\ub2e4.. \ucc98\uc74c\uc5d0\ub294 \uadf8\ub0e5 \uad6c\ubb38 \ubd84\uc11d\uc5d0 \ubca1\ud130\ub97c \uc368\uc11c \ubb58 \ud55c\ub2e4\ub294 \uac74\uac00?? \ud588\ub294\ub370.. \uadf8\uac8c \uc544\ub2c8\uace0.. \uac01 \ub2e8\uc5b4\ub4e4\uc744 \uc2e0\uacbd\ub9dd \ud559\uc2b5\uc73c\ub85c \ube44\uc2b7\ud55c \ub2e8\uc5b4\ub07c\ub9ac \ubca1\ud130 \uac70\ub9ac \u00a0( vector distance )\ub77c\ub294 \uc218\ud559 \uac12\uc744 \uc774\uc6a9\ud558\uc5ec \ube44\uc2b7\ud55c \ub2e8\uc5b4\u2026","rel":"","context":"In "\uae30\uc220\uc790\ub8cc"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":855,"url":"https:\/\/blog.box.kr\/?p=855","url_meta":{"origin":809,"position":5},"title":"[scrap][AngularJS] AngularJS \uc640 RequireJS \ub97c \ud65c\uc6a9\ud55c \ub300\uaddc\ubaa8 \uc6f9 \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158 \uac1c\ubc1c","date":"2015-05-20","format":false,"excerpt":"http:\/\/programmingsummaries.tistory.com\/m\/post\/229 \u00a0 AngularJS \uae30\ubc18 \uc6f9 \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158, \uc5b4\ub514\uc11c\ubd80\ud130 \uc2dc\uc791\ud574\uc57c \ud560\uae4c? AngularJS\ub97c \uae30\ubc18\uc73c\ub85c \uc6f9 \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uac1c\ubc1c\ud560 \ub54c, AngularJS \uc0ac\uc774\ud2b8\uc5d0\uc11c \uc81c\uacf5\ud574\uc8fc\ub294 \ubb38\uc11c\ub4e4\uc740 \ud2b9\uc815 API \ud65c\uc6a9 \ubc29\ubc95\uc744 \uc774\ud574\ud558\uac70\ub098 \ub2e8\uc21c\ud55c \uc218\uc900\uc73c\ub85c \uc2dc\uc791\ud558\uae30\uc5d0\ub294 \uc801\ud569\ud558\uc9c0\ub9cc \uc5b4\ub5bb\uac8c \uc218\ubc31\uc5d0\uc11c \uc218\ucc9c\uc904\uc5d0 \uc774\ub974\ub294 \ucf54\ub4dc\ub85c \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uad6c\uc131\ud558\uace0 \ubc1c\uc804\uc2dc\ucf1c\uc57c\ud558\ub294\uc9c0\uc5d0 \ub300\ud574\uc11c\ub294 \uba85\ud655\ud55c \uac00\uc774\ub4dc\ub77c\uc778\uc744 \uc81c\uacf5\ud574\uc8fc\uace0 \uc788\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. AngularJS\ub97c \uae30\ubc18\uc73c\ub85c \uc218\ucc28\ub840\uc758 \ud06c\uace0 \uc791\uc740 \uac1c\ubc1c\uc744 \uc9c4\ud589\ud558\uba70 \uc5bb\uc740\u2026","rel":"","context":"In "\uae30\uc220"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/809"}],"collection":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=809"}],"version-history":[{"count":0,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/809\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=809"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=809"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=809"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}