http://www.mysqlkorea.co.kr
Çѱ۸Ŵº¾ó 5.0 , Çѱ۸Ŵº¾ó 5.1 , MySQL 5.1 HA , »ç¿ëÀڸŴº¾ó
°øÁö»çÇ×  
´º½º  
Áú¹®°ú ´äº¯
DBA
Developer
Cluster
ÅäÅ©¹Ú½º  
À̺¥Æ®  
¼­Æ÷Æ® ƼÄÏ  
ÃֽűÛ
foreign key ¼³Á¤¡¦
ÀÎÅØ½º Ãß°¡ µî¿¡¡¦
mysql master - s¡¦
´Ù´ë´Ù °ü°è¿¡¼­ ¡¦
mysql myÆÄÀϰú ¡¦
 
Áú¹®°ú ´äº¯ (Cluster) > Ä¿¹Â´ÏƼ Á¸ > Áú¹®°ú ´äº¯ (Cluster)
alter online ±¸¹® Áú¹®Á» µå¸±°Ô¿ä
±Û¾´ÀÌ : ¹ÎÄɺñÄ¡   ³¯Â¥ : 13-04-04 17:11   Á¶È¸¼ö : 5519
 ÀÌÇØ¸¦ Á» ´Þ¸®ÇØ¾ß ÇÒ°Í °°½À´Ï´Ù. ¾Æ·¡ ³»¿ëÀ» Âü°í ÇϽðí, ´Ù½Ã ¸Þ´º¾óÀ» º¸½Ã´Â °ÍÀÌ µµ¿òÀÌ µÉ µí ½Í³×¿ä.
mysql> CREATE TABLE t1 (
    >    c1 INT NOT NULL PRIMARY KEY,
    >    c2 VARCHAR(30)
    >    )
    >    TABLESPACE ts1 STORAGE DISK
    >    ENGINE NDBCLUSTER;
Query OK, 0 rows affected (1.73 sec)
Records: 0  Duplicates: 0  Warnings: 0
mysql> ALTER ONLINE TABLE t1 ADD COLUMN c3 INT COLUMN_FORMAT DYNAMIC STORAGE MEMORY;
Query OK, 0 rows affected (1.25 sec)
Records: 0  Duplicates: 0  Warnings: 0
mysql> ALTER ONLINE TABLE t1 ADD COLUMN c4 INT STORAGE MEMORY;
Query OK, 0 rows affected, 1 warning (1.17 sec)
Records: 0  Duplicates: 0  Warnings: 0
 
 
À§ Å×À̺íÀº disk ·Î ÀúÀåÇÏ´Â Å×À̺íÀ»¸¸´À´À°ÅÀݾƿä
c1Àº À妽º´Ï ¸Þ¸ð¸®·Î ÀúÀåµÇ°í, c2´Â µ¥ÀÌÅÍ´Ï µð½ºÅ©¿¡ ÀúÀåµÇ°í
 
¿©±â¼­ alter ±¸¹®À¸·Î c3 ¿Í c4¸¦ Ãß°¡Ç޴µ¥
 
1. µÎ°³´Ù À妽º°¡ ¾Æ´Ñµ¥. ¸Þ¸ð¸® ÀúÀåÇϱâÀ§ÇÑ ±¸¹®Àΰ¡¿ä?? Á¦°¡»ý°¢ÇÑ°Ô ¸Â³ª¿ä?
 
2. dynamic storage memory ¿Í storage memoryÀÇ Â÷ÀÌÁ¡À½ ¹«¾ùÀΰ¡¿ä?
ÀÌÀü±Û CLUSER Çϵå¿þ¾î »ç¾ç ¹× TABLESPACE °ü·ÃÇÏ¿© Áú¹®µå¸³´Ï´Ù.. 
´ÙÀ½±Û mysql Ŭ·¯½ºÅÍ ±¸¼ºÁß¿¡ ´Ù¸¥¼­¹ö¿¡¼­ API Á¢¼ÓÀ̾ȵǰí ÀÕ½À´Ï´Ù. ¤Ì.¤Ì 
MySQL Korea »çÀÌÆ®ÀÇ ÄÁÅÙÃ÷ ¼ÒÀ¯±ÇÀº (ÁÖ)»ó»óÀ̺ñÁî¿¡ ÀÖÀ¸¹Ç·Î ¹«´ÜÀüÀ縦 ±ÝÇÕ´Ï´Ù.
Copyright ¨Ï ssebiz All Rights Reserved.