{"id":807,"date":"2015-05-18T15:56:29","date_gmt":"2015-05-19T00:56:29","guid":{"rendered":"http:\/\/blog.box.kr\/?p=807"},"modified":"2015-05-18T15:56:29","modified_gmt":"2015-05-19T00:56:29","slug":"scrap-mysql-dual-master-replication","status":"publish","type":"post","link":"https:\/\/blog.box.kr\/?p=807","title":{"rendered":"[scrap] mysql &#8211; dual master replication"},"content":{"rendered":"<p><a href=\"http:\/\/simonshin.egloos.com\/2247518\">http:\/\/simonshin.egloos.com\/2247518<\/a><\/p>\n<ul>\n<li><strong>\/etc\/my.cnf \ud30c\uc77c \ub0b4\uc6a9<\/strong><\/li>\n<\/ul>\n<p>Below is what needs to be added to the configuration for <b>Server A<\/b>:<\/p>\n<div>\n<p>server-id = 1<br \/>\nreplicate-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,\n<\/div>\n<div>\n<p>\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.\n<\/p><\/div>\n<div>\n<p>\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 ID\ub97c \uac00\uc9c0\uace0 \uc788\ub294 \uc774\ubca4\ud2b8\ub97c \uac74\ub108 \ub744\uc9c0 \uc54a\uac8c \ub429\ub2c8\ub2e4.<br \/>\nauto-increment-increment = 2\n<\/div>\n<div>\n<p>auto-increment-offset = 1<\/p>\n<p>master-host = &lt;IP address of Server B&gt;<br \/>\nmaster-user = &lt;slave user&gt;<br \/>\nmaster-password = &lt;slave password&gt;<br \/>\nmaster-connect-retry = 60<br \/>\nreplicate-do-db = &lt;database name&gt;<\/p>\n<p>log-bin = C:mysqlloglog-bin.log\u00a0 \/\/ \uc2dc\uc2a4\ud15c\uc5d0 \ub9de\ub3c4\ub85d binlog\uac00 \uc313\uc774\uac8c \ub420 \uc704\uce58\ub97c \uc815\ud574 \uc900\ub2e4.\n<\/p><\/div>\n<div>\n<p>binlog-do-db = &lt;database name&gt;\n<\/p><\/div>\n<p>&nbsp;<\/p>\n<p>Below is what needs to be added to the configuration for <b>Server B<\/b>:<\/p>\n<div>\n<p>server-id = 2<br \/>\nreplicate-same-server-id = 0<br \/>\nauto-increment-increment = 2<br \/>\nauto-increment-offset = 2<\/p>\n<p>master-host = &lt;IP address of Server A&gt;<br \/>\nmaster-user = &lt;slave user&gt;<br \/>\nmaster-password = &lt;slave password&gt;<br \/>\nmaster-connect-retry = 60<br \/>\nreplicate-do-db = &lt;database name&gt;<\/p>\n<p>log-bin= C:mysqlloglog-bin.log # change this to a path\/name appropriate to your system<br \/>\nbinlog-do-db = &lt;database name&gt;\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<p>\uba40\ud2f0 \ub9c8\uc2a4\ud130\ub85c \uc11c\ube44\uc2a4\ub97c \uc6b4\uc601\ud558\ub2e4 \ubcf4\uba74 \ub73b\ud558\uc9c0 \uc54a\uac8c pk \uc911\ubcf5\uc774 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0\uac00 \uc788\ub2e4.<\/p>\n<p>\uc774\ub7ec\ud55c \uacbd\uc6b0\ub294 M1\uc5d0\uc11c write\ubaa8\ub4dc\ub97c \uc6b4\uc601\uc911\uc774\ub2e4\uac00 \uc7a5\uc560\uac00 \ubc1c\uc0dd\ud574 M2\ub85c write\ubaa8\ub4dc\uac00 \uc774\uc591\ub418\uc5c8\ub294\ub370 replication\uc774 \ubaa8\ub450 M2\ub85c \uc62e\uaca8\uc9c0\uc9c0 \uc54a\uc740 \uc0c1\ud0dc\uc5d0\uc11c \ub2e4\uc2dc M2\uc5d0 write operation\uc774 \ub4e4\uc5b4\uc640\uc11c \ubc1c\uc0dd\ub418\ub294 \uacbd\uc6b0\uc774\ub2e4.<\/p>\n<ul>\n<li>\u00a0<a title=\"[Dual Master Rep]Multi master replication\uc744 \uc704\ud55c auto-increment \uc124\uc815\"><strong>[Dual Master Rep]Multi master replication\uc744 \uc704\ud55c auto-increment \uc124\uc815<\/strong><\/a><\/li>\n<\/ul>\n<p>\uc774\uac19\uc740 \uc0c1\ud669\uc744 \ud53c\ud574\uac00\uae30 \uc704\ud574\uc11c Mysql 5.X\ubc84\uc804\uc5d0\uc11c\ub294<\/p>\n<p>auto_increment_increment<\/p>\n<p>auto_increment_offset<\/p>\n<p>\uc774\ub780 \ud30c\ub77c\ubbf8\ud130\uac00 \ucd94\uac00\ub418\uc5c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>auto_increment_increment=2 \ub85c \uc124\uc815\ud55c\ub2e4\ub294 \uac83\uc758 \uc758\ubbf8\ub294 \ud574\ub2f9 db server\uc5d0\uc11c\uc758 auto\uceec\ub7fc\uc740 2\ub2e8\uc704\ub85c \uc99d\uac00\ud55c\ub2e4\ub294 \uac83\uc774\ub2e4.<\/p>\n<p>\uc608\ub97c \ub4e4\uba741, 3, 5..\uc640 \uac19\uc774<\/p>\n<p>&nbsp;<\/p>\n<p>\uc5ec\uae30\uc5d0 auto_increment_offset=5\ub85c \uc9c0\uc815\ud558\uba74<\/p>\n<p>\uc2dc\uc791\uc810\uc774 5\ubd80\ud130 \uc9c0\uc815\ub41c\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>\ub54c\ubb38\uc5d0 \ub4c0\uc5bc\ub9c8\uc2a4\ud130 \uad6c\uc870\ub97c \uac00\uc9c4\ub2e4\uba74<\/p>\n<p><strong>M1\uc5d0\uc11c<\/strong><\/p>\n<p><strong>auto_increment_increment=2<\/strong><\/p>\n<p><strong>auto_increment_offset=1<\/strong><\/p>\n<p><strong>\ub85c \uc124\uc815\ud558\uba74<\/strong><\/p>\n<p><strong>pk\ub294 1,3,5,7,9\ub85c \uc99d\uac00\ud558\uace0<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>M2\uc5d0\uc11c<\/strong><\/p>\n<p><strong>auto_increment_increment=2<\/strong><\/p>\n<p><strong>auto_increment_offset=2<\/strong><\/p>\n<p><strong>\ub85c \uc124\uc815\ud558\uba74<\/strong><\/p>\n<p><strong>pk\ub294 2,4,6,8,10\uacfc \uac19\uc740 \uc21c\uc11c\ub85c \uc99d\uac00\ud558\uac8c \ub41c\ub2e4<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<p>\ub54c\ubb38\uc5d0 \uc774\uacbd\uc6b0 \uac01\uc11c\ubc84\uc5d0\uc11c \ubc1c\uae09\ub418\ub294 pk\uac00 \uc911\ubcf5\ub418\uc9c0 \uc54a\uac8c \ub41c\ub2e4.<\/p>\n<\/div>\n<div>\n<\/div>\n<div class=\"posttaglist\"><a href=\"http:\/\/simonshin.egloos.com\/tag\/dual-master-replication\" rel=\"tag\">dual-master-replication<\/a>,\u00a0<a href=\"http:\/\/simonshin.egloos.com\/tag\/mysql-replication\" rel=\"tag\">mysql-replication<\/a>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>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 ID\ub97c \uac00\uc9c0\uace0 \uc788\ub294 \uc774\ubca4\ud2b8\ub97c \uac74\ub108 \ub744\uc9c0 \uc54a\uac8c \ub429\ub2c8\ub2e4. auto-increment-increment = 2 auto-increment-offset = 1 master-host = &lt;IP address of Server B&gt; master-user = &lt;slave user&gt; master-password = &lt;slave password&gt; master-connect-retry = 60 replicate-do-db = &lt;database name&gt; log-bin = C:mysqlloglog-bin.log\u00a0 \/\/ \uc2dc\uc2a4\ud15c\uc5d0 \ub9de\ub3c4\ub85d binlog\uac00 \uc313\uc774\uac8c \ub420 \uc704\uce58\ub97c \uc815\ud574 \uc900\ub2e4. binlog-do-db = &lt;database name&gt; &nbsp; Below is what needs to be added to the configuration for Server B: server-id = 2 replicate-same-server-id = 0 auto-increment-increment = 2 auto-increment-offset = 2 master-host = &lt;IP address of Server A&gt; master-user = &lt;slave user&gt; master-password = &lt;slave password&gt; master-connect-retry = 60 replicate-do-db = &lt;database name&gt; log-bin= C:mysqlloglog-bin.log # change this to a path\/name appropriate to your system binlog-do-db = &lt;database name&gt; \uba40\ud2f0 \ub9c8\uc2a4\ud130\ub85c \uc11c\ube44\uc2a4\ub97c \uc6b4\uc601\ud558\ub2e4 \ubcf4\uba74 \ub73b\ud558\uc9c0 \uc54a\uac8c pk \uc911\ubcf5\uc774 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0\uac00 \uc788\ub2e4. \uc774\ub7ec\ud55c \uacbd\uc6b0\ub294 M1\uc5d0\uc11c write\ubaa8\ub4dc\ub97c \uc6b4\uc601\uc911\uc774\ub2e4\uac00 \uc7a5\uc560\uac00 \ubc1c\uc0dd\ud574 M2\ub85c write\ubaa8\ub4dc\uac00 \uc774\uc591\ub418\uc5c8\ub294\ub370 replication\uc774 \ubaa8\ub450 M2\ub85c \uc62e\uaca8\uc9c0\uc9c0 \uc54a\uc740 \uc0c1\ud0dc\uc5d0\uc11c \ub2e4\uc2dc M2\uc5d0 write operation\uc774 \ub4e4\uc5b4\uc640\uc11c \ubc1c\uc0dd\ub418\ub294 [&hellip;]<\/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-d1","jetpack-related-posts":[{"id":809,"url":"https:\/\/blog.box.kr\/?p=809","url_meta":{"origin":807,"position":0},"title":"[scrap] Replication Startup Options","date":"2015-05-18","format":false,"excerpt":"http:\/\/simonshin.egloos.com\/2247545 \u00a0 \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\u2026","rel":"","context":"In &quot;DB\uad00\ub828&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":801,"url":"https:\/\/blog.box.kr\/?p=801","url_meta":{"origin":807,"position":1},"title":"[scrap] MySQL Replication \uc124\uc815\uacfc \uba87 \uac00\uc9c0 \ud14c\uc2a4\ud2b8","date":"2015-05-18","format":false,"excerpt":"http:\/\/blog.hibrainapps.net\/130 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 MySQL\uc744 DB\ub85c \uc0ac\uc6a9\ud558\uba74\uc11c \uc11c\ubc84\uc758 \ubd80\ud558 \ubd84\uc0b0\uc744 \uc704\ud55c \ubc29\ubc95 \uc911 \ud558\ub098\ub85c Replication \uc744 \uc0ac\uc6a9\ud55c\ub2e4. Replication \uc740 Master \ud558\ub098\uc5d0 n\uac1c\uc758 Slave\ub85c \uc9c0\uc815\uc774 \uac00\ub2a5\ud558\ub2e4. Slave\ub294 \ub2e4\uc2dc Master \uc5ed\ud560\uc744 \ud560\uc218 \uc788\uc73c\uba70 \uc5ed\uc2dc \ub610 \ub2e4\ub978 n\uac1c\uc758 Slave\ub97c \uc9c0\uc815\ud560 \uc218 \uc788\ub2e4. \ubd80\ud558 \ubd84\uc0b0\uc758 \ud6a8\uacfc\ub294 inser,update \ub4f1 \ubcc0\uacbd\uacfc \uad00\ub828\ub41c \ubaa8\ub4e0 \uc791\uc5c5\uc740\u2026","rel":"","context":"In &quot;DB\uad00\ub828&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":720,"url":"https:\/\/blog.box.kr\/?p=720","url_meta":{"origin":807,"position":2},"title":"[\ud38c]Java \uc5d0\uc11c DataBase Replication Master\/Slave (write\/read) \ubd84\uae30 \ucc98\ub9ac\ud558\uae30","date":"2015-04-15","format":false,"excerpt":"http:\/\/kwon37xi.egloos.com\/ \ub300\uaddc\ubaa8 \uc11c\ube44\uc2a4 \uac1c\ubc1c\uc2dc\uc5d0 \uac00\uc7a5 \uae30\ubcf8\uc801\uc73c\ub85c \ud558\ub294 \ud29c\ub2dd\uc740 \ubc14\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c Write\uc640 Read DB\ub97c Replication(\ub9ac\ud50c\ub9ac\ucf00\uc774\uc158)\ud558\uace0 \uc4f0\uae30 \uc791\uc5c5\uc740 Master(Write)\ub85c \ubcf4\ub0b4\uace0 \uc77d\uae30 \uc791\uc5c5\uc740 Slave(Read)\ub85c \ubcf4\ub0b4\uc5b4 \ubd80\ud558\ub97c \ubd84\uc0b0 \uc2dc\ud0a4\ub294 \uac83\uc774\ub2e4. \ud2b9\ud788 \ub300\ubd80\ubd84\uc758 \uc11c\ube44\uc2a4\ub294 \uc77d\uae30\uac00 \uc555\ub3c4\uc801\uc73c\ub85c \ub9ce\uae30 \ub54c\ubb38\uc5d0\u00a0 Slave\ub294 \uc5ec\ub7ec \ub300\ub97c \ub450\uc5b4 \uc77d\uae30 \ubd80\ud558\ub97c \ubd84\uc0b0 \uc2dc\ud0a8\ub2e4. \uadf8\ub7f0\ub370 \ub610 \ud558\ub098 \uae30\uc5b5\ud574\uc57c \ud560 \uac83\uc774 Replication\uc740 \ube44\ub85d \uc9e7\ub354\ub77c\ub3c4\u2026","rel":"","context":"In &quot;JAVA&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":590,"url":"https:\/\/blog.box.kr\/?p=590","url_meta":{"origin":807,"position":3},"title":"[\ud38c]Java \uc5d0\uc11c DataBase Replication Master\/Slave (write\/read) \ubd84\uae30 \ucc98\ub9ac\ud558\uae30 \ud504\ub85c\uadf8\ub798\ubc0d","date":"2015-01-30","format":false,"excerpt":"Cloud\ud658\uacbd\uc5d0\uc11c DB\ub97c \uc0ac\uc6a9\ud558\ub2e4\ubcf4\ub2c8 Disk I\/O\ub098 \ub108\ubb34 \ub290\ub824\uc11c \ub9ce\uc740 \uace0\ubbfc\uc744 \ud558\uac8c \ub410\ub2e4. \uc77c\ub2e8 \uc0dd\uac01\ub098\ub294\uac83\uc774 \ub9ce\uc774 \ub4e4 \ud558\ub294 Replication\uc744 \uc774\uc6a9\ud55c \ubd80\ud558\ubd84\uc0b0 ( Master\ub294 Insert\/Update\ub9cc, Slave\ub294 SELECT\ub9cc ) \uadf8\ub7f0\ub370 \ub9c9\uc0c1 \ud560\ub824\uba74 \uc774\uac83 \uc800\uac83 \uc190\uc774 \ub9ce\uc774 \uac04\ub2e4.. \uadf8\ub798\uc11c.. \uc0dd\uac01\ub9cc \ud558\uace0 \uc801\uc6a9\uc744 \uc548\ud588\uc5c8\ub294\ub370.. \u00a0 \uc6f9\uc11c\ud551\uc744 \ud558\ub2e4\uac00 \uc774\ub7f0 \uae00\uc744 \ubc1c\uacac.. \uc544!! \uc774\ub807\uac8c \uc88b\uc744 \uc218\uac00.. \u00a0 \uc5ed\uc2dc\u2026","rel":"","context":"In &quot;JAVA&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":803,"url":"https:\/\/blog.box.kr\/?p=803","url_meta":{"origin":807,"position":4},"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 &quot;DB\uad00\ub828&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":687,"url":"https:\/\/blog.box.kr\/?p=687","url_meta":{"origin":807,"position":5},"title":"[\ud38c]MariaDB \uc124\uc815 \ud30c\uc77c my.cnf","date":"2015-04-13","format":false,"excerpt":"http:\/\/www.programkr.com\/blog\/MUDM5ADMwYT2.html \u00a0 \u00a0 # MariaDB database server configuration file. # # You can copy this file to one of: # - \"\/etc\/mysql\/my.cnf\" to set global options, # - \"~\/.my.cnf\" to set user-specific options. # # One can use all long options that the program supports. # Run program with --help\u2026","rel":"","context":"In &quot;\uae30\uc220\uc790\ub8cc&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/807"}],"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=807"}],"version-history":[{"count":0,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/807\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=807"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=807"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}