http://www.mysqlkorea.co.kr
Çѱ۸Ŵº¾ó 5.0 , Çѱ۸Ŵº¾ó 5.1 , MySQL 5.1 HA , »ç¿ëÀڸŴº¾ó
°øÁö»çÇ×  
´º½º  
Áú¹®°ú ´äº¯
DBA
Developer
Cluster
ÅäÅ©¹Ú½º  
À̺¥Æ®  
¼­Æ÷Æ® ƼÄÏ  
ÃֽűÛ
foreign key ¼³Á¤¡¦
ÀÎÅØ½º Ãß°¡ µî¿¡¡¦
mysql master - s¡¦
´Ù´ë´Ù °ü°è¿¡¼­ ¡¦
mysql myÆÄÀϰú ¡¦
 
Áú¹®°ú ´äº¯ (DBA) > Ä¿¹Â´ÏƼ Á¸ > Áú¹®°ú ´äº¯ (DBA)
µà¾ó¸¶½ºÅÍ ±¸¼º ½Ã ÀϺΠÅ×ÀÌºí µ¥ÀÌÅÍ µ¿±âÈ­°¡ ¾ÈµÇ¾úÀ» ½Ã Á¶Ä¡ ¹æ¹ý
±Û¾´ÀÌ : À嶯   ³¯Â¥ : 19-03-15 11:08   Á¶È¸¼ö : 3180
¼ö°íÇϽʴϴÙ.
DB¸¦ µà¾ó ¸¶½ºÅÍ·Î ±¸¼ºÇߴµ¥, µÎ¼­¹ö ¸ðµÎ ¾Æ·¡ »óÅ´ ¼­·Î Á¤È®ÇÏ°Ô ÀÏÄ¡ÇÕ´Ï´Ù.(ÇöÀç Á¤»ó)
Slave_IO_Runging, Slave_SQL_Running, Master_Log_File, Read_Master_Log_Pos
¾î´À½ÃÁ¡¿¡ µ¿±âÈ­°¡ Ʋ¾îÁ³´Ù ´Ù½Ã ½ÇÇàµÈ°Å °°½À´Ï´Ù. ¿¡·¯µµ Ưº°ÇÑ ·Î±×°¡¾ø´Âµ¥
¾Æ¸¶, ³×Æ®¿öÅ© ºÎÇÏ·Î ¹ß»ýÇÑ°Ô ¾Æ´Ñ°¡..»ý°¢µË´Ï´Ù.
ÀÌ·±°æ¿ì ÀϺΠÅ×À̺íÀÇ µ¥ÀÌÅÍ Ä«¿îÅͰ¡ ´Ù¸¥µ¥(2¹ø¼­¹öº¸´Ù 1¹ø¼­¹ö Å×À̺íÀÇ ÀÚ·á°¡ ¸¹À½)
¾î¶»°Ô ÇØ´ç Å×À̺íÀÇ µ¥ÀÌÅ͸¦ µ¿±âÈ­ÇÒ ¼ö ÀÖ³ª¿ä?(Å×À̺í ŸÀÔ : innodb)
Å×ÀÌºí ´ÜÀ§·Î µ¿±âÈ­¸¦ ÁøÇàÇßÀ¸¸é ÁÁ°Ú´Âµ¥
¹æ¹ýÀ» ãÀ»¼ö°¡ ¾ø³×¿ä.(1,2¹ö DB ¼­ºñ½º¸¦ ¸ðµÎ ÁßÁöÇÒ ¼ö´Â ¾ø´Â »óÅÂÀÔ´Ï´Ù.)
¼ö°íÇϼ¼¿ä.
royster
±Û½ê¿ä
µ¥ÀÌÅͰ¡ ÀÏÄ¡ÇÏÁö ¾Ê´Â´Ù¸é  Å×ÀÌºí ´ÜÀ§·Î µ¿±âÈ­´Â ±î´Ù·Î¿ïµí ½Í±¸¿ä.
¿ì¼± 1,2¹ø ¼­¹öÀÇ µ¿±âÈ­¸¦ ²÷°í reset slaveµµ ÇÊ¿äÇÕ´Ï´Ù.
¶ÇÇÑ was»ó¿¡¼­ 2¹ø¼­¹öÀÇ ¿¬°áµµ ²÷¾î¾ß°ÚÁÒ

±×´ÙÀ½ 1¹ø ¼­¹ö¿¡¼­ Ç®¹é¾÷À» ¹ÞÀºÈÄ 2¹ø¼­¹ö¿¡ restore ½ÇÇàÈÄ
Æ÷Áö¼Ç ½º³À¼¦À» Âü°íÇÏ¿©  ¾ç¹æÇâ ¸®Çø®ÄÉÀ̼ÇÀ» ±¸¼ºÇÏ¸é µÇ°Ú½À´Ï´Ù.

Æ÷Áö¼Ç ½º³À¼¦ ¹× hot-backup(only innodb)À¸·Î mysqldump »ç¿ë ¹æ¹ýÀº  ¾Æ·¡ ·¹ÆÛ·±½º¸¦ Àо±â ¹Ù¶ø´Ï´Ù.
https://dev.mysql.com/doc/refman/5.7/en/backup-policy.html
ÀÌÀü±Û Can't open and lock privilege tables: Table 'mysql.host' doesn't exist ¿¡·¯ ¸Þ¼¼Áö 
´ÙÀ½±Û PREPARE »ç¿ë½Ã ÇÑ±Û ±úÁö´Â Çö»ó ÇØ°áÇϽźР°è½Ç±î¿ä? 
MySQL Korea »çÀÌÆ®ÀÇ ÄÁÅÙÃ÷ ¼ÒÀ¯±ÇÀº (ÁÖ)»ó»óÀ̺ñÁî¿¡ ÀÖÀ¸¹Ç·Î ¹«´ÜÀüÀ縦 ±ÝÇÕ´Ï´Ù.
Copyright ¨Ï ssebiz All Rights Reserved.