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 ·Î º¯°æÇؼ ¿î¿µÁßÀ̽ŠºÐÀ̳ª,
ÀÌ¿¡ ´ëÇÑ ÇØ°áÇϼ̴ø ºÐ °è½Ã¸é µµ¿òÁ» ºÎʵ右´Ï´Ù.