{"id":801,"date":"2015-05-18T15:51:57","date_gmt":"2015-05-19T00:51:57","guid":{"rendered":"http:\/\/blog.box.kr\/?p=801"},"modified":"2015-05-18T15:51:57","modified_gmt":"2015-05-19T00:51:57","slug":"scrap-mysql-replication-%ec%84%a4%ec%a0%95%ea%b3%bc-%eb%aa%87-%ea%b0%80%ec%a7%80-%ed%85%8c%ec%8a%a4%ed%8a%b8","status":"publish","type":"post","link":"https:\/\/blog.box.kr\/?p=801","title":{"rendered":"[scrap] MySQL Replication \uc124\uc815\uacfc \uba87 \uac00\uc9c0 \ud14c\uc2a4\ud2b8"},"content":{"rendered":"

http:\/\/blog.hibrainapps.net\/130<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

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.<\/p>\n

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.<\/p>\n

\ubd80\ud558 \ubd84\uc0b0\uc758 \ud6a8\uacfc\ub294 inser,update \ub4f1 \ubcc0\uacbd\uacfc \uad00\ub828\ub41c \ubaa8\ub4e0 \uc791\uc5c5\uc740 Master\uc5d0\uc11c \uc2e4\ud589\uc744 \ud558\uace0, select \ub4f1 \uc77d\uae30\uacfc \uad00\ub828\ub41c \uc791\uc5c5\uc740 Slave\ub97c \ud1b5\ud558\uc5ec \uc791\uc5c5\uc744 \ud568\uc73c\ub85c\uc11c \uc77d\uae30\uc640 \uc4f0\uae30\uc5d0 \ub300\ud55c \ubd80\ud558\ubd84\uc0b0\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n

 <\/p>\n

MySQL\uc758 Replication \uc740 \ube44\ub3d9\uae30 \ubc29\uc2dd\uc73c\ub85c \ucc98\ub9ac \ub418\uba70, Master \uc5d0\uc11c \ubcc0\uacbd\ub41c \ub0b4\uc6a9\uc774 Slave\uc5d0 \uc801\uc6a9\uc774 \ub41c\ub2e4.<\/p>\n

 <\/p>\n

MySQL \uc5d0\uc11c \u00a0Replication \uc774 \uc801\uc6a9\ub418\ub294 \ubc29\uc2dd\uc740 \uc544\ub798 \uadf8\ub9bc\uc744 \uc694\uc57d\ud560 \uc218 \uc788\ub2e4.<\/p>\n

    \n
  1. Master \uc5d0\uc11c \ub370\uc774\ud130\uc758 \ubcc0\uacbd\uc791\uc5c5\uc774 \ubc1c\uc0dd\ud558\uba74 Master DB\uc758 \ubcc0\uacbd \uc2e4\ud589<\/li>\n
  2. \ubcc0\uacbd\ub41c \uc774\ub825\uc744 Binary Log \uc5d0 \uae30\ub85d<\/li>\n
  3. Slave \uc758 IO Thread \uac00 Master \uc758 \ubcc0\uacbd Event \ub97c \uac10\uc9c0\ud558\uace0 Master \uc758 Binary Log \ub97c \uc790\uc2e0(Slave)\uc758 Relay Log \uc5d0 \uae30\ub85d\ud55c\ub2e4.<\/li>\n
  4. Slave \uc758 SQL Thread \ub294 Relay Log \ub97c \uc77d\uace0 \uc790\uc2e0(Slave)\uc758 DB\uc5d0 \uae30\ub85d\ud55c\ub2e4.<\/li>\n<\/ol>\n

    \uc704 \uadf8\ub9bc\uc5d0\uc11c\ucc98\ub7fc Master \uc5d0\uc11c Slave \ubc29\ud5a5\uc73c\ub85c \ub2e8\ubc29\ud5a5\uc73c\ub85c\ub9cc \ucc98\ub9ac\uac00 \uc774\ub8e8\uc5b4 \uc9c0\ubbc0\ub85c \ubcc0\uacbd\uc791\uc5c5(Write)\ub294 Master\uc5d0\ub9cc \ud558\uc5ec\uc57c \ud55c\ub2e4.<\/p>\n

    Slave\uc5d0\uc11c \ubcc0\uacbd\uc791\uc5c5\uc744 \ud560 \uacbd\uc6b0 Master\uc5d0\ub294 \ub2f9\uc5f0\ud788 \ubc18\uc601\uc774 \uc548\ub418\uba70, Slave\uc5d0\uc11c \ubcc0\uacbd\uc791\uc5c5\ud55c Object \uc5d0 \ub300\ud558\uc5ec Master \uc11c \ubcc0\uacbd\uc791\uc5c5\uc744 \ub2e4\uc2dc \uc2dc\ub3c4\ud560 \uacbd\uc6b0 \ubcc0\uacbd\uc740 \ub418\uc9c0\ub9cc \ub2e4\uc2dc slave\uc5d0 \ub294 \uc801\uc6a9\ub418\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n

     <\/p>\n

    MySQL Replication \uc124\uc815<\/p>\n

      \n
    1. \uae30\ubcf8\uc801\uc73c\ub85c Master\uc640 Slave\ub85c \uc0ac\uc6a9\ud560 Mysql \uc11c\ubc84\uac00 \uac01\uac01 \uc124\uce58\ub418\uc5b4 \uc788\uc5b4\uc57c \ud55c\ub2e4. \uac00\ub2a5\ud558\uba74 \ubb3c\ub9ac\uc801\uc73c\ub85c \ub2e4\ub978 \uc11c\ubc84\uac00 \ud544\uc694\ud558\uc9c0\ub9cc port \ub97c \ub2ec\ub9ac \uc124\uce58\ud55c \ubb3c\ub9ac\uc801 \ub3d9\uc77c \uc11c\ubc84\ub0b4\uc5d0\uc11c \ud14c\uc2a4\ud2b8\ud558\ub294\uac83\ub3c4 \uac00\ub2a5\ud560\uac83 \uac19\ub2e4.<\/li>\n<\/ol>\n

      Replication \uae30\ub2a5\uc740 3.23.15\ubd80\ud130 \uc9c0\uc6d0\ub418\uae30 \uc2dc\uc791\ud558\uc600\uc73c\ub098, 3.23.32\ubd80\ud130 \uc548\uc815\ud654 \ub418\uc5c8\uae30\uc5d0 \uac00\ub2a5\ud558\uba74 \ucd5c\uc2e0\ubc84\uc804\uc758 MySQL \uc744 \uad8c\ud55c\ub2e4.(\ud604\uc7ac 5.6 \ubc84\uc804\uc774 release\u00a0 \ub418\uc5c8\ub294\ub370……)<\/p>\n

       <\/p>\n

      \uc124\uc815 \uc694\uc57d<\/p>\n

      -. Master 1\uac1c\uc5d0 Slave 1\uac1c\ub97c \uc9c0\uc815<\/p>\n

      -. Master<\/p>\n

      IP: 192.168.0.1<\/p>\n

      server-id = 1<\/p>\n

      replication \ub300\uc0c1 db\uba85 : classmate<\/p>\n

      \uacc4\uc815 : root(‘rootpassword’)<\/p>\n

      replication \uad8c\ud55c \uacc4\uc815 : rep(‘reppassword’)<\/p>\n

      -. Slave<\/p>\n

      IP : 192.168.0.2<\/p>\n

      server-id = 2<\/p>\n

       <\/p>\n

        \n
      1. Master \uacc4\uc815\uc0dd\uc131<\/li>\n<\/ol>\n

        -. Slave \uc5d0\uc11c Master \ub85c \uc811\uadfc \ud560\uc218 \uc788\ub294 \uacc4\uc815\uc774 \ud544\uc694\ud558\ub2e4. \uc774 \uacc4\uc815\uc740 ‘REPLICATION SALVE’ \uad8c\ud55c\uc774 \uae30\ubcf8\uc801\uc73c\ub85c \ud544\uc694\ud558\ub2e4<\/p>\n

        Master \uc11c\ubc84\uc5d0\uc11c \uc544\ub798\uc640 \uac19\uc774 \uad8c\ud55c\uc744 \uc9c0\uc815\ud55c\ub2e4.<\/p>\n

         <\/p>\n

        master mysql > GRANT REPLICATION SLAVE ON *.* TO ‘rep’@’192.168.0.2’<\/a> IDENTIFIED BY ‘reppassword’;<\/p>\n

         <\/p>\n

          \n
        1. Master Data \ub97c Slave\ub85c \ubcf5\uc0ac<\/li>\n<\/ol>\n

          -. HOT \ubc31\uc5c5<\/p>\n

          master mysql > FLUSH TABLES WITH READ LOCK;
          \nmaster shell > tar -cvf \/tmp\/mysql-snapshot.tar .
          \nslave\u00a0\u00a0 shell > tar -xvf \/tmp\/mysql-snapshot.tar
          \nmaster mysql > UNLOCK TABLES;<\/p>\n

           <\/p>\n

          -. mysqldump \uc774\uc6a9 \ubc31\uc5c5<\/p>\n

          master Shell > mysqldump -u root -p \u2018rootpassword\u2019 \u00a0classmate > dump_classmate.sql\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0db \uba85 : classmate<\/p>\n

          –\uc544\ub798 slave \uc11c\ubc84\ub85c\uc758 dump \ud30c\uc77c\uc744 \uc774\ub3d9 & load \ub294 ‘6’\uc5d0\uc11c \uc2e4\ud589\ud558\uba74 \ub428–<\/p>\n

          dump_classmate.sql \ud30c\uc77c\uc744 slave \ub85c \ubcf5\uc0ac \ud6c4<\/p>\n

          slave Shell > mysql\u00a0-u root -p \u2018rootpassword\u2019 \u00a0classmate\u00a0< dump_classmate.sql\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0db \uba85 : classmate<\/p>\n

           <\/p>\n

           <\/p>\n

            \n
          1. Master \ud658\uacbd\uc124\uc815<\/li>\n<\/ol>\n

            -. master\uc758 my.cnf \ud30c\uc77c\uc744 \uc218\uc815\ud55c\ub2e4.<\/p>\n

             <\/p>\n

            master shell> vi \/etc\/my.cnf<\/p>\n

             <\/p>\n

            [mysqld]
            \nlog-bin=mysql-bin
            \nserver-id\u00a0 = 1<\/p>\n

             <\/p>\n

            -. master \uc758 server-id \ub97c 1\ub85c \uc9c0\uc815\ud55c\ub2e4.(\ub2e4\ub978\uc22b\uc790 \uac12\uc73c\ub85c \ud558\uc5ec\ub3c4 \uc0c1\uad00\uc5c6\ub2e4. slave \uc640 \uc911\ubcf5\ub418\uc9c0 \uc54a\uc73c\uba74 \ub41c\ub2e4(1~(2^32)-1\ub0b4\uc758 \uc22b\uc790)<\/p>\n

            -. [mysqld]\uc139\uc158\uc5d0 \uc704\uc640 \uac19\uc774 log-bin \uc774 \uc874\uc7ac\ud558\ub294\uc9c0 \ud655\uc778\ud55c\ub2e4<\/p>\n

             <\/p>\n

              \n
            1. Master \uc758 Replication \uc815\ubcf4 \uc870\ud68c<\/li>\n<\/ol>\n

              master mysql> SHOW MASTER STATUS;<\/strong><\/p>\n

              +——————+———-+————–+——————+<\/p>\n

              | File | Position | Binlog_Do_DB | Binlog_Ignore_DB |<\/p>\n

              +——————+———-+————–+——————+<\/p>\n

              | mysql-bin.000001 | 98 | | |<\/p>\n

              +——————+———-+————–+——————+<\/p>\n

              -.\u00a0File : \ub85c\uadf8 \ud30c\uc77c<\/p>\n

              -. Position : \ub85c\uadf8 \ud30c\uc77c\ub0b4 \uc77d\uc744 \uc704\uce58<\/p>\n

              -.\u00a0Binlog_Do_DB : binary log \ud30c\uc77c(\ubcc0\uacbd\ub41c \uc774\ubca4\ud2b8 \uc815\ubcf4\uac00 \uc313\uc774\ub294 \ud30c\uc77c)<\/p>\n

              -.\u00a0Binlog_Ignore_DB : \ubcf5\uc81c \uc81c\uc678 \uc815\ubcf4<\/p>\n

              n Binlog_Do_DB\uc640 Binlog_Ignore_DB\ub294 Slave \uc2dc\uc791\ud558\uae30 \uc804\uae4c\uc9c0\ub294 \ub098\ud0c0\ub098\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n

              -. File \uacfc Position \uc815\ubcf4\uac00 ‘7’\uc758 \uacfc\uc815\uc5d0\uc11c \ud544\uc694\ud558\ub2e4.<\/p>\n

               <\/p>\n

                \n
              1. Slave \ud658\uacbd \uc124\uc815<\/li>\n<\/ol>\n

                -. slave \uc758 my.cnf \ud30c\uc77c\uc744 \uc218\uc815\ud55c\ub2e4.<\/p>\n

                slave\u00a0shell> vi \/etc\/my.cnf<\/p>\n

                [mysqld]
                \nserver-id\u00a0 = 2
                \nmaster-host = 192.168.0.1<\/p>\n

                master-port = 3306
                \nmaster-user = rep (\uc704\uc5d0\uc11c \uc124\uc815\ud55c replication\uc744 \uc704\ud55c \uacc4\uc815 \uc815\ubcf4)
                \nmaster-password = reppassword<\/p>\n

                 <\/p>\n

                  \n
                1. Slave \uc11c\ubc84 Start<\/li>\n<\/ol>\n

                  -. 2\uc758 \uacfc\uc815\uc5d0\uc11c HOT \ubc31\uc5c5\uc744 \ud558\uc600\ub2e4\uba74 Slave \uc11c\ubc84\uc758 mysql data \ub514\ub809\ud1a0\ub9ac\uc5d0 master \uc11c\ubc84\uc758 \ub370\uc774\ud130\ub97c \ubcf5\uc0ac\ud558\uace0, mysqldump \ub97c \uc774\uc6a9\ud558\uc5ec \ubc31\uc5c5\ud558\uc600\ub2e4\uba74, mysql \uc11c\ubc84\ub97c start \ud6c4 dump \ud30c\uc77c\uc744 load \ud55c\ub2e4.<\/p>\n

                  slave shell > \/etc\/init.d\/mysqld start<\/p>\n

                   <\/p>\n

                  2\uc5d0\uc11c mysldump \ub85c dump \ud55c dump_classmate.sql \ud30c\uc77c\uc744 slave \ub85c \ubcf5\uc0ac \ud6c4<\/p>\n

                  slave Shell > mysql -u root -p \u2018rootpassword\u2019\u00a0classmate < dump_classmate.sql\u00a0 \u00a0(db \uba85 : classmate)<\/p>\n

                  master\uc5d0\uc11c classamte db\ub97c dump \ud55c dump_classmate.sql \ud30c\uc77c\uc744 \uc774\uc6a9\ud558\uc5ec slave\uc758 clsssmate db\ub85c load(slave\uc5d0\ub294 classmate \ub77c\ub294 db\uac00 \uc874\uc7ac\ud558\uc5ec\uc57c \ud568)<\/p>\n

                   <\/p>\n

                    \n
                  1. Slave \uc815\ubcf4 \uc124\uc815<\/li>\n<\/ol>\n

                    -. Slave \uc5d0\uc11c Master\ub85c \uc5f0\uacb0\ud558\uae30 \uc704\ud55c \uc815\ubcf4\ub97c \uc124\uc815\ud55c\ub2e4.<\/p>\n

                    slave mysql > CHANGE MASTER TO<\/p>\n

                    MASTER_HOST=’192.168.0.1′,<\/p>\n

                    MASTER_USER=’rep’,<\/p>\n

                    MASTER_PASSWORD=’reppassword’,<\/p>\n

                    MASTER_LOG_FILE=’mysql-bin.000001′,<\/p>\n

                    MASTER_LOG_POS=98;<\/p>\n

                    -. 4\uc5d0\uc11c \uc870\ud68c\ud55c master \uc758 logfile\uacfc position \uc815\ubcf4\ub97c \uc9c0\uc815\ud55c\ub2e4.<\/p>\n

                     <\/p>\n

                      \n
                    1. Slave Start<\/li>\n<\/ol>\n

                      slave mysql > start slave;<\/p>\n

                       <\/p>\n

                      \uc774\uc81c Master \ubcc0\uacbd\uc774 \ub418\uba74 \uc790\ub3d9\uc73c\ub85c Slave\uc5d0\uc11c\ub3c4 \ubcc0\uacbd\ub41c \uac83\uc744 \ud655\uc778 \ud560 \uc218 \uc788\ub2e4.<\/p>\n

                       <\/p>\n

                      \uba87\uac00\uc9c0 Test \ub0b4\uc6a9<\/p>\n

                      -. \uae30\ubcf8\uc801\uc778 master\uc5d0\uc11c \ub370\uc774\ud130\uc785\ub825\uacfc slave\uc5d0\uc11c\uc758 \ud655\uc778<\/p>\n

                        \n
                      1. master\uc758 classmate DB\uc758 tb_textbook \uc815\ubcf4 \uc870\ud68c<\/li>\n<\/ol>\n

                        master mysql> select * from tb_textbook;<\/p>\n

                        +————-+————+—————+—————+——–+———–+————–+———+———–+<\/p>\n

                        | textbook_id | subject_id | textbook_type | textbook_name | author | publisher | publish_year | main_yn | refer_url |<\/p>\n

                        +————-+————+—————+—————+——–+———–+————–+———+———–+<\/p>\n

                        | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 7 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a01 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1 | 1 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 | 1 \u00a0 \u00a0 \u00a0| 1 \u00a0 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a01 | 1 \u00a0 \u00a0 \u00a0 | 1 \u00a0 \u00a0 \u00a0 \u00a0 |<\/p>\n

                        | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 6 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a01 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1 | 1 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 | 1 \u00a0 \u00a0 \u00a0| 1 \u00a0 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a01 | 1 \u00a0 \u00a0 \u00a0 | 2 \u00a0 \u00a0 \u00a0 \u00a0 |<\/p>\n

                        +————-+————+—————+—————+——–+———–+————–+———+———–+<\/p>\n

                        2 rows in set (0.00 sec)<\/p>\n

                          \n
                        1. master \uc5d0\uc11c tb_textbook\uc5d0 1\uac1c\uc758 row \ub4f1\ub85d<\/li>\n<\/ol>\n

                          master mysql>\u00a0INSERT INTO `classmatetest`.`tb_textbook` (`textbook_id`, `subject_id`, `textbook_type`, `textbook_name`, `author`, `publisher`, `publish_year`, `main_yn`, `refer_url`) VALUES (’10’, ‘2’, ‘2’, ‘\uad50\uc591 \ucef4\ud4e8\ud130’, ‘\uad50\uc218\ub2d8’, ‘\ucd9c\ud310\uc0ac’, ‘2013’, ‘n’, ‘http:\/\/hibrain.net’);<\/p>\n

                          mysql> select * from tb_textbook;<\/p>\n

                          +————-+————+—————+——————+———–+———–+————–+———+——————–+<\/p>\n

                          | textbook_id | subject_id | textbook_type | textbook_name \u00a0 \u00a0| author \u00a0 \u00a0| publisher | publish_year | main_yn | refer_url \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|<\/p>\n

                          +————-+————+—————+——————+———–+———–+————–+———+——————–+<\/p>\n

                          | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 7 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a01 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1 | 1 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| 1 \u00a0 \u00a0 \u00a0 \u00a0 | 1 \u00a0 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a01 | 1 \u00a0 \u00a0 \u00a0 | 1 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|<\/p>\n

                          | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 6 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a01 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1 | 1 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| 1 \u00a0 \u00a0 \u00a0 \u00a0 | 1 \u00a0 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a01 | 1 \u00a0 \u00a0 \u00a0 | 2 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|<\/p>\n

                          | \u00a0 \u00a0 \u00a0 \u00a0 \u00a010 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a02 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2 | \uad50\uc591 \ucef4\ud4e8\ud130 \u00a0 \u00a0 \u00a0| \uad50\uc218\ub2d8 \u00a0 \u00a0| \ucd9c\ud310\uc0ac \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 \u00a0 2013 | n \u00a0 \u00a0 \u00a0 | http:\/\/hibrain.net |<\/p>\n

                          +————-+————+—————+——————+———–+———–+————–+———+——————–+<\/p>\n

                          3 rows in set (0.00 sec)<\/p>\n

                          slave\uc5d0\uc11c \uc815\ubcf4 \uc870\ud68c<\/p>\n

                          mysql> select * from tb_textbook;<\/p>\n

                          +————-+————+—————+——————+———–+———–+————–+———+——————–+<\/p>\n

                          | textbook_id | subject_id | textbook_type | textbook_name \u00a0 \u00a0| author \u00a0 \u00a0| publisher | publish_year | main_yn | refer_url \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|<\/p>\n

                          +————-+————+—————+——————+———–+———–+————–+———+——————–+<\/p>\n

                          | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 7 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a01 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1 | 1 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| 1 \u00a0 \u00a0 \u00a0 \u00a0 | 1 \u00a0 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a01 | 1 \u00a0 \u00a0 \u00a0 | 1 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|<\/p>\n

                          | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 6 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a01 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1 | 1 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| 1 \u00a0 \u00a0 \u00a0 \u00a0 | 1 \u00a0 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a01 | 1 \u00a0 \u00a0 \u00a0 | 2 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|<\/p>\n

                          | \u00a0 \u00a0 \u00a0 \u00a0 \u00a010 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a02 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2 | \uad50\uc591 \ucef4\ud4e8\ud130 \u00a0 \u00a0 \u00a0| \uad50\uc218\ub2d8 \u00a0 \u00a0| \ucd9c\ud310\uc0ac \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 \u00a0 2013 | n \u00a0 \u00a0 \u00a0 | http:\/\/hibrain.net |<\/p>\n

                          +————-+————+—————+——————+———–+———–+————–+———+——————–+<\/p>\n

                          3 rows in set (0.00 sec)<\/p>\n

                          -.\u00a0 Master \uc5d0\uc11c\uc758 Table \uceec\ub7fc\uc815\ubcf4 \ubcc0\uacbd<\/p>\n

                            \n
                          1. Master tb_textbook \uc815\ubcf4<\/li>\n<\/ol>\n

                            mysql> desc tb_textbook;<\/p>\n

                            +—————+————–+——+—–+———+——-+<\/p>\n

                            | Field \u00a0 \u00a0 \u00a0 \u00a0 | Type \u00a0 \u00a0 \u00a0 \u00a0 | Null | Key | Default | Extra |<\/p>\n

                            +—————+————–+——+—–+———+——-+<\/p>\n

                            | textbook_id \u00a0 | int(11) \u00a0 \u00a0 \u00a0| NO \u00a0 | \u00a0 \u00a0 | NULL \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 |<\/p>\n

                            | subject_id \u00a0 \u00a0| int(11) \u00a0 \u00a0 \u00a0| NO \u00a0 | \u00a0 \u00a0 | NULL \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 |<\/p>\n

                            | textbook_type | int(11) \u00a0 \u00a0 \u00a0| NO \u00a0 | \u00a0 \u00a0 | NULL \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 |<\/p>\n

                            | textbook_name | varchar(100) | NO \u00a0 | \u00a0 \u00a0 | NULL \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 |<\/p>\n

                            | author \u00a0 \u00a0 \u00a0 \u00a0| varchar(100) | YES \u00a0| \u00a0 \u00a0 | NULL \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 |<\/p>\n

                            | publisher \u00a0 \u00a0 | varchar(100) | YES \u00a0| \u00a0 \u00a0 | NULL \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 |<\/p>\n

                            | publish_year \u00a0| int(11) \u00a0 \u00a0 \u00a0| YES \u00a0| \u00a0 \u00a0 | NULL \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 |<\/p>\n

                            | main_yn \u00a0 \u00a0 \u00a0 | char(1) \u00a0 \u00a0 \u00a0| YES \u00a0| \u00a0 \u00a0 | NULL \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 |<\/p>\n

                            | refer_url \u00a0 \u00a0 | varchar(200) | YES \u00a0| \u00a0 \u00a0 | NULL \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 |<\/p>\n

                            +—————+————–+——+—–+———+——-+<\/p>\n

                            9 rows in set (0.00 sec)<\/p>\n

                              \n
                            1. Master \uc5d0\uc11c tb_textbook\uc758 refer_url \uc5d0 \ub300\ud558\uc5ec varchar(200) ==> int \ub85c \ubcc0\uacbd<\/li>\n<\/ol>\n

                              ALTER\u00a0TABLE<\/a>\u00a0`tb_textbook`\u00a0CHANGE\u00a0`refer_url`\u00a0`refer_url`\u00a0INT\u00a0NULL\u00a0DEFAULT\u00a0NULL<\/p>\n

                              3.Slave\uc5d0\uc11c \ud655\uc778<\/p>\n

                              mysql> desc tb_textbook;<\/p>\n

                              +—————+————–+——+—–+———+——-+<\/p>\n

                              | Field \u00a0 \u00a0 \u00a0 \u00a0 | Type \u00a0 \u00a0 \u00a0 \u00a0 | Null | Key | Default | Extra |<\/p>\n

                              +—————+————–+——+—–+———+——-+<\/p>\n

                              | textbook_id \u00a0 | int(11) \u00a0 \u00a0 \u00a0| NO \u00a0 | \u00a0 \u00a0 | NULL \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 |<\/p>\n

                              | subject_id \u00a0 \u00a0| int(11) \u00a0 \u00a0 \u00a0| NO \u00a0 | \u00a0 \u00a0 | NULL \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 |<\/p>\n

                              | textbook_type | int(11) \u00a0 \u00a0 \u00a0| NO \u00a0 | \u00a0 \u00a0 | NULL \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 |<\/p>\n

                              | textbook_name | varchar(100) | NO \u00a0 | \u00a0 \u00a0 | NULL \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 |<\/p>\n

                              | author \u00a0 \u00a0 \u00a0 \u00a0| varchar(100) | YES \u00a0| \u00a0 \u00a0 | NULL \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 |<\/p>\n

                              | publisher \u00a0 \u00a0 | varchar(100) | YES \u00a0| \u00a0 \u00a0 | NULL \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 |<\/p>\n

                              | publish_year \u00a0| int(11) \u00a0 \u00a0 \u00a0| YES \u00a0| \u00a0 \u00a0 | NULL \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 |<\/p>\n

                              | main_yn \u00a0 \u00a0 \u00a0 | char(1) \u00a0 \u00a0 \u00a0| YES \u00a0| \u00a0 \u00a0 | NULL \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 |<\/p>\n

                              | refer_url \u00a0 \u00a0 | int(11) \u00a0 \u00a0 \u00a0| YES \u00a0| \u00a0 \u00a0 | NULL \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 |<\/p>\n

                              +—————+————–+——+—–+———+——-+<\/p>\n

                              9 rows in set (0.01 sec)<\/p>\n

                               <\/p>\n

                              -. \uceec\ub7fc \ucd94\uac00, \uc0ad\uc81c\uc758 \uacfc\uc815\ub3c4 \ub9c8\ucc2c\uac00\uc9c0\ub85c \uc704\uc758 \uacfc\uc815\uacfc \ub3d9\uc77c\ud558\uac8c \ud655\uc778\uc774 \uac00\ub2a5\ud558\ub2e4<\/p>\n

                              -. Index \uc0dd\uc131<\/p>\n

                              master mysql> show index from tb_textbook;<\/p>\n

                              +————-+————+————————-+————–+————-+———–+————-+———-+——–+——+————+———+—————+<\/p>\n

                              | Table \u00a0 \u00a0 \u00a0 | Non_unique | Key_name \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |<\/p>\n

                              +————-+————+————————-+————–+————-+———–+————-+———-+——–+——+————+———+—————+<\/p>\n

                              | tb_textbook | \u00a0 \u00a0 \u00a0 \u00a0 \u00a00 | PRIMARY \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a01 | textbook_id | A \u00a0 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 3 | \u00a0 \u00a0 NULL | NULL \u00a0 | \u00a0 \u00a0 \u00a0| BTREE \u00a0 \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |<\/p>\n

                              +————-+————+————————-+————–+————-+———–+————-+———-+——–+——+————+———+—————+<\/p>\n

                              1 rows in set (0.00 sec)<\/p>\n

                              master mysql >\u00a0ALTER TABLE<\/a> `classmatetest`.`tb_textbook` ADD INDEX `textbook_subject_id_idx` ( `subject_id` );<\/p>\n

                              mysql> show index from tb_textbook;<\/p>\n

                              +————-+————+————————-+————–+————-+———–+————-+———-+——–+——+————+———+—————+<\/p>\n

                              | Table \u00a0 \u00a0 \u00a0 | Non_unique | Key_name \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |<\/p>\n

                              +————-+————+————————-+————–+————-+———–+————-+———-+——–+——+————+———+—————+<\/p>\n

                              | tb_textbook | \u00a0 \u00a0 \u00a0 \u00a0 \u00a00 | PRIMARY \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a01 | textbook_id | A \u00a0 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 3 | \u00a0 \u00a0 NULL | NULL \u00a0 | \u00a0 \u00a0 \u00a0| BTREE \u00a0 \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |<\/p>\n

                              | tb_textbook | \u00a0 \u00a0 \u00a0 \u00a0 \u00a01 | textbook_subject_id_idx | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a01 | subject_id \u00a0| A \u00a0 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 3 | \u00a0 \u00a0 NULL | NULL \u00a0 | \u00a0 \u00a0 \u00a0| BTREE \u00a0 \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |<\/p>\n

                              +————-+————+————————-+————–+————-+———–+————-+———-+——–+——+————+———+—————+<\/p>\n

                              2 rows in set (0.00 sec)<\/p>\n

                               <\/p>\n

                              slave\uc5d0\uc11c \ud655\uc778<\/p>\n

                              mysql> show index from tb_textbook;<\/p>\n

                              +————-+————+————————-+————–+————-+———–+————-+———-+——–+——+————+———+—————+<\/p>\n

                              | Table \u00a0 \u00a0 \u00a0 | Non_unique | Key_name \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |<\/p>\n

                              +————-+————+————————-+————–+————-+———–+————-+———-+——–+——+————+———+—————+<\/p>\n

                              | tb_textbook | \u00a0 \u00a0 \u00a0 \u00a0 \u00a00 | PRIMARY \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a01 | textbook_id | A \u00a0 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 3 | \u00a0 \u00a0 NULL | NULL \u00a0 | \u00a0 \u00a0 \u00a0| BTREE \u00a0 \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |<\/p>\n

                              | tb_textbook | \u00a0 \u00a0 \u00a0 \u00a0 \u00a01 | textbook_subject_id_idx | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a01 | subject_id \u00a0| A \u00a0 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 3 | \u00a0 \u00a0 NULL | NULL \u00a0 | \u00a0 \u00a0 \u00a0| BTREE \u00a0 \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |<\/p>\n

                              +————-+————+————————-+————–+————-+———–+————-+———-+——–+——+————+———+—————+<\/p>\n

                              2 rows in set (0.00 sec)<\/p>\n

                               <\/p>\n

                              -. now() \uc640 sysdate() \uc758 \uc0ac\uc6a9\uc5d0 \ub300\ud55c \ud14c\uc2a4\ud2b8<\/p>\n

                              now()\uc640 sysdate()\uc758 \ucc28\uc774\ub294\u00a0MySQL\uc5d0\uc11c\uc758 \ud604\uc7ac\uc2dc\uac01\uc870\ud68c\ub97c \uc704\ud55c sysdate\uc640 now \uc758 \ucc28\uc774<\/a>\u00a0\uc5d0\uc11c \uc124\uba85\uc774 \ub418\uc5c8\ub2e4. \uadf8\uc911 replication \uc5d0\uc11c \uc2e4\uc81c\ub85c \uc5b4\ub5a4 \ucc28\uc774\uac00 \uc788\ub294\uc9c0 \ud655\uc778\ud574 \ubcf4\ub3c4\ub85d \ud55c\ub2e4.<\/p>\n

                              \uba3c\uc800 \uc544\ub798\uc640 \uac19\uc740 \uad6c\uc870\ub97c \uac00\uc9c4\u00a0\uc784\uc2dc table\uc744 \uc0dd\uc131\ud55c\ub2e4.<\/p>\n

                              master mysql> desc tb_timetable;<\/p>\n

                              +———+————-+——+—–+———+——-+<\/p>\n

                              | Field \u00a0 | Type \u00a0 \u00a0 \u00a0 \u00a0| Null | Key | Default | Extra |<\/p>\n

                              +———+————-+——+—–+———+——-+<\/p>\n

                              | nowdate | varchar(50) | NO \u00a0 | \u00a0 \u00a0 | NULL \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 |<\/p>\n

                              | sysdate | varchar(50) | NO \u00a0 | \u00a0 \u00a0 | NULL \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 |<\/p>\n

                              +———+————-+——+—–+———+——-+<\/p>\n

                              2 rows in set (0.00 sec)<\/p>\n

                              \uadf8\ub9ac\uace0 \ub2e4\uc74c\uc758 \ucffc\ub9ac\ub85c now()\uc640 sysdate()\ub97c \uac01\uac01 \uc785\ub825\ud558\ub3c4\ub85d \ud55c\ub2e4.<\/p>\n

                              INSERT<\/a>\u00a0INTO\u00a0`classmatetest`.`tb_timetable`\u00a0(`nowdate`\u00a0,`sysdate`)VALUES\u00a0(NOW<\/a>(\u00a0)\u00a0,\u00a0SYSDATE<\/a>(\u00a0));<\/p>\n

                              master mysql> select * from tb_timetable;<\/p>\n

                              +———————+———————+<\/p>\n

                              | nowdate \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 | sysdate \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |<\/p>\n

                              +———————+———————+<\/p>\n

                              | 2013-02-07 14:50:37 | 2013-02-07 14:50:37 |<\/p>\n

                              +———————+———————+<\/p>\n

                              1 row in set (0.00 sec)<\/p>\n

                              slave\u00a0mysql> select * from tb_timetable;<\/p>\n

                              +———————+———————+<\/p>\n

                              | nowdate \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 | sysdate \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |<\/p>\n

                              +———————+———————+<\/p>\n

                              | 2013-02-07 14:50:37 | 2013-02-07 14:41:31\u00a0|<\/p>\n

                              +———————+———————+<\/p>\n

                              1 row in set (0.00 sec)<\/p>\n

                              \uae30\ubcf8\uc801\uc73c\ub85c now\uc640 sysdate\ub294 \ud604\uc7ac\uc2dc\uac01\uc744 \ubc18\ud658\ud558\ub294 \ud568\uc218\ub85c \ub3d9\uc77c\ud55c \uae30\ub2a5\uc774\ub2e4. \ud558\uc9c0\ub9cc replication\uc5d0\uc11c now\ub97c \uc0ac\uc6a9\ud558\uac8c \ub418\uba74 master\uc640 slave\uc5d0 \ub3d9\uc77c\ud55c \uac12\uc73c\ub85c \uad00\ub9ac\uac00 \ub418\uc9c0\ub9cc, sysdate\ub97c \uc0ac\uc6a9\ud558\uac8c \ub418\uba74 \ud638\ucd9c\ud55c \uc2dc\uac04 \ubc18\ud654\ud558\ub294 \uad00\uacc4\ub85c master\uc640 slave\uc5d0 \uc785\ub825\ub41c \uac12\uc774 \ub2e4\ub974\uac8c \ub418\ub294 \ubb38\uc81c\uc810\uc774 \uc788\ub2e4. \uc774\ub7ec\ud55c \uc810\uc744 \uace0\ub824\ud558\uc5ec \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c sysdate\ubcf4\ub2e4\ub294 now \ub97c \uc0ac\uc6a9\ud558\ub294\uac83\uc774 \ub0ab\uace0, \uadf8\ub807\uc9c0 \ubabb\ud55c \uc0c1\ud669\uc774\ub77c\uba74\u00a0mysql \uc758 –sysdate-is-now \uc635\uc158\uc744 \uc124\uc815\ud558\uc5ec sysdate()\uc640 now()\uc758 \ud568\uc218\ub97c \ub3d9\uc77c\ud558\uac8c \uc801\uc6a9\ud558\ub3c4\ub85d \ud55c\ub2e4.<\/p>\n

                               <\/p>\n

                              \ucc38\uc870<\/p>\n

                              http:\/\/hanaduri.egloos.com\/2389708<\/a><\/p>\n

                              http:\/\/linuxism.tistory.com\/846<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

                              http:\/\/blog.hibrainapps.net\/130           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 Master\uc5d0\uc11c \uc2e4\ud589\uc744 \ud558\uace0, select \ub4f1 \uc77d\uae30\uacfc \uad00\ub828\ub41c \uc791\uc5c5\uc740 Slave\ub97c \ud1b5\ud558\uc5ec \uc791\uc5c5\uc744 \ud568\uc73c\ub85c\uc11c \uc77d\uae30\uc640 \uc4f0\uae30\uc5d0 \ub300\ud55c \ubd80\ud558\ubd84\uc0b0\uc774 \uac00\ub2a5\ud558\ub2e4.   MySQL\uc758 Replication \uc740 \ube44\ub3d9\uae30 \ubc29\uc2dd\uc73c\ub85c \ucc98\ub9ac \ub418\uba70, Master \uc5d0\uc11c \ubcc0\uacbd\ub41c \ub0b4\uc6a9\uc774 Slave\uc5d0 \uc801\uc6a9\uc774 \ub41c\ub2e4.   MySQL \uc5d0\uc11c \u00a0Replication \uc774 \uc801\uc6a9\ub418\ub294 \ubc29\uc2dd\uc740 \uc544\ub798 \uadf8\ub9bc\uc744 \uc694\uc57d\ud560 \uc218 \uc788\ub2e4. Master \uc5d0\uc11c \ub370\uc774\ud130\uc758 \ubcc0\uacbd\uc791\uc5c5\uc774 \ubc1c\uc0dd\ud558\uba74 Master DB\uc758 \ubcc0\uacbd \uc2e4\ud589 \ubcc0\uacbd\ub41c \uc774\ub825\uc744 Binary Log \uc5d0 \uae30\ub85d Slave \uc758 IO Thread \uac00 Master \uc758 \ubcc0\uacbd Event \ub97c \uac10\uc9c0\ud558\uace0 Master \uc758 Binary Log \ub97c \uc790\uc2e0(Slave)\uc758 Relay Log \uc5d0 \uae30\ub85d\ud55c\ub2e4. Slave \uc758 SQL Thread \ub294 Relay Log \ub97c \uc77d\uace0 \uc790\uc2e0(Slave)\uc758 DB\uc5d0 \uae30\ub85d\ud55c\ub2e4. \uc704 \uadf8\ub9bc\uc5d0\uc11c\ucc98\ub7fc Master \uc5d0\uc11c Slave \ubc29\ud5a5\uc73c\ub85c \ub2e8\ubc29\ud5a5\uc73c\ub85c\ub9cc \ucc98\ub9ac\uac00 \uc774\ub8e8\uc5b4 \uc9c0\ubbc0\ub85c \ubcc0\uacbd\uc791\uc5c5(Write)\ub294 Master\uc5d0\ub9cc \ud558\uc5ec\uc57c \ud55c\ub2e4. Slave\uc5d0\uc11c \ubcc0\uacbd\uc791\uc5c5\uc744 \ud560 \uacbd\uc6b0 Master\uc5d0\ub294 \ub2f9\uc5f0\ud788 \ubc18\uc601\uc774 \uc548\ub418\uba70, Slave\uc5d0\uc11c \ubcc0\uacbd\uc791\uc5c5\ud55c Object \uc5d0 \ub300\ud558\uc5ec Master \uc11c \ubcc0\uacbd\uc791\uc5c5\uc744 \ub2e4\uc2dc \uc2dc\ub3c4\ud560 \uacbd\uc6b0 \ubcc0\uacbd\uc740 \ub418\uc9c0\ub9cc \ub2e4\uc2dc slave\uc5d0 \ub294 \uc801\uc6a9\ub418\uc9c0 \uc54a\ub294\ub2e4.   MySQL Replication \uc124\uc815 \uae30\ubcf8\uc801\uc73c\ub85c Master\uc640 Slave\ub85c \uc0ac\uc6a9\ud560 Mysql \uc11c\ubc84\uac00 \uac01\uac01 \uc124\uce58\ub418\uc5b4 \uc788\uc5b4\uc57c \ud55c\ub2e4. \uac00\ub2a5\ud558\uba74 \ubb3c\ub9ac\uc801\uc73c\ub85c \ub2e4\ub978 \uc11c\ubc84\uac00 […]<\/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,7],"tags":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5q9Zn-cV","jetpack-related-posts":[{"id":720,"url":"https:\/\/blog.box.kr\/?p=720","url_meta":{"origin":801,"position":0},"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 "JAVA"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":590,"url":"https:\/\/blog.box.kr\/?p=590","url_meta":{"origin":801,"position":1},"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 "JAVA"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":807,"url":"https:\/\/blog.box.kr\/?p=807","url_meta":{"origin":801,"position":2},"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":379,"url":"https:\/\/blog.box.kr\/?p=379","url_meta":{"origin":801,"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":809,"url":"https:\/\/blog.box.kr\/?p=809","url_meta":{"origin":801,"position":4},"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 "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":362,"url":"https:\/\/blog.box.kr\/?p=362","url_meta":{"origin":801,"position":5},"title":"[\ud38c]Trello \uc544\ud0a4\ud14d\ucc98","date":"2014-09-15","format":false,"excerpt":"Trello \uc544\ud0a4\ud14d\ucc98 CoffeeScript Trello\uc758 \ud074\ub77c\uc774\uc5b8\ud2b8\uc640 \uc11c\ubc84 \ubaa8\ub450 \uc21c\uc218 \uc790\ubc14\uc2a4\ud06c\ub9bd\ud2b8 \ud504\ub85c\uc81d\ud2b8\ub85c \uc2dc\uc791\ub418\uc5c8\uace0, 2011\ub144 5\uc6d4\uae4c\uc9c0\ub294 \uc801\uc5b4\ub3c4 \uadf8\ub807\uac8c \uc720\uc9c0\ub418\uc5c8\ub294\ub370 \uadf8 \uc774\ud6c4\ubd80\ud130 CoffeeScript\ub97c \uc5bc\ub9c8\ub098 \uc88b\uc544\ud558\ub294\uc9c0 \ubcf4\uae30 \uc704\ud574\uc11c CoffeeScript\ub85c \uc774\uc911\uc73c\ub85c \uac1c\ubc1c\ud574 \ud3ec\ud305\ud558\uae30 \uc2dc\uc791\ud588\ub2e4. \uadf8 \ud6c4 \uc6b0\ub9ac\ub294 CoffeeScript\ub97c \uc0ac\ub791\ud568\uc744 \ud655\uc778\ud588\uace0 \uace7, \ub098\uba38\uc9c0 \ubaa8\ub450\uc758 \ucf54\ub4dc\ub3c4 CoffeeScript\ub85c \uc804\ud658\uc744 \uc644\ub8cc\ud588\ub2e4.\u00a0 CoffeeScript\ub294 JavaScript\ub97c \uc77d\uc744 \uc218 \uc788\ub294 \ucef4\ud30c\uc77c \uc5b8\uc5b4\uc774\ub2e4. \uc6b0\ub9ac\uac00 \uc2dc\uc791\ud588\uc744\u2026","rel":"","context":"In "\ucc38\uace0\ub97c \uc704\ud55c \uc800\uc7a5\ubb3c"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/801"}],"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=801"}],"version-history":[{"count":0,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/801\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=801"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=801"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}