¹«ÇÑÁ¤ ´Ã¾î³ª´Â log-bin ÆÄÀÏ ÁÙÀ̱â
MySQL¿¡¼ »ç¿ëÇÏ´Â log-binÀ̶ó´Â ¿É¼ÇÀº »ç¿ëµÈ Äõ¸®µéÀÌ ·Î±ëµÇ´Â ÆÄÀÏÀ̸ç Innodb ȤÀº Replicationµî¿¡¼ »ç¿ëµÇ°ï ÇÕ´Ï´Ù.
ÇÏÁö¸¸ ÀÌ ÆÄÀÏÀÇ ¹®Á¦´Â ¹«ÇÑÁ¤ ´Ã¾î³´Ù´Â °ÍÀÔ´Ï´Ù. relay-log-space-limit °°Àº ¿É¼ÇÀÌ ÀÖÁö¸¸ ÀÌ ¿É¼ÇÀº Replication¿¡¼ »ç¿ëµÇ´Â relay-log-binÀÇ ¿ë·®À» Á¦ÇÑ ÇÏ´Â ¿É¼ÇÀÌÁö ÇØ°áÃ¥ÀÌ µÇÁö ¸øÇÕ´Ï´Ù.
ÇÏÁö¸¸ ÀÌ ÆÄÀÏÀ» Á¤¸®ÇÏ´Â ¹æ¹ýÀÌ ÀÖ½À´Ï´Ù. ¿ì¼± ´ÙÀ½ÀÇ Query¸¦ »ç¿ëÇÏ´Â °ÍÀÔ´Ï´Ù.
PURGE MASTER LOGS BEFORE DATE_SUB(CURRENT_DATE, INTERVAL 30 DAY)
INTERVAL¿¡¼´Â ¿øÇϽô ·Î±ë ½ÃÁ¡À» ±â·ÏÇÏ½Ã¸é µË´Ï´Ù. À§ÀÇ °æ¿ì¿¡´Â 30ÀÏ ÀÌÀüÀÇ ·Î±ë Á¤º¸¸¦ »èÁ¦ÇÏ°Ô µË´Ï´Ù.
Â÷·ÊÂ÷·Ê Çغ¸µµ·Ï ÇÏ°Ú½À´Ï´Ù.
1. ÇöÀçÀÇ Çϵåµð½ºÅ© ¿ë·® »óŸ¦ È®ÀÎÇÕ´Ï´Ù.
[root@Theeye db]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda1 18G 1.9G 15G 12% / /dev/sda3 15G 803M 13G 6% /home /dev/sda2 97G 78G 15G 85% /usr/local/mysql/db
µ¥ÀÌÅͺ£À̽º °ø°£ÀÌ 85%³ª »ç¿ëµÇ¾î °ð ²ËÂûÁöµµ ¸ð¸¥´Ù´Â ºÒ¾È°¨¿¡ ÈÛ½ÎÀÌ°Ô µÇ¾ú½À´Ï´Ù.
2. log-bin ÆÄÀÏÀ» È®ÀÎÇØ º¾½Ã´Ù.
[root@Theeye db]# ls mysql-bin.* mysql-bin.000001 mysql-bin.000002 mysql-bin.000003 ...... mysql-bin.000073
ÆÄÀÏÀÌ ¾öû³ª°Ô ¸¹ÀÌ ÀÖ½À´Ï´Ù.
3. ´ÙÀ½ ¸í·É¾î¸¦ ¼öÇàÇÕ´Ï´Ù.
mysql -e "PURGE MASTER LOGS BEFORE DATE_SUB(CURRENT_DATE, INTERVAL 30 DAY)"
¹°·Ð mysql¿¡ Á¢¼ÓÇϼż À§ÀÇ ¸í·É¾î¸¦ ÀÔ·ÂÇϼŵµ µË´Ï´Ù. Super±ÇÇÑÀ» °¡Áø root°èÁ¤À¸·Î ½ÇÇàÇØ ÁÖ¼¼¿ä.
4. log-bin ÆÄÀÏÀÌ ÁÙ¾ú³ª È®ÀÎÇØ º¾½Ã´Ù.
[root@Theeye db]# ls mysql-bin.* mysql-bin.000041 mysql-bin.000042 mysql-bin.000043 ...... mysql-bin.000073
41¹ø ÀÌÀüÀÇ ÆÄÀϵéÀÌ ¸ðµÎ »èÁ¦ µÇ¾ú½À´Ï´Ù. 41¹ø ºÎÅÍ°¡ ÃÖ±Ù 30ÀÏ À̳»ÀÇ ·Î±×Á¤º¸°¡ ³²¾ÆÀÖ´Â ¸ð¾çÀ̱º¿ä.
5. Çϵåµð½ºÅ© ¿ë·® »óŸ¦ È®ÀÎÇØ º¾½Ã´Ù.
[root@Theeye db]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda1 18G 1.9G 15G 12% / /dev/sda3 15G 803M 13G 6% /home /dev/sda2 97G 40G 53G 43% /usr/local/mysql/db
ÁÖ±âÀûÀÎ ½ÇÇàÀÌ ÇÊ¿äÇÏ½Ç °æ¿ì¿¡´Â À§ÀÇ ¸í·É¾î¸¦ crontab¿¡ µî·ÏÇÏ½Ã¸é µË´Ï´Ù. ÀÏÁÖÀÏ¿¡ ÇѹøÁ¤µµÀÇ ½ÇÇàÀÌ Àû´çÇϰڳ׿ä.