¾È³çÇϼ¼¿ä...
cluster ¼³Á¤... Á¤¸» ¾î·Æ½À´Ï´Ù. ¤Ñ,.¤Ñ;;;
*½Ã½ºÅÛ ½ºÆåÀº ¾Æ·¡¿Í °°½À´Ï´Ù.
CPU => XEON ³ªÀÌÆ®¹Ìµð¾î 4CORE..
RAM => 8G * 4°³ 32
*Ŭ·¯½ºÅÍ ±¸ÃàÇüÅÂ
192.168.0.1 : mgm, ndbd, mysqld
192..168.0.2 : ndbd, mysqld
µÎ °³ÀÇ µ¥ÀÌÅÍ ³ëµå·Î ¿î¿µÇÕ´Ï´Ù.
config.iniÀÇ ³»¿ëÀº ¾Æ·¡¿Í °°½À´Ï´Ù.
[ndbd default]
NoOfReplicas=2
MaxNoOfExecutionThreads=4
DataMemory=20480M
IndexMemory=8192M
MaxNoOfConcurrentTransactions=2000000
MaxNoOfConcurrentIndexOperations=2000000
MaxNoOfConcurrentOperations=4000000
MaxNoOfAttributes=20000
TransactionDeadLockDetectionTimeOut=1000000
[tcp default]
SendBufferMemory=4M
ReceiveBufferMemory=4M
[mgm default]
portNumber=1186
datadir=/db/MYSQL_DATA/ndb_data
[ndb_mgmd]
hostname=192.168.0.1
NodeId=1
[ndbd]
hostname=192.168.0.1
datadir=/db/MYSQL_DATA/ndb_data
NodeId=2
[ndbd]
hostname=192.168.0.2
datadir=/home/db/MYSQL_DATA/ndb_data
NodeId=3
[mysqld]
hostname=192.168.0.1
NodeId=6
[mysqld]
hostname=192.168.0.2
NodeId=7
#ndb_mgm -e show ½Ã Á¤»óÀûÀÎ ¿¬°áºÎºÐµµ È®ÀÎ ÇÏ¿´½À´Ï´Ù.
¿ë·®ÀÛÀº µ¥ÀÌÅÍ¿Í, µ¥ÀÌÅͺ£À̽º, Å×ÀÌºí µîÀ» ±¸ÃàÇϸç, ½Ö¹æÇâ µ¿±âÈ ³»¿ëµµ È®ÀÎ ÇÏ¿´½À´Ï´Ù.
ÀÌÁ¦ºÎÅͰ¡ ¹®Á¦ ÀÎ °Í °°½À´Ï´Ù.
mysql>load infile·Î µ¥ÀÌÅ͸¦ ¹Ð¾î ³Ö½À´Ï´Ù. ÅØ½ºÆ®·Î 100¸¸°Ç [¾à 150mb]µ¥ÀÌÅÍ´Â Àß ¾÷·Îµå µË´Ï´Ù.
240¸¸°Ç[350MB]ÀÌ»óÀÇ µ¥ÀÌÅÍ ºÎÅÍ´Â Áß°£¿¡ ¾Æ·¡¿Í °°Àº ¿¡·¯ ¸Þ¼¼Áö°¡ ³³´Ï´Ù.
ERROR 1297 (HY000): Got temporary error 4010 'Node failure caused abort of transaction' from NDBCLUSTER
³°¨ ÇÕ´Ï´Ù. ¤Ñ,.¤Ñ;; CONFIG.INIÀÇ ¿É¼ÇµéÀÌ ³»¿ëµµ Àß ¸ð¸£°Ú°í....
°í¼ö´ÔµéÀÇ Á¶¾ð ºÎʵ叮°Ú½À´Ï´Ù.
°¨»çÇÕ´Ï´Ù.