{"id":1459,"date":"2026-05-13T23:14:02","date_gmt":"2026-05-13T14:14:02","guid":{"rendered":"http:\/\/www.igoni.kr\/?p=1459"},"modified":"2026-05-13T23:14:02","modified_gmt":"2026-05-13T14:14:02","slug":"mysql-%eb%a6%ac%ed%94%8c%eb%a6%ac%ec%bc%80%ec%9d%b4%ec%85%98-uuid%ec%98%a4%eb%a5%98%eb%ac%b8%ec%a0%9c","status":"publish","type":"post","link":"http:\/\/www.igoni.kr\/?p=1459","title":{"rendered":"mysql \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 UUID\uc624\ub958\ubb38\uc81c"},"content":{"rendered":"<p>\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. DB\uc7a5\uc560 \uc870\uce58\uacfc\uc815\uc911 \ub17c\ub9ac\uc801\uc778 \ubb38\uc81c\ub85c DBMS\ub0b4\ubd80\uc5d0\uc11c \ud574\uc18c\uac00 \uc548\ub420\ub54c \uc11c\ubc84\uae30\uc900\uc5d0\uc11c \uc791\uc5c5\uc744 \ud560 \uc218 \uc788\uc744\uac83 \uac19\uc544\uc694.<\/p>\n<p id=\"bkmrk-mysql-%ED%86%B5%EC%A7%B8%EB%A1%9C-%EB%B3%B5%EC%82%AC%ED%95%9C-%EC%9D%B4%ED%9B%84%EC%97%90-%EB%A6%AC%ED%94%8C\">mysql \ud1b5\uc9f8\ub85c \ubcf5\uc0ac\ud55c \uc774\ud6c4\uc5d0 \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uad6c\uc131\ud560\ub54c slave status\ud655\uc778\ud558\uba74 UUID\uad00\ub828\ub41c \uc624\ub958\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\" border=\"1\">\n<colgroup>\n<col style=\"width: 99.881%;\" \/><\/colgroup>\n<tbody>\n<tr>\n<td><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1461\" src=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/50c2a41f-5624-40c6-84c9-18184d706192.png\" alt=\"\" width=\"1032\" height=\"576\" srcset=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/50c2a41f-5624-40c6-84c9-18184d706192.png 1032w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/50c2a41f-5624-40c6-84c9-18184d706192-300x167.png 300w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/50c2a41f-5624-40c6-84c9-18184d706192-1024x572.png 1024w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/50c2a41f-5624-40c6-84c9-18184d706192-768x429.png 768w\" sizes=\"auto, (max-width: 1032px) 100vw, 1032px\" \/><\/td>\n<\/tr>\n<tr>\n<td class=\"align-right\">perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<pre id=\"bkmrk-mysql%3E-show-slave-st\"><code class=\"language-SQL\">mysql&gt; show slave status \\G;\r\n*************************** 1. row ***************************\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Slave_IO_State:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_Host: 192.168.0.130\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_User: repl\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_Port: 3306\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Connect_Retry: 60\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_Log_File: mysql-bin.000005\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Read_Master_Log_Pos: 502\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Relay_Log_File: localhost-relay-bin.000001\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Relay_Log_Pos: 4\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Relay_Master_Log_File: mysql-bin.000005\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Slave_IO_Running: No\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Slave_SQL_Running: Yes\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Replicate_Do_DB:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Replicate_Ignore_DB:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Replicate_Do_Table:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Replicate_Ignore_Table:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Replicate_Wild_Do_Table:\r\n\u00a0\u00a0Replicate_Wild_Ignore_Table:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Last_Errno: 0\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Last_Error:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Skip_Counter: 0\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Exec_Master_Log_Pos: 502\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Relay_Log_Space: 120\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Until_Condition: None\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Until_Log_File:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Until_Log_Pos: 0\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_SSL_Allowed: No\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_SSL_CA_File:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_SSL_CA_Path:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_SSL_Cert:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_SSL_Cipher:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_SSL_Key:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Seconds_Behind_Master: NULL\r\nMaster_SSL_Verify_Server_Cert: No\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Last_IO_Errno: 1593\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Last_IO_Error: Fatal error: The slave I\/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work.\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Last_SQL_Errno: 0\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Last_SQL_Error:\r\n\u00a0\u00a0Replicate_Ignore_Server_Ids:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_Server_Id: 1\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_UUID:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_Info_File: \/usr\/local\/mysql\/var\/master.info\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SQL_Delay: 0\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SQL_Remaining_Delay: NULL\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I\/O thread to update it\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_Retry_Count: 86400\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_Bind:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Last_IO_Error_Timestamp: 160409 23:55:09\r\n\u00a0\u00a0\u00a0\u00a0\u00a0Last_SQL_Error_Timestamp:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_SSL_Crl:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_SSL_Crlpath:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Retrieved_Gtid_Set:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Executed_Gtid_Set:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Auto_Position: 0\r\n1 row in set (0.00 sec)\r\n\r\nERROR:\r\nNo query specified<\/code><\/pre>\n<p id=\"bkmrk-master%2C-slave-%EA%B0%81-%EC%84%9C%EB%B2%84-u\">master, slave \uac01 \uc11c\ubc84 UUID\uac12\uc774 \uc911\ubcf5\ub418\uba74 \ub370\uc774\ud130 \ub3d9\uae30\ud654\uac00 \uc2e4\ud328\ud569\ub2c8\ub2e4.<br \/>\n\uc591\ucabd \uc11c\ubc84\ubaa8\ub450 uuid \uac12\uc744 \ud655\uc778\ud574\ubcf4\uba74\u00a0Value\uac12\uc774 \ub3d9\uc77c\ud55c\ub370\uc694.<br \/>\n\uc5ec\uae30 \ud574\uacb0\ucc45\uc740 auto.cnf\ud30c\uc77c\uc744 \uc0ad\uc81c\ud558\uace0 mysql \uc7ac\uc2dc\uc791\ud574\uc8fc\uba74 \ub429\ub2c8\ub2e4. auto.cnf\ud30c\uc77c\uc740 \ubcf4\ud1b5 \ub370\uc774\ud130\ub514\ub809\ud1a0\ub9ac\uc5d0 \uc800\uc7a5\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<pre id=\"bkmrk-mysql%3E-show-variable\"><code class=\"language-SQL\">mysql&gt; show variables like '%uuid%';\r\n+---------------+--------------------------------------+\r\n| Variable_name | Value \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|\r\n+---------------+--------------------------------------+\r\n| server_uuid \u00a0\u00a0| 90af1fbb-fe5e-11e5-883a-0050569b3781 |\r\n+---------------+--------------------------------------+\r\n1 row in set (0.00 sec)<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. DB\uc7a5\uc560 \uc870\uce58\uacfc\uc815\uc911 \ub17c\ub9ac\uc801\uc778 \ubb38\uc81c\ub85c DBMS\ub0b4\ubd80\uc5d0\uc11c \ud574\uc18c\uac00 \uc548\ub420\ub54c \uc11c\ubc84\uae30\uc900\uc5d0\uc11c \uc791\uc5c5\uc744 \ud560 \uc218 \uc788\uc744\uac83 \uac19\uc544\uc694.&hellip;<\/p>\n","protected":false},"author":1,"featured_media":1461,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[381],"tags":[383,411],"class_list":["post-1459","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysqlmariadb","tag-mysql","tag-uuid"],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1459","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1459"}],"version-history":[{"count":1,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1459\/revisions"}],"predecessor-version":[{"id":1463,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1459\/revisions\/1463"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/media\/1461"}],"wp:attachment":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1459"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1459"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1459"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}