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)
±âÁ¸¿¡ »ç¿ëÇÏ´ø InnoDB Å×À̺íÀ» ndbcluster ·Î º¯°æÇÏ´Â ¹æ¹ýÀ» ¾Ë°í½Í½À´Ï´Ù.. ¿¡·¯°¡ ³ª³×¿ä 1118
±Û¾´ÀÌ : ´ëÀå°õ   ³¯Â¥ : 14-12-05 13:28   Á¶È¸¼ö : 4844
mysql cluster ±¸¼ºÀ» ÇÏ¿´½À´Ï´Ù.
»õ·Î¿î DB aaa ¸¦ »ý¼ºÇϰí, ±× ¾Æ·¡¿¡ »õ·Î¿î Å×À̺íÀ» engine=ndbcluster ·Î Ãß°¡ÇÏ¿©
Å×À̺íÀÌ Å¬·¯½ºÅ͸µ µÇµµ·Ï ÇÏ·Á°í Çϴµ¥ Ãß°¡ ½Ã ´ÙÀ½ ¿¡·¯¸¦ ¶ç¿ì¸ç ¿¡·¯°¡ ³³´Ï´Ù.
(ÇöÀç DB ÀÚü´Â Àß ½ÌÅ©µÇ°í ÀÖ´Â »óÅÂÀÔ´Ï´Ù...)

MySQL [aaa]> CREATE TABLE `MACCIDENT_HISTORY` (
    ->   `UUID` bigint(20) NOT NULL,
    ->   `MUSER_UUID` varchar(20) DEFAULT NULL,
    ->   `MCOMPANY_UUID` varchar(4) DEFAULT NULL,
    ->   `USERNAME_KO` varchar(50) DEFAULT NULL,
    ->   `USERNAME_EN` varchar(50) DEFAULT NULL,
    ->   `USERNAME_CN` varchar(50) DEFAULT NULL,
    ->   `USERNAME_JP` varchar(50) DEFAULT NULL,
    ->   `MTOKEN_SERIAL_NUMUMBER` varchar(15) DEFAULT NULL,
    ->   `ACCIDENT_STATE` varchar(4) DEFAULT NULL,
    ->   `ACCIDENT_PROC_MUSER_UUID` varchar(20) DEFAULT NULL,
    ->   `ACCIDENT_PROC_STATE` varchar(1) DEFAULT NULL,
    ->   `ACCIDENT_COMMENT` varchar(3000) DEFAULT NULL,
    ->   `NOTICE_START_TIME` timestamp NULL DEFAULT NULL,
    ->   `NOTICE_END_TIME` timestamp NULL DEFAULT NULL,
    ->   `ACCIDENT_PROC_START_TIME` timestamp NULL DEFAULT NULL,
    ->   `ACCIDENT_PROC_END_TIME` timestamp NULL DEFAULT NULL,
    ->   `ACCIDENT_PROC_COMMENT` varchar(3000) DEFAULT NULL,
    ->   `TEMP_AUTH_FLAG` int(11) DEFAULT NULL,
    ->   `TEMP_AUTH_ISSUE_TIME` timestamp NULL DEFAULT NULL,
    ->   `DUMMY_01` varchar(256) DEFAULT NULL,
    ->   `DUMMY_02` varchar(256) DEFAULT NULL,
    ->   `DUMMY_03` varchar(256) DEFAULT NULL,
    ->   PRIMARY KEY (`UUID`)
    -> ) ENGINE=ndbcluster DEFAULT CHARSET=utf8;
ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 14000. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
 
Ȥ½Ã mysql Ŭ·¯½ºÅ͸µ ÀÌÈÄ  ±âÁ¸¿¡ »ç¿ëÇÏ´ø DB¸¦ ¸®½ºÅä¾î ¹Þ¾Æ¼­ alter ¸í·ÉÀ¸·Î ¿£ÁøÀº ndbcluster ·Î º¯°æÇؼ­ ¿î¿µÁßÀ̽ŠºÐÀ̳ª,
ÀÌ¿¡ ´ëÇÑ ÇØ°áÇϼ̴ø ºÐ °è½Ã¸é µµ¿òÁ» ºÎʵ右´Ï´Ù.
´ëÀå°õ
±âÁ¸¿¡ »ç¿ëÇÏ´ø InnoDB Å×À̺íÀ» ±×´ë·Î ´ýÇÁ ¶°¼­ ºÙ¿©³ÖÀº´ÙÀ½
alter table ·Î engine=ndbcluster ÇÏ·Á°íµµ Çߴµ¥ °°Àº ¿À·ù·Î ½ÇÆÐÇÕ´Ï´Ù.
´ëÀå°õ
¹º°¡ »çÀÌÁî °ü·Ã ¿À·ùÀÎ °Ç ÁüÀÛÀÌ °©´Ï´Ù¸¸ ¾î´ÀºÎºÐÀ» ¼Õ´ëÁà¾ß ÇØ°áÀÌ µÇ´Â°ÇÁö ¸ð¸£°Ú³×¿ä..
ÀÌÀü±Û Max Connection °ü·Ã ¹®ÀÇ 
´ÙÀ½±Û Ŭ·¯½ºÅÍ µ¥ÀÌÅÍ ÀúÀå ±Ã±Ý. 
MySQL Korea »çÀÌÆ®ÀÇ ÄÁÅÙÃ÷ ¼ÒÀ¯±ÇÀº (ÁÖ)»ó»óÀ̺ñÁî¿¡ ÀÖÀ¸¹Ç·Î ¹«´ÜÀüÀ縦 ±ÝÇÕ´Ï´Ù.
Copyright ¨Ï ssebiz All Rights Reserved.