[±èÇÏ´Ã]´ÔÀÌ ³²±â½Å ±Û:
>À¥¼¹ö¸¦ ºÐ»êÇÏ¿© ¼ºñ½ºÇÏ´Â °æ¿ì¿¡ MySQL µðºñ´Â ¾î¶»°Ô µ¿±âÈÇÒ ¼ö
ÀÖ´ÂÁö¿ä?
>
>
>
À¥¼¹ö°¡ µ¿ÀÏÇÑ ÆäÀÌÁö¸¦ ¿©·¯´ë·Î ºÐ»êÇÏ¿© ¼ºñ½ºÇÒ °æ¿ì
MySQL ¼¹ö°¡ ÇÑ´ëÀ̸é 'µ¿±âÈ'°¡ ÇÊ¿ä¾ø°ÚÁÒ...
À¥¼¹ö¿¡ »ó°ü¾øÀÌ
MySQL ¼¹ö°¡ µ¿ÀÏÇÑ DB ±¸Á¶¸¦ °®´Â ÇüÅ·Π°¢ À¥¼¹ö°¡
·£´ýÇÏ°Ô MySQL ¼¹ö¿¡ Á¢±ÙÇؾßÇÏ´Â °æ¿ì¿¡´Â 'MySQL ¼¹ö°£ÀÇ µ¿±âÈ'°¡
ÇÊ¿äÇÕ´Ï´Ù.
'MySQL ¼¹ö°£ÀÇ µ¿±âÈ' ¹æ¹ýÀº MySQL ¼¹öÇѴ븦 master·Î
³ª¸ÓÁö MySQL ¼¹öµéÀ» slave ÇüÅ·Π±¸¼ºÇؾßÇÕ´Ï´Ù.
±× ¿ø¸®¸¦ °£´ÜÇÏ°Ô ¼³¸íÇϸé,
MySQL slave µéÀº master¿¡ ½Ç½Ã°£À¸·Î Á¢¼ÓÇÏ¿© log-bin ÆÄÀÏÀ» ÂüÁ¶·Î
Çؼ ÀÚ½Å(slave)ÀÇ DB¸¦ ¾÷±×·¹À̵åÇÏ´Â ¿ø¸®ÀÔ´Ï´Ù.
'¹é¾÷ DB ±¸Ãà'ÀÇ ÇÑ°¡Áö ¹æ¹ýÀÔ´Ï´Ù.
ÁÖÀÇÇÒÁ¡Àº master¿¡¼¸¸ ¼öµ¿À¸·Î insert, update, delete ÇؾßÇÕ´Ï´Ù.
(slave¿¡¼ ¼öµ¿À¸·Î Á¶ÀÛÇÏ¸é µ¿±âÈÇϱⰡ ¾î·Æ±â ¶§¹®)
³ª¸ÓÁö slave µéÀº ÀڽŵéÀÌ ÀÚµ¿À¸·Î insert, update, delete ÇÔ.
ÀÌ ±¸Ãà ¹æ¹ýÀº »ó´çÈ÷ ¾î·Æ°í ¹æ´ëÇϱ⠶§¹®¿¡ ¾Æ·¡ URLÀ»
Âü°íÇÏ½Ã±æ ¹Ù¶ø´Ï´Ù.
MySQL ¸Å´º¾ó 4.10 Replication in MySQL
http://www.mysql.com/doc/en/Replication.html
±âŸ
http://www.phpschool.com/bbs2/inc_view.html?id=8050&code=tnt2
|