{"id":1489,"date":"2026-05-13T23:25:38","date_gmt":"2026-05-13T14:25:38","guid":{"rendered":"http:\/\/www.igoni.kr\/?p=1489"},"modified":"2026-05-13T23:26:16","modified_gmt":"2026-05-13T14:26:16","slug":"mysql-replication-%ec%84%a4%ec%a0%95","status":"publish","type":"post","link":"http:\/\/www.igoni.kr\/?p=1489","title":{"rendered":"mysql replication \uc124\uc815"},"content":{"rendered":"

\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8\uc785\ub2c8\ub2e4. Mysql \ub370\uc774\ud130\ubcf5\uc824\ub974 \uc704\ud55c\u00a0 replication \uc124\uc815\uc808\ucc28\uc5d0 \ub300\ud574 \uc5c5\ub370\uc774\ud2b8 \ud588\uc2b5\ub2c8\ub2c8\ub2e4.<\/p>\n\n\n<\/colgroup>\n\n\n\n
\"\"<\/td>\n<\/tr>\n
perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    \n
  1. 5.5\ubd80\ud130\ub294 innodb\ub97c \uae30\ubcf8\uc5d4\uc9c4\uc73c\ub85c \uc0ac\uc6a9\ud558\uae30 \ub54c\ubb38\uc5d0, Myisam\uc744 \uc0ac\uc6a9\ud560 \uacbd\uc6b0, \ud14c\uc774\ube14 \uad6c\uc131\uc2dc \uc5d4\uc9c4\ud0c0\uc785\uc744 \ub530\ub85c \uae30\uc7ac\ud574 \uc8fc\uc5b4\uc57c \ud568.<\/li>\n<\/ol>\n
      \n
    • \n
        \n
      • Master1 : 192.168.20.11<\/li>\n
      • Master2 : 192.168.20.12<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
          \n
        1. Mysql replication \uad6c\uc131\ud558\uae30(Dual Master)<\/li>\n
        2. Master1 my.cnf\ud30c\uc77c \uc218\uc815\n
            \n
          1. \/etc\/my.cnf\ud30c\uc77c\uc5d0 \ud574\ub2f9 \ub0b4\uc6a9 \ucd94\uac00\ud558\uae30\n
            $> vi \/etc\/my.cnf\r\nserver-id\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0= 1\r\nbinlog-do-db=wordpress (\ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc0ac\uc6a9\ud560 DB\uba85, \uc5ec\ub7ec\uac1c\uc758 DB\uc77c \uacbd\uc6b0, \ud55c\uce78\uc529 \ub744\uc6b0\uba74 \ub428. wordpress mysql, \uc804\uccb4 DB\ub97c \ubcf5\uc81c\ud560\uacbd\uc6b0\uc5d4\ub294 \ub530\ub85c \uc124\uc815\ud558\uc9c0\uc54a\uc544\ub3c4 \ub428)<\/code><\/pre>\n<\/li>\n<\/ol>\n<\/li>\n
          2. Master2\u00a0\/etc\/my.cnf\ud30c\uc77c\uc5d0 \ub0b4\uc6a9 \ubcc0\uacbd\n
            $> vi \/etc\/my.cnf\r\nserver-id\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0= 2\r\nbinlog-do-db=wordpress<\/code><\/pre>\n<\/li>\n
          3. Master1\uc5d0 master \ud50c\ub7ec\uadf8\uc778 \uc124\uce58 \ubc0f \ud65c\uc131\ud654\n
            mysql>\u00a0INSTALL\u00a0PLUGIN\u00a0rpl_semi_sync_master\u00a0SONAME\u00a0'semisync_master.so';\r\nQuery\u00a0OK,\u00a00\u00a0rows\u00a0affected\u00a0(0.00\u00a0sec)\r\nmysql>\u00a0set\u00a0global\u00a0rpl_semi_sync_master_enabled=1;\r\nQuery\u00a0OK,\u00a00\u00a0rows\u00a0affected\u00a0(0.00\u00a0sec)\r\nmysql>\u00a0set\u00a0global\u00a0rpl_semi_sync_master_timeout\u00a0=1000;\r\nQuery\u00a0OK,\u00a00\u00a0rows\u00a0affected\u00a0(0.00\u00a0sec)\r\nmysql>\u00a0show\u00a0variables\u00a0like\u00a0'rpl_semi_sync%';\r\n+~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-+~-~-~-~-~-~--+\r\n|\u00a0Variable_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0Value\u00a0|\r\n+~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-+~-~-~-~-~-~--+\r\n|\u00a0rpl_semi_sync_master_enabled\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0ON\u00a0\u00a0\u00a0\u00a0|\r\n|\u00a0rpl_semi_sync_master_timeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a01000\u00a0\u00a0|\r\n|\u00a0rpl_semi_sync_master_trace_level\u00a0\u00a0\u00a0|\u00a032\u00a0\u00a0\u00a0\u00a0|\r\n|\u00a0rpl_semi_sync_master_wait_no_slave\u00a0|\u00a0ON\u00a0\u00a0\u00a0\u00a0|\r\n+~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-+~-~-~-~-~-~--+<\/code><\/pre>\n<\/li>\n
          4. Master2\uc11c\ubc84\uc5d0\uc11c \ucffc\ub9ac \uc801\uc6a9\ud560 \uc218 \uc788\uac8c \uad8c\ud55c \ubd80\uc5ec\n
            mysql>\u00a0grant\u00a0replication\u00a0slave\u00a0on\u00a0*.*\u00a0to\u00a0'repl_test'@'192.168.20.12'\u00a0identified\u00a0by\u00a0'repltest';\r\n\\\\Query\u00a0OK,\u00a00\u00a0rows\u00a0affected\u00a0(0.00\u00a0sec)<\/code><\/pre>\n<\/li>\n
          5. Master2\uc11c\ubc84\uc5d0 \uc2ac\ub808\uc774\ube0c\u00a0\ud50c\ub7ec\uadf8\uc778 \uc124\uce58 \ubc0f \ud65c\uc131\ud654\n
            mysql>\u00a0INSTALL\u00a0PLUGIN\u00a0rpl_semi_sync_slave\u00a0SONAME\u00a0'semisync_slave.so';\r\nmysql>\u00a0set\u00a0global\u00a0rpl_semi_sync_slave_enabled=1;\r\nmysql>\u00a0show\u00a0variables\u00a0like\u00a0'rpl_semi_sync%';\r\n+~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~--+~-~-~-~-~-~--+\r\n|\u00a0Variable_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0Value\u00a0|\r\n+~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~--+~-~-~-~-~-~--+\r\n|\u00a0rpl_semi_sync_slave_enabled\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0ON\u00a0\u00a0\u00a0\u00a0|\r\n|\u00a0rpl_semi_sync_slave_trace_level\u00a0|\u00a032\u00a0\u00a0\u00a0\u00a0|\r\n+~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~--+~-~-~-~-~-~--+\r\n2\u00a0rows\u00a0in\u00a0set\u00a0(0.01\u00a0sec)<\/code><\/pre>\n<\/li>\n
          6. Master1\uc11c\ubc84\uc5d0\uc11c \uc811\uc18d\ud560 \uc218 \uc788\uac8c \uad8c\ud55c \uc124\uc815\n
            mysql>\u00a0grant\u00a0replication\u00a0slave\u00a0on\u00a0*.*\u00a0to\u00a0'repl_test'@'192.168.20.11'\u00a0identified\u00a0by\u00a0'repltest';<\/code><\/pre>\n<\/li>\n
          7. \uc591\ucabd Master\uc11c\ubc84\uc758 bin log, postion \ucd08\uae30\ud654\n
            mysql>\u00a0reset\u00a0master;<\/code><\/pre>\n<\/li>\n
          8. \uac01 \uc11c\ubc84 Master\uc0c1\ud0dc \ud655\uc778\n
            \n
            \n
            \n
            #\u00a0Master1\uc5d0\uc11c\u00a0\ud655\uc778<\/div>\n<\/div>\n<\/div>\n<\/div>\n
            mysql>\u00a0show\u00a0master\u00a0status;\r\n+~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-+~-~-~-~-~-~-~-~-~-~-+~-~-~-~-~-~-~-~-~-~-~-~-~-~-+~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-+\r\n|\u00a0File\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0Position\u00a0|\u00a0Binlog_Do_DB\u00a0|\u00a0Binlog_Ignore_DB\u00a0|\r\n+~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-+~-~-~-~-~-~-~-~-~-~-+~-~-~-~-~-~-~-~-~-~-~-~-~-~-+~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-+\r\n|\u00a0mysql-bin.000001\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0100\u00a0|\u00a0wordpress\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\n1\u00a0row\u00a0in\u00a0set\u00a0(0.00\u00a0sec)\r\n<\/code><\/pre>\n
            \n
            \n
            \n
            #\u00a0Master2\uc5d0\uc11c\u00a0\ud655\uc778<\/div>\n<\/div>\n<\/div>\n<\/div>\n
            mysql>\u00a0show\u00a0master\u00a0status;\r\n+~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-+~-~-~-~-~-~-~-~-~-~-+~-~-~-~-~-~-~-~-~-~-~-~-~-~-+~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-+\r\n|\u00a0File\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0Position\u00a0|\u00a0Binlog_Do_DB\u00a0|\u00a0Binlog_Ignore_DB\u00a0|\r\n+~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-+~-~-~-~-~-~-~-~-~-~-+~-~-~-~-~-~-~-~-~-~-~-~-~-~-+~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-+\r\n|\u00a0mysql-bin.000001\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0100\u00a0|\u00a0wordpress\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\n1\u00a0row\u00a0in\u00a0set\u00a0(0.00\u00a0sec)<\/code><\/pre>\n
            \n
            \n
            <\/div>\n<\/div>\n<\/div>\n<\/li>\n
          9. \uc591\ucabd \uc11c\ubc84 Master\uc5f0\uacb0 (File\uacfc Position\uc744 \ub9de\ucd94\uba74 \ub428)\n
            \n
            \n
            \n
            #\u00a0Master1\uc5d0\uc11c\u00a0\uc218\ud589<\/div>\n<\/div>\n<\/div>\n<\/div>\n
            mysql>\u00a0change\u00a0master\u00a0to\u00a0\u00a0master_host='192.168.20.12',\u00a0master_user='repl_test',\u00a0master_password='repltest',\u00a0master_log_file='mysql-master-bin.000001',\u00a0master_log_pos=100;<\/code><\/pre>\n
            \n
            \n
            \n
            \n
            #\u00a0Master2\uc5d0\uc11c\u00a0\uc218\ud589<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
            mysql>\u00a0change\u00a0master\u00a0to\u00a0\u00a0master_host='192.168.20.11',\u00a0master_user='repl_test',\u00a0master_password='repltest',\u00a0master_log_file='mysql-master-bin.000001',\u00a0master_log_pos=100;<\/code><\/pre>\n
            \n
            \n
            <\/div>\n<\/div>\n<\/div>\n<\/li>\n
          10. \uac01\uc11c\ubc84 \uc5f0\uacb0\uc0c1\ud0dc\ud655\uc778\n
            \n
            \n
            \n
            Master1)<\/div>\n<\/div>\n<\/div>\n<\/div>\n
            mysql>\u00a0show\u00a0slave\u00a0status\u00a0\\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:\u00a0192.168.20.12\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_User:\u00a0repl_test\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_Port:\u00a03306\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Connect_Retry:\u00a060\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_Log_File:\u00a0mysql-bin.000001\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Read_Master_Log_Pos:\u00a0107\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Relay_Log_File:\u00a0ha1-relay-bin.000001\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Relay_Log_Pos:\u00a04\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Relay_Master_Log_File:\u00a0mysql-bin.000001\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Slave_IO_Running:\u00a0Yes\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Slave_SQL_Running:\u00a0Yes\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:\u00a00\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:\u00a00\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Exec_Master_Log_Pos:\u00a0107\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Relay_Log_Space:\u00a0107\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Until_Condition:\u00a0None\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:\u00a00\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_SSL_Allowed:\u00a0No\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:\u00a00\r\nMaster_SSL_Verify_Server_Cert:\u00a0No\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Last_IO_Errno:\u00a00\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Last_IO_Error:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Last_SQL_Errno:\u00a00\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:\u00a00\r\n1\u00a0row\u00a0in\u00a0set\u00a0(0.00\u00a0sec)\r\nERROR:\r\nNo\u00a0query\u00a0specified<\/code><\/pre>\n
            \n
            \n
            \n
            Master2)<\/div>\n<\/div>\n<\/div>\n<\/div>\n
            mysql>\u00a0show\u00a0slave\u00a0status\u00a0\\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:\u00a0192.168.20.11\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_User:\u00a0repl_test\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_Port:\u00a03306\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Connect_Retry:\u00a060\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_Log_File:\u00a0mysql-bin.000001\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Read_Master_Log_Pos:\u00a0107\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Relay_Log_File:\u00a0ha2-relay-bin.000001\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Relay_Log_Pos:\u00a04\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Relay_Master_Log_File:\u00a0mysql-bin.000001\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Slave_IO_Running:\u00a0Yes\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Slave_SQL_Running:\u00a0Yes\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:\u00a00\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:\u00a00\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Exec_Master_Log_Pos:\u00a0107\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Relay_Log_Space:\u00a0107\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Until_Condition:\u00a0None\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:\u00a00\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Master_SSL_Allowed:\u00a0No\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:\u00a00\r\nMaster_SSL_Verify_Server_Cert:\u00a0No\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Last_IO_Errno:\u00a00\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Last_IO_Error:\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Last_SQL_Errno:\u00a00\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:\u00a00\r\n1\u00a0row\u00a0in\u00a0set\u00a0(0.00\u00a0sec)\r\nERROR:\r\nNo\u00a0query\u00a0specified<\/code><\/pre>\n
            \n
            \n
            <\/div>\n<\/div>\n<\/div>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
            \uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8\uc785\ub2c8\ub2e4. Mysql \ub370\uc774\ud130\ubcf5\uc824\ub974 \uc704\ud55c\u00a0 replication \uc124\uc815\uc808\ucc28\uc5d0 \ub300\ud574 \uc5c5\ub370\uc774\ud2b8 \ud588\uc2b5\ub2c8\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 5.5\ubd80\ud130\ub294 innodb\ub97c \uae30\ubcf8\uc5d4\uc9c4\uc73c\ub85c…<\/p>\n","protected":false},"author":1,"featured_media":1491,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[423,383,405],"class_list":["post-1489","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux-","tag-data-sync","tag-mysql","tag-replication"],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1489","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=1489"}],"version-history":[{"count":2,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1489\/revisions"}],"predecessor-version":[{"id":1495,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1489\/revisions\/1495"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/media\/1491"}],"wp:attachment":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1489"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1489"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1489"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}